JDBC连接mySQL数据库报错“java.lang.ClassNotFoundException: com.mysql.jdbc.Driver”,求助!!!
import java.sql.*;
public class JDBCtest {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String url = "jdbc:mysql://localhost:3306/employee";
String user = "root";
String password = "123456";
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
String intoData = "insert into employee";
stmt.executeUpdate(intoData + "(first, last, age) values('ming', 'li', 22)");
}
}
以下是错误提示:
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 com.jeffrey.study.JDBCtest.main(JDBCtest.java:21)
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jeffrey.study.JDBCtest.main(JDBCtest.java:34)
-----------------------------------------------------------------------------------
我已经将mysql-connector-java-3.0.15-ga-bin.jar添加进CLASSPATH,后来甚至干脆拷到JDK下的lib下,仍然不行,我用的是eclipse,求助各位大虾!!!!帮帮小弟!!!!