主题:jsp与sql 2000连接问题
我也是一位新手,麻烦你给公布一下你的方法。
还有我现在编了一个登陆界面和注册截面,凡是和数据库(Sql 2000)连接的都会出现以下问题:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 26 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:69: <identifier> expected
class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
^
An error occurred at line: 26 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:69: '{' expected
class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
^
An error occurred at line: 26 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:76: ';' expected
String sql="select * from custom where uid='"+uid"'";
^
An error occurred at line: 26 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:79: illegal start of type
if(rs.next())
^
An error occurred at line: 133 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:225: <identifier> expected
out.write("\r\n");
^
An error occurred at line: 133 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:226: <identifier> expected
out.write("</body>\r\n");
^
An error occurred at line: 133 in the jsp file: /reg2.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:227: <identifier> expected
out.write("</html>\r\n");
^
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:228: 'catch' without 'try'
} catch (Throwable t) {
^
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:31: 'try' without 'catch' or 'finally'
try {
^
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\reg2_jsp.java:240: '}' expected
^
10 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
麻烦给解释以一下,谢谢