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