mybatis 批量拆入，mapper 每次commit 1000

由于使用union all oracle ,超长会报错，所以采用SqlSessionTemplate动态获取mapper,
然后每次循环1000条插入数据库，参考Url
http://www.tuicool.com/articles/mEFb6zq

http://www.tuicool.com/articles/E3ARBzI

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory"/>
</bean>

Service 层注注入SqlSessionTemplate, 因为没有dao层。所以动态获取Mapper，单笔插入数据库。

@Resource
private SqlSessionTemplate sqlSessionPS;


SqlSession session = sqlSessionPS.getSqlSessionFactory().openSession( ExecutorType.BATCH, false);
//通过新的session获取mapper
InstCheckSettlementDetailMapper instDetailMapper = session.getMapper(InstCheckSettlementDetailMapper.class);
int size = list.size();
try {
for (int i = 0; i < size; i++) {
TtCheckSettlementDetail dtl= list.get(i);
instDetailMapper.insertCheckSettlementDtlOne(dtl);
if (i % 1000 == 0 || i == size - 1) {
//手动每1000个一提交，提交后无法回滚
session.commit();
//清理缓存，防止溢出
session.clearCache();
}
}
} catch (Exception e) {
//没有提交的数据可以回滚
session.rollback();
} finally {
session.close();
}