使用前端框架,SQL适应
前端框架需要,if标签需要指定使用格式使用
<select id="listByMemberId" resultType="com.sunbtech.zoocoffee.admin.modules.wechat.entity.MemberAddress">
select * from member_address
where del_flag=0
<if test="memberAddress.queryString != null and memberAddress.queryString != ''">
and ( real_name like concat('%',#{memberAddress.queryString},'%')
or mobile like concat('%',#{memberAddress.queryString},'%')
or addr_detail like concat('%',#{memberAddress.queryString},'%')
)
</if>
</select>
修改于传统单个条件判断
别说差点,差点就是永远