Cause: java.sql.SQLException: Invalid value for getInt() - 'P000011'

最新推荐文章于 2022-03-16 19:20:28 发布

luckzhaoyanw

最新推荐文章于 2022-03-16 19:20:28 发布

阅读量2.5k

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/qq_42318281/article/details/80717954

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

写mybatis 练习，出现如下错误：

分析：

java.sql.SQLException: Invalid value for getInt() - 'P000011'

原来是getInt(),类型有误，改为String类型解决。

rg.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLException: Invalid value for getInt() - 'P000011'
### The error may exist in cn/tedu/mybatis/pojo/OrderMapper.xml
### The error may involve cn.tedu.mybatis.pojo.OrderMapper.get
### The error occurred while handling results
### SQL: SELECT   d.id as door_id,   d.name,d.tel,   o.id,   o.order_no,o.order_type,o.person_num,o.cashier,o.create_time,o.end_time,o.payment_type,o.price   FROM (SELECT * FROM tb_order WHERE id=?) o LEFT JOIN ( SELECT * FROM tb_door WHERE id = (SELECT door_id FROM tb_order WHERE id=?) ) d ON o.door_id=d.id
### Cause: java.sql.SQLException: Invalid value for getInt() - 'P000011'
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException