jdbc

jdbc ===Java Database Connection

jdbc的三个核心API是：Connection、statement、resultSet及类DriverManager

jdbc的操作步骤：

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try {
      //1.构造驱动
      Class.forName(driver);
      //2.获得连接
      conn = DriverManager.getConnection(url, dbUser, dbPassword);
      //3.构造stmt对象
      stmt = conn.createStatement();
      //4.执行sql语句
      String sql = "select ename from emp";

       //获取结果集
      rs = stmt.executeQuery(sql);
      //5.操作结果集
      while (rs.next()){
        System.out.println(rs.getString("ename"));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally{
      //6.关闭资源
      try{
        rs.close();
        stmt.close();
        conn.close();
      }catch(Exception e){
        e.printStackTrace();
      }
    }