ClassesMapper.xml:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<id property= "id" column= "c_id" javaType= "int" />
<result property= "name" column= "c_name" javaType= "String" />
<!-- <association property= "teacher" javaType= "Teacher" >
<id property= "id" column= "t_id" javaType= "int" />
<result property= "name" column= "t_name" javaType= "String" />
<result property= "age" column= "t_age" javaType= "int" />
</association> -->
<association property= "teacher" javaType= "Teacher" resultMap= "com.lsj.test.mybatis.mapper.TeacherMapper.teacherMap" ></association>
<collection property= "studentList" ofType= "Student" resultMap= "com.lsj.test.mybatis.mapper.StudentMapper.studentMap" ></collection>
</resultMap>
<sql id= "selectAllClassesSql" >
SELECT
c.id as c_id,c.name as c_name,teacher_id,
t.id as t_id,t.name as t_name,t.age as t_age,
s.id as stu_id,s.name as stu_name,s.classes_id
from classes c,teacher t,student s
</sql>
|
TeacherMapper.xml的resultMap:
1
2
3
4
5
|
<resultMap type= "Teacher" id= "teacherMap" >
<id property= "id" column= "t_id" javaType= "int" />
<result property= "name" column= "t_name" javaType= "String" />
<result property= "age" column= "t_age" javaType= "int" />
</resultMap>
|
利用命名空间+resultMapID就可以直接引用其他Mapper文件的resultMap,其中resultMap的column在本文件中也有用,也可以对应sql语句中的column别名。
总结
以上所述是小编给大家介绍的mybatis 不同Mapper文件引用resultMap,希望对大家有所帮助,如果大家有任何疑问请给我留
言,小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持!
原文链接:http://blog.csdn.net/caser_hdmi/article/details/76064542