mybatis的if
- 作者: 六味地黄丸治肾亏不含糖
- 来源: 51数据库
- 2020-09-29
<select id="selectUser" parameterType="com.test.entity.User" resultMap="BaseResultMap">
select <include refid="basesql"/> from users where 1=1
<if test="userid !
=null">and userid=#{userid}</if>
<if test="username!=null">
and username like concat('%',#{username},'%')
</if>
<if test="age!=null">and age=#{age}</if>
</select>
select <include refid="basesql"/> from users where 1=1
<if test="userid !
=null">and userid=#{userid}</if>
<if test="username!=null">
and username like concat('%',#{username},'%')
</if>
<if test="age!=null">and age=#{age}</if>
</select>
推荐阅读
