直接上例子:
package com.dsp.batch;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
import org.junit.Test;
import com.dsp.util.JdbcUtil;
public class BatchDemo1 {
/**
* 当 sql 语句不同时用 statement
* @throws Exception
*/
@Test
public void updatetest() throws Exception {
Connection conn = null;
conn = JdbcUtil.getConnection();
Statement stat = conn.createStatement();
String sql = "update users set name='spdai' where id=1";
String sql1 = "insert into users(name,password,email,birthday) value('bbb','ccc','dd@s.com','2015-08-09')";
stat.addBatch(sql1);
stat.addBatch(sql);
int[] aa = stat.executeBatch();
for (int i : aa)
System.out.println(i);
JdbcUtil.release(null, stat, conn);
}
@Test
public void test2() throws Exception{
Connection conn = null;
conn = JdbcUtil.getConnection();
PreparedStatement stat = conn.prepareStatement("insert into users(name,password,email,birthday) value(?,?,?,?)");
for(int i=0;i<10;i++){
stat.setString(1, "spdai"+i);
stat.setString(2, "aa");
stat.setString(3, "aa@b.com");
stat.setString(4, "2015-01-09");
stat.addBatch();
}
int[] aa = stat.executeBatch();
for (int i : aa)
System.out.println(i);
JdbcUtil.release(null, stat, conn);
}
@Test
public void test3() throws Exception{
Connection conn = null;
conn = JdbcUtil.getConnection();
PreparedStatement stat = conn.prepareStatement("insert into users(name,password,email,birthday) value(?,?,?,?)");
for(int i=0;i<1000;i++){
stat.setString(1, "spdai"+i);
stat.setString(2, "aa");
stat.setString(3, "aa@b.com");
stat.setString(4, "2015-01-09");
stat.addBatch();
if (i%100==0) {//如果是大数据的导入还是分批导入毕竟是先把数据放到内存如何在一次导入数据库,如果数据量很多 内存会溢出
int[] aa = stat.executeBatch();
for (int j : aa)
{
System.out.println(i+j);
}
stat.clearBatch();
}
}
JdbcUtil.release(null, stat, conn);
}
}