Java 最简单的批处理

当前位置:
首页 > 编程开发 > 批处理教程 >

Java 最简单的批处理
批处理Batch && PreparedStatement :
		
								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();

								    }

								}
　　出处：https://www.cnblogs.com/sunxun/p/4701808.html
栏目列表