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>
查询正常