mybatis学习中报错 Error querying database. Cause: java.lang.NumberFormatException: For input string: "女"(二)

在进行数据库调试<choose></choose>标签时,写入代码

<choose>

  <when test="sex == '女'">

    sex = '女'

  </when>

  <when test="sex == '男'">

    sex = '男'

  </when>

  <otherwise>

    and sex = 'null'

  </otherwise>

</choose>

时报错

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NumberFormatException: For input string: "女"
### Cause: java.lang.NumberFormatException: For input string: "女"

 

讲代码改为

<choose>

  <when test="sex == '女'.toString()">

    sex = '女'

  </when>

  <when test="sex == '男'.toString()">

    sex = '男'

  </when>

  <otherwise>

    and sex = 'null'

  </otherwise>  

</choose>

posted @ 2021-01-29 23:50  SGold  阅读(310)  评论(1)    收藏  举报