`
石头的日记
  • 浏览: 199017 次
  • 性别: Icon_minigender_1
  • 来自: 北京
文章分类
社区版块
存档分类

Ibatis 批量添加修改删除-batch-insert-update-delete

iBATISPHPHTML
阅读更多

转载出处:http://www.javadn.com/read.php?tid-790.html

 

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

    }

分享到：
| ubantu 输入法设置
评论
1 楼 wang4674890 2011-11-07  
天下文章一般抄！
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics