JDBC批处理

/**
 * 批处理
 * @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();//将sql语句打成一个包
            }
            ps.executeBatch();//批量执行sql语句
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}