mybatis 拼接sql语句 if test等条件
If test 条件 判断不为空 和空字符串的情况<select id="findActiveBlogWithTitleLike"
resultType="Blog">
SELECT * FROM BLOG
WHERE state = ‘ACTIVE’
<if test="title != null">
AND title like #{t...
转载
2018-07-04 14:37:59 ·
13049 阅读 ·
1 评论