发出请求后加载用户信息,当需要部门信息后再加载用户的部门信息。
创建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 " ";
}
}