一、mysql JDBC连接

import java.sql.*;

public class testmysql {
    static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://数据库域名:端口/库名?user=账号&password=密码";

    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String sql = "SELECT * from idrisk_rule_kyc_type_result where id_account in ('2226447','2228231')";

        try {
            Class.forName(JDBC_DRIVER);// 加载驱动
            conn = DriverManager.getConnection(DB_URL);// 获取数据库连接
            stmt = conn.createStatement();// 创建执行环境
            rs = stmt.executeQuery(sql);// 执行SQL语句
            while (rs.next()) {// 输出数据
                System.out.println("id_account: " + rs.getInt("id_account"));
                System.out.println("call_type: " + rs.getString("call_type"));
            }
        } catch (ClassNotFoundException e) {
            System.out.println("加载驱动异常");
            e.printStackTrace();
        } catch (SQLException e) {
            System.out.println("数据库异常");
            e.printStackTrace();
        } finally {
            try {
                if (rs != null)
                    rs.close(); // 关闭结果数据集
                if (stmt != null)
                    stmt.close(); // 关闭执行环境
                if (conn != null)
                    conn.close(); // 关闭数据库连接
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}