使用JDBC操作数据库的六部曲

  要使用JDBC操作Mysql首先要导入JDBC_Mysql的驱动，maven导入如下：

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>

  接下来就可以操作Mysql数据库了：

		String uri = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=UTF-8&useSSL=false";
        String user = "root";
        String password = "123456";
        Connection con = null;

        //1.加载驱动
        try{  Class.forName("com.mysql.jdbc.Driver"); //加载JDBC_MySQL驱动
        }
        catch(Exception e){}

        //2.连接数据库
        try{
            con = DriverManager.getConnection(uri,user,password); //连接代码
        }
        catch(SQLException e){}
        //3.向数据库发送sql的对象Statement:CRUD
        Statement statement = con.createStatement();

        //4.编写sql语句
        String sql = "select * from users";

        //5.执行sql语句
        ResultSet rs = statement.executeQuery(sql);

        while (rs.next()){
            System.out.println("id="+rs.getObject("id"));
            System.out.println("name="+rs.getObject("name"));
            System.out.println("password="+rs.getObject("password"));
            System.out.println("email="+rs.getObject("email"));
            System.out.println("birthday="+rs.getObject("birthday"));

        }
        //6.关闭连接，释放资源（一定要做），先打开的后关闭，后打开的先关闭
        rs.close();
        statement.close();
        con.close();