关联查询:
一对一:
a.业务扩展类
就是继承类属性多的,少的属性写在子类中
b.resultMap 学生有学生卡,学生类有学生卡对象属性(stucard)
<select id="as" resultMap="xxx" parameterType="int">
select id ,name from student
</select>
<resultMap type="student" id="xxx">
<id property="stuNo" column="id" />
<result property="stuName" column="name" />
一对一用association 属性名stucard,对应类型StudentCard
<association property="stucard" javaType="StudentCard">
<id property="cardId" column="cardId"/>
<result property="cardInfo" column="cardInfo" />
</association>
</resultMap>
一对多:一个班级里有很多学生,班级类中有班级号属性(clssid),班级名属性(classname),list集合中存放Student(students)
<select id="as" resultMap="xxx" parameterType="int">
select id ,name from student
</select>
<resultMap type="studentclass" id="xxx">
<id property="classid" column="id" />
<result property="className" column="classname" />
一对多用collection 属性名stucard,对应类型(ofType)StudentCard
<collection property="students" ofType="Student">
<id property="stuNo" column="stuNo"/>
<result property="name" column="name" />
<result property="age" column="age" />
</collection>
</resultMap>