jsp无法连接mysql数据库
HTTPStatus500-typeExceptionreportmessagedescriptionTheserverencounteredaninternalerro...
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. 展开
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. 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询