mybatis where-if中if不能识别大写AND，OR

最新推荐文章于 2025-06-19 21:00:54 发布

原创最新推荐文章于 2025-06-19 21:00:54 发布 · 8.6k 阅读

1 ·

CC 4.0 BY-SA版权

本文解决了一个MyBatis在执行SQL时遇到的OGNL解析错误，错误发生在IF条件判断语句中，由于AND关键字使用了大写导致无法识别。通过将AND关键字改为小写，成功解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis报错:Caused by: org.apache.ibatis.ognl.ParseException: Encountered " "AND “” at line 1

错误代码：

  <select id="selectAccountList" resultMap="BaseResultMap">
  	SELECT ct.customer_name customerName,sam.city_code,sam.user_name,sam.account_name
		FROM sys_account_manager sam LEFT JOIN sys_customer ct ON ct.id = sam.customer_id 
	  WHERE sam.deleted = 0
	  <if test="customerName != null AND customerName != '' ">
	  	AND ct.customer_name LIKE concat('%',#{customerName},'%')
	  </if>
	  <if test="cityCode != null AND cityCode != '' ">
	  	AND LOCATE(#{cityCode},sam.city_code)
	  </if>
	  order by status,account_validity_time DESC
  </select>

正确代码：
原因是：if条件中AND为大写，大写不能识别，应改为小写。

<select id="selectAccountList" resultMap="BaseResultMap">
  	SELECT ct.customer_name customerName,sam.city_code,sam.user_name,sam.account_name
		FROM sys_account_manager sam LEFT JOIN sys_customer ct ON ct.id = sam.customer_id 
	  WHERE sam.deleted = 0
	  <if test="customerName != null and customerName != '' ">
	  	AND ct.customer_name LIKE concat('%',#{customerName},'%')
	  </if>
	  <if test="cityCode != null and cityCode != '' ">
	  	AND LOCATE(#{cityCode},sam.city_code)
	  </if>
	  order by status,account_validity_time DESC
  </select>