程序如下:
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 加载过了驱动,
但是还报出以上的错误,请问这是什么问题?谢谢
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 加载过了驱动,
但是还报出以上的错误,请问这是什么问题?谢谢
String url = "jdbc:MySQL://localhost:3306/mydatabase";