紧急求助数据库连接的问题
各位大虾好,小弟初学jsp,现在想用jsp做一个简单的数据管理页面,使用的是mysql-4.0.20a-win,tomcat5.0,jdbc驱动是mm.mysql-2.0.14,可是参照网上的各种方法始终出现一下错误:
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: 2 in the jsp file: /jdbctest.jsp
Generated servlet error:
[javac] Compiling 1 source file
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\demo\org\apache\jsp\jdbctest_jsp.java:47: cannot resolve symbol
symbol : variable sqlConn
location: class org.apache.jsp.jdbctest_jsp
An error occurred at line: 2 in the jsp file: /jdbctest.jsp
Generated servlet error:
sqlConn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
请高手能够给出详细的解决办法,另外,是不是不同版本的mysql所需要的jdbc驱动程序也不同,如果是,对应的版本号应该是什么,我在mysql网站上也没看到有关的说明。