数据库连接问题
ahwen 2003-04-13 02:58:38 为什么我用java就可以连接mysql数据库的(说明系统变量没有问题),
而在JSP中用javabean连接就有问题,说找不到数据库的driver。
java.lang.ClassNotFoundException: ClassNotFoundException: Could not locate database driver.
JavaBean文件Books.java如下:
package com.wrox.databases;
import java.sql.*;
import java.util.*;
public class Books {
String error;
Connection con;
public Books() { }
public void connect() throws ClassNotFoundException,
SQLException,
Exception {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(
"jdbc:mysql://localhost/test?user=Owen&password=5527981");
} catch (ClassNotFoundException cnfe) {
error = "ClassNotFoundException: Could not locate database driver.";
throw new ClassNotFoundException(error);
} catch (SQLException cnfe) {
error = "SQLException: Could not connect to database.";
throw new SQLException(error);
} catch (Exception e) {
error = "Exception: An unknown error occurred while connecting " +
"to database.";
throw new Exception(error);
}
}
}