简介
本文介绍MyBatis如何判断boolean类型实现动态sql。
使用MyBatis时,有时需要使用if标签判断boolean类型,从而决定是否拼接sql(动态查询)。
代码
mapper
public interface HouseTypeMapper extends BaseMapper<HouseType> {
List<HouseType> queryHouses(@Param("isCity") Boolean isCity);
}
xml
<select id="queryHouses" resultType="com.xxx.xxx.entity.HouseType">
SELECT * FROM house_type ht
WHERE 1 = 1
<if test="!isCity">
AND ht.covered_area = 5
</if>
</select>
测试SQL输出
isCity为false时
SELECT * FROM house_type ht WHERE 1 = 1 AND ht.covered_area = 5
isCity为true时
SELECT * FROM house_type ht WHERE 1 = 1标签:--,house,ht,boolean,sql,type,SELECT From: https://blog.51cto.com/knifeedge/5825950