使用实体类或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都对应执⾏⼀个UPDATE语句，UPDATE语句之间⽤分号分隔（在同⼀mybatis⽅法中执⾏多个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}