mybatis复杂查询（resultMap复杂处理）

最新推荐文章于 2024-01-18 02:09:51 发布

程序猿修行

最新推荐文章于 2024-01-18 02:09:51 发布

阅读量178

点赞数

分类专栏： spring 文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/trekker_qin/article/details/128232333

版权

spring 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1、多对一关联（对象）

实体类

@Data
public class Student {
	private int id;
	private String name;
	private Teacher teacher;
}

@Data
public class Teacher {
	private int id;
	private String name;
}

按照查询嵌套处理

<resultMap id="studentTeacher” type="student">
<result property="id" column="id"/>
<result property="name" column="name"/>
<!--复杂的属性，我们需要单独处理 对象: association 集合: collection --><association property="teacher" column="tid" javaType="Teacher" select="getTeacher"/>
</resultMap>

<select  id="getStudent" resultMap="StudentTeacher">
	select * from student
</select>

<select id="getTeacher” resultType="Teacher">
	select * from teacher where id = #{id}
</select>

按照结果嵌套处理

<!-- 按结果嵌套处理-->
<select id="getStudent2” resultMap="StudentTeacher2">
select s.id sid, s.name sname, t.name tname from student s, teacher t
where s.tid = t.id
</select>

<resultMap id="StudentTeacher2" type="student">
	<result property="id” column="sid"/>
	<result property="name” column="sname"/>
	<association property="teacher" javaType="Teacher">
		<result property="name" column="tname"/>
	</association>
</resultMap>

2、一对多集合

实体类

@Data
public class Student {
	private int id;
	private String name;
}

@Data
public class Teacher {
	private int id;
	private String name;
	private List<Student> students;
}

按照结果嵌套处理

<!-- 按结果嵌套处理-->
<select id="getTeacher” resultMap="TeacherStudent">
	select s.id sid, s.name sname, t.name tname,t.id tid 
	from student s,teacher t 
	where s.tid = t.id and t.id = #{tid)
</select>

<resultMap id="TeacherStudent" type="teacher">
	<result property="id” column="tid"/>
	<result property="name” column="tname"/>
	<!--复杂的属性，我们需要单独处理 对象: association 集合: collection
	javaType="” 指定属性的类型!
	集合中的泛型信息，我们使用ofType获取-->
	<collection property="students” ofType="student">
		<result property="id" column="sid"/>
		<result property="name" column="sname"/>
		<result property="tid" column="tid"/>
	</collection>
</resultMap>

按照查询嵌套处理

<select id="getTeacher2” resultMap="TeacherStudent2">
	select * from mybatis.teacher where id = #{tid)
</select>

<resultMap id="TeacherStudent2" type="Teacher"
	<collection property="students" javatype="Arraylist" ofType="Student" select="getStudentByTeacherId" column="id"/>
</resultMap>

<select id="getstudentByTeacherId" resultType="Student">
	select * from mybatis.student where tid = #{tid}
</select>