JDBC连接MySQL

• jdbc8.0.13连接MySQL的 
• 导入jar包mysql-connector-java-8.0.13.jar

    public static Connection getConnection(){
        Connection conn=null;
        try {
            //ppp是数据库名称
            String URL = "jdbc:mysql://localhost:3306/ppp?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT";
            String USER = "root";
            String PASSWORD = "hyy5201314";
            //1.加载驱动程序
            Class.forName("com.mysql.cj.jdbc.Driver");
            //2.获得数据库链接
            conn= DriverManager.getConnection(URL, USER, PASSWORD);
        }catch (SQLException e) {
            e.printStackTrace();
        }catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void CloseConn(Connection conn){
        try {
            if (conn!=null){
                conn.close();
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
    public void findMaster(Person person) {
        Connection conne = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        String sql = "SELECT * FROM people";

        try {
            conne = getConnection();

            // 建立了到特定数据库的连接之后，就可用该连接发送 SQL 语句。
            pstmt = conne.prepareStatement(sql);
            rs = pstmt.executeQuery();

            if (rs.next()) {
                String id=rs.getString("id");
                String name=rs.getString("name");
                String password=rs.getString("password");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            CloseConn(conne);
        }
    }