1 String类型!=null
where 1=1
<if test="cityName !=null">
and city_name=#{cityName}
</if>
a:
List<String> cityNameList = areaService.queryByTableType(new AreaQO(1, "忻州"));//能正确查询
b:传入""则条件生效
List<String> cityNameList = areaService.queryByTableType(new AreaQO(1, ""));//条件生效,只查询符合条件的
DEBUG: 2018-12-13 17:24:46 ==> Preparing: select city_name from area_table where 1=1 and city_name=?
DEBUG: 2018-12-13 17:24:46 ==> Parameters: (String)
DEBUG: 2018-12-13 17:24:46 <== Total: 0
c:传入null则条件不生效
List<String> city