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();
   }