@Transactional(propagation = Propagation.MANDATORY)
public Long createTempList(final Long listId, final Collection<? extends BaseEntity> list) {
Assert.notNull(listId);
Assert.isTrue(CollectionUtils.isNotEmpty(list));
// creates a new local temporary table if it doesn't exists to handle temporary lists
getJdbcTemplate().update(createTemporaryListQuery);
// fills in a temporary list by given values
int i = 0;
final Iterator<? extends BaseEntity> iterator = list.iterator();
final MapSqlParameterSource[] batchArgs = new MapSqlParameterSource[list.size()];
while (iterator.hasNext()) {
MapSqlParameterSource params = new MapSqlParameterSource();
params.addValue(HelperParameters.LIST_ID.name(), listId);
params.addValue(HelperParameters.LIST_VALUE.name(), iterator.next().getId());
batchArgs[i] = params;
i++;
}
getNamedParameterJdbcTemplate().batchUpdate(insertTemporaryListItemQuery, batchArgs);
return listId;
}
DaoHelper.java 文件源码
java
阅读 30
收藏 0
点赞 0
评论 0
项目:NGB-master
作者:
评论列表
文章目录