//批处理可以大幅提升增、删、改的速度
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);
}
}
}
JDBC批处理功能
最新推荐文章于 2024-06-29 08:00:00 发布