Mybatis一对多映射采用延迟加载提高查询性能-----Mybatis框架

旧约Alatus

已于 2023-10-07 21:20:28 修改

阅读量145

点赞数 1

分类专栏： # Mybatis框架 JAVA 文章标签： mybatis sql java maven xml logback mysql

于 2023-09-15 23:52:43 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/132913209

版权

JAVA 同时被 2 个专栏收录

543 篇文章 3 订阅

订阅专栏

Mybatis框架

132 篇文章 0 订阅

订阅专栏

<?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.powernode.mybatis.mappers.StudentMapper">
    <resultMap id="studentResultMapAssociation" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
<!--        association意思是关联,一个Student对象关联上一个clazz对象-->
<!--        javaType标签用来指定要映射的JAVA类型-->
        <association property="clazz" javaType="clazz">
            <id column="cid" property="cid"></id>
            <result property="cname" column="cname"></result>
        </association>
    </resultMap>
    <resultMap id="studentResultMap" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
        <result property="clazz.cid" column="cid"></result>
        <result property="clazz.cname" column="cname"></result>
    </resultMap>
    <select id="selectById" resultMap="studentResultMap">
        select
            s.sid,s.sname,c.cid,c.cname
        from
            t_stu as s left join t_clazz as c on s.cid = c.cid
        where
            s.sid = #{sid};
    </select>
    <select id="selectByAssociation" resultMap="studentResultMapAssociation">
        select
            s.sid,s.sname,c.cid,c.cname
        from
            t_stu as s left join t_clazz as c on s.cid = c.cid
        where
            s.sid = #{sid};
    </select>
    <select id="selectByIDStepOne" resultMap="studentResultMapByStep">
        select sid,sname,cid from t_stu where sid = #{sid}
    </select>
<!--    结果映射,两条SQL语句,完成多对一的分步查询-->
<!--    这里是第一步,根据学生的id查询学生的所有信息-->
<!--    这些信息当中含有班级的cid-->
    <resultMap id="studentResultMapByStep" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
<!--        这里需要指定另外一句SQL语句的ID,来实现查询出另一个关联对象-->
<!--        设置完成后,就是这条sql语句的内容被需要时,我们才进行执行兼并加载数据-->
        <association property="clazz"
                     select="com.powernode.mybatis.mappers.ClazzMapper.selectByIdStepTwo"
                     fetchType="eager"
                     column="cid"></association>
    </resultMap>
    <select id="selectByCidStepTwo" resultType="student">
        select * from t_stu where cid = #{cid}
    </select>
</mapper>

<?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.powernode.mybatis.mappers.StudentMapper">
    <resultMap id="studentResultMapAssociation" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
<!--        association意思是关联,一个Student对象关联上一个clazz对象-->
<!--        javaType标签用来指定要映射的JAVA类型-->
        <association property="clazz" javaType="clazz">
            <id column="cid" property="cid"></id>
            <result property="cname" column="cname"></result>
        </association>
    </resultMap>
    <resultMap id="studentResultMap" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
        <result property="clazz.cid" column="cid"></result>
        <result property="clazz.cname" column="cname"></result>
    </resultMap>
    <select id="selectById" resultMap="studentResultMap">
        select
            s.sid,s.sname,c.cid,c.cname
        from
            t_stu as s left join t_clazz as c on s.cid = c.cid
        where
            s.sid = #{sid};
    </select>
    <select id="selectByAssociation" resultMap="studentResultMapAssociation">
        select
            s.sid,s.sname,c.cid,c.cname
        from
            t_stu as s left join t_clazz as c on s.cid = c.cid
        where
            s.sid = #{sid};
    </select>
    <select id="selectByIDStepOne" resultMap="studentResultMapByStep">
        select sid,sname,cid from t_stu where sid = #{sid}
    </select>
<!--    结果映射,两条SQL语句,完成多对一的分步查询-->
<!--    这里是第一步,根据学生的id查询学生的所有信息-->
<!--    这些信息当中含有班级的cid-->
    <resultMap id="studentResultMapByStep" type="student">
        <id property="sid" column="sid"></id>
        <result property="sname" column="sname"></result>
<!--        这里需要指定另外一句SQL语句的ID,来实现查询出另一个关联对象-->
<!--        设置完成后,就是这条sql语句的内容被需要时,我们才进行执行兼并加载数据-->
        <association property="clazz"
                     select="com.powernode.mybatis.mappers.ClazzMapper.selectByIdStepTwo"
                     fetchType="eager"
                     column="cid"></association>
    </resultMap>
    <select id="selectByCidStepTwo" resultType="student">
        select * from t_stu where cid = #{cid}
    </select>
</mapper>

<?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.powernode.mybatis.mappers.ClazzMapper">
    <select id="selectByIdStepTwo" resultType="clazz">
        select cid,cname from t_clazz where cid = #{cid}
    </select>
    <select id="selectByCollection" resultMap="clazzResultMap">
        select c.cid,c.cname,s.sid,s.sname from t_clazz as c left join t_stu as s on c.cid = s.cid where c.cid = #{cid}
    </select>
    <resultMap id="clazzResultMap" type="Clazz">
        <id property="cid" column="cid"></id>
        <result property="cname" column="cname"></result>
<!--        ofType用来指定集合中元素的类型-->
        <collection property="studentList" ofType="student">
            <id property="sid" column="sid"></id>
            <result property="sname" column="sname"></result>
        </collection>
    </resultMap>
    <resultMap id="ResultByStepOne" type="clazz">
        <id property="cid" column="cid"></id>
        <result property="cname" column="cname"></result>
        <collection property="stus"
        select="com.powernode.mybatis.mappers.StudentMapper.selectByCidStepTwo"
        column="cid"></collection>
    </resultMap>
    <select id="selectByStepOne" resultMap="selectByStepOne">
        select cid,cname from t_clazz where cid = #{cid}
    </select>
</mapper>

<?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.powernode.mybatis.mappers.ClazzMapper">
    <select id="selectByIdStepTwo" resultType="clazz">
        select cid,cname from t_clazz where cid = #{cid}
    </select>
    <select id="selectByCollection" resultMap="clazzResultMap">
        select c.cid,c.cname,s.sid,s.sname from t_clazz as c left join t_stu as s on c.cid = s.cid where c.cid = #{cid}
    </select>
    <resultMap id="clazzResultMap" type="Clazz">
        <id property="cid" column="cid"></id>
        <result property="cname" column="cname"></result>
<!--        ofType用来指定集合中元素的类型-->
        <collection property="studentList" ofType="student">
            <id property="sid" column="sid"></id>
            <result property="sname" column="sname"></result>
        </collection>
    </resultMap>
    <resultMap id="ResultByStepOne" type="clazz">
        <id property="cid" column="cid"></id>
        <result property="cname" column="cname"></result>
        <collection property="stus"
        select="com.powernode.mybatis.mappers.StudentMapper.selectByCidStepTwo"
        column="cid"></collection>
    </resultMap>
    <select id="selectByStepOne" resultMap="selectByStepOne">
        select cid,cname from t_clazz where cid = #{cid}
    </select>
</mapper>

package com.powernode.mybatis.mappers;

import com.powernode.mybatis.pojo.Student;

import java.util.List;

public interface StudentMapper
{
    List<Student> selectByCidStepTwo(Integer cid);
    //分步查询第一步,根据SID查询学生信息
    Student selectByIDStepOne(Integer id);
    //使用Association的方式查询学生信息
    Student selectByAssociation(Integer id);
    //根据ID获取学生信息,获取学生关联的ID信息
    Student selectById(Integer id);
}

package com.powernode.mybatis.mappers;

import com.powernode.mybatis.pojo.Student;

import java.util.List;

public interface StudentMapper
{
    List<Student> selectByCidStepTwo(Integer cid);
    //分步查询第一步,根据SID查询学生信息
    Student selectByIDStepOne(Integer id);
    //使用Association的方式查询学生信息
    Student selectByAssociation(Integer id);
    //根据ID获取学生信息,获取学生关联的ID信息
    Student selectById(Integer id);
}

package com.powernode.mybatis.mappers;

import com.powernode.mybatis.pojo.Clazz;

public interface ClazzMapper
{
    Clazz selectByStepOne(Integer id);
    //分步查询第二步,根据cid查询班级信息
    Clazz selectByIdStepTwo(Integer cid);
    Clazz selectByCollection(Integer cid);
}

package com.powernode.mybatis.mappers;

import com.powernode.mybatis.pojo.Clazz;

public interface ClazzMapper
{
    Clazz selectByStepOne(Integer id);
    //分步查询第二步,根据cid查询班级信息
    Clazz selectByIdStepTwo(Integer cid);
    Clazz selectByCollection(Integer cid);
}

package com.powernode.mybatis.Test;

import com.powernode.mybatis.mappers.ClazzMapper;
import com.powernode.mybatis.mappers.StudentMapper;
import com.powernode.mybatis.pojo.Clazz;
import com.powernode.mybatis.pojo.Student;
import com.powernode.mybatis.utils.SqlSessionUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class StudentMapperTest
{
    private static final Logger logger = LoggerFactory.getLogger(StudentMapperTest.class);
    @Test
    public void selectById()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectById(1);
        logger.info(student.toString());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void selectByAssociation()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectByAssociation(2);
        logger.info(student.toString());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void selectByIdStepTwo()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectByIDStepOne(1);
        logger.info(student.getSname().toString());
        //程序执行到这里了,我想看看班级名字
        logger.info(student.getClazz().getCname());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void clazzResultMap()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        ClazzMapper mapper = sqlSession.getMapper(ClazzMapper.class);
        Clazz clazz = mapper.selectByCollection(1000);
        logger.info(clazz.toString());
    }
    @Test
    public void TestselectByCidStepTwo()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        ClazzMapper mapper = sqlSession.getMapper(ClazzMapper.class);
        Clazz clazz = mapper.selectByStepOne(1000);
        logger.info(clazz.toString());
        SqlSessionUtils.close(sqlSession);
    }
}

package com.powernode.mybatis.Test;

import com.powernode.mybatis.mappers.ClazzMapper;
import com.powernode.mybatis.mappers.StudentMapper;
import com.powernode.mybatis.pojo.Clazz;
import com.powernode.mybatis.pojo.Student;
import com.powernode.mybatis.utils.SqlSessionUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class StudentMapperTest
{
    private static final Logger logger = LoggerFactory.getLogger(StudentMapperTest.class);
    @Test
    public void selectById()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectById(1);
        logger.info(student.toString());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void selectByAssociation()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectByAssociation(2);
        logger.info(student.toString());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void selectByIdStepTwo()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.selectByIDStepOne(1);
        logger.info(student.getSname().toString());
        //程序执行到这里了,我想看看班级名字
        logger.info(student.getClazz().getCname());
        SqlSessionUtils.close(sqlSession);
    }
    @Test
    public void clazzResultMap()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        ClazzMapper mapper = sqlSession.getMapper(ClazzMapper.class);
        Clazz clazz = mapper.selectByCollection(1000);
        logger.info(clazz.toString());
    }
    @Test
    public void TestselectByCidStepTwo()
    {
        SqlSession sqlSession = SqlSessionUtils.openSession();
        ClazzMapper mapper = sqlSession.getMapper(ClazzMapper.class);
        Clazz clazz = mapper.selectByStepOne(1000);
        logger.info(clazz.toString());
        SqlSessionUtils.close(sqlSession);
    }
}