- 延迟加载的概念只存在于分步查询时;
- 延迟加载的本质是为第一步查询返回的Java Bean创建了一个代理对象;
- 延迟加载的全局设置有两个:
- lazyLoadingEnabled,作用为设置select语句的默认延迟加载是否开启;
-
aggressiveLazyLoading,对于开启了延迟加载的select作用如下:
- 值为true时,假设select返回的Java Bean为xxx,那么获取任何xxx属性的动作都会导致resultMap中定义的所有关联查询马上执行;
- 值为false时,假设yyy为xxx的一个属性,由关联查询获取,那么只有在yyy的某一属性被使用时,获取yyy的关联查询才会执行
- 延迟加载针对单个查询的具体设置为resultMap的 fetchType属性;
- 全局设置lazyLoadingEnabled和具体设置fetchType的关系如下:
-
- 如果设置了resultMap的 fetchType属性,那么全局设置lazyLoadingEnabled便不再对该select生效,是否延迟加载要以fetchType属性为准;
- 如果select的resultMap没有设置 fetchType属性,那么该select会采用lazyLoadingEnabled的设置;
- aggressiveLazyLoading只对延迟加载的select生效
演示如下
需要注意的是,一下演示在DEBUG模式下不成立,均为RUN模式;DEBUG模式下(IDEA环境)MyBatis不会延迟加载
E-R图:一个City隶属于一个Country,同时一个City包含多个Address
实体类:CityPlusPlus中包含一个Country和多个Address
CityPlusPlus
public class CityPlusPlus { private Long id; private String name; private Long countryId; private Date lastUpdate; private Country country; private List<Address> addressList; }
Country
public class Country { Long id; String name; Date lastUpdate; }
Address
public class Address { Long addressId; String address; String address2; String district; String postalCode; String phone; Long cityId; Location location; Date lastUpdate; }
lazyLoadingEnabled和aggressiveLazyLoading均为true,fetchType不设置
<?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="canger.study.chapter04.mapper.CityPlusPlusMapper"> <resultMap id="cityPlusPlusResultMap" type="canger.study.chapter04.bean.CityPlusPlus"> <id column="city_id" property="id"/> <result column="city" property="name"/> <result column="country_id" property="countryId"/> <result column="last_update" property="lastUpdate"/> <association property="country" select="canger.study.chapter04.mapper.CountryMapper.selectCountryById" column="country_id"/> <association property="addressList" select="canger.study.chapter04.mapper.AddressMapper.selectAddressesByCityId" column="city_id"/> </resultMap> <select id="selectCityPlusPlusById" resultMap="cityPlusPlusResultMap"> select * from city where city_id=#{id} </select> </mapper>
<settings> <setting name="mapUnderscoreToCamelCase" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="aggressiveLazyLoading" value="true"/> </settings>
测试代码如下:
@Test public void testCityPlusPlusMapper(){ SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtil.initSqlSessionFactory(); SqlSession sqlSession = null; try { sqlSession = sqlSessionFactory.openSession(); CityPlusPlusMapper mapper = sqlSession.getMapper(CityPlusPlusMapper.class); System.out.println("************开始主动查询**************"); CityPlusPlus cityPlusPlus = mapper.selectCityPlusPlusById(42L); System.out.println("*************主动查询结束*************"); System.out.println(cityPlusPlus.getName()); System.out.println("*************Step2*************"); System.out.println(cityPlusPlus.getCountry()); System.out.println("**************Step3************"); System.out.println(cityPlusPlus.getAddressList()); System.out.println(); System.out.println(); sqlSession.commit(); } catch (Exception e) { e.printStackTrace(); sqlSession.rollback(); } finally { sqlSession.close(); } }
日志输出如下,可以看到,当调用 cityPlusPlus.getName() 时,两个关联查询均马上执行
************开始主动查询************** [DEBUG] 2018-11-21 23:37:12,307(300) --> [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:137): Opening JDBC Connection [DEBUG] 2018-11-21 23:37:12,552(545) --> [main] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:406): Created connection 1514160588. [DEBUG] 2018-11-21 23:37:12,553(546) --> [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:101): Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5a4041cc] [DEBUG] 2018-11-21 23:37:12,555(548) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select * from city where city_id=? [DEBUG] 2018-11-21 23:37:12,575(568) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 42(Long) [DEBUG] 2018-11-21 23:37:12,631(624) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 1 *************主动查询结束************* [DEBUG] 2018-11-21 23:37:12,632(625) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select * from country where country_id=? [DEBUG] 2018-11-21 23:37:12,637(630) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 103(Integer) [DEBUG] 2018-11-21 23:37:12,640(633) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 1 [DEBUG] 2018-11-21 23:37:12,641(634) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select address_id,address,address2,district,city_id,postal_code,phone,astext(location) as location,last_update from address where city_id=? [DEBUG] 2018-11-21 23:37:12,641(634) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 42(Integer) [DEBUG] 2018-11-21 23:37:12,651(644) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 2 Aurora *************Step2************* Country{id=103, name='United States', lastUpdate=Wed Feb 15 04:44:00 CST 2006} **************Step3************ [Address{addressId=335, address='587 Benguela Manor', address2='', district='Illinois', postalCode='91590', phone='165450987037', cityId=42, location=POINT(-88.3200762 41.760583), lastUpdate=Thu Sep 25 22:33:44 CST 2014}, Address{addressId=543, address='43 Vilnius Manor', address2='', district='Colorado', postalCode='79814', phone='484500282381', cityId=42, location=POINT(-104.8319273 39.729439), lastUpdate=Thu Sep 25 22:33:44 CST 2014}]
lazyLoadingEnabled为true和aggressiveLazyLoading为false,fetchType不设置
<settings> <setting name="mapUnderscoreToCamelCase" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="aggressiveLazyLoading" value="false"/> </settings>
输出日志,可以看到:
- 当调用cityPlusPlus.getCountry() 时,第一个关联查询执行
- 当调用cityPlusPlus.getAddressList()时,第二个关联查询执行
************开始主动查询************** [DEBUG] 2018-11-21 23:56:04,599(286) --> [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:137): Opening JDBC Connection [DEBUG] 2018-11-21 23:56:04,829(516) --> [main] org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:406): Created connection 1514160588. [DEBUG] 2018-11-21 23:56:04,830(517) --> [main] org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:101): Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5a4041cc] [DEBUG] 2018-11-21 23:56:04,844(531) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select * from city where city_id=? [DEBUG] 2018-11-21 23:56:04,865(552) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 42(Long) [DEBUG] 2018-11-21 23:56:04,941(628) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 1 *************主动查询结束************* Aurora *************Step2************* [DEBUG] 2018-11-21 23:56:04,942(629) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select * from country where country_id=? [DEBUG] 2018-11-21 23:56:04,943(630) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 103(Integer) [DEBUG] 2018-11-21 23:56:04,956(643) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 1 Country{id=103, name='United States', lastUpdate=Wed Feb 15 04:44:00 CST 2006} **************Step3************ [DEBUG] 2018-11-21 23:56:04,961(648) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Preparing: select address_id,address,address2,district,city_id,postal_code,phone,astext(location) as location,last_update from address where city_id=? [DEBUG] 2018-11-21 23:56:04,961(648) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): ==> Parameters: 42(Integer) [DEBUG] 2018-11-21 23:56:04,971(658) --> [main] org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:159): <== Total: 2 [Address{addressId=335, address='587 Benguela Manor', address2='', district='Illinois', postalCode='91590', phone='165450987037', cityId=42, location=POINT(-88.3200762 41.760583), lastUpdate=Thu Sep 25 22:33:44 CST 2014}, Address{addressId=543, address='43 Vilnius Manor', address2='', district='Colorado', postalCode='79814', phone='484500282381', cityId=42, location=POINT(-104.8319273 39.729439), lastUpdate=Thu Sep 25 22:33:44 CST 2014}]