package jdbcday04;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/*
* 插入1W条数据
*/
public class JdbcInsert {
public static void main(String[] args) {
Connection conn = null;
boolean autoCommit = false;
try {
conn = JdbcUtil.getConn();
autoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
String sql = "insert into gjxfj(username,password,email,phone) values(?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
for(int i=0;i<10000;i++){
pstmt.setString(1, "用户"+i);
pstmt.setString(2,"密码"+i);
pstmt.setString(3,"邮箱"+i);
pstmt.setString(4,"电话"+i);
//添加到语句列表
pstmt.addBatch();
if (i%70 == 0) {
//每70条数据执行一次
pstmt.executeBatch();
//清除语句列表数据
pstmt.clearBatch();
}
}
//把剩下的没执行的数据执行
pstmt.executeBatch();
//提交
conn.commit();
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException