java - 将 JDBC 连接到 IP 地址-6ren

java - 将 JDBC 连接到 IP 地址

转载作者：太空宇宙更新时间：2023-11-03 11:27:32

<分区>

我在使用 JDBC 连接到外部 IP 地址时遇到问题。当我执行以下代码时，出现此错误 No suitable driver found for jdbc:mysql://52.206.157.109:3306/U054Jk

代码:

package util;

import java.sql.*;

public class db {
    private static String server = "52.206.157.109";
    private static String dbName = "U054Jk";
    private static String userName = "secret";
    private static String password = "secret";

    private static Connection getCon() throws SQLException {
        String host = "jdbc:mysql://" + server + ":3306/" + dbName;

        Connection conn = DriverManager.getConnection(
                host,
                userName,
                password
        );

        return conn;
    }

    public static ResultSet ExecQuery(String query) throws SQLException {
        //Get the connection
        Connection conn = getCon();

        //Create the statement
        Statement stmt = conn.createStatement();

        //Execute the statement
        ResultSet rs = stmt.executeQuery(query);

        //Return ResultSet
        return rs;
    }
}