jsp连接数据库错误 Invalid character constant

来源：百度知道编辑：UC知道时间：2024/05/26 14:23:24

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

An error occurred at line: 17 in the jsp file: /tjia.jsp
Invalid character constant
14: con=DriverManager.getConnection(uri,"root","java");
15: stmt=con.createStatement();
16:
17: rs=stmt.executeUpdate("insert into syan(id,name,sex,year) values("id","'+name+'","'+sex+'","'+year'")");
18:
19: con.close();}
20: catch(SQLException e1){

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasp

rs=stmt.executeUpdate("insert into syan(id,name,sex,year) values(id,"'+name+'","'+sex+'","'+year'")");
这句字符串连接有问题。应该是这样的吧。
rs=stmt.executeUpdate("insert into syan(id,name,sex,year) values(id,'"+name+"','"+sex+"','"+year+"')");

最好把Jsp的源代码贴出来。

jsp连接数据库问题 jsp连接数据库 jsp连接mysql数据库 jsp如何连接数据库？ jsp连接sql数据库 JSP连接数据库 jsp 连接access数据库 jsp连接数据库问题~~~~~~~~~~~~~~~~ JSP连接数据库问题 jsp中的如何连接数据库?