Java 使用 JDBC 连接到 MySQL 数据库

Question

我正在尝试创建一个使用 JDBC 连接到 MySQL 数据库的程序。但是当我尝试运行它时，出现以下错误:-

java.sql.SQLException: No suitable driver found for a9442ca6-992c-411b-8bda-a42f00a0ab2e.mysql.sequelizer.com
    at java.sql.DriverManager.getConnection(DriverManager.java:596)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at DVDLibrary.MySQLDBConnection.testConnect(MySQLDBConnection.java:24)
    at DVDLibrary.MainClass.main(MainClass.java:12)

我已经安装了 Maven 并将 MySQL 依赖项添加到 POM 文件中(见下文)。但仍然无法让我的程序运行。请问有人可以帮忙吗？

<dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.17</version>
            <type>jar</type>
            <scope>compile</scope>
        </dependency>
    </dependencies>
</project>

package DVDLibrary;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MySQLDBConnection {

        public void testConnect(){

        String dbUrl = "xxx";
        String username  = "xxx";
        String password  = "xxx";
        String dbClass = "com.mysql.jdbc.Driver";

        String query = "SELECT * FROM DVD Info Table";

        try {

            Class.forName(dbClass);
            Connection connection = DriverManager.getConnection(dbUrl, username, password);

            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(query);

            while (resultSet.next()) {
                String tableName = resultSet.getString(1);
                System.out.println(tableName);
            }
            connection.close();

        }
        catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }

}

其他类:-

package DVDLibrary;

import oracle.jrockit.jfr.tools.ConCatRepository;


public class MainClass {

     public static void main(String []args)
    {
    MySQLDBConnection con = new MySQLDBConnection();

    con.testConnect();

        if(con != null)
        {
            System.out.println("Succes"); 

        }
        else
        {
            System.out.println("Fail"); 
        }

    }

}

Answer 1

请将 mysql JDBC 驱动程序添加到您的类路径中，然后重试。您可以从here下载或here如果你没有它并加载它。效果应该很好。这是示例代码:

 Connection getConnection() {
    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(
                "jdbc:mysql:localhost:3306/Database", "username",
                "password");
        if (!conn.isClosed())
            return conn;
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
    return null;
}