MyBatis的核心配置之遇到的所有报错

扶离_flee

已于 2024-05-09 09:23:35 修改

阅读量819

点赞数 12

文章标签： mybatis

于 2024-05-08 19:40:14 首次发布

本文链接：https://blog.csdn.net/2301_77491688/article/details/138581638

版权

本文章写于本人看完《Java EE企业级应用开发教程 Spring+SpringMVC+Mybatis》第二章"MyBatis的核心配置"

错误代码

最开始的错误
org.apache.ibatis.exceptions.PersistenceException:
###Error building SqlSession.
###The error may exist in com/itheima/mapper/StudentMapper.xml
###The error occurred while processing mapper_resultMap[studentMap]
###Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is ‘com/itheima/mapper/StudentMapper.xml’. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ‘com.itheima.domain.Student’. Cause: java.lang.ClassNotFoundException: Cannot find class: com.itheima.domain.Student

![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/956109c397d64598a67f807e0df167dd.png

解决方法

一个个开始解决

第一步

经查找发现是StudentMapper.xml中的pojo写成domain了

< resultMap type=“com.itheima.pojo.Student” id=“studentMap”>

在这里插入图片描述
改正后报错变为
org.apache.ibatis.exceptions.PersistenceException:
###Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.itheima.mapper.StudentMapper.findAllStudent
###Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.itheima.mapper.StudentMapper.findAllStudent

第二步

检查IDEA有没有成功连接上mysql
在这里插入图片描述

连接上后报错依旧没有改变

上次报错

Error querying database. Cause: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)

这次报错

Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.itheima.mapper.StudentMapper.findAllStudent

然后检查

在这里插入图片描述
查了很久,发现findAllStudent写错了多加了个s,改正过后,报错变为

org.apache.ibatis.exceptions.PersistenceException:
###Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table ‘mybatis.t_student’ doesn’t exist
###The error may exist in com/itheima/mapper/StudentMapper.xml
###The error may involve defaultParameterMap
###The error occurred while setting parameters
###SQL: select * from t_student
###Cause: java.sql.SQLSyntaxErrorException: Table ‘mybatis.t_student’ doesn’t exist