JDBC批处理代码

/**
     * 批处理
     */
    @org.junit.Test
    public void test1() {
        try {
            long start_millis = System.currentTimeMillis();
    //      conn.setAutoCommit(false);
            Statement statement = conn.createStatement();
            String sql = "";
            int gender = 1;
            for (int i = 0; i < 500000; i++) {
                if (i % 2 == 0) {
                    sql = "INSERT INTO `user` VALUES (" + i + ",'name" + i+"'" + ",'pwd" + i+"'" + "," + i + "," + 1 + ")";
                } else {
                    sql = "INSERT INTO `user` VALUES (" + i + ",'name" + i+"'" + ",'pwd" + i+"'" + "," + i + "," + 2 + ")";
                }
                statement.addBatch(sql);
                if (i % 1000 == 0) {
                    int[] count = statement.executeBatch();
                    System.out.println("计数是:" + count[0]);
                    statement.clearBatch();
                }
            }
//          conn.commit();
            long end_millis = System.currentTimeMillis();
            System.out.println("共计时间为:"+(end_millis-start_millis));
        } catch (Exception e) {
            try {
                conn.rollback();
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
        }
    }

表结构
id int 11 0 0 -1 0 0 0 0 -1 0
user_name varchar 20 0 0 0 0 0 0 0 utf8 utf8_general_ci 0 0
password varchar 20 0 0 0 0 0 0 0 utf8 utf8_general_ci 0 0
age int 11 0 -1 0 0 0 0 0 0 0
gender tinyint 1 0 0 0 0 0 0 0 0 0

“`