mybatis项目中常见的小错误_com.example.mybatis.mapper.usermapper.getalluser-优快云博客

本文链接：https://blog.youkuaiyun.com/xiaoerduo123x/article/details/51146210

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

再创建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.