private void updateGroup() {
String sql = "update um_group set pid=:pid where group_id=:id";
CompiledSQL cs = tm.getCompiledSQLBuilder().buildCompiledSQL(
User.class, sql);
cs.addParamType("pid", "int");
cs.addParamType("id", "int");
WriteTranSession session = tm.openRWTran(false);
try {
SQLBatcher batcher = session.createCompiledSQLBatcher(cs);
batcher.setBatchSize(80);
for (int i = 0; i < groups.size(); i++) {
Map g = groups.get(i);
HashMap params = new HashMap();
params.put("pid", Util.o2l(g.get("pid")));
params.put("id", Util.o2l(g.get("id")));
batcher.addNewBatchParams(params);
}
batcher.executeBatch();
session.commit();
} finally {
session.close();
}
}
转载于:https://my.oschina.net/webas/blog/108534