MyBatis高级第二章 缓存
github源码(day56-mybatis-senior) https://github.com/1196557363/ideaMavenProject
【MyBatis篇】四. MyBatis高级第一章 #{}和${}符号的区别
项目准备
- 因为在同一个module中所以大环境不用改,参考第一章的项目准备
- 将接口com.wpj.dao.IUserDao2 改为 com.wpj.dao2.IUserDao2 已示区分知识点
- mapper也改为mapper2 接口对应映射文件的namespace记得改。
- MyBatis的mapper映射记得加。
缓存
1.1 一级缓存sqlSession
1.1.1 接口
package com.wpj.dao2;
import com.wpj.bean.*;
import org.apache.ibatis.annotations.*;
import java.util.*;
/**
* ClassName: IUserDao2
* Description:
*
* @author JieKaMi
* @version 1.0
* @date: 2020\1\7 0007 19:02
* @since JDK 1.8
*/
public interface IUserDao2 {
User getUserById(Integer id);
}
1.1.2 接口对应mapper
<?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.wpj.dao2.IUserDao2">
<select id="getUserById" resultType="user">
select * from user where id = #{id}
</select>
</mapper>
1.1.3 test
import com.wpj.bean.*;
import com.wpj.dao.*;
import com.wpj.dao2.IUserDao2;
import org.apache.ibatis.io.*;
import org.apache.ibatis.session.*;
import org.junit.*;
import java.io.*;
import java.util.*;
/**
* ClassName: MyBatisTest
* Description:
*
* @author JieKaMi
* @version 1.0
* @date: 2020\1\7 0007 19:19
* @since JDK 1.8
*/
public class MyBatisTest2 {
/**
* 测试一级缓存
*/
@Test
public void testSqlSessionCache(){
String config = "MyBatis.xml";
InputStream is = null;
try {
is = Resources.getResourceAsStream(config);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
// 可以和数据库建立连接
SqlSession sqlSession = sqlSessionFactory.openSession();
IUserDao2 userDao2 = sqlSession.getMapper(IUserDao2.class);
User user = userDao2.getUserById(1);
System.out.println(user);
System.out.println("-------sqlSession分割线--------");
User user2 = userDao2.getUserById(2);
System.out.println(user2);
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
} finally {
if(is!=null) {
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
}
1.1.4 结果
Preparing: select * from user where id = ?
Parameters: 1(Integer)
Total: 1
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
-------sqlSession分割线--------
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
发了1条sql语句,一级缓存已经开启。(默认开启) 不能在sqlSession.close()之后去查询。
1.2 二级缓存
1.2.1 test
/**
* 测试二级缓存
*/
@Test
public void testSqlSessionFactoryCache(){
String config = "MyBatis.xml";
InputStream is = null;
try {
is = Resources.getResourceAsStream(config);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
SqlSession sqlSession = sqlSessionFactory.openSession();
IUserDao2 userDao2 = sqlSession.getMapper(IUserDao2.class);
User user = userDao2.getUserById(1);
System.out.println(user);
System.out.println("-------sqlSessionFactory分割线--------");
SqlSession sqlSession2 = sqlSessionFactory.openSession();
IUserDao2 userDao22 = sqlSession2.getMapper(IUserDao2.class);
User user2 = userDao22.getUserById(1);
System.out.println(user2);
sqlSession.close();
sqlSession2.close();
} catch (IOException e) {
e.printStackTrace();
} finally {
if(is!=null) {
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
1.2.2 结果
Opening JDBC Connection
Created connection 1920467934.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@727803de]
Preparing: select * from user where id = ?
Parameters: 1(Integer)
Total: 1
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
-------sqlSessionFactory分割线--------
Opening JDBC Connection
Created connection 1514160588.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@5a4041cc]
Preparing: select * from user where id = ?
Parameters: 1(Integer)
Total: 1
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
连接了2次JDBC Connection 很明显没有二级缓存 (默认关闭)
1.3 开启二级缓存
1.3.1 接口对应mapper文件中添加<cache />
<!-- 开启二级缓存 -->
<cache />
1.3.2 User实现序列化接口
public class User implements Serializable{
private Integer id;
private String name;
private String pwd;
private Integer age;
...
}
1.3.3 sqlSession要提交事务
/**
* 测试二级缓存
*/
@Test
public void testSqlSessionFactoryCache(){
String config = "MyBatis.xml";
InputStream is = null;
try {
is = Resources.getResourceAsStream(config);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
SqlSession sqlSession = sqlSessionFactory.openSession();
IUserDao2 userDao2 = sqlSession.getMapper(IUserDao2.class);
User user = userDao2.getUserById(1);
sqlSession.commit(); // 开启二级缓存需提交事务
System.out.println(user);
System.out.println("-------sqlSessionFactory分割线--------");
SqlSession sqlSession2 = sqlSessionFactory.openSession();
IUserDao2 userDao22 = sqlSession2.getMapper(IUserDao2.class);
User user2 = userDao22.getUserById(1);
System.out.println(user2);
sqlSession.close();
sqlSession2.close();
} catch (IOException e) {
e.printStackTrace();
} finally {
if(is!=null) {
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
1.3.4 结果
Opening JDBC Connection
Created connection 282432134.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@10d59286]
Preparing: select * from user where id = ?
Parameters: 1(Integer)
Total: 1
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
-------sqlSessionFactory分割线--------
2020-01-07 21:27:48 DEBUG com.wpj.dao2.IUserDao2:62 - Cache Hit Ratio [com.wpj.dao2.IUserDao2]: 0.5
User{id=1, name=‘wpj’, pwd=‘123’, age=22}
只连接了1次JDBC Connection,并且第二次是从cache中取得 开启了二级缓存。
1.2.2 二级缓存的其他配置
<!--
useCache
true:默认值
false:可以设置这条sql语句的结果不缓存,只是对二级缓存才有效
-->
<select id="getUserById" resultType="user" useCache="false">
select * from user where id = #{id}
</select>
<!-- flushCache
二级缓存默认会在insert,update,detele操作后刷新缓存,通过配置false达到不刷新。
-->
<!--
size:设置缓存中最大能放1024个对象
readOnly:设置放在缓存中的数据是否是只读的(一般都是只读的)
eviction:设置缓存的清空策略
LRU:最少使用原则,移除最长时间不使用的对象
FIFO:先进先出原则,按照对象进入缓存顺序进行回收
flushInterval:缓存刷新时间间隔
-->
<cache size="1024" readOnly="true" eviction="LRU" flushInterval="100000"/>