1.Xml
Mabatis中xml性的核心配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 是mybaitis的核心配置文件
1.数据库的链接信息(连接池)
-->
<properties resource="jdbcoracle.properties">
</properties>
<typeAliases>
<typeAlias type="cn.et.lesson03.returnMap.xml.Grade" alias="grade"/>
<typeAlias type="cn.et.lesson03.returnMap.xml.Student" alias="student"/>
</typeAliases>
<environments default="development">
<environment id="development">
<!-- 事务管理器默契使用jdbc事务-->
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driverClass}"/>
<property name="url" value="${url}"/>
<property name="username" value="${userName}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="cn/et/lesson03/returnMap/xml/grademap.xml"/>
<mapper resource="cn/et/lesson03/returnMap/xml/studentmap.xml"/>
</mappers>
</configuration>
<!-- 映射多对1关系studentmap.xml-->
<resultMap type="student" id="studentMap" autoMapping="true">
<id column="sid" property="sid"/>
<!-- select * from student where gid=${学生信息中gid} -->
<association property="grade" column="gid" fetchType="lazy" select="cn.et.lesson03.returnMap.xml.GradeMapper.queryGradeByGid"></association>
</resultMap>
<select id="queryStudent" resultMap="studentMap">
select * from student where sid=#{0}
</select>
<select id="queryStudentByGid" resultType="student">
select * from student where gid=#{0}
</select>
<!-- 1对多的关系
查询某个班级 班级下的学生
Grademap.xml
-->
<select id="queryGrade" resultMap="gradeOne">
select * from grade where gid=#{gid}
</select>
Grademap.xml
<select id="queryGradeByGid" resultMap="gradeMap">
select * from grade where gid=#{gid}
</select>
<!-- 用于映射一对多 -->
<resultMap type="grade" id="gradeOne" autoMapping="true">
<id column="gid" property="gid"/>
<result column="gname" property="gname1"/>
<collection property="studentList" column="gid" javaType="arraylist" select="cn.et.lesson03.returnMap.xml.StudentMapper.queryStudentByGid"
autoMapping="true"/>
</resultMap>
2.注解
一对多
public interface GradeMapper {
/**
* 根据名称查询所有的班级
* @param foodName
* @return
*/
public List<Grade> queryAllGrade();
/**
* 通过gid查询班级
* @param gid
* @return
*/
@Results({@Result(property="gname1",column="gname"),
//@Many查询多条 @Result(property="studentList",column="gid",javaType=ArrayList.class,many=@Many(select="cn.et.lesson03.returnMap.anno.StudentMapper.queryStudentByGid"))
})
@Select("select * from grade where gid=#{0}")
public Grade queryGrade(String gid);
@Results(@Result(property="gname1",column="gname"))
@Select("select * from grade where gid=#{0}")
public Grade queryGradeByGid(String gid);
}
多对一
public interface StudentMapper {
/**
* 通过编号查询学生
@one查询一条
*/
@Results({
@Result(property="grade",column="gid",one=@One(select="cn.et.lesson03.returnMap.anno.GradeMapper.queryGradeByGid"))
})
@Select("select * from student where sid=#{0}")
public Student queryStudent(String sid);
/**
* 通过班级ID查询学生
*/
@Select("select * from student where gid=#{0}")
public List<Student> queryStudentByGid(String gid);
}