IBATIS 批量更改操作

  // service 层

   for (int i = 0; i < vmIds.size(); i++) {
    id = vmIds.get(i).toString();

    // 1. 修改表中的状态为 operating
    virtualMachineManagementDAO .updateVmStateAfterVMOperationByVMId(id, "operating");
 }

 

// DAO 层

 public void updateVmStateAfterVMOperationByVMId(String id, String state) {
   Map<String, String> paramMap = new HashMap<String, String>();
  paramMap.put("vmId", id);
  paramMap.put("state", state);
  this.sqlMapClientTemplate.update("updateVmStateAfterVMOperationByVMId", paramMap);
  }

 

//ibatis配置

<update id="updateVmStateAfterVMOperationByVMId" parameterClass="java.util.Map">
  <![CDATA[
   UPDATE VIRTUALMACHINE SET STATE = #state# WHERE VMID = #vmId#
  ]]>
 </update>