if标签语法
<select...>
SQL语句1
<if test="条件表达式">
SQL语句2
</if>
</select>
条件表达式中大于号小于号用 gt,lt
<if test="num gt 0">...</if>
<if test="num lt 0">...</if>
mapper
List<ZftjHalf> selectByAreaIdAndYear(@Param("areaId") String areaId,
@Param("year") String year,
@Param("level") int level);
xml
<select id="selectByAreaIdAndYear" resultType="com.zftdata.nyzft.entity.ZftjHalf">
select * from ZFTJ_HALF
where FILLING_TIME LIKE CONCAT(#{year},'%')
<if test="level lt 3">
and AREA_ID_PID =#{areaId}
</if>
<if test="level gt 2">
and AREA_ID =#{areaId}
</if>
<if test="level == 4">
and AREA_ID =#{areaId}
</if>
</select>
标签:areaId,数字,AREA,标签,Param,year,Mybatis,ID
From: https://www.cnblogs.com/leepandar/p/16711907.html