程序如下:
import java.sql.*;
public class DatabaseConnection {
public static void main(String args[]) {
// String aaa = "com.MySQL.jdbc.Driver ";
String url = "jdbc:MySQL://localhost:3306/mydatabase ";
String user = "root ";
String password = "admin ";
try {
Class.forName( "com.MySQL.jdbc.Driver ");
Connection con = DriverManager.getConnection(url, user, password);
Statement statement = con.createStatement();
String query = "select * from friend ";
ResultSet result = statement.executeQuery(query);
while (result.next()) {
System.out.println(result.getString( "name "));
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
}
}
报告的错误:
java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DatabaseConnection.main(DatabaseConnection.java:11)
我已经用eclipse 加载过了驱动,
但是还报出以上的错误,请问这是什么问题?谢谢
------解决方案--------------------
Class.forName( "com.MySQL.jdbc.Driver ");
driver字符串错误。
------解决方案--------------------
全部换成小写
------解决方案--------------------
Class.forName( "com.mysql.jdbc.Driver ");//你的是大写了换小写的
String dbUrl= "jdbc:mysql://localhost:3306/jspdev?useUnicode=true&characterEncoding=gb2312 ";
String dbUser= "root ";
String dbPwd= "123 ";
con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
------解决方案--------------------
你的包导入了么?
------解决方案--------------------
你的mysql驱动包没有导入到webroot下的wen-inf下的lib目录下
------解决方案--------------------
java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
这是驱动问题,将mysql的驱动放在webroot的WEB-INF下的lib下或放在Tomcat下的common下的lib目录下
------解决方案--------------------
String aaa= "com.mysql.jdbc.Driver ";
String URL = "jdbc:mysql://localhost/bbs?user=root&password=root ";
Class.forName(aaa)
Connection con = DriverManager.getConnection(URL);
楼主看看这里,
------解决方案--------------------
驱动没加