Discuss / Java / 代码是如何实现batch落库的呢?

代码是如何实现batch落库的呢?

Topic source
for (T bean : beans) {    doInsert(bean, false);}

这边看源码,是循环入库的,是否这样会损失性能?

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

你优化成

    for (T bean : beans) {
        ps.setString(1, ...);
        ps.setBoolean(2, ...);
        ps.addBatch();
    }
    int[] ns = ps.executeBatch();

  • 1

Reply