ibatis 批量操作数据 -

alargon

浏览: 28008 次
性别:
来自: 成都

最近访客更多访客>>

kofboboangelk1

JuMin

wsndng

李登春

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

ibatis 批量操作数据

public void batchUpdate( final String statementName, final List list) {
       try {
           if (list != null ) {
              this .getSqlMapClientTemplate().execute( new SqlMapClientCallback() {
                  public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
                     executor.startBatch();
                     for ( int i = 0, n = list.size(); i < n; i++) {
                         executor.update(statementName, list.get(i));
                     }
                     executor.executeBatch();
                     return null ;
                  }
              });
           }
       } catch (Exception e) {
           if ( log .isDebugEnabled()) {
              e.printStackTrace();
              log .debug( "batchUpdate error: id [" + statementName + "], parameterObject [" + list + "]. Cause: " + e.getMessage());
           }
       }

    }
    public void batchInsert( final String statementName, final List list) {
       try {
           if (list != null ) {
              this .getSqlMapClientTemplate().execute( new SqlMapClientCallback() {
                  public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
                     executor.startBatch();
                     for ( int i = 0, n = list.size(); i < n; i++) {
                         executor.insert(statementName, list.get(i));
                     }
                     executor.executeBatch();
                     return null ;
                  }
              });
           }
       } catch (Exception e) {
           if ( log .isDebugEnabled()) {
              e.printStackTrace();
              log .debug( "batchInsert error: id [" + statementName + "], parameterObject [" + list + "]. Cause: " + e.getMessage());
           }
       }

    }
    public void batchDelete( final String statementName, final List list) {
       try {
           if (list != null ) {
              this .getSqlMapClientTemplate().execute( new SqlMapClientCallback() {
                  public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
                     executor.startBatch();
                     for ( int i = 0, n = list.size(); i < n; i++) {
                         executor.delete(statementName, list.get(i));
                     }
                     executor.executeBatch();
                     return null ;
                  }
              });
           }
       } catch (Exception e) {
           if ( log .isDebugEnabled()) {
              e.printStackTrace();
              log .debug( "batchDelete error: id [" + statementName + "], parameterObject [" + list + "]. Cause: " + e.getMessage());
           }
       }

    }

分享到：