JDBC

1、JDBC 连接 MySql

Class.forName("com.mysql.jdbc.Driver");               //生成驱动类对象，并自动向DriverManger注册
Connection conn = DriverManger.getConnection(URL);    //获得数据库连接
Statement stmt = conn.creatStatement();               //SQL语句
ResultSet rs = stmt.execute();                        //结果集
...
close()   

MyEclipse引入驱动jar包 ： Build Path - Add External Archives

2、3种Statement

java.sql 
    接口 Statement
            所有超级接口：
                   Wrapper
            所有已知子接口：
                   CallableStatement, PreparedStatement

pstmt = conn.prepareStatement("insert into myTable values(?,?,?)");
pstmt.setInt(1,11);
pstmt.setString(2, "aa");
pstmt.setString(3, "AA");
pstmt.executeUpdate();

3、批处理语句

try {
    ......

    conn.setAutoCommit(false);
    stmt = conn.creatStatement();
    
    stmt.addBatch(sql);         //sql语句
    ......                      //sql语句
    stmt.addBatch(sql);         //sql语句
    
    stmt.executeBatch();
    conn.commit();
    conn.setAutoCommit(true);

    ......
    } catch (SQLException e){
         try {
             if(conn != null){
                 conn.rollback();
                 conn.setAutoCommit(true);
             }
          }
      }
......