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