运行java项目时出错
到目前为止,我一直使用这个编译器,从未遇到过任何问题,但现在,当我运行以下代码时(在Eclipse LUNA中,最新版本):
import java.sql.*;
public class TestJDBC {
public static void main (String[] args) {
String dbUrl = "jdbc:mysql://localhost:3306/database";
String user = "user";
String password = "root";
try {
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(ClassNotFoundException e) {
e.printStackTrace();
System.out.println("Eroare incarcare driver!\n" + e);
}
try {
Connection c=DriverManager.getConnection(dbUrl, user, password);
Statement s= c.createStatement();
ResultSet r = s.executeQuery(" SELECT cod, nume FROM localitati"
+ " ORDER BY nume");
while (r.next()) {
System.out.println(r.getString ("cod") + "," + r.getString ("nume") );
}
s.close();
}
catch(SQLException e) {
e.printStackTrace();
}
}
}
我得到以下错误:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
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.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at TestJDBC.main(TestJDBC.java:8)
Eroare incarcare driver!
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/database
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestJDBC.main(TestJDBC.java:15)
我能做些什么来解决这个问题
# 1 楼答案
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
出现异常是因为应用程序中没有该类要解决这个问题,您必须检查
lib
文件中是否存在类,或者下载并配置mysql-2_0_12.jar
jar文件,它将支持org.gjt.mm.mysql.Driver
驱动程序# 2 楼答案
下载mysql驱动程序jarclick here
在构建路径中添加jar
# 3 楼答案
生成路径中缺少JAR库。 你可以在这里找到它:
不要忘记将jar库添加到构建路径中