MyBatis 缓存

MyBatis 缓存

使⽤缓存的作用也是为了减少 Java Application 与数据库的交互次数，从而提升程序的运行效率。

MyBatis 有两种缓存：一级缓存和二级缓存。

一级缓存

MyBatis 自带⼀级缓存，并且是无法关闭的，⼀直存在，⼀级缓存的数据存储在 SqlSession 中。即使用同⼀个 SqlSession 进行查询操作的时候，⼀级缓存存在，如果使用多个 SqlSession 进行查询操作，⼀级缓存不存在，缓存只针对于查询，但是如果 SqlSession 执行了增、删、改操作，MyBatis 会自动清空 SqlSession 缓存中的数据，以此来保证数据的⼀致性。

一级缓存不需要进行任何配置，直接使用即可。

1、实体类

package com.southwind.entity;
import lombok.Data;
@Data
public class MyClass {
 private Integer id;
 private String name; }

2、Mapper.java

package com.southwind.repository;
import com.southwind.entity.MyClass;
public interface MyClassRepository {
 public MyClass findById(Integer id);
}

3、Mapper.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.southwind.repository.MyClassRepository">
 <select id="findById" parameterType="java.lang.Integer"
resultType="com.southwind.entity.MyClass">
 select * from t_classes where id = #{id}
 </select>
</mapper>

4、Test

package com.southwind.test;
import com.southwind.entity.MyClass;
import com.southwind.repository.MyClassRepository;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.InputStream;
public class Test6 {
 public static void main(String[] args) {
 InputStream inputStream =
Test2.class.getClassLoader().getResourceAsStream("config.xml");
 SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new
SqlSessionFactoryBuilder();
 SqlSessionFactory sqlSessionFactory =
sqlSessionFactoryBuilder.build(inputStream);
 SqlSession sqlSession = sqlSessionFactory.openSession();
 MyClassRepository myClassRepository =
sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass = myClassRepository.findById(1);
 System.out.println(myClass);
 MyClass myClass2 = myClassRepository.findById(1);
 System.out.println(myClass2);
 }
}

package com.southwind.test;
import com.southwind.entity.MyClass;
import com.southwind.repository.MyClassRepository;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.InputStream;
public class Test6 {
 public static void main(String[] args) {
 InputStream inputStream =
Test2.class.getClassLoader().getResourceAsStream("config.xml");
 SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new
SqlSessionFactoryBuilder();
 SqlSessionFactory sqlSessionFactory =
sqlSessionFactoryBuilder.build(inputStream);
 SqlSession sqlSession = sqlSessionFactory.openSession();
 MyClassRepository myClassRepository =
sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass = myClassRepository.findById(1);
 System.out.println(myClass);
 //关闭sqlSession
 sqlSession.close();
 //开启新的sqlSession
 sqlSession = sqlSessionFactory.openSession();
 myClassRepository = sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass2 = myClassRepository.findById(1);
 System.out.println(myClass2);
 }
}

二级缓存

MyBatis 二级缓存是比一级缓存作用域更⼤的缓存机制，它是 Mapper 级别的，只要是同⼀个Mapper，无论使用多少个 SqlSession，数据都是共享的。

MyBatis ⼆级缓存默认是关闭的，需要使用时可以通过配置手动开启。
MyBatis 可以使用自带的⼆级缓存，也可以使用第三⽅ ehcache ⼆级缓存。

自带二级缓存

1、config.xml 中配置开启二级缓存。

<settings>
 <!-- 开启⼆级缓存 -->
 <setting name="cacheEnabled" value="true"/>
</settings>

2、Mapper.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.southwind.repository.MyClassRepository">
 <cache></cache>
 <select id="findById" parameterType="java.lang.Integer"
resultType="com.southwind.entity.MyClass">
 select * from t_classes where id = #{id}
 </select>
</mapper>

3、实体类实现 Serializable 接口。

package com.southwind.entity;
import lombok.Data;
import java.io.Serializable;
@Data
public class MyClass implements Serializable {
 private Integer id;
 private String name; }

4、测试。

package com.southwind.test;
import com.southwind.entity.MyClass;
import com.southwind.repository.MyClassRepository;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.InputStream;
public class Test6 {
 public static void main(String[] args) {
 InputStream inputStream =
Test2.class.getClassLoader().getResourceAsStream("config.xml");
 SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new
SqlSessionFactoryBuilder();
 SqlSessionFactory sqlSessionFactory =
sqlSessionFactoryBuilder.build(inputStream);
 SqlSession sqlSession = sqlSessionFactory.openSession();
 MyClassRepository myClassRepository =
sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass = myClassRepository.findById(1);
 System.out.println(myClass);
 sqlSession.close();
 sqlSession = sqlSessionFactory.openSession();
 myClassRepository = sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass2 = myClassRepository.findById(1);
 System.out.println(myClass2);
 }
}

第三方ehcache 二级缓存

1、pom.xml

<!-- ehcache -->
<dependency>
 <groupId>net.sf.ehcache</groupId>
 <artifactId>ehcache-core</artifactId>
 <version>2.4.3</version>
</dependency> <dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis-ehcache</artifactId>
 <version>1.0.0</version>
</dependency>

2、resources 路径下创建 ehcache.xml

<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation="../config/ehcache.xsd">
 <diskStore/>
 <defaultCache
 maxElementsInMemory="1000"
 maxElementsOnDisk="10000000"
 eternal="false"
 overflowToDisk="false"
 timeToIdleSeconds="120"
 timeToLiveSeconds="120"
 diskExpiryThreadIntervalSeconds="120"
 memoryStoreEvictionPolicy="LRU">
 </defaultCache>
</ehcache>

3、config.xml 中配置二级缓存。

<settings>
 <!-- 开启⼆级缓存 -->
 <setting name="cacheEnabled" value="true"/>
</settings>

4、Mapper.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.southwind.repository.MyClassRepository">
 <!-- 开启⼆级缓存 -->
 <cache type="org.mybatis.caches.ehcache.EhcacheCache" >
 <!-- 缓存创建以后，最后⼀次访问缓存的时间⾄失效的时间间隔 -->
 <property name="timeToIdleSeconds" value="3600"/>
 <!-- 缓存⾃创建时间起⾄失效的时间间隔-->
 <property name="timeToLiveSeconds" value="3600"/>
 <!-- 缓存回收策略，LRU移除近期最少使⽤的对象 -->
 <property name="memoryStoreEvictionPolicy" value="LRU"/>
 </cache>
 <select id="findById" parameterType="java.lang.Integer"
resultType="com.southwind.entity.MyClass">
 select * from t_classes where id = #{id}
 </select>
</mapper>

5、实体类不需要实现序列化接口。

package com.southwind.entity;
import lombok.Data;
@Data
public class MyClass {
 private Integer id;
 private String name; }

6、测试

package com.southwind.test;
import com.southwind.entity.MyClass;
import com.southwind.repository.MyClassRepository;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.InputStream;
public class Test6 {
 public static void main(String[] args) {
 InputStream inputStream =
Test2.class.getClassLoader().getResourceAsStream("config.xml");
 SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new
SqlSessionFactoryBuilder();
 SqlSessionFactory sqlSessionFactory =
sqlSessionFactoryBuilder.build(inputStream);
 SqlSession sqlSession = sqlSessionFactory.openSession();
 MyClassRepository myClassRepository =
sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass = myClassRepository.findById(1);
 System.out.println(myClass);
 sqlSession.close();
 sqlSession = sqlSessionFactory.openSession();
 myClassRepository = sqlSession.getMapper(MyClassRepository.class);
 MyClass myClass2 = myClassRepository.findById(1);
 System.out.println(myClass2);
 }
}