Java 最简单的批处理

import java.sql.*;

 

public class TestBatch {

     

    public static void main(String[] args) throws ClassNotFoundException, SQLException

    {

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

         

        Connection conn = DriverManager.getConnection

        ("jdbc:mysql://localhost/test","root","ZHEN");

         

        /*

        Statement stmt = conn.createStatement();  //执行静态 SQL 语句并返回它所生成结果的对象。

         

        stmt.addBatch("INSERT INTO student VALUES(30,'ddd',12,'ii')");

        stmt.addBatch("INSERT INTO student VALUES(31,'ddd',12,'ii')");

        stmt.addBatch("INSERT INTO student VALUES(32,'ddd',12,'ii')");

        stmt.addBatch("INSERT INTO student VALUES(33,'ddd',12,'ii')");

         

        stmt.executeBatch();

         

        stmt.close();

         

        */

         

        PreparedStatement pstmt =

            conn.prepareStatement("INSERT INTO student VALUES(?,?,?,?)");

         

        pstmt.setInt(1, 40);

        pstmt.setString(2,"qq");

        pstmt.setInt(3,5);

        pstmt.setString(4,"ww");

        pstmt.addBatch();

         

        pstmt.setInt(1, 41);

        pstmt.setString(2,"qq");

        pstmt.setInt(3,5);

        pstmt.setString(4,"ww");

        pstmt.addBatch();

         

        pstmt.setInt(1, 42);

        pstmt.setString(2,"qq");

        pstmt.setInt(3,5);

        pstmt.setString(4,"ww");

        pstmt.addBatch();

         

        pstmt.executeBatch();

        pstmt.close();

         

        conn.close();

         

    }

 

}