// 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>