<select id = "test01" resultType="DemoUser">
select * from demo_user where
<if test="name != null">name = #{name}</if>
<if test="name !=null and age !=null">and </if>
<if test="age != null">age=#{age}</if>
<if test="(name !=null or age !=null) or sex != nell">and </if>
<if test="sex != null">sex=#{sex}</if>
</select>
我发现if标签不用放在where标签里也可以解决and多出的问题,这样写可以吗?