mysql mapper 判断‘-‘报错

张开发
• 2026/5/17 19:45:49 • 15 分钟阅读

最新文章

推荐文章

相关文章

分享文章

mysql mapper 判断‘-‘报错
1 场景mysql mapper 方法报错### Cause: java.lang.NumberFormatException: For input string: -(String), NumberFormatException: For input string: -(String), org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.NumberFormatException: For input string: -java 字段private String capacityClassificationjava 入参 “capacityClassification”: “-”mysql 字段capacity_classificationvarchar(50)DEFAULTNULLCOMMENT运力分类三年期、一年期、市场分类xml 判断iftestparam.capacityClassification ! null and param.capacityClassification ! and param.capacityClassification ! -and capacity_classification #{param.capacityClassification}/if2. 原因MyBatis 会把右边的 ‘-’ 当成【字符 char】而左边是【字符串 String】OGNL 表达式在比较 String ! char 时会尝试把字符串 强制转成数字于是 - 就爆了。3. 解决iftestparam.capacityClassification ! null and param.capacityClassification ! and param.capacityClassification !quot;-quot;and capacity_classification #{param.capacityClassification}/if

更多文章