批处理

package DataBaseTest;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class Batch {/** * @2013/2/11 * @param args */private static final String DBURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=db_test"; // 数据库协议private static final String username = "sa"; // 姓名private static final String password = "lao"; // 密码public static void main(String[] args) throws Exception{// TODO Auto-generated method stubConnection conn = null;// 连接PreparedStatement pstmt = null;// 数据库操作ResultSet rs = null;// 查询String sql1="insert into tb_batch(id,name,age,date) values(?,?,?,?)";String sql="select id,name,age,date from tb_batch";conn=DriverManager.getConnection(DBURL,username,password);pstmt=conn.prepareStatement(sql1);for(int i=0;i<=10;i++){pstmt.setInt(1, i);pstmt.setString(2, "张三—"+i);pstmt.setInt(3, 20+i);pstmt.setDate(4, new java.sql.Date(new java.util.Date().getTime()));pstmt.addBatch();//加入批处理，等待执行}int temp[]=pstmt.executeBatch();//执行批处理System.out.println("处理了"+temp.length +"条记录");pstmt=conn.prepareStatement(sql);rs=pstmt.executeQuery();while(rs.next()){int id=rs.getInt(1);String name=rs.getString(2);int age=rs.getInt(3);java.util.Date date=rs.getDate(4);System.out.print("id:"+id);System.out.print("name:"+name);System.out.print("age:"+age);System.out.print("date:"+date);System.out.println("-------------------------------");}}}