Mybatis使用foreach查询参数为List<Map>的查询

一、mapper.xml文件

<!--微服务接口-查询雇员银行卡信息-->
 <select id="queryEmpBankInfoList" resultType="hashmap" parameterType="java.util.Map">
   select t2.NAME,t2.ID_CARD,t1.*
   from emp_bank_card t1
    left join emp_info t2 on t1.emp_id = t2.id
    <where>
      1=1
     <if test="list != null and list.size>0">
        and (t1.CUS_ID,t2.ID_CARD) in
      <foreach collection="list" index="index" item="item" open=("separator=","close=")"  >
          (#{item.cusId},#{item.identityNum})
      </foreach>
     </if>
   </where>
 </select>

二、mapper

 /**
   *微服务接口-查询雇员银行卡信息
   * @param list
   * @return
 */
 List<Map<String,Object>> queryEmpBankInfoList(List<Map<String,Object>> list);

三、service层和impl

    //根据客户id和雇员证件号码
    List<Map<String,Object>> getEmpBankInfo(List<Map<String,Object>> list);



    @Override
    public List<Map<String,Object>> getEmpBankInfo(List<Map<String,Object>> list) {
        List<Map<String, Object>> retMap = baseMapper.queryEmpBankInfoList(list);
        return retMap;
    }

四、controller层

    @PostMapping("/get-empbank-by-idcard")
    @ApiOperation("接口-根据客户id和雇员证件号码查询雇员银行卡信息")
    @ResponseBody
    public R getEmpBankByCusIdAndIdCard(@RequestBody List<Map<String,Object>> list){
        return new R(iEmpBankCardService.getEmpBankInfo(list));
    }

五、前端json格式参数：

[
    {"identityNum":"110108196606228528", "cusId":"1248138531219668994"},
    {"identityNum":"510521198202231882", "cusId":"1248138531219668994"},
    {"identityNum":"110109198512310024", "cusId":"1248138531219668994"},
    {"identityNum":"130323198611172650", "cusId":"1248138531219668994"}
]

六、postMan测试