好像数据库里字段是空值的话map里就不包含了,这个感觉不好,传到前台页面还以为这个值没取到,有什么办法可以让null值的也返回?总不能每个字段都用ifnull处理吧
when null then ''
select id="findActiveBlogLike"
parameterType="Blog" resultType="Blog"
SELECT * FROM BLOG
where
if test="state != null"
state = #{state}
if
if test="title != null”
AND title like #{title}
if
if test="author != null and author.name != null"
AND author_name like #{author.name}
where
select
parameterType="Blog" resultType="Blog">
SELECT * FROM BLOG
state = #{state}
AND title like #{title}
AND author_name like #{author.name}
api 里面有啊