mybatis项目中常见的小错误

最新推荐文章于 2024-09-18 20:36:27 发布

原创最新推荐文章于 2024-09-18 20:36:27 发布 · 2.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #sql

本文总结了使用MyBatis过程中常见的错误及其解决办法，包括SQL语法错误、ID唯一性问题、类找不到异常、配置问题导致的类型转换异常等，并提供了具体的修正建议。

再创建mybatis时，总是会遇见一些小错误

1.有时候手抖，sql语句写错

解决方法取mybatis项目中找到Mapper映射

2.有时候，我们在src/main/resources的实体类映射，没有保证id的唯一性

解决方法发现有id一样就修改

3.cannot find class:｛driver｝，这里时配置错误

解决方法

4.jdbc中 TypeForNull configuration property. Cause:java.sql.SQL

解决方法

5.org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'org.mybatis.mapper.UserMapper.getAllUser'. It's likely that neither a Result Type nor a Result Map was specified.
### The error may exist in mapper/UserMapper.xml
### The error may involve org.mybatis.mapper.UserMapper.getAllUser
### The error occurred while handling results
### SQL: select * from profile
### Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'org.mybatis.mapper.UserMapper.getAllUser'. It's likely that neither a Result Type nor a Result Map was specified.