myBatisPlus组合条件查询

最新推荐文章于 2024-09-06 08:00:00 发布

人约黄昏月

最新推荐文章于 2024-09-06 08:00:00 发布

阅读量680

点赞数

文章标签： spring

本文链接：https://blog.csdn.net/baidu_41909845/article/details/121212103

版权

本文介绍了如何使用myBatisPlus在mapper.java层和Controller层进行组合条件查询，详细解析了在Spring环境中实现这一功能的步骤和关键代码。

摘要由CSDN通过智能技术生成

mapper.java层代码

@Select("<script>" +
        "select p.* " +
        " from PropertyCostInfo p, RoomInfo r, Layer l, Building b" +
        " where 1=1 and  b.B_id = l.L_bid and l.L_id= r.R_lid and p.Pc_rid=r.R_address " +
        " <if test='buildId != null and buildId > 0'>" +
        " AND b.B_id=#{buildId}" +
        " </if>" +
        " <if test='layerId != null and layerId > 0'>" +
        " AND l.L_id=#{layerId}" +
        " </if>" +
        " <if test='roomNumber != null and roomNumber != \"\"' >" +
        " AND r.R_address =#{roomNumber}" +
        " </if>" +
        " <if test='remarks != null and remarks != \"\"'>" +
        &#