批处理的简单的案例

用于处理大量的数据

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.Test
	public 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();
	}
}