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