通过jdbc手动连接mysql测试示例

本篇记录一个比较基础的例子，手动通过jdbc连接mysql。

有时候用在测试环境，进行一些测试还是不错的，供参考，代码如下：

    public static void main(String[] args) throws Exception {
        String url="jdbc:mysql://10.xx.x.xxx:3008/db_name?useUnicode=true&characterEncoding=utf-8";
        String username = "user_name";
        String password = "password";

        // jdk1.6之前需注册驱动
//        Class.forName("com.mysql.jdbc.Driver");
        // 建立数据库连接
        try (Connection connection = DriverManager.getConnection(url, username, password);
             Statement stmt = connection.createStatement();) {
            /* // 执行测试sql
            String sql = "insert into table_A(...)";
            for (int i = 0; i < 1000; i++) {
                stmt.execute(sql);
            }*/

            String sql = "select * from table_A";
            try (ResultSet rs = stmt.executeQuery(sql);) {
                rs.last();
                System.out.println("count = " + rs.getRow());

                /*int count = 0;
                while (rs.next()) {
                    // 查看执行结果
                    Long id = rs.getLong("id");
                    String name = rs.getString("name");
                    System.out.println(id + "--" + name);
                    count++;
                }*/
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

 

参考：https://www.runoob.com/java/java-mysql-connect.html