多条件查询时，用<where>
<select id="findAllSelective" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from sys_user
<where>
<if test="id != null">
and id = #{id,jdbcType=BIGINT}
</if>
<if test="username != null">
and username = #{username,jdbcType=VARCHAR}
</if>
</where>
</select>
<select id="findAllSelective" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from sys_user
<where>
<if test="id != null">
and id = #{id,jdbcType=BIGINT}
</if>
<if test="username != null">
and username = #{username,jdbcType=VARCHAR}
</if>
</where>
</select>
扫一扫
397
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
