请大家帮帮忙。看一下
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 |
+----+-------+-------+
//<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 
<html>
<body>
<% 
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+"<br>");
}
%>
</body>
</html>
org.apache.jasper.JasperException: An exception occurred processing JSP page /p1/sql2.jsp at line 85: <% 
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)