81,094
社区成员
发帖
与我相关
我的任务
分享
create table stu(
sno int auto_increment primary key ,
sname varchar(10)
);
create table class (
cid int auto_increment primary key,
cname varchar(10)
);
create table cs (
cid int,
sno int,
foreign key(cid) references class(cid),
foreign key(sno) references stu(sno)
);
insert into stu values (0,'stu1');
insert into stu values (0,'stu2');
insert into stu values (0,'stu3');
insert into stu values (0,'stu4');
insert into stu values (0,'stu5');
insert into class values (0,'class1');
insert into class values (0,'class2');
insert into cs values (1,1);
insert into cs values (1,2);
insert into cs values (2,3);
insert into cs values (2,4);
insert into cs values (2,5);
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.iails.site.dao.ClazzMapper">
<!-- 第一种方式 -->
<resultMap id="getList2ResultMap" type="com.iails.site.entity.Clazz">
<id property="classId" column="cid"/>
<result property="className" column="cname"/>
<collection property="students" column="cid" ofType="com.iails.site.entity.Student"
select="getList2Student">
<id property="studentId" column="sno"/>
<result property="studentName" column="sname"/>
</collection>
</resultMap>
<select id="getList2Student" resultType="com.iails.site.entity.Student">
select *
from stu,cs
where stu.sno=cs.sno and #{cid}=cs.cid
</select>
<select id="getList2" resultMap="getList2ResultMap">
select *
from class
</select>
<!-- 第二种方式 -->
<resultMap id="getListResultMap" type="com.iails.site.entity.Clazz">
<id property="classId" column="cid"/>
<result property="className" column="cname"/>
<collection property="students" column="cid" ofType="com.iails.site.entity.Student">
<id property="studentId" column="sno"/>
<result property="studentName" column="sname"/>
</collection>
</resultMap>
<select id="getList" resultMap="getListResultMap">
select *
from stu, class, cs
where class.cid=cs.cid and stu.sno=cs.sno
</select>
</mapper>
[{"classId":1,"className":"class1","students":[null, null]}, {"classId":2,"className":"class2","students":[null, null, null]}]
<!-- 第三种方式 -->
<resultMap id="getList3ResultMap" type="com.iails.site.entity.Clazz">
<id property="classId" column="cid"/>
<result property="className" column="cname"/>
<collection property="students" column="cid" ofType="com.iails.site.entity.Student"
select="getList3Student">
</collection>
</resultMap>
<resultMap id="getList3StudentResultMap" type="com.iails.site.entity.Student">
<id property="studentId" column="sno"/>
<result property="studentName" column="sname"/>
</resultMap>
<select id="getList3Student" resultMap="getList3StudentResultMap">
select *
from stu,cs
where stu.sno=cs.sno and #{cid}=cs.cid
</select>
<select id="getList3" resultMap="getList3ResultMap">
select *
from class
</select>