mybatis查询数据报bad format错误

[Godsname]

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: Bad format for number '中国' in column 2.
### The error may exist in com/usoftchina/mapperxml/RegionCityMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from h_regioncity
### Cause: java.sql.SQLException: Bad format for number '中国' in column 2.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:91)
at com.usoftchina.dao.RegionCityDao.findAll(RegionCityDao.java:20)
at com.usoftchina.dao.RegionCityDao.main(RegionCityDao.java:30)
Caused by: java.sql.SQLException: Bad format for number '中国' in column 2.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.getDoubleInternal(ResultSetImpl.java:2486)
at com.mysql.jdbc.ResultSetImpl.getDoubleInternal(ResultSetImpl.java:2425)
at com.mysql.jdbc.ResultSetImpl.getDouble(ResultSetImpl.java:2386)
at com.mysql.jdbc.ResultSetImpl.getDouble(ResultSetImpl.java:2404)
at org.apache.ibatis.type.DoubleTypeHandler.getNullableResult(DoubleTypeHandler.java:34)
at org.apache.ibatis.type.DoubleTypeHandler.getNullableResult(DoubleTypeHandler.java:23)
at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:314)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:295)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:264)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:214)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:186)
at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:152)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
... 4 more

[KeepSayingNo]

不知道你是不是采用注解的方式注入SQL的，如果是，那么接口方法的参数前需要加上 @parameter("参数名")

[symjh]

异常意思是 查询结果第二列有个数据 ‘中国' 不能转换为 number 类型。 检查下是不是对象属性或者映射设置错了