mysql链接jdbc配置_怎样配置jdbc驱动连接mysql

JSP开发环境为JDK1.6+Eclipse3.2+MyEclipse5.5+Tomcat5.5+mysql4.1在所有程序安装完后配好了环境变量，其中mysql的驱动是这样配置的：1、在C:\ProgramFiles\Java目录下建立mysqlforjd...

JSP开发环境为JDK1.6+Eclipse3.2+MyEclipse5.5+Tomcat5.5+mysql4.1

在所有程序安装完后配好了环境变量，其中mysql的驱动是这样配置的：

1、在C:\Program Files\Java目录下建立mysqlforjdbc子目录，进入该目录将mysql-connector-java-3.1.14-bin.jar拷到该目录下

2、进入C:\Program Files\Java\jdk1.6.0_02\lib目录将mysql-connector-java-3.1.10-bin-g.jar拷贝到该目录下

3、追加%JAVA_HOME%\lib\mysql-connector-java-3.1.14-bin-g.jar;C:\Program Files\Java\mysqlforjdbc\mysql-connector-java-3.1.14-bin.jar;到该环境变量中

现有jsp文件first.jsp(存放在\Tomcat 5.5\webapps\myapp文件夹中)内容如下：

Class.forName("com.mysql.jdbc.Driver").newInstance();

String url ="jdbc:mysql://localhost/first?user=root&password=zs&useUnicode=true&characterEncoding=8859_1"

//first为数据库名

Connection conn= DriverManager.getConnection(url);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from test";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next()) {%>

test表的name值为：

stmt.close();

conn.close();

%>

在Tomcat中运行报错：

异 常

org.apache.jasper.JasperException: 无法编译JSP

An error occurred at line: 5 in the jsp file: /first4.jsp

Generated servlet error:

Syntax error, insert ";" to complete LocalVariableDeclarationStatement

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

或者

异 常

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

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

请问要如何做才能够让first.jsp运行起来？

将文档(first.jsp就是first4.jsp，两个是一样的文件，现在直接运行了first4.jsp)修改后，错误报告为

org.apache.jasper.JasperException: Exception in JSP: /first4.jsp:6

3:

4:

5:

6: Class.forName("com.mysql.jdbc.Driver");

7: Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/first","root","zs"); //first为数据库名

8: Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

9: String sql="select * from test";

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

展开