SQL中and的优先级要高于or所以使用时要用括号将or中的条件包上如:
where tti.status = 1
<trim>
<if test="keyWord != null and keyWord != ''">
and (tti.team_name like concat('%', #{keyWord}, '%')
or tbp.person_name like concat('%', #{keyWord}, '%'))
</if>
<if test="releaseBeginTime != null">
and date_format(tti.create_time,'%y%m%d') >= date_format(#{releaseBeginTime},'%y%m%d')
</if>
<if test="releaseEndTime != null">
and date_format(tti.create_time,'%y%m%d') <= date_format(#{releaseEndTime},'%y%m%d')
</if>
<if test="teamType != null and teamType != ''">and tti.team_type = #{teamType}</if>
<if test="teamLevel != null">and tti.team_level = #{teamLevel}</if>
</trim>