使用JDBC的批处理功能

package cn.itcast.jdbc;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BatchTest {

    public static void main(String[] args) throws SQLException {
        /*for (int i = 0; i < 1000; i++) {
            create(i);
        }*/
        createBatch();
    }

    static int create(int i) throws SQLException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            conn = jdbcUtils.getConnection();

            String sql = "insert into user(name,birthday,money) values(?,?,?)";

            ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, "name" + i);
            ps.setDate(2, (java.sql.Date) new Date(System.currentTimeMillis()));
            ps.setFloat(3, 1000F + i);

            ps.executeUpdate();

            rs = ps.getGeneratedKeys();
            int id = 0;

            if (rs.next())
                id = rs.getInt(1);

            return id;

        } finally {
            jdbcUtils.free(rs, ps, conn);
        }
    }

    static void createBatch() throws SQLException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            conn = jdbcUtils.getConnection();

            String sql = "insert into user(name,birthday,money) values(?,?,?)";

            ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);

            for (int i = 0; i < 1000; i++) {
                ps.setString(1, "name" + i);
                ps.setDate(2, new Date(System.currentTimeMillis()));
                ps.setFloat(3, 1000F + i);

                ps.addBatch();
            }

            int[] is = ps.executeBatch();

        } finally {
            jdbcUtils.free(rs, ps, conn);
        }
    }

}