mybatis中SQL语句给boolean类型赋值问题

https://www.jb51.net/article/200546.htm

<if test="param2.ifRelease != null and param2.ifRelease != ''">
    and if_release = #{param2.ifRelease}
</if>

一样的问题,值ifRelease是Boolean类型,只有传true进入查询,传null及false都查询全部数据,所以判断需修改为

<if test="param2.ifRelease != null">
    and if_release = #{param2.ifRelease}
</if>

查询正常

posted @ 2022-02-13 10:44  wujingqi  阅读(262)  评论(0编辑  收藏  举报