Question

jsp无法连接mysql数据库

HTTP Status 500 -

type Exception report

message

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

exception
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 12 in the jsp file: /custom.jsp
String literal is not properly closed by a double-quote
9: Connection conn=DriverManager.getConnection("jdbc:odbc:washshop","sa","");
10: Statement stmt=conn.createStatement();
11: try{
12: sql="Insert Into custom(danhao,name,tel,address,quantity,price,sdate,qdate)
13: Values('"+s_danhao+"','"+s_name+"','"+s_tel+"','"+s_address+"','"+s_quantity+"','"+s_price+"','"+s_sdate+"','"+s_qdate+"')";
14: stmt.executeUpdate(sql);
15: ResultSet rs;

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:95)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:457)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:367)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:345)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:332)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:594)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:342)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

note The full stack trace of the root cause is available in the
Apache Tomcat/7.0.8 logs.

Answer 1

首先确认一下danhao,name,tel,address,quantity,price,sdate,qdate
这几个字段剩下的是否是可以为空的，比如如果有主键Id，是否是自增的，不是自增的此处不填ID值是会报错的
再一个确认试一下execute的方法，insert语句貌似不能用executeUpdate
吧，stmt.execute(sql);你试一下吧，我也记不清楚了