mapper.xml sql模糊查询

最新推荐文章于 2024-09-14 18:46:05 发布

置顶还好头发在

最新推荐文章于 2024-09-14 18:46:05 发布

阅读量1.6k

点赞数 2

分类专栏：项目细节文章标签： java mysql

本文链接：https://blog.csdn.net/X_The_chief/article/details/107581547

版权

项目细节专栏收录该内容

5 篇文章 0 订阅

订阅专栏

模糊查询

 <select id="mapper接口名称" resultType="实体类全限定名">
    SELECT
    p.id,
    s.mobile mobiles,
    ps.`name` names,
    p.created_at,
    p.evaluation,
    p.is_show,
    ps.class_id classId
    FROM `product_evaluation` p
    LEFT JOIN customers s ON p.user_id =s.securty_id
    LEFT JOIN products ps ON p.sku_id=ps.sku_id
    where 1=1
    <if test="params.classId != null and params.classId != '' ">
        and ps.class_id in (SELECT
        c.id
        FROM
        classes c
        WHERE
        c.id = #{params.classId}
        OR parent_id = #{params.classId})
    </if>
    <if test="params.mobiles != null and params.mobiles != '' ">
        and s.mobile = #{params.mobiles}
    </if>
    <if test="params.names != null and params.names != '' ">
      <!--   名称模糊查询 -->
        and ps.name like '%${params.names}%'
    </if>
</select>