批处理的简单的案例

用于处理大量的数据

package cn.et;import java.util.List;import java.sql.Connection;import java.sql.PreparedStatement;import java.util.ArrayList;public class Test {public String name;public String dloc;static List<Test> l=new ArrayList<>();//把对象添加到集合中static {Test d = null;for (int i = 0; i < 5; i++) {d = new Test();d.name = "ss" + i;d.dloc = "ee" + i;l.add(d);}}@org.junit.Testpublic void ff() throws Exception{int next=1;String sql="insert into dept values(?,?,?)";Connection conn=OracleDbUtil.getConnection();PreparedStatement ps=conn.prepareStatement(sql);for(int i=0;i<l.size();i++){Test u=l.get(i);next=next+1;ps.setInt(1, next);ps.setString(2, u.name);ps.setString(3, u.dloc);ps.addBatch();//避免值覆盖  将数据打包}int[] r=ps.executeBatch();ps.close();conn.close();}}