JDBC基本操作

配置:

官方文档地址: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-usagenotes-connect-drivermanager.html

  String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
        String DB_URL = "jdbc:mysql://localhost:3306/mydbtest";
        try {
        //    Class.forName("com.mysql.cj.jdbc.Driver");

            Class.forName(JDBC_DRIVER).newInstance();
            Properties properties = new Properties();
            properties.setProperty("user", "root");
            properties.setProperty("password", "123456");
            properties.setProperty("useSSL", "false");
            properties.setProperty("verifyServerCertificate", "false");
            properties.setProperty("serverTimezone", "UTC");
         //   Connection connection = DriverManager.getConnection(DB_URL, USER, PASS);

            Connection connection =  DriverManager.getConnection(DB_URL,properties);
            Statement statement = connection.createStatement();

            String sql;
            sql = "SELECT name, age,sex FROM person";

            ResultSet resultSet = statement.executeQuery(sql);
            while (resultSet.next()) {
                String name = resultSet.getString("name");
                String age = resultSet.getString("age");
                String sex = resultSet.getString("sex");
                System.out.println("查找结果为 " + name + ", " + age + " ," + sex);
            }
            resultSet.close();
            statement.close();
            connection.close();
        }