//本例使用Statement的addBatch方法和executeBatch方法实现批处理。当然PreparedStatement也可以实现,不过就显得麻烦了
import java.sql.* ;
public class BatchTest {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT","scott","tiger");
stmt = conn.createStatement();
stmt.addBatch("insert into dept values (1001,'GAME','BJ')");
stmt.addBatch("insert into dept values (1002,'SPORTS','SH')");
stmt.addBatch("insert into dept values (1003,'GAME','CD')");
stmt.executeBatch(); //一次执行上面的所有sql语句
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e) {
e.printStackTrace();
}
finally {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
}
catch(SQLException e) {
e.printStackTrace();
}
}
}
}