使用實體類或Map類型的List作為mybatis參數

使?實體類或Map類型的List作為mybatis參數案例?：保存List<Stock>數據Inventory（盤庫指令）中有倉庫列表屬性List<Stock>以及盤庫編碼屬性invCode,其中Stock中有id、stockCode、stockName、bscCode屬性，向數據庫中保存盤庫指令對應的倉庫列表關系時，映射?件內容如下，其中該?法接收的參數為Inventory實體類<insertid="saveInvStockList">INSERTINTOqk_yw_pk_stock(pkcode,stockid,stockcode,stockname,rwjxscode,bsccode)<foreachcollection="stockList"item="stock"separator="unionall">SELECT#{invCode},#{stock.id},#{stock.stockCode},#{stock.stockName},#{stock.rwjxsCode},#{stock.bscCode}FROMdual</foreach></insert>案例?：使?List<Map>傳遞數據更新車輛信息應?背景為：接?接收List<Map>類型的數據，Map中存放的是車輛信息，根據車輛信息中的id更新數據庫中的車輛信息數據。直接貼上映射?件的?法的代碼，該?法接收的參數為List<Map>數據：效果就是每?個Map都對應執(zhí)??個UPDATE語句，UPDATE語句之間?分號分隔（在同?mybatis?法中執(zhí)?多個sql語句，需要將jdbc配置中加上allowMultiQueries=true，如下：url:jdbc:mysql://10.2.29.146:3306/ms_inventory?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&allowMultiQueries=true）<updateid="updateTrucks"parameterType="Map"><foreachcollection="trucks"item="truck"separator=";">UPDATEqk_yw_pk_trucksSET<iftest="truck.containsKey('truckid')">truckid=#{truck.truckid},</if><iftest="truck.containsKey('clzt')">clzt=#{truck.clzt},</if><iftest="truck.containsKey('xsdid')">xsdid=#{truck.xsdid},</if><iftest="truck.containsKey('xsdh')">xsdh=#{truck.xsdh},</if><iftest="truck.containsKey('xszt')">xszt=#{truck.xszt},</if><iftest="truck.containsKey('cxh')">cxh=#{truck.cxh},</if><iftest="truck.containsKey('ywms')">ywms=#{truck.ywms},</if><iftest="truck.containsKey('stockid')">stockid=#{truck.stockid},</if><iftest="truck.containsKey('stockcode')">stockcode=#{truck.stockcode},</if><iftest="truck.containsKey('stockname')">stockname=#{truck.stockname},</if><iftest="truck.containsKey('bscid')">bscid=#{truck.bscid},</if><iftest="truck.containsKey('bsccode')">bsccode=#{truck.bsccode},</if><iftest="truck.containsKey('bscname')">bscname=#{truck.bscname},</if><iftest="truck.containsKey('rwjxsid')">rwjxsid=#{truck.rwjxsid},</if><iftest="truck.containsKey('rwjxscode')">rwjxscode=#{truck.rwjxscode},</if><iftest="truck.containsKey('rwjxsjc')">rwjxsjc=#{truck.rwjxsjc},</if><iftest="truck.containsKey('truck_create_date')"><choose><whentest="truck.truck_create_date==''">truck_create_date=null,</when><otherwise>truck_create_date=#{truck.truck_create_date},</otherwise></choose></if><iftest="truck.containsKey('truck_jnck_date')"><choose><whentest="truck.truck_jnck_date==''">truck_jnck_date=null,</when><otherwise>truck_jnck_date=#{truck.truck_jnck_date},</otherwise></choose></if><iftest="truck.containsKey('truck_zsck_date')"><choose><whentest="truck.truck_zsck_date==''">truck_zsck_date=null,</when><otherwise>truck_zsck_date=#{truck.truck_zsck_date},</otherwise></choose></if><iftest="truck.containsKey('truck_md_date')"><choose><whentest="truck.truck_md_date==''">truck_md_date=null,</when><otherwise>truck_md_date=#{truck.truck_md_date},</otherwise></choose></if><iftest="truck.containsKey('truck_sx_date')"><choose><whentest="truck.truck_sx_date==''">truck_sx_date=null,</when><otherwise>truck_sx_date=#{truck.truck_sx_date}