java文件mybatis动态sql-where条件拼接-多种比较

最新推荐文章于 2025-06-03 14:21:53 发布

原创最新推荐文章于 2025-06-03 14:21:53 发布 · 979 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #mysql

数据库同时被 3 个专栏收录

14 篇文章

订阅专栏

web

14 篇文章

订阅专栏

框架

10 篇文章

订阅专栏

String QUERY_WHERE_SQL = " where 1=1  " +
        //直接等于
        "<if test='source!=null and source!=\"\" '>" +
        " AND t.source = #{source} " +
        "</if>" +
        //字符串转日期
        "<if test='dateStart!=null and dateStart!=\"\" '>" +
        " AND t.date &gt;= STR_TO_DATE(#{dateStart}, '%Y-%m-%d %H:%i:%s') " +
        "</if>" +
        "<if test='dateEnd!=null and dateEnd!=\"\" '>" +
        " AND t.date &lt;= STR_TO_DATE(#{dateEnd}, '%Y-%m-%d %H:%i:%s') " +
        "</if>"  +
        //大小比较
        "<if test='score!=null and score!=\"\" '>" +
            "<if test='score &gt;= 0 '>" +
                " AND t.score &gt;= 0 " +
            "</if>" +
            "<if test='score &lt; 0 '>" +
                " AND t.score &lt; 0 " +
            "</if>" +
        "</if>" +
        //模糊比较
        "<if test='searchWord!=null and searchWord!=\"\" '>" +
        " AND t.title like CONCAT('%',#{searchWord},'%') " +
        "</if>" ;

ps:持续更新