问如何解决异常jdbc错误？

提问于 2018-05-30 04:04:44

回答 1关注 0查看 902

这个问题在这里已经有了答案：

ClassNotFoundException with com.mysql.cj.jdbc.Driver, MySQL Connector and IntelliJ IDEA
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
java.lang.ClassNotFoundException inspite of adding dependency

截图 :

java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
    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 Main.main(Main.java:13)

这是我正在使用的代码：

import java.sql.*;

public class Main {

public static void main(String args[]) throws SQLException {

    String host = "jdbc:mysql://localhost:3306/lorann?autoReconnect=true&useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
    String uName = "root";
    String uPass= "";

    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
    e.printStackTrace();
}

    Connection co = DriverManager.getConnection(host,uName,uPass);
    Statement stmt = co.createStatement();


    ResultSet rs = stmt.executeQuery("SELECT contenu FROM niveau");
    @SuppressWarnings("unused")
    ResultSetMetaData rsm = rs.getMetaData();



    while(rs.next()) {
        System.out.println(rs.getString("contenu"));
    }

}}

jdbc