Mybatis的多对一,一对多

最新推荐文章于 2023-07-31 15:22:54 发布

Raya_L

最新推荐文章于 2023-07-31 15:22:54 发布

阅读量821

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/xcl18215166914/article/details/78720208

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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>

<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);
}