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();}}

　　

Java 最簡單的批處理