This question already has answers here:
The infamous java.sql.SQLException: No suitable driver found
                                
                                    (13个回答)
                                
                        
                                2年前关闭。
            
                    
我从Oracle网站上获取了此示例,但我无法实现它。它一直显示错误。我已经将mysql 5.1 driver jar添加到我的项目lib文件夹中
以及我的构建路径。如何修复我的代码?

链接-http://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html

错误-

java.sql.SQLException: No suitable driver found for jdbc:JavaEE://localHost:3306/
    at java.sql.DriverManager.getConnection(DriverManager.java:602)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at com.beans.us.dao.Data.getConnection(Data.java:25)
    at com.beans.us.dao.Data.main(Data.java:43)
Cannot connect to database


代码-

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class Data {

    public static Connection getConnection() {

        Connection conn = null;
        Properties connectionProps = new Properties();
        String userName = "root";
        String password = "root";
        String dbms = "JavaEE";
        String serverName = "localHost";
        String portNumber = "3306";

        connectionProps.put("user", userName);
        connectionProps.put("password", password);

        try {

            conn = DriverManager.getConnection("jdbc:" + dbms + "://"
                    + serverName + ":" + portNumber + "/", connectionProps);
        } catch (SQLException sQLException) {
            sQLException.printStackTrace();
        }

        if (conn != null) {
            System.out.println("Connected to database");
        } else {
            System.out.println("Cannot connect to database");
        }

        return conn;
    }

    public static void main(String[] args) {

        getConnection();

    }

}

最佳答案

您的连接字符串为:

"jdbc:JavaEE://..."


但是使用MySQL应该是

"jdbc:mysql://..."


另外,您忘记加载驱动程序:

Class.forName("com.mysql.jdbc.Driver");


需要在致电之前完成

conn = DriverManager.getConnection(...);

10-07 19:38
查看更多