MyBatis笔记（一）错误 Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not

最近在学习MyBatis的映射器（一对一的级联查询）

遇到一个问题，报错信息如下：

Exception in thread "main" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mybatis.demo.IdCardDAO.selectCodeById
### The error may exist in com/mybatis/demo/mapper/PersonMapper.xml
### The error may involve com.mybatis.demo.dao.PersonDAO.selectPersonById1
### The error occurred while handling results
### SQL: select * from person where id=?
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mybatis.demo.IdCardDAO.selectCodeById
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    at com.sun.proxy.$Proxy30.selectOne(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy31.selectPersonById1(Unknown Source)
    at com.mybatis.demo.controller.OneToOneController.test(OneToOneController.java:20)
    at com.mybatis.demo.test.TestOneToOne.main(TestOneToOne.java:15)
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mybatis.demo.IdCardDAO.selectCodeById
### The error may exist in com/mybatis/demo/mapper/PersonMapper.xml
### The error may involve com.mybatis.demo.dao.PersonDAO.selectPersonById1
### The error occurred while handling results
### SQL: select * from person where id=?
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mybatis.demo.IdCardDAO.selectCodeById
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
    ... 7 more
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mybatis.demo.IdCardDAO.selectCodeById
    at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:888)
    at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:721)
    at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:714)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:751)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:460)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:436)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:399)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:351)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:326)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:299)
    at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:192)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    ... 14 more

 

一开始以为是一对一的级联关系<association>这写错了

检查之后，没觉得有哪里写错了，又以为是使用Navicat for Mysql的两张表的手动设置的外键设置错了或者设置反了，检查后发现也不是，各个文件配置spring的配置applicationContext.xml以及mybatis的配置文件 mybatis-config.xml都检查了一遍也没有找到问题所在，于是上网查了查找个错误，总结如下：

Mapped Statements collection does not contain value for后面是什么类什么方法之类的： 
错误原因有几种： 
1、mapper.xml中没有加入namespace 
2、mapper.xml中的方法和接口mapper的方法不对应 
3、mapper.xml没有加入到mybatis-config.xml中(即总的配置文件)，例外：配置了mapper文件的包路径的除外 
4、mapper.xml文件名和所写的mapper名称不相同。

最后对着各个po的mapper文件检查了一遍，发现还是最开始的地方写错了也就是<association>那里写错了

 

而我的包路径是这样的

也就是

应该改成

以上问题就结束了。