MyBatis07：缓存

MyBatis07：缓存

缓存

1. 内存中的临时数据
2. 经常查询的数据放在缓存中，提高效率
3. mybatis中默认定义两级缓存：一级缓存、二级缓存

一级缓存

• 默认开启，SqlSession级别的缓存，也叫本地缓存
• 同一次会话查询到的数据会放在本地缓存
• 一级缓存就是一个map

搭建项目

接口

User queryUserById(@Param("id")int id);

UserMapper.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.wgg.mapper.UserMapper">

    <select id="queryUserById" resultType="user">
        select * from user where id=#{id}
    </select>

</mapper>

测试

@Test
public void testQueryUserById(){
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);

    User user1 = mapper.queryUserById(1);
    System.out.println(user1);

    User user2 = mapper.queryUserById(1);
    System.out.println(user2);

    System.out.println(user1==user2);

    session.close();
}

一级缓存失效

sqlSession不同

每个sqlSession中的缓存相互独立

@Test
public void testQueryUserById(){
    SqlSession session1 = MybatisUtils.getSession();
    SqlSession session2 = MybatisUtils.getSession();

    UserMapper mapper1 = session1.getMapper(UserMapper.class);
    UserMapper mapper2 = session2.getMapper(UserMapper.class);

    User user1 = mapper1.queryUserById(1);
    System.out.println(user1);

    User user2 = mapper2.queryUserById(1);
    System.out.println(user2);

    System.out.println(user1==user2);

    session1.close();
    session2.close();
}

sqlSession相同，查询条件不同

@Test
public void testQueryUserById(){
    SqlSession session = MybatisUtils.getSession();

    UserMapper mapper1 = session.getMapper(UserMapper.class);
    UserMapper mapper2 = session.getMapper(UserMapper.class);

    User user1 = mapper1.queryUserById(1);
    System.out.println(user1);

    User user2 = mapper2.queryUserById(2);
    System.out.println(user2);

    System.out.println(user1==user2);

    session.close();
}

sqlSession相同，两次查询之间执行了增删改操作

因为增删改操作可能会对当前数据产生影响

接口方法

int updateUser(Map map);

<update id="updateUser" parameterType="map">
    update user set name=#{name} where id=#{id}
</update>

测试

@Test
public void testQueryUserById(){
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);

    User user = mapper.queryUserById(1);
    System.out.println(user);

    HashMap map = new HashMap();
    map.put("name","张山");
    map.put("id",4);
    mapper.updateUser(map);

    //修改后再查询
    User user2 = mapper.queryUserById(1);
    System.out.println(user2);

    System.out.println(user==user2);

    session.close();
}

sqlSession相同，手动清除一级缓存

@Test
public void testQueryUserById(){
    SqlSession session = MybatisUtils.getSession();
    UserMapper mapper = session.getMapper(UserMapper.class);

    User user = mapper.queryUserById(1);
    System.out.println(user);

    session.clearCache();//手动清除缓存

    User user2 = mapper.queryUserById(1);
    System.out.println(user2);

    System.out.println(user==user2);

    session.close();
}

二级缓存

• 需要手动开启，namespace级别的缓存，通过实现Cache接口来自定义二级缓存

• 也叫全局缓存，

• 工作机制

• • 一个会话查询一条数据，这个数据就会被放在当前会话的一级缓存中；
  • 如果当前会话关闭了，这个会话对应的一级缓存就没了；但是我们想要的是，会话关闭了，一级缓存中的数据被保存到二级缓存中；
  • 新的会话查询信息，就可以从二级缓存中获取内容；
  • 不同的mapper查出的数据会放在自己对应的缓存（map）中；

开启二级缓存

mybatis-config.xml中

<setting name="cacheEnabled" value="true"/>

UserMapper.xml中配置使用

<cache/>

可以配置的属性

<cache
 eviction="FIFO"
 flushInterval="60000"	//隔60秒刷新
 size="512"
 readOnly="true"/>

实体类需要序列化

public class User implements Serializable{

测试

@Test
public void testQueryUserById(){
    SqlSession session1 = MybatisUtils.getSession();
    SqlSession session2 = MybatisUtils.getSession();

    UserMapper mapper1 = session1.getMapper(UserMapper.class);
    UserMapper mapper2 = session2.getMapper(UserMapper.class);

    User user1 = mapper1.queryUserById(1);
    System.out.println(user1);
    session1.close();

    User user2 = mapper2.queryUserById(1);
    System.out.println(user2);

    System.out.println(user1==user2);

    session2.close();
}

缓存原理

第三方缓存EhCache

添加依赖

<dependency>
   <groupId>org.mybatis.caches</groupId>
   <artifactId>mybatis-ehcache</artifactId>
   <version>1.1.0</version>
</dependency>

userMapper.xml

<mapper namespace="org.acme.FooMapper">
    <cache type="org.mybatis.caches.ehcache.EhcacheCache"/>
</mapper>