ibatis的批量处理数据处理

/**

1000条去数据库修改一次

     * update.
     * @param cloundSign cloundSign
     * @throws DataAccessException DataAccessException
     * 批量更新
     * @throws SQLException 
     */
    public void updateCloundSignBatch(final List<CloundSign> clList) throws DataAccessException, SQLException {
		if (logger.isDebugEnabled()) {
    		logger.debug("进入updateCloundSignBatch, 输入参数[" + clList + "]");
		}
		/*this.getSqlMapClient().startBatch();
		for (CloundSign cloundSign : clList) {
			this.getSqlMapClientTemplate().update(
					"CloundSign_updateCloundSign", cloundSign);
		}*/
		getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
			public Object doInSqlMapClient(SqlMapExecutor executor)
					throws SQLException {
				executor.startBatch();
				int batchCommit = 0;
				for (CloundSign clound : clList) {
					executor.update("CloundSign_updateCloundSign", clound);
					batchCommit++;
					if (batchCommit >= 1000) {
						executor.executeBatch();
						batchCommit = 0;
					}
				}
				if (batchCommit != 0) {
					executor.executeBatch();
				}
				return null;
			}
		});
		this.getSqlMapClient().executeBatch();
		if (logger.isDebugEnabled()) {
    		logger.debug("离开updateCloundSignBatch");
		}
    }