resultMap可以实现高级映射,即使用association和collection实现一对一、一对多的映射,association和collection具备懒加载的功能。懒加载可以提高数据库性能,MyBatis延迟加载的策略是先从单表查询然后再从关联表查询,这样可以大大提高数据库性能,单表查询要比关联查询多张表速度要快。
1、数据库设计
user用户表
orders订单表
orders订单表外键
2、需求
查询订单表,并且关联用户信息
3、SQL语句
4、实现
4.1、在MyBatis配置文件SqlMapConfig.xml中添加全局参数
<settings>
<!-- 打开延迟加载的开关 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!-- 将积极加载改为消极加载即按需要加载 -->
<setting name="aggressiveLazyLoading" value="false"/>
</settings>
4.2、在OrdersMapper.xml文件中添加resultMap
<!-- 延迟加载的resultMap -->
<resultMap type="org.mybatis.demo.po.Orders" id="OrdersUserLazyLoadingResultMap">
<!--对订单信息进行映射配置 -->
<id column="id" property="id" />
<result column="user_id" property="userId" />
<result column="number" property="number" />
<result column="createtime" property="createtime" />
<result column="note" property="note" />
<!-- 实现对用户信息进行延迟加载 select:指定延迟加载需要执行的statement的id(是根据user_id查询用户信息的statement)
,如果findUserById不在本mapper中需要前边加namespace
column:订单信息中关联用户信息查询的列,是user_id,即外键-->
<association property="user" javaType="org.mybatis.demo.po.User"
select="org.mybatis.demo.mapper.OrdersMapper.findUserById" column="user_id">
</association>
</resultMap>
4.3、select中引用resultMap
<select id="findUserById" parameterType="int" resultType="org.mybatis.demo.po.User">
SELECT * FROM USER WHERE id=#{value}
</select>
<!-- 查询订单关联查询用户,用户信息需要延迟加载 -->
<select id="findOrdersUserLazyLoading" resultMap="OrdersUserLazyLoadingResultMap">
SELECT * FROM orders
</select>
4.4、创建OrdersMapper接口关联OrdersMapper.xml
package org.mybatis.demo.mapper;
import java.util.List;
import org.mybatis.demo.po.Orders;
public interface OrdersMapper {
public List<Orders> findOrdersUserLazyLoading();
}
4.5、测试
package org.mybatis.demo.test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;
import org.mybatis.demo.mapper.OrdersMapper;
import org.mybatis.demo.po.Orders;
public class TestMyBatis {
private SqlSessionFactory sessionFactory;
@Before
public void createSqlSessionFactory() throws IOException {
//引入配置文件
String resource = "SqlMapConfig.xml";
InputStream ins = Resources.getResourceAsStream(resource);
//创建SqlSession对象
sessionFactory = new SqlSessionFactoryBuilder().build(ins);
}
@Test
public void test1() {
SqlSession session = null;
try {
session = sessionFactory.openSession();
OrdersMapper mapper = session.getMapper(OrdersMapper.class);
List<Orders> list = mapper.findOrdersUserLazyLoading();
for(Orders order : list){
System.out.println(order.getUser().getUsername() + " 在 " +order.getCreatetime() + " 提交了订单");
}
} finally {
if(session != null){
session.close();
}
}
}
}
4.6、源代码