<select id="findByName" resultMap="BaseResultMap" parameterType="java.lang.String">
select
<include refid="Base_Column_List" />
from city
WHERE 1 = 1
<if test = "cityName != '' AND cityName != NULL" >
AND city_name = #{cityName}
</if>
select
<include refid="Base_Column_List" />
from city
WHERE 1 = 1
<if test = "cityName != '' AND cityName != NULL" >
AND city_name = #{cityName}
</if>
</select>
项目正常启动,但是在访问的时候,报出AND的错误 无法识别,此处AND应改为and。
再次启动项目,依然报错,找不到NULL,此处NULL应改为null。
Mybatis的动态sql语句非常的严格,区分大小写。