一代天骄 2011-11-12 10:23
浏览 429
已采纳

我是javaee新手,运行数据库出现这样的问题不知道怎么修改description The server encountered an internal err

<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB18030"%>
<%@ page import="java.util.*" %>
<%
reponse.setCharacterEncoding("GB18030");
String susername,spassward,school,scho,sclass,stel,sgender;
susername=request.getParameter("Name");
spassword=request.getParameter("passward1");
school=request.getParameter("xueyuan");
scho=request.getParameter("zhuanye");
sclass=request.getParameter("nianji");
stel=request.getParameter("number");
sgender=request.getParameter("gender");
String insertquery= "insert into student set
Name='"+susername+"',passward1='"+spassward+"',
xueyuan='"+school+"',number='"+stel+"',zhuanye='"+scho+"',nianji='"+sclass+"',number='"+stel+"',gender='"+sgender+"'";
String selectquery="select * from student where Name='"+susername+";
Connction conn=null;
Statement stmt=null;
Resultset rs=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn= DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
stmt= conn.createStatement();
rs=stmt.executeQuery(selectquery);
if(rs.next()){
response.sendRendirect("register.jsp");}
return;}
else{
stmt.executeQuery(insertquery);}
}catch(SQLException ex){
ex.printStackTrace();
response.sendRendirect("login.jsp");}
finally
{stmt.close();
conn.close();}
%>

  • 写回答

2条回答 默认 最新

  • 08_shou 2011-11-13 12:09
    关注

    1、你输出一下要插入的信息,看看有没有为null的数据或者是乱码。
    2、你要补充一下异常的信息是什么,比如这样子:
    [code="java"]
    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception

    org.apache.jasper.JasperException
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

    root cause

    java.lang.NullPointerException
    org.apache.jsp.submit_jsp._jspService(submit_jsp.java:107)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

    [/code]
    有这些才好找错误。。。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
  • ¥15 数据可视化Python
  • ¥15 要给毕业设计添加扫码登录的功能!!有偿
  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘