Cause: java.lang.NumberFormatException: For input string: "Y"

" "

错误描述

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

​Error querying database. Cause: java.lang.NumberFormatException: For input string: "Y"

Cause: java.lang.NumberFormatException: For input string: "Y"

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)  
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)  
at com.sun.proxy.$Proxy121.selectList(Unknown Source)  
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)

引起原因

=='Y'报错了

​

解决办法

​

其他解决办法：

有问题的写法：

<if test=" name=='张三' ">

<if>

没问题的写法：

<if test=' name=="张三" '>

<if>