mybatis延迟加载

1.需求

1.1有一个订单表以及一个用户表，一个用户可以创建多个订单，现在需要查询出所有订单，但是订单所属的用户不能一起查询出来，当需要的时候再进行查询，这样就用到mybatis的延迟查询。

2.实现

2.1ordermapper.xml

     <!-- 实现延迟加载 -->
     <resultMap type="order" id="ordersUserLazyLoadingResultMap">
        <id column="id" property="id"/>
        <result column="user_id" property="user_id"/>
        <result column="number" property="number"/>
        <result column="create_time" property="create_time"/>
        <result column="note" property="note"/>
        <!-- property =Order里面的user变量  javatype =pojo类型  select=查询用户使用的statement column= 传递的参数  select不在同一个包下需要命名空间-->
        <association property="user" javaType="user" select="com.ssm.mapping.UserMapperDAO.findUserById" column="user_id">

        </association>
     </resultMap>
     <select id="findOrdersUserLazyLoading" resultMap="ordersUserLazyLoadingResultMap">
        select * from orders
     </select>

2.2usermapperdao.xml

<!-- ${}表示拼接sql字符串 根据姓名模糊查询用户 
        可能会造成sql注入为题，如果接收的参数为简单类型，只能为${value} 与 #{}不一样，可是使用任何名称
    -->
    <select id="findUserByName" parameterType="java.lang.String" resultType="com.ssm.model.User">
        SELECT * FROM USER WHERE USERNAME LIKE '%${value}%'
    </select>

2.3ordermapper.java

public List<Order> findOrdersUserLazyLoading();

2.4springmvc控制器

@RequestMapping(value="/lazyload",method=RequestMethod.GET)
    public String ordersUserLazyLoading(HttpServletRequest request)
    {
        List<Order> list = ordermapper.findOrdersUserLazyLoading();
        request.setAttribute("orderlist", list);
        return "order_detail";
    }

2.5mybatis配置文件

<settings>
        <!-- 开启延迟加载 -->
        <setting name="lazyLoadingEnabled" value="true"/>
        <!-- 是否主动加载 -->
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>
    <typeAliases>
        <!-- 批量定义别名 别名为类名 首字母大小写均可-->
        <package name="com.ssm.model"/>
    </typeAliases>
    <!-- 引入资源 -->

2.6jsp页面

<c:forEach var="order" items="${requestScope.orderlist}">
        <p>订单id：${order.id}</p>
        <p>订单number：${order.number}</p>
        <p>订单user_id：${order.user_id}</p>
        <p>订单create_time：${order.create_time}</p>
        <p>订单note：${order.note}</p>
        <p>用户名：${order.user.username}</p>
   </c:forEach>

3.结果

3.1控制台输出

DEBUG [http-bio-8080-exec-12] - DispatcherServlet with name 'springmvc' processing GET request for [/SSM/order/lazyload]
DEBUG [http-bio-8080-exec-12] - Mapping [/order/lazyload] to HandlerExecutionChain with handler [com.ssm.controller.OrderController@32bef7ff] and 1 interceptor
DEBUG [http-bio-8080-exec-12] - Last-Modified value for [/SSM/order/lazyload] is: -1
DEBUG [http-bio-8080-exec-12] - Invoking request handler method: public java.lang.String com.ssm.controller.OrderController.ordersUserLazyLoading(javax.servlet.http.HttpServletRequest)
DEBUG [http-bio-8080-exec-12] - Creating a new SqlSession
DEBUG [http-bio-8080-exec-12] - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@50c31fd4] was not registered for synchronization because synchronization is not active
DEBUG [http-bio-8080-exec-12] - Fetching JDBC Connection from DataSource
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@11fe15ef] will not be managed by Spring
DEBUG [http-bio-8080-exec-12] - ==>  Preparing: select * from orders 
DEBUG [http-bio-8080-exec-12] - ==> Parameters: 
DEBUG [http-bio-8080-exec-12] - <==      Total: 3
DEBUG [http-bio-8080-exec-12] - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@50c31fd4]
DEBUG [http-bio-8080-exec-12] - Returning JDBC Connection to DataSource
DEBUG [http-bio-8080-exec-12] - com.mchange.v2.async.ThreadPoolAsynchronousRunner@48a767dd: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@1ca4c610
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - Rendering view [org.springframework.web.servlet.view.JstlView: name 'order_detail'; URL [/WEB-INF/views/order_detail.jsp]] in DispatcherServlet with name 'springmvc'
DEBUG [http-bio-8080-exec-12] - Forwarding to resource [/WEB-INF/views/order_detail.jsp] in InternalResourceView 'order_detail'
DEBUG [http-bio-8080-exec-12] - Fetching JDBC Connection from DataSource
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@7122bae3] will not be managed by Spring
DEBUG [http-bio-8080-exec-12] - ==>  Preparing: SELECT * FROM USER WHERE id=? 
DEBUG [http-bio-8080-exec-12] - ==> Parameters: 1(Integer)
DEBUG [http-bio-8080-exec-12] - <==      Total: 1
DEBUG [http-bio-8080-exec-12] - Returning JDBC Connection to DataSource
DEBUG [http-bio-8080-exec-12] - com.mchange.v2.async.ThreadPoolAsynchronousRunner@48a767dd: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@77e0abe
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - Fetching JDBC Connection from DataSource
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@43e14471] will not be managed by Spring
DEBUG [http-bio-8080-exec-12] - ==>  Preparing: SELECT * FROM USER WHERE id=? 
DEBUG [http-bio-8080-exec-12] - ==> Parameters: 1(Integer)
DEBUG [http-bio-8080-exec-12] - <==      Total: 1
DEBUG [http-bio-8080-exec-12] - Returning JDBC Connection to DataSource
DEBUG [http-bio-8080-exec-12] - com.mchange.v2.async.ThreadPoolAsynchronousRunner@48a767dd: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@29fbdf8b
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - Fetching JDBC Connection from DataSource
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@671c4bc1] will not be managed by Spring
DEBUG [http-bio-8080-exec-12] - ==>  Preparing: SELECT * FROM USER WHERE id=? 
DEBUG [http-bio-8080-exec-12] - ==> Parameters: 10(Integer)
DEBUG [http-bio-8080-exec-12] - <==      Total: 1
DEBUG [http-bio-8080-exec-12] - Returning JDBC Connection to DataSource
DEBUG [http-bio-8080-exec-12] - com.mchange.v2.async.ThreadPoolAsynchronousRunner@48a767dd: Adding task to queue -- com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@50fee334
DEBUG [http-bio-8080-exec-12] - trace com.mchange.v2.resourcepool.BasicResourcePool@161a1f7f [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@514d00d3)
DEBUG [http-bio-8080-exec-12] - Successfully completed request
DEBUG [C3P0PooledConnectionPoolManager[identityToken->1hge8029

3.2结论

1.可以看到mybatis并没有一次性查询出订单以及所属用户，而是等到jsp页面取order的变量user时才发出的查询语句根据user_id查询用户名