<?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.dao.StudentinfoDao">
<resultMap id="c" type="Classinfo">
<result property="cid" column="cid"></result>
<result property="cname" column="cname"></result>
</resultMap>
<resultMap id="stu" type="Studentinfo">
<result property="stuid" column="stuid"></result>
<result property="stuName" column="stuName"></result>
<result property="stuSex" column="stuSex"></result>
<result property="stuAge" column="stuAge"></result>
<result property="class_cid" column="class_cid"></result>
<association property="classinfo" javaType="Classinfo" resultMap="c"></association>
</resultMap>
<resultMap id="classs" type="classinfo">
<result property="cid" column="cid"></result>
<result property="cname" column="cname"></result>
<collection property="studentinfoList" ofType="studentinfo">
<result property="stuid" column="stuid"></result>
<result property="stuName" column="stuName"></result>
<result property="stuSex" column="stuSex"></result>
<result property="stuAge" column="stuAge"></result>
<result property="class_cid" column="class_cid"></result>
</collection>
</resultMap>
<select id="findAll" resultMap="stu">
select s.*, c.cname
from studentinfo s,
classinfo c
where s.class_cid = c.cid
</select>
<select id="findByAge" resultType="Studentinfo">
select *
from studentinfo
where stuAge > #{stuAge}
</select>
<select id="findByCid" resultMap="classs">
select s.*, c.cname
from studentinfo s,
classinfo c
where s.class_cid = c.cid
and c.cid = #{cid}
</select>
</mapper>
mybits一对多 多对一映射关系
最新推荐文章于 2023-08-27 23:18:30 发布