/**
  * 設(shè)置數(shù)據(jù)庫是否自動(dòng)提交事務(wù)
  * @param flag
  * @throws SQLException
  */
 public void setAutoCommit(boolean flag) throws SQLException {
  con.setAutoCommit(flag);
 }
 
 /**
  * 提交
  * @throws SQLException
  */
 public void commit() throws SQLException {
  con.commit();
 }
 
 /**
  * 回滾
  * @throws SQLException
  */
 public void rollback() throws SQLException {
  con.rollback();
 }

List<OrdLogSyn> ordLogSynList = ordLogSynMapper.batchQuery("AP", "20190926", "0", "1000");
  for (int i = 0; i < 2; i++) {
   DefaultTransactionDefinition def = new DefaultTransactionDefinition();
   def.setPropagationBehavior(DefaultTransactionDefinition.PROPAGATION_REQUIRES_NEW);
   TransactionStatus status = platformTransactionManager.getTransaction(def);
   List<OrdLogSyn> subList = null;
   if (i==0){
    subList = ordLogSynList.subList(0, 500);
   }else if (i==1){
    subList = ordLogSynList.subList(501, 1000);
   }
   for (OrdLogSyn ordLogSyn : subList) {
    int q = ordLogSynMapper.updateChkFlag(ordLogSyn.getConfirmSeqId(), ordLogSyn.getAcctDate(), "I");
    System.out.println("q = " + q);
   }
   platformTransactionManager.commit(status);
 
  }