jsp环境配置mysql_jsp+mysql+tomcat环境配置

请大家帮帮忙。。。。看一下。。。jsp+tomcat+mysqltomcat6.0E:\Tomcat6.0mysqlD:\mysqljdkC:\ProgramFiles\Java\jdk1.6.0_07mysql-connector-java-5.0.8-bin.jar把mysql-connector-j...

请大家帮帮忙。。。。看一下。。。

jsp+tomcat+mysql

tomcat6.0 E:\Tomcat 6.0

mysql D:\mysql

jdk C:\Program Files\Java\jdk1.6.0_07

mysql-connector-java-5.0.8-bin.jar

把

mysql-connector-java-5.0.8-bin.jar 复制到了 E:\Tomcat 6.0\lib 和 C:\Program Files\Java\jdk1.6.0_07\lib

环境变量配置 如下 ：

catalina_home E:\Tomcat 6.0

classpath .;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;E:\Tomcat 6.0\lib\servlet-api.jar;%JAVA_HOME%\lib\mysql-connector-java-5.0.8-bin.jar;

JAVA_HOME C:\Program Files\Java\jdk1.6.0_07

//mysql> create database javatest;

mysql> create table testdata (

-> id int not null auto_increment primary key,

-> foo varchar(25),

-> bar int);

+----+-------+-------+

| id | foo | bar |

+----+-------+-------+

| 1 | hello | 12345 |

+----+-------+-------+

//

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

String url ="jdbc:mysql://localhost/javatest?

user=root&password=4408&useUnicode=true&characterEncoding=GB2312" ;

Connection conn= DriverManager.getConnection(url);

Statement stmt=conn.createStatement();

String query="select * from testdata";

ResultSet rs=stmt.executeQuery(query);

while(rs.next())

{

String s=rs.getString("foo");

int i=rs.getInt("id");

out.println(s+" "+i+"
");

}

%>

org.apache.jasper.JasperException: An exception occurred processing JSP page /p1/sql2.jsp at line 8

5:

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

7: String url ="jdbc:mysql://localhost/javatest?user=root&password=4408&useUnicode=true&characterEncoding=GB2312" ;

8: Connection conn= DriverManager.getConnection(url);

9: Statement stmt=conn.createStatement();

10: String query="select * from testdata";

11: ResultSet rs=stmt.executeQuery(query);

Stacktrace:

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

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

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)

展开