jsp连接MYSQL数据库问题..........
搞了一个通宵了还是连不上,急死了....
我在java中以可以连上,下面把jsp代码和java代码贴出来给大家看看,高手请指教,谢谢.
-----jsp代码-----
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
String userName = "zzit";
String userPassword = "123456";
String dbName = "zzit";
String tableName = "test1";
String url = "jdbc:mysql://localhost:3306/" + dbName;
try{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e){
out.print(e+"<BR>");
}
try{
Connection conn = DriverManager.getConnection(url,userName,userPassword);
Statement statement = conn.createStatement();
String sql = "SELECT * FROM test1";
ResultSet rs = statement.executeQuery(sql);
ResultSetMetaData rmeta = rs.getMetaData();
while( rs.next()){
out.print(rs.getString(1)+" ");
out.print("|");
out.print(rs.getString(2)+" ");
out.print("<br>");
}
rs.close();
statement.close();
conn.close();
}
catch(Exception ex){
out.print(ex);
}
%>
</body>
</html>
-------出错为---------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
java.sql.SQLException: No suitable driver
****************************************************************************
-------java代码--------
// Java Document
//装入驱动程序
import java.sql.*;
public class LoadDriver
{
public static void main(String[] args)
{
String userName = "zzit";
String userPassword = "123456";
String dbName = "zzit";
String url = "jdbc:mysql://localhost:3306/" + dbName + "?user=" + userName + "&password=" + userPassword;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(Exception ex){
System.out.println(ex);
}
try{
Connection conn = DriverManager.getConnection(url);
Statement statement = conn.createStatement();
String sql = "SELECT * FROM test1";
ResultSet rs = statement.executeQuery(sql);
ResultSetMetaData rmeta = rs.getMetaData();
while( rs.next()){
System.out.print(rs.getString(1)+" ");
System.out.print("|");
System.out.print(rs.getString(2)+" ");
System.out.println(" ");
}
rs.close();
statement.close();
conn.close();
}
catch(Exception ex){
System.out.print(ex);
}
}
}
---------java代码运行成功-------------------
如果我的驱动配置不成功那么java也运行不成功才对,为什么java运行成功,而jsp却运行不成功?
驱动为: mysql-connector-java-3.1.12-bin.jar
tomcat为: 5.5.16