jdbc执行批处理②

BatchAdvanceDemo.java :

public class BatchAdvanceDemo {

	public static void main(String[] args) {
		batch();
	}
	
	public static void batch(){
		Connection conn=null;
		PreparedStatement pstmt=null;
		String sql="insert into mytemp values(?,?)";
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn=DriverManager.
					getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
			conn.setAutoCommit(false);
			pstmt=conn.prepareStatement(sql);
			for(int i=1;i<=100076;i++){
				pstmt.setInt(1,i);
				pstmt.setString(2,"value"+i);
				pstmt.addBatch();
				if(i%1000==0){
					pstmt.executeBatch();
				}
			}
			pstmt.executeBatch();
			conn.commit();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			//关闭stmt和conn
		}
		
	}

}