mybatis like '%%'问题

最新推荐文章于 2025-04-04 21:50:18 发布

intelrain

最新推荐文章于 2025-04-04 21:50:18 发布

阅读量9.6k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Mybatis 文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/intelrain/article/details/81145901

Mybatis 专栏收录该内容

8 篇文章

订阅专栏

<select id="getMaxNotOnlineInfoByConditon" resultType="com.shishike.susie.entity.CustomConfirmInfo">

SELECT *
FROM t_customconfirminfo
WHERE (if(#{pduName,jdbcType=VARCHAR} IS NULL, 0 = 0, pduname = #{pduName,jdbcType=VARCHAR})
   AND if(#{moduleName,jdbcType=VARCHAR} IS NULL, 0 = 0, modulename = #{moduleName,jdbcType=VARCHAR})
   AND if(#{env,jdbcType=VARCHAR} IS NULL, 0 = 0, confirminfo = #{env,jdbcType=VARCHAR})
   AND if(#{ossAddress,jdbcType=VARCHAR} IS NULL, 0 = 0, ossaddress = #{ossAddress,jdbcType=VARCHAR})
   AND if(#{branch,jdbcType=VARCHAR} IS NULL, 0 = 0,  branch like concat(concat('%',#{branch,jdbcType=VARCHAR}),'%'))
   AND if(#{confirmId,jdbcType=BIGINT} IS NULL, 0 = 0, id > #{confirmId,jdbcType=BIGINT})
   AND onlineinfo is null)
ORDER BY CREATED DESC
LIMIT 1
</select>