JDBC连接MySQL数据库流程步骤

1. 加载驱动

   Class.forName("com.mysql.jdbc.Driver");

2. 创建数据库连接对象

   String url = "jdbc:mysql://127.0.0.1:3306/myschool";
   Connection conn = DriverManager.getConnection(url,"root","xxxx");

3. 编写sql语句

   String sql = " select * from student ";

4. 创建语句执行者对象

   Statement stat = conn.createStatement();

5. 执行sql语句

   ResultSet rs = stat.executeQuery(sql);// 执行查询语句    executeUpdate():增 删 改

    

6. 遍历结果集

    while(rs.next()){ //如果rs里面有数据就会一直循环
                    // 从rs中获取数据
       int studentNo = rs.getInt("StudentNo");//学生编号
       String studentName = rs.getString("StudentName");//学生姓名
       String phone = rs.getString("phone");//手机号
       String address = rs.getString("address");//地址
       System.out.println(studentNo+"\t"+studentName+"\t"+phone+"\t"+address);
    }

    

7. 关流

   try {
                   if (rs != null){
                       rs.close();
                   }
                   if (stat != null){
                       stat.close();
                   }
                   if (conn != null){
                       conn.close();
                   }
               } catch (SQLException throwables) {
                   throwables.printStackTrace();
               }