Question

HTTP Status 500 - Unable to compile class for JSP

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

An error occurred at line: 37 in the jsp file: /mkfriend/register.jsp
executeUpdate cannot be resolved or is not a field
34: try{
35: con=DriverManager.getConnection ("jdbc:sqlserver://localhost:1433;DatabaseName=Warehouse","sa","sa");
36: sql=con.createStatement();
37: sql.executeUpdate=("INSERT INTO u_user(ID) VALUES('"+ID+"')");
38: con.close();
39: }
40: catch(SQLException e)

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:103)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:366)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:468)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:378)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:353)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:340)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:657)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:357)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
求教哪里错了。。。。

Answer 1

错误提示：37行“sql.executeUpdate=("INSERT INTO u_user(ID) VALUES('"+ID+"')");
”这里有问题，你的sql语句有问题。