Mybatis多条件批量查询

最新推荐文章于 2023-11-09 10:51:45 发布

跌入凡尘的张公子

最新推荐文章于 2023-11-09 10:51:45 发布

阅读量183

点赞数

文章标签： mybatis windows java mysql

本文链接：https://blog.csdn.net/zh555888/article/details/133123835

版权

请求参数如下：

{
    "list": [
        {
            "supplierCode": "M10143",
            "sendPlaceCode": "A1"
        },
        {
            "supplierCode": "M10155",
            "sendPlaceCode": "A1"
        }
    ],
    "__menuName": ""
}

service层：

@Override
    @PMethodHandle(runMethodName = "checkSupplierSendChange")
    public EntityResult checkSupplierSendChangeQuery(Map<String, Object> paraMap) {
        if (ObjectUtils.isEmpty(paraMap.get("list"))) throw new BusicenException("参数为空");
        List<Map> list = JSON.parseArray(JSON.toJSONString((List<Map<String, Object>>) paraMap.get("list")), Map.class);
        List<Map<String, String>> res = iTmDbSupplierSendPlaceMapperBase.checkSupplierSendChangeQuery(list);
        return ResultHandler.operOk(res);
    }

Dao层：

List<Map<String,String>>  checkSupplierSendChangeQuery(@Param("list") List<Map> list);

Xml：

 <select id="checkSupplierSendChangeQuery" resultType="java.util.Map">
            select
            distinct
            SUPPLIER_CODE,
            SEND_PLACE_CODE
            from t_sc_tm_db_supplier_part
            where
        <foreach collection="list" item="map" open="(" close=")" separator="or">
             SUPPLIER_CODE =#{map.supplierCode} and SEND_PLACE_CODE =#{map.sendPlaceCode}
        </foreach>
    </select>