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{

                          executor.update(statementname, list.get(i));

 }

//  批量添加

public void batchinsert(final string statementname, final list list) throws exception{

                          executor.insert(statementname, list.get(i));

       }