JDBC批处理

jdbc批处理示例

public class TestBatch {
	public void testBatch() throws Exception{
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/jdbc",
					"root","root");
		//statement批处理
		Statement stmt = conn.createStatement();
		stmt.addBatch("insert into bank values(10001,'李四',20000)");
		stmt.addBatch("insert into bank values(10002,'王五',30000)");
		stmt.executeBatch();
		//preparedStatement批处理
		String sql = "insert into bank values(?, ?, ?)";
		PreparedStatement pstmt = conn.prepareStatement(sql);
		
		pstmt.setInt(1, 10001);
		pstmt.setString(2, "李四");
		pstmt.setInt(3, 20000);
		pstmt.addBatch();
		
		pstmt.setInt(1, 10002);
		pstmt.setString(2, "王五");
		pstmt.setInt(3, 30000);
		pstmt.addBatch();
		
		pstmt.executeBatch();
		
		stmt.close();
		pstmt.close();
		conn.close();
	}
}