sql

 2、模糊查询

1  and  (
2           (b.NAME like ‘%${SearchText}%‘)
3            or
4            (a.ADDRESS like ‘%${SearchText}%‘)
5       )

3、可选条件

1 where
2        1=1
3        <if test="MEMBER_ID != ‘‘ and MEMBER_ID != null">
4     and 
5             MEMBER_ID = #{MEMBER_ID}
6        </if> 

sql

标签：