处理JSP页面类型异常报告时发生异常
An exception occurred processing JSP page - type Exception report
我正在使用PreparedStatement
运行以下代码。
<%
Class.forName("com.mysql.jdbc.Driver");
Connection Con=DriverManager.getConnection("jdbc:mysql://localhost:3306/onlineshopping","root","2710");
out.println("connection success full");%>
<%String username=request.getParameter("user_name");
String password=request.getParameter("password");
String cpassword=request.getParameter("cpassword");
String emailid=request.getParameter("email_id");
String address=request.getParameter("address");
String city=request.getParameter("city");
String pincode=request.getParameter("pincode");
String country=request.getParameter("country");
PreparedStatement pst = null;
if(password.equals(cpassword))
{
String str= "insert into register(user_name,password,email_id,address,city,pin,country) values(?,?,?,?,?,?,?)";
pst = Con.prepareStatement(str);
pst.setString(1,username);
pst.setString(2,password);
pst.setString(3,emailid);
pst.setString(4,address);
pst.setString(5,city);
pst.setString(6,pincode);
pst.setString(7,country);
int i = pst.executeUpdate();
String str1="insert into login(user_name,password) values (?,?)";
pst=Con.prepareStatement(str1);
pst.setString(1,username);
pst.setString(2,password);
int j=pst.executeUpdate();
if(i==0||j==0)
{
response.sendRedirect("registerError.jsp");
}
else
{
HttpSession ses=request.getSession(true);
session.setAttribute("user_name",username);
response.sendRedirect("loggedIn.jsp");
}
}
%>
但是,它生成了这个错误消息:
type Exception report
message An exception occurred processing JSP page /register.jsp at line 35
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /register.jsp at line 35
32: pst.setString(5,city);
33: pst.setString(6,pincode);
34: pst.setString(7,country);
35: int i = pst.executeUpdate();
36: String str1="insert into login(user_name,password) values (?,?)";
37: pst=Con.prepareStatement(str1);
38: pst.setString(1,username);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:575)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'user_name' cannot be null
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
org.apache.jsp.register_jsp._jspService(register_jsp.java:125)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'user_name' cannot be null
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:408)
com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
com.mysql.jdbc.Util.getInstance(Util.java:384)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
org.apache.jsp.register_jsp._jspService(register_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.63 logs.
我做错了什么?
错误是在你的帖子本身。例外:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException
,消息为Column 'user_name' cannot be null
。请检查user_name
字段是否为空
相关文章:
- 如何通过自己获得Chrome扩展的用户反馈/错误报告
- 在javaservlet doPost方法中启动线程时,无法返回异常消息
- angularjs$valid-on-dates在firefox中报告错误
- document.applet.method在Mounatin Lion上抛出safari 6+JDK7异常
- 为什么浏览器没有为语法错误抛出异常
- java,javascript签名的小程序(文件选择,ftp上传)安全性/套接字异常
- node.js和express中的异常处理
- 派生进程的stdout在管道传输时工作异常
- NodeJS和pg promise,捕获PostgreSQL异常
- 当显式定义控制器参数时,默认模型绑定器会发生异常
- 显示引导弹出操作异常的逻辑
- 调用谷歌地图路线服务时未捕获的异常
- web配置http到https重定向异常
- 转换异常时间&Datestring到JavaScript日期
- 为什么在python中使用异常比javascript更容易接受
- PHP REST服务抛出异常——希望避免控制台错误
- JS异常:animate不是一个函数
- 在蓝鸟中处理异常
- 处理JSP页面类型异常报告时发生异常
- js方法失败(抛出异常?),firebug不报告