关于Access连接问题,急。。。谢谢!!! String sqlsm="insert into table11(user,password,name,sex,textarea)values(name,password,name,sex,textarea)";有的数据类型应该是char吧,少单引号哦,其它不好说,该把你的异常报上来啊! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 哦 下面是异常org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 18 in the jsp file: /do_register1.jspsm cannot be resolved15: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");16: String url="jdbc:odbc:s11";17: con=DriverManager.getConnection(url);18: sm=con.createStatement();19: String sqlsm="insert into table11(user,password,name,sex,textarea)values('user','password','name','sex','textarea')";20: rs=sm.executeUpdate(sqlsm);21: session.setAttribute("user",user);An error occurred at line: 20 in the jsp file: /do_register1.jspsm cannot be resolved17: con=DriverManager.getConnection(url);18: sm=con.createStatement();19: String sqlsm="insert into table11(user,password,name,sex,textarea)values('user','password','name','sex','textarea')";20: rs=sm.executeUpdate(sqlsm);21: session.setAttribute("user",user);22: response.sendRedirect("register.jsp");23: }Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423) org.apache.jasper.compiler.Compiler.compile(Compiler.java:308) org.apache.jasper.compiler.Compiler.compile(Compiler.java:286) org.apache.jasper.compiler.Compiler.compile(Compiler.java:273) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 好像还要用户名和密码吧!你这样没有数据库用户名和密码它怎么去登数据库呢?con=DriverManager.getConnection(url);那你的sm肯定是空的了。 救急。。 jsp 关于input标签的file类型问题<input type="file"/> jsp 如何统计阅读次数 jdbc连接sql,没成功过!!急!!! JDBC连接SQL SERVER2000的问题 tomcat编译部署servlet的问题? 在JSP中如何定制ClassLoader,实现自己编写的JavaBean源代码保密。 来者有分,探讨关于全局变量的问题! 关于linux下web.xml的问题!在线等!急 急急、在线等待 关于发Email的问题(这里有源码,但有一点小问题) 如何把JSP页面的数据导入.txt 关于ajax的初级问题请教高手指教
下面是异常
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 18 in the jsp file: /do_register1.jsp
sm cannot be resolved
15: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
16: String url="jdbc:odbc:s11";
17: con=DriverManager.getConnection(url);
18: sm=con.createStatement();
19: String sqlsm="insert into table11(user,password,name,sex,textarea)values('user','password','name','sex','textarea')";
20: rs=sm.executeUpdate(sqlsm);
21: session.setAttribute("user",user);
An error occurred at line: 20 in the jsp file: /do_register1.jsp
sm cannot be resolved
17: con=DriverManager.getConnection(url);
18: sm=con.createStatement();
19: String sqlsm="insert into table11(user,password,name,sex,textarea)values('user','password','name','sex','textarea')";
20: rs=sm.executeUpdate(sqlsm);
21: session.setAttribute("user",user);
22: response.sendRedirect("register.jsp");
23: }
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
那你的sm肯定是空的了。