IBatis配置一对一、一对多两种实现方式
有两张表:student(id,name,num,classes_id)、classes(id,description),一个学生只属于某一个班级,但某一个班下可以有多个学生。
一对一配置
方式一:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="one-to-one">
<typeAlias alias="student" type="com.test.Student" />
<typeAlias alias="classes" type="com.test.Classes" />
<resultMap class="student" id="studentResult">
<result property="id" column="id" />
<result property="name" column="name" />
<result property="num" column="num" />
<result property="classes" column="classes_id" select="getClasses" />
</resultMap>
<resultMap class="classes" id="classesResult">
<result property="id" column="id" />
<result property="description" column="description" />
</