Mybatis-结果集映射&&关联查询&&分步查询&&懒加载

已于 2022-04-05 04:16:57 修改
阅读量306 收藏
点赞数
分类专栏： Mybatis 文章标签： 后端 java
于 2022-04-05 04:04:09 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_25243147/article/details/123963884
版权

一、结果集映射
（1）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.wsh.mapper.UserMapper">
    <resultMap id="UserResult" type="User">
        <id property="id" column="id"/>
        <result property="lastName" column="last_name"/>
        <result property="password" column="password"/>
    </resultMap>

    <select id="selectUserList" resultMap="UserResult">
        select * from user
    </select>
</mapper>

（2）接口文件

public interface UserMapper {
    public List<User> selectUserList();
}

（3）JAVA程序

public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<User> users = mapper.selectUserList();
            for (User user : users) {
                System.out.println(user.toString());
                /*
                User{id=1, lastName='a', password='123'}
				User{id=2, lastName='b', password='123'}
				User{id=3, lastName='c', password='123'}
                */
            }
        }finally {
            sqlSession.close();
        }
    }

二、关联查询
（1）数据表准备
department

create table department(
	id bigint AUTO_INCREMENT,
	name varchar(20),
	primary key(id)
)engine = innodb default charset = utf8

insert into department (name) values ('研发部');
insert into department (name) values ('产品部');
insert into department (name) values ('运维部');

employee

create table employee(
	id bigint AUTO_INCREMENT,
	name varchar(20),
	dept_id int,
	primary key(id)
)engine = innodb default charset = utf8

insert into employee (name, dept_id) values ('张三', 1);
insert into employee (name, dept_id) values ('李四', 1);
insert into employee (name, dept_id) values ('王五', 1);
insert into employee (name, dept_id) values ('赵六', 2);
insert into employee (name, dept_id) values ('威爷', 3);

（2）Maven添加依赖Lombok

		<dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.22</version>
        </dependency>

（3）实体类
Department

@Data
@ToString
@AllArgsConstructor
@NoArgsConstructor
public class Department {
    private Long id;
    private String name;
    private List<Employee> employees;
}

Employee

@Data
@ToString
@AllArgsConstructor
@NoArgsConstructor
public class Employee {
    private Long id;
    private String name;
    private Long deptId;
    private Department department;
}

（4）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.wsh.mapper.UserMapper">
    <resultMap id="EmployeeResult" type="Employee">
        <id property="id" column="e_id"/>
        <result property="name" column="e_name"/>
        <result property="deptId" column="dept_id"/>
        <association property="department" javaType="Department">
            <id property="id" column="d_id"/>
            <result property="name" column="d_name"/>
        </association>
    </resultMap>

    <resultMap id="DepartmentResult" type="Department">
        <id property="id" column="d_id"/>
        <result property="name" column="d_name"/>
        <collection property="employees" ofType="Employee">
            <id property="id" column="e_id"/>
            <result property="name" column="e_name"/>
            <result property="deptId" column="dept_id"/>
        </collection>
    </resultMap>

    <select id="selectEmployeeList" resultMap="EmployeeResult">
        select
            e.id e_id, e.name e_name, e.dept_id, d.id d_id, d.name d_name
        from employee e
        left join department d on e.dept_id = d.id
    </select>

    <select id="selectDepartmentList" resultMap="DepartmentResult">
        select
            e.id e_id, e.name e_name, e.dept_id, d.id d_id, d.name d_name
        from department d
        left join employee e on d.id = e.dept_id
    </select>
</mapper>

（5）接口文件

public interface UserMapper {
    public List<Employee> selectEmployeeList();
    public List<Department> selectDepartmentList();
}

（6）JAVA程序

    public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<Employee> employees = mapper.selectEmployeeList();
            for (Employee employee : employees) {
                System.out.println(employee.toString());
                /*
                Employee(id=1, name=张三, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=2, name=李四, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=3, name=王五, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=4, name=赵六, deptId=2, department=Department(id=2, name=产品部, employees=null))
				Employee(id=5, name=威爷, deptId=3, department=Department(id=3, name=运维部, employees=null))
                */
            }
            List<Department> departments = mapper.selectDepartmentList();
            for (Department department : departments) {
                System.out.println(department);
                /*
                Department(id=1, name=研发部, employees=[Employee(id=1, name=张三, deptId=1, department=null), Employee(id=2, name=李四, deptId=1, department=null), Employee(id=3, name=王五, deptId=1, department=null)])
				Department(id=2, name=产品部, employees=[Employee(id=4, name=赵六, deptId=2, department=null)])
				Department(id=3, name=运维部, employees=[Employee(id=5, name=威爷, deptId=3, department=null)])
                */
            }
        }finally {
            sqlSession.close();
        }
    }

二、分步查询association
（1）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.wsh.mapper.UserMapper">
    <resultMap id="EmployeeResult" type="Employee">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="deptId" column="dept_id"/>
        <association property="department" select="selectDepartmentById" column="dept_id">

        </association>
    </resultMap>

    <resultMap id="DepartmentResult" type="Department">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
    </resultMap>

    <select id="selectEmployeeList" resultMap="EmployeeResult">
        select * from employee
    </select>

    <select id="selectDepartmentById" parameterType="Long" resultMap="DepartmentResult">
        select * from department where id = #{id}
    </select>
</mapper>

（2）接口文件

public interface UserMapper {
    public List<Employee> selectEmployeeList();
    public Department selectDepartmentById(Long id);
}

（3）JAVA文件

    public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<Employee> employees = mapper.selectEmployeeList();
            for (Employee employee : employees) {
                System.out.println(employee.toString());
                /*
                Employee(id=1, name=张三, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=2, name=李四, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=3, name=王五, deptId=1, department=Department(id=1, name=研发部, employees=null))
				Employee(id=4, name=赵六, deptId=2, department=Department(id=2, name=产品部, employees=null))
				Employee(id=5, name=威爷, deptId=3, department=Department(id=3, name=运维部, employees=null))
                */
            }
        }finally {
            sqlSession.close();
        }
    }

注：分步查询中的association仅是说明用哪个查询（select）及给查询传递哪个参数（column），最后将查询到的结果放在该属性（property）

三、分步查询collection
（1）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.wsh.mapper.UserMapper">
    <resultMap id="DepartmentResult" type="Department">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <collection property="employees" select="selectEmployeeByDeptId" column="id">

        </collection>
    </resultMap>

    <resultMap id="EmployeeResult" type="Employee">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="deptId" column="dept_id"/>
    </resultMap>

    <select id="selectDepartmentList" resultMap="DepartmentResult">
        select * from department
    </select>

    <select id="selectEmployeeByDeptId" parameterType="Long" resultMap="EmployeeResult">
        select * from employee where dept_id = #{id}
    </select>
</mapper>

（2）接口文件

public interface UserMapper {
    public List<Department> selectDepartmentList();
    public List<Employee> selectEmployeeByDeptId(Long id);
}

（3）JAVA文件

    public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<Department> departments = mapper.selectDepartmentList();
            for (Department department : departments) {
                System.out.println(department.toString());
                /*
                Department(id=1, name=研发部, employees=[Employee(id=1, name=张三, deptId=1, department=null), Employee(id=2, name=李四, deptId=1, department=null), Employee(id=3, name=王五, deptId=1, department=null)])
				Department(id=2, name=产品部, employees=[Employee(id=4, name=赵六, deptId=2, department=null)])
				Department(id=3, name=运维部, employees=[Employee(id=5, name=威爷, deptId=3, department=null)])
                */
            }
        }finally {
            sqlSession.close();
        }
    }

注：分步查询中的collection仅是说明用哪个查询（select）及给查询传递哪个参数（column），最后将查询到的结果放在该属性（property）

四、懒加载
（1）Maven添加log4j依赖

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

（2）创建log4j.properties

log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO

（3）Mybatis配置文件添加设置

    <settings>
        <setting name="logImpl" value="LOG4J"/>
        <setting name="lazyLoadingEnabled" value="true"/>
    </settings>

（4）JAVA程序

    @Test
    public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<Department> departments = mapper.selectDepartmentList();
            boolean flag = false;
            for (Department department : departments) {
                System.out.println(department.getId() + " " + department.getName());
                if (!flag){
                    System.out.println(department.getEmployees());
                    flag = true;
                }
            }
        }finally {
            sqlSession.close();
        }
    }

输出

2022-04-05 03:53:57,278 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - ==>  Preparing: select * from department
2022-04-05 03:53:57,302 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - ==> Parameters: 
2022-04-05 03:53:57,357 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - <==      Total: 3
1 研发部
2022-04-05 03:53:57,358 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - ==>  Preparing: select * from employee where dept_id = ?
2022-04-05 03:53:57,358 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - ==> Parameters: 1(Long)
2022-04-05 03:53:57,360 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - <==      Total: 3
[Employee(id=1, name=张三, deptId=1, department=null), Employee(id=2, name=李四, deptId=1, department=null), Employee(id=3, name=王五, deptId=1, department=null)]
2 产品部
3 运维部

分析：开启懒加载后，当使用要执行分步查询后才能得到的数据，才执行发布查询获取该数据。

（5）当开启aggressiveLazyLoading
给Department实体类增加方法

@Data
@ToString
@AllArgsConstructor
@NoArgsConstructor
public class Department {
    private Long id;
    private String name;
    private List<Employee> employees;

    public void die(){
        System.out.println("die");
    }
}

    <settings>
        <setting name="logImpl" value="LOG4J"/>
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="true"/>
    </settings>

    public void test() throws IOException {
        //读取配置文件创建SqlSession工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //利用SqlSession工厂创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            //利用SqlSession创建代理对象
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            List<Department> departments = mapper.selectDepartmentList();
            departments.get(0).die();
        }finally {
            sqlSession.close();
        }
    }

输出


2022-04-05 04:14:14,765 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - ==>  Preparing: select * from department
2022-04-05 04:14:14,792 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - ==> Parameters: 
2022-04-05 04:14:14,841 [main] DEBUG [com.wsh.mapper.UserMapper.selectDepartmentList] - <==      Total: 3
2022-04-05 04:14:14,841 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - ==>  Preparing: select * from employee where dept_id = ?
2022-04-05 04:14:14,841 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - ==> Parameters: 1(Long)
2022-04-05 04:14:14,843 [main] DEBUG [com.wsh.mapper.UserMapper.selectEmployeeByDeptId] - <==      Total: 3
die

分析：开启aggressiveLazyLoading后，当使用对象中的任一方法，都会执行对应的分步查询。

qq_25243147
关注
专栏目录
7、MyBatis框架——MyBatis对一对一关系的处理、分步查询、MyBatis对一对多关系的处理
CSDN_Loveletter的博客
02-14 1029
在实体类中添加额外属性实现多表查询 1、mybatis两表关联查询 （1）实体类类型映射规则 （2）代码演示 2、分步查询 （1）autoMapping开启自动映射 （2）封装SQL语句 （2）懒加载 三、MyBatis对一对多关系的处理 1、collection配置集合映射
MyBatis学习之关联(集合)映射：嵌套查询/结果
LJW874362735的博客
12-19 2628
Table of Contents 01结果映射（resultMap）：集合（关联）映射 1.1 代码示例 1.2 resultMap元素及属性说明 02 关联映射（association） 2.1关联的嵌套 Select 查询 2.2 关联的嵌套结果 03 集合映射（collection） 3.1集合的嵌套 Sele...
MyBatis分步查询及懒加载
weixin_43014205的博客
12-26 992
分步查询： 两个pojo类： package com.itlike.domain; import lombok.Getter; import lombok.Setter; import lombok.ToString; @Setter@Getter@ToString public class Customer { private Integer cust_id; priv...
1.类加载：什么是类加载？？？什么是类加载器？？？类加载器有哪三种类型？？？如何获取类加载器？？？
ADbyCool的博客
07-04 844
跟汤老师学Java笔记：类加载 完成：第一遍 1.什么是类加载？ 将class文件读取到内存中的过程，称为类加载 2.什么是类加载器？ class文件的加载由ClassLoader完成，称为类加载器 3.类加载器有哪三种类型？ 第一种：BootStrapClassLoader：启动类加载器，用C++编写的，由JVM在启动时加载初始化的 主要负责加载%JAVA_HOME%/jre/lib路径下的类 第二种：ExtClassLoader：扩展类加载器，用Java编写的，由BootStrapClassLoader
MyBatis的分步查询
weixin_42614150的博客
06-18 613
MyBatis的分步查询
Mybatis分步查询
java_t_t的博客
07-09 1217
Mybatis分步查询
21.MyBatis学习--映射文件_select_resultMap_关联查询_collection分步查询&延迟加载
Adela0916的博客
12-28 199
一、概述 在前的文章中介绍了通过association实现分步查询&延迟加载（MyBatis学习–映射文件_select_resultMap_关联查询_association分步查询&&延时加载），以及上一篇文章中通过collection实现级联查询结果集封装（MyBatis学习-映射文件_select_resultMap_关联查询_collection定义关联集合封装规则），这篇文章主要通过collection来实现分步查询&延迟加载。 二、使用场景 这里，以查询某一部门信
Java-开发技术框架-Mybatis基本用法 --- 使用Mybatis映射关联关系（对一、对多、分步查询、延迟加载、多对多关联关系需要中间表）
MrDaKai的博客
10-17 373
关联关系 对一 对多 分步查询 延迟加载 多对多关联关系需要中间表
22.MyBatis学习--映射文件_select_resultMap_分步查询通过column传递多列值&fetchType
Adela0916的博客
12-28 455
分步查询通过column传递多列值 在前面，无论是通过association还是collection实现分步查询，我们通过column来传递的参数都是一个，column是可以传递多列值得。传递方法就是将多列值封装成map形式：column="{key1=column1,key2=column2}". 例如： 在DepartmentMapper.xml中分步查找部门信息及其下的员工信息。 <resultMap id="MyDeptStep" type="com.fzl.mybatis.bean.Dep
Mybatis --- 自定义映射、特殊和动态SQL
乌云的博客
03-20 385
自定义映射、特殊和动态SQL
mybatis分布查询以及resulttype和resultmap的用法
01-17
mybatis分布查询以及resulttype和resultmap的用法,以及作为一个新手对于mybatis的学习过程的记录
mybatis分步查询
Ting1king的博客
07-25 359
<?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"> <!--namespace命名空间mapper方式下，必须为mapper接口的长类名--> <mapper namespace="com.wance.map
MyBatis分步查询
m0_63378258的博客
12-03 1834
基于MyBatis对一对多、多对一关系的分步查询
【MyBatis笔记】11-分步查询懒加载
萌宅鹿的技术小屋
09-01 264
分步查询——懒加载模式懒加载模式示例不使用懒加载使用懒加载aggressiveLazyLoadinglazyLoadTriggerMethods 所谓懒加载，也称延时加载，是指不一下子加载完全部资源。需要用到哪些资源才去加载这些资源，用不到的资源，就不去加载他，以达到节约资源，优化的目的。分步查询中存在懒加载现象。 懒加载模式示例 不使用懒加载 首先看一下不使用懒加载的情况下，是如何运行的。 我...
MyBatis-在分步查询的基础上配置懒加载
最新发布
CodeRunning的博客
06-27 153
Mybatis作为一个优秀的ORM框架当然也支持懒加载，和Hibernate不同是，它默认情况下是禁止了懒加载的，要使用懒加载需要手动的开启，开启的方法就是配置两个全局变量：lazyLoadingEnabled设置为true，aggressiveLazyLoading设置为false。Hibernate中，涉及到关联查询的时候，懒加载是默认就开启着的，前面讲过设计懒加载就是，在关联查询中，真正需要用到关联的对象的时候，才发起sql语句，从数据库中查询数据，从而实现提升数据库性能的目标。
mybatis分步式查询方法
xiaoqinqin_222的博客
08-14 1270
mybatis分步式查询方法
mybatis多表映射-分步查询
小丁的博客
12-11 319
是 MyBatis 配置文件中的一个设置项，用于控制 自动映射行为 。MyBatis 是一个 Java 的持久层框架，它允许你使用 SQL 语句来操作数据库，并将结果映射到 Java 对象上。在 MyBatis 中，你可以使用元素来定义结果映射规则，指定如何将数据库的结果集映射到 Java 对象上。然而，为了简化配置，MyBatis 提供了自动映射的特性，可以自动将结果集的列名映射
Mybatis 一对一 关系查询（分步查询）
m0_51963973的博客
07-26 510
在studentMapper.xml当中设置分步查询。④在TeacherMapper.xml当中设置关于教师的查询。③配置studentMapper。⑤配置TeacherMapper。
【Mybatis从入门到实战教程】第五章 Mybatis 关联查询详解
波哩个波的博客
04-25 994
Mybatis 关联查询： 一对一查询 一对多查询 多对多查询
MyBatis-Plus分页查询与代码生成器详解
资源摘要信息:"MyBatis-Plus分页查询以及自定义sql分页.pdf文件和mybatis-plus-master压缩包文件，包含了关于MyBatis-Plus分页查询、代码生成器、简单使用以及多数据源的知识点。" 在当今的软件开发领域，MyBatis-...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值