JDBC 批處理

劍握在手發表於2013-12-06

public class BatchTest {

    /**
     * @param args
     * @throws SQLException
     */
    public static void main(String[] args) throws SQLException {
        long start = System.currentTimeMillis();
        for (int i = 0; i < 100; i++)
            create(i);
        long end = System.currentTimeMillis();
        System.out.println("create:" + (end - start));

        start = System.currentTimeMillis();
        createBatch();
        end = System.currentTimeMillis();
        System.out.println("createBatch:" + (end - start));
    }

    static void 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, "no batch name" + i);
            ps.setDate(2, new Date(System.currentTimeMillis()));
            ps.setFloat(3, 100f + i);

            ps.executeUpdate();
        } 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 < 100; i++) {
                ps.setString(1, "batch name" + i);
                ps.setDate(2, new Date(System.currentTimeMillis()));
                ps.setFloat(3, 100f + i);

                ps.addBatch();//sql語句封包一起傳送到資料庫伺服器
            }
            int[] is = ps.executeBatch();
        } finally {
            JdbcUtils.free(rs, ps, conn);
        }
    }
}

相關文章