JDBC批处理功能

//批处理可以大幅提升增、删、改的速度
public class Batch {

	//测试
	public static void main(String[] args) throws Exception {
		//create: 5281ms
		/*long start = System.currentTimeMillis();
		for(int i=0; i < 100; i++) {
			create(i);
		}
		long end = System.currentTimeMillis();
		System.out.println("create: " + (end - start) + "ms");*/

		// createBatch: 1203ms
		/*long start = System.currentTimeMillis();
		createBatch();
		long end = System.currentTimeMillis();
		System.out.println("createBatch: " + (end - start) + "ms");*/

		//删还是很快的
		deleteBatch();
	}

	static void create(int i) throws Exception {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			// 3创建语句
			String sql = "insert into user(name, birthday, money) values(?, ?, ?)";
			ps = conn.prepareStatement(sql);
				ps.setString(1, "name" + i);
				ps.setDate(2, new Date(System.currentTimeMillis()));
				ps.setFloat(3, 100f);
				//先放到包里面去
				ps.addBatch();
			// 4.执行结果
			ps.executeUpdate();
		} finally {
			JdbcUtils.free(rs, ps, conn);
		}
	}

	static void createBatch() throws Exception {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			// 3创建语句
			String sql = "insert into user(name, birthday, money) values(?, ?, ?)";
			ps = conn.prepareStatement(sql);
			for(int i=0; i < 100; i++) {
				ps.setString(1, "name" + i);
				ps.setDate(2, new Date(System.currentTimeMillis()));
				ps.setFloat(3, 100f);
				//先放到包里面去
				ps.addBatch();
			}
			// 4.执行结果
			int[] arr = ps.executeBatch();
			System.out.println(arr);
		} finally {
			JdbcUtils.free(rs, ps, conn);
		}
	}

	static void deleteBatch() throws Exception {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			// 创建语句
			st = conn.createStatement();
			String sql = "delete from user where id > 5";

			st.addBatch(sql);
			st.executeBatch();
		} finally {
			JdbcUtils.free(rs, st, conn);
		}
	}

}