ibatis的批量存储

最新推荐文章于 2024-03-09 21:58:51 发布

iteye_17205

最新推荐文章于 2024-03-09 21:58:51 发布

阅读量122

点赞数

分类专栏：学习笔记文章标签： iBATIS

本文链接：https://blog.csdn.net/iteye_17205/article/details/81930883

版权

学习笔记专栏收录该内容

21 篇文章 0 订阅

订阅专栏

public void saveItemBatch(final List<Item> itemList, final Long catalogId) {
this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor)
throws SQLException {
executor.startBatch();
int batch = 0;
for (Item item : itemList) {
Long itemId = getId();
item.setId(itemId);
executor.insert(save, item);

Map<String, Object> map = new HashMap<String, Object>();
map.put("catalog_id", catalogId);
map.put("item_id", itemId);
map.put("score", 0);
executor.insert(saveCatalogItemLink, map);

batch++;
if (batch == 1000) {
executor.executeBatch();
batch = 0;
}
}
return executor.executeBatch();
}
});
}