1. 开发场景
mybatis语法:
UPDARE USER
SET
<if test=" userYn=='Y' ">
USERNAME = #{userName}
</if>
SEX = #{sex}
WHERE ID = #{id}
2.发生错误
执行时报错:
java.lang.NumberFormatException:For Input String “Y”
3. 解决方法
‘y’/‘n’ 被认为时char类型,需要将其修改为String.
UPDARE USER
SET
<if test=" userYn=='Y'.toString() ">
USERNAME = #{userName}
</if>
SEX = #{sex}
WHERE ID = #{id}
UPDARE USER
SET
<if test=' userYn=="Y" '>
USERNAME = #{userName}
</if>
SEX = #{sex}
WHERE ID = #{id}