mybatis项目中常见的小错误

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

解决方法  把parameterType 换成resultType