阅读484 返回首页    go 阿里云 go 技术社区[云栖]

iBATIS批量操作

  

其中statementName为sql文件ID,list为参数集合

   

//  批量删除

public void batchDelete(final String statementName, final List list) throws Exception{
       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;
                   }
               });
        }

}

 

//  批量修改

public void batchUpdate(final String statementName, final List list) throws Exception{
       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;
                   }
               });
        }

 }

 

//  批量添加

public void batchInsert(final String statementName, final List list) throws Exception{
       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;
                   }
               });
       }
 }

 

原帖地址:https://blog.csdn.net/xinghui_liu/article/details/7230400

 

 

最后更新：2017-04-03 16:49:26

  上一篇：go Hibernate联合主键
  下一篇：go java中的this关键字