使用JDBC方式连接MySQL数据库

假如存在一张表，表结构是这样婶儿的：

id	code	name
1001	code01	name01
1002	code02	name02

使用JDBC方式简单的查询下这张表，代码如下：

public static void main(String[] args) {
        Connection connection = null;
        PreparedStatement ps = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "user", "password");

            String sql = "select * from test_user";

            ps = connection.prepareStatement(sql);
            ps.execute(sql);
            ResultSet rs = ps.getResultSet();
            int length = 4;
            while (rs.next()) {
                for (int i = 1; i < length; i++) {
                    System.out.print(rs.getString(i) + "\t");
                    if (i + 1 == length)
                        System.out.println();
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (!connection.isClosed()) {
                    connection.close();
                }
                if (!ps.isClosed()) {
                    ps.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }