JDBC 批处理

最新推荐文章于 2025-09-08 20:55:49 发布

weixin_30535167

最新推荐文章于 2025-09-08 20:55:49 发布

阅读量59

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/flying607/p/3462315.html

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);
        }
    }
}

转载于:https://www.cnblogs.com/flying607/p/3462315.html