使用實(shí)體類或Map類型的List作為mybatis參數(shù)

使?實(shí)體類或Map類型的List作為mybatis參數(shù)案例?：保存List<Stock>數(shù)據(jù)Inventory（盤庫指令）中有倉(cāng)庫列表屬性List<Stock>以及盤庫編碼屬性invCode,其中Stock中有id、stockCode、stockName、bscCode屬性，向數(shù)據(jù)庫中保存盤庫指令對(duì)應(yīng)的倉(cāng)庫列表關(guān)系時(shí)，映射?件內(nèi)容如下，其中該?法接收的參數(shù)為Inventory實(shí)體類<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>傳遞數(shù)據(jù)更新車輛信息應(yīng)?背景為：接?接收List<Map>類型的數(shù)據(jù)，Map中存放的是車輛信息，根據(jù)車輛信息中的id更新數(shù)據(jù)庫中的車輛信息數(shù)據(jù)。直接貼上映射?件的?法的代碼，該?法接收的參數(shù)為L(zhǎng)ist<Map>數(shù)據(jù)：效果就是每?個(gè)Map都對(duì)應(yīng)執(zhí)??個(gè)UPDATE語句，UPDATE語句之間?分號(hào)分隔（在同?mybatis?法中執(zhí)?多個(gè)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}