Question

mybatis的where和trim标签的异同点

Answer 1

mybatis where标签的使用
where后面跟查询条件 简化sql语句中判断条件的书写
例:
<select id="user" parameterType="user" resultType="User">
select * from user
<where>
<if test="id!=null and id!=''">
id=#{id}
</if>
<if test="name!=null and name!=''">
and name=#{name}
</if>
<if test="gender!=null and gender!=''">
and gender=#{gender}