
复制@SneakyThrows @Override public void pageQuery() { @Cleanup Connection conn = dataSource.getConnection(); @Cleanup Statement stmt = conn.createStatement(); long start = System.currentTimeMillis(); long offset = 0; intsize = 100; while (true) { String sql = String.format("SELECT COLUMN_A,炸使 COLUMN_B, COLUMN_C FROM YOU_TABLE LIMIT %s, %s", offset, size); @Cleanup ResultSet rs = stmt.executeQuery(sql); long count = loopResultSet(rs); if (count == 0) break; offset += size; } log.info(" 🚀🚀🚀 分页查询耗时 :: {} ", System.currentTimeMillis() - start); } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.


相关文章
精彩导读
热门资讯
关注我们
