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

柔情只为你懂 2023-07-25 14:18 17阅读 0赞

一、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测试

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Rhbmd5aW5fMDA3_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Rhbmd5aW5fMDA3_size_16_color_FFFFFF_t_70]: /images/20230528/d7ccaeaf5ee2430fb9efe0f5a5acfe74.png