代码（全）实现mybatis懒加载机制

最新推荐文章于 2023-06-18 23:39:06 发布

Gydxjnvfg

最新推荐文章于 2023-06-18 23:39:06 发布

阅读量311

点赞数

分类专栏：框架

本文链接：https://blog.csdn.net/qq_45058061/article/details/102922235

版权

框架专栏收录该内容

17 篇文章 0 订阅

订阅专栏

发出请求后加载用户信息，当需要部门信息后再加载用户的部门信息。
创建maven项目，结构如下：
在这里插入图片描述
添加SSM相关jar包：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.gf</groupId>
  <artifactId>MybaytisLazyLoading</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <!-- 防止更新maven后中文乱码 -->
  <properties>
  	<!-- 文件拷贝时的编码 -->
  	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  	<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  	<!-- 编译时的编码 -->
  	<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
  </properties>
  
  <dependencies>
  	<dependency>
  		<groupId>log4j</groupId>
  		<artifactId>log4j</artifactId>
  		<version>1.2.14</version>
  	</dependency>
  	<dependency>
  		<groupId>aopalliance</groupId>
  		<artifactId>aopalliance</artifactId>
  		<version>1.0</version>
  	</dependency>
  	<dependency>
  		<groupId>org.aspectj</groupId>
  		<artifactId>aspectjweaver</artifactId>
  		<version>1.7.4</version>
  	</dependency>
  	<dependency>
  		<groupId>javax.annotation</groupId>
  		<artifactId>javax.annotation-api</artifactId>
  		<version>1.3</version>
  	</dependency>
  	<dependency>
  		<groupId>javax.servlet</groupId>
  		<artifactId>servlet-api</artifactId>
  		<version>2.5</version>
  	</dependency>
  	<dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>5.1.10</version>
  	</dependency>
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis</artifactId>
  		<version>3.4.6</version>
  	</dependency>
  	<dependency>
  		<groupId>cglib</groupId>
  		<artifactId>cglib</artifactId>
  		<version>3.1</version>
  	</dependency>
  	<dependency>
  		<groupId>commons-pool</groupId>
  		<artifactId>commons-pool</artifactId>
  		<version>1.6</version>
  	</dependency>
  	<dependency>
  		<groupId>commons-logging</groupId>
  		<artifactId>commons-logging</artifactId>
  		<version>1.2</version>
  		<type>jar.lastUpdated</type>
  	</dependency>
  	<dependency>
  		<groupId>commons-beanutils</groupId>
  		<artifactId>commons-beanutils</artifactId>
  		<version>1.8.0</version>
  	</dependency>
  	<dependency>
  		<groupId>commons-collections</groupId>
  		<artifactId>commons-collections</artifactId>
  		<version>3.2.1</version>
  	</dependency>
  	<dependency>
  		<groupId>commons-lang</groupId>
  		<artifactId>commons-lang</artifactId>
  		<version>2.4</version>
  	</dependency>
  	<dependency>
  		<groupId>net.sf.ezmorph</groupId>
  		<artifactId>ezmorph</artifactId>
  		<version>1.0.6</version>
  	</dependency>
  	<dependency>
  		<groupId>commons-dbcp</groupId>
  		<artifactId>commons-dbcp</artifactId>
  		<version>1.4</version>
  	</dependency>
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis-spring</artifactId>
  		<version>1.3.2</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-web</artifactId>
  		<version>4.3.16.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-webmvc</artifactId>
  		<version>4.3.16.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-core</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-beans</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-context</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-expression</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-aop</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-tx</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-jdbc</artifactId>
  		<version>5.0.4.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>asm</groupId>
  		<artifactId>asm</artifactId>
  		<version>3.3.1</version>
  	</dependency>
  	<dependency>
  		<groupId>net.sf.json-lib</groupId>
  		<artifactId>json-lib</artifactId>
  		<version>2.4</version>
  		<classifier>jdk15</classifier>
  	</dependency>
  	  	<dependency>
     <groupId>com.github.pagehelper</groupId>
     <artifactId>pagehelper</artifactId>
     <version>4.1.4</version>
 	</dependency>
  	  	<dependency>
  	  		<groupId>com.jhlabs</groupId>
  	  		<artifactId>filters</artifactId>
  	  		<version>2.0.235</version>
  	  	</dependency>
  </dependencies>
</project>

配置web.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  <display-name>MybatisLazyLoading</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  
  <!-- 2、配置springmvcservlet -->
  <servlet>
  	<servlet-name>springmvcservlet</servlet-name>
  	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  	
  	<init-param>
  		<!-- 配置核心控制器DispatcherServlet读取的springMVC的配置文件 -->
  		<param-name>contextConfigLocation</param-name>
  		<param-value>classpath:springmvc-*.xml</param-value>
  	</init-param>
  	
  	<!-- 
  	 0  <0  在服务器启动时不加载，何时使用就何时加载
  	 1 或 >1  在服务器启动时就加载
  	 1  2  3   4   tomcat加载servlet中内容的顺序  	 
  	 -->
  	<load-on-startup>1</load-on-startup>
  </servlet>
  
  <!-- 1、拦截所有请求 -->
  <servlet-mapping>
  	<servlet-name>springmvcservlet</servlet-name>
  	<url-pattern>/</url-pattern>
  </servlet-mapping>
  
  
  <!-- 配置springMVC框架的过滤器 -->
  <filter>
  	<filter-name>charsetfilter</filter-name>
  	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  	<init-param>
  		<param-name>encoding</param-name>
  		<param-value>UTF-8</param-value>
  	</init-param>
  	<init-param>
  		<param-name>forceEncoding</param-name>
  		<param-value>true</param-value>
  	</init-param>
  </filter>
  
  <!-- 拦截所有请求到达过滤器中 -->
  <filter-mapping>
  	<filter-name>charsetfilter</filter-name>
  	<url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

配置resources文件下的配置文件：
配置打印日志文件：(log4j.properties)

log4j.rootLogger = debug,stdout,logfile

log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.err
log4j.appender.stdout.layout = org.apache.log4j.SimpleLayout

log4j.appender.logfile = org.apache.log4j.FileAppender
log4j.appender.logfile.File = gf.log
log4j.appender.logfile.layout = org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern = %d{yyyy-MM-dd HH:mm:ss} %l %F %p %m%n

配置springMVC：（springmvc-config.xml）

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
        
        <!-- 配置url和控制器中方法之间映射 -->
        <context:component-scan base-package="com.mybatis.lazyloading.controller"></context:component-scan>
        <!-- 告知springmvc使用注解方式扫描 -->
        <mvc:annotation-driven></mvc:annotation-driven>
        <!-- 配置响应结果和视图之间的映射  -->
        <bean  class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        	<property name="prefix" value="/"></property>
        	<property name="suffix" value=".html"></property>
        </bean>
        <mvc:default-servlet-handler/><!-- 解禁静态资源 -->

</beans>

配置mybatis-config.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>

	<settings>
		<!-- 打印出SQL -->
		<setting name="logImpl" value="STDOUT_LOGGING"/>
		<!-- 设置允许延迟加载
		   true:允许
		   false:默认值，不进行懒加载
		 -->
		<setting name="lazyLoadingEnabled" value="true"/>
		<!-- 按需加载：false -->
		<setting name="aggressiveLazyLoading" value="false"/>
		
		<!-- 启用二级缓存
		<setting name="cacheEnabled" value="true"/> -->
	</settings>
	
</configuration>

配置spring：（springmvc-application.xml）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-3.2.xsd
	http://www.springframework.org/schema/tx
	http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">
	
	<!-- 配置数据源：dbcp连接池 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://localhost:3306/select"></property>
		<property name="username" value="root"></property>
		<property name="password" value="root"></property>
		<!--<property name="defaultAutoCommit" value="false"></property>  -->
	</bean>
	
	<!-- 让spring自己创建sqlSessionFactory:用来获取连接，创建sqlSessionTemplate -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 设置引用的数据源，到设置的连接池中获取连接 -->
		<property name="dataSource" ref="dataSource"></property>
		<!-- 告知spring，mybatis配置文件所在的位置 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>
	
	<!-- 加载Mapper映射文件：
			MapperScannerConfigurer类加载、读取mapper文件，
			根据mapper映射文件和对应的接口生成实现类，并且创建实现类对象。
	 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.mybatis.lazyloading.dao"></property>
	</bean>
	<!-- 告知spring扫描指定的包，按注解执行 -->
	<context:component-scan base-package="com.mybatis.lazyloading.service"></context:component-scan>
	<context:component-scan base-package="com.mybatis.lazyloading.controller"></context:component-scan>
	
	<!-- 配置事务管理器 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<!-- 告知spring使用注解的方式 -->
	<tx:annotation-driven/>
</beans>

至此，所有配置工作完毕。接下来编写实体类（Dept类和Emp类）：
在这里插入图片描述
Emp.java:

package com.mybatis.lazyloading.bean;

import java.io.Serializable;

public class Emp implements Serializable{
	private String empno;
	private String ename;
	private String job;
	private double sal;
	private double com;
	private String deptno;
	private Dept dept;
	//表中列不在一一列出
	public String getEmpno() {
		return empno;
	}
	public void setEmpno(String empno) {
		this.empno = empno;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public double getSal() {
		return sal;
	}
	public void setSal(double sal) {
		this.sal = sal;
	}
	public double getCom() {
		return com;
	}
	public void setCom(double com) {
		this.com = com;
	}
	public String getDeptno() {
		return deptno;
	}
	public void setDeptno(String deptno) {
		this.deptno = deptno;
	}
	public Dept getDept() {
		return dept;
	}
	public void setDept(Dept dept) {
		this.dept = dept;
	}
	
}

Dept.java:

package com.mybatis.lazyloading.bean;

import java.io.Serializable;
import java.util.List;

public class Dept implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private String deptno;
	private String dname;
	private String loc;
	private Emp emp;
	
	public Emp getEmp() {
		return emp;
	}
	public void setEmp(Emp emp) {
		this.emp = emp;
	}
	public String getDeptno() {
		return deptno;
	}
	public void setDeptno(String deptno) {
		this.deptno = deptno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getLoc() {
		return loc;
	}
	public void setLoc(String loc) {
		this.loc = loc;
	}
	
}

编写dao层：
在这里插入图片描述
EmpDaoMapper.java:

package com.mybatis.lazyloading.dao;

import java.util.List;

import com.mybatis.lazyloading.bean.Emp;

public interface EmpDaoMapper {
	public List<Emp> getEmps();
}

EmpDaoMapper.xml:

<?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.mybatis.lazyloading.dao.EmpDaoMapper">

	<resultMap type="com.mybatis.lazyloading.bean.Emp" id="empMap">
		<id column="empno" property="empno"/>
		<result column="ename" property="ename"/>
		<result column="job" property="job"></result>
		<result column="sal" property="sal"></result>
		<result column="deptno" property="deptno"/>
		<!-- 
			<collection property="emp" ofType="com.mybatis.lazyloading.bean.Emp"
						column="deptno" select="com.mybatis.lazyloading.dao.EmpDaoMapper.getEmps">
			</collection> 
		-->
		<association property="dept" javaType="com.mybatis.lazyloading.bean.Dept"
					 column="deptno" select="com.mybatis.lazyloading.dao.DeptDaoMapper.getDept"></association>
	</resultMap>
	
	<select id="getEmps" resultMap="empMap">
		select * from emp
	</select>
</mapper>

DeptDaoMapper.java:

package com.mybatis.lazyloading.dao;

import com.mybatis.lazyloading.bean.Dept;

public interface DeptDaoMapper {
	
	public Dept getDept(String deptno);
}

DeptDaoMapper.xml:

<?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.mybatis.lazyloading.dao.DeptDaoMapper">

	<resultMap type="com.mybatis.lazyloading.bean.Dept" id="deptMap">
		<id column="deptno" property="deptno"></id>
		<result column="dname" property="dname"/>
		<result column="loc" property="loc"/>
	</resultMap>
	
	<select id="getDept" parameterType="String" resultMap="deptMap">
		select * from dept where deptno = #{deptno}
	</select>
</mapper>

在这里插入图片描述
EmpService.java:

package com.mybatis.lazyloading.service;

import java.util.List;

import com.mybatis.lazyloading.bean.Emp;

public interface EmpService {
	public List<Emp> getEmps();
}

EmpServiceImpl.java:

package com.mybatis.lazyloading.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.mybatis.lazyloading.bean.Emp;
import com.mybatis.lazyloading.dao.EmpDaoMapper;
@Service("eservice")
public class EmpServiceImpl implements EmpService{

	@Autowired
	private EmpDaoMapper empdao;
	public List<Emp> getEmps() {
		// TODO Auto-generated method stub
		List<Emp> emps = empdao.getEmps();
		return emps;
	}
}

在这里插入图片描述
EmpController.java:

package com.mybatis.lazyloading.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.mybatis.lazyloading.bean.Emp;
import com.mybatis.lazyloading.service.EmpService;

import net.sf.json.JSONArray;

@Controller
public class EmpController {

	@Autowired
	private EmpService es;
	
	@RequestMapping(value="ask",method= {RequestMethod.GET})
	public String getemps() {
		List<Emp> emps = es.getEmps();
		String string = JSONArray.fromObject(emps).toString();
		System.out.println(string);
		System.out.println("+++++++++++++++");
		for(Emp e: emps) {
			System.out.println(e.getEname()+"======="+e.getDeptno()+"=========="+e.getDept().getDeptno());
		}
		return string;
	}
}

测试页面：index.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

	<a href="ask">点击</a>

</body>
</html>

在这里插入图片描述

当没有调用部门的时候(注释控制器里的增强for的时候），也会查询每一个员工对应的部门，有多少个员工查询多少次，why？？？
查了半年，最后原因是在控制器的方法中，JSONArray.fromObject(emps).toString()这一句触发了懒加载，注释了这一句后就不会触发懒加载。

public String getemps() {
		List<Emp> emps = es.getEmps();
		
		//String string = JSONArray.fromObject(emps).toString();
	
		System.out.println("+++++++++++++++");
		for(Emp e: emps) {
			//查询员工的姓名和部门编号（都是员工表的内容）
			System.out.println(e.getEname()+"======="+e.getDeptno()+"==========");
		}
		return string;
	}

在这里插入图片描述
需要部门信息的时候再去查询：

@Controller
public class EmpController {

	@Autowired
	private EmpService es;
	
	@RequestMapping(value="ask",method= {RequestMethod.GET})
	public String getemps() {
		List<Emp> emps = es.getEmps();
		System.out.println("+++++++++++++++");
		for(Emp e: emps) {
			System.out.println(e.getDept().getDname()+"******************"+e.getDept().getLoc());	
		}
		return " ";
	}
}

在这里插入图片描述

Gydxjnvfg

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
2
评论
代码（全）实现mybatis懒加载机制

发出请求后加载用户信息，当需要部门信息后再加载用户的部门信息。创建maven项目，结构如下：添加SSM相关jar包：<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://mav...
复制链接

扫一扫