Mapper.xml 错误查找与分析

Mapper.xml 报错

---

 org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### The error may exist in cn/itcast/mybatis/mapper/UserMapper.xml
### The error occurred while processing mapper_resultMap[userResultMap]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'userResultMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: userResultMap

---

Mapper.xml代码

    <resultMap type="User" id="userResultMap">
        <!--id表示查询结果唯一标识 -->
        <id column="id_" property="id" />

        <!-- result普通名映射定义 -->
        <result column="username_" property="username" />
    </resultMap>

    <!-- 使用resultMap输出映射 -->
    <select id="findUserByIdResultMap" parameterType="int"
        resultType="userResultMap">
        SELECT id id_,username username_ FROM USER WHERE id=#{value}
    </select>

---

错误分析：
无法找到别名为userResultMap的java对象

查出问题代码

<select id="findUserByIdResultMap" parameterType="int"
        resultType="userResultMap">

---

解决方案
将resultType 改为 resultMap 即可

---

心得
细节决定成败