/**
* 批处理
* @author John
*
*/
public class BatchDeal {
@Test
public void createbacth(){
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
JDBCUtils utils = JDBCUtils.getInstance();
try {
conn=utils.getConnection();
String sql = "insert into user(username,password,sex,age) values (?,?,?,?)";
ps = conn.prepareStatement(sql);
for(int i=0;i<1000;i++){
ps.setString(1, "name"+i);
ps.setString(2, i+"");
ps.setInt(3, i%2==0?0:1);
ps.setInt(4, i%2!=0?18:19);
ps.addBatch();
}
ps.executeBatch();
} catch (SQLException e) {
e.printStackTrace();
}
}
}