MyBatis框架一级缓存与二级缓存

最新推荐文章于 2024-04-08 18:00:00 发布

明月夜～

最新推荐文章于 2024-04-08 18:00:00 发布

阅读量141

点赞数

本文链接：https://blog.csdn.net/myy_llc/article/details/104722148

版权

为了提升查询效率，提高用户体验，MyBatis提供了数据缓存支持，依据数据缓存的有效范围默认定义了一级缓存和二级缓存
一级缓存：
1、该级缓存默认开启，不能关闭；
2、该级缓存为SqlSession级别的缓存，也称为本地缓存；
3、以下4种情况将会导致该级缓存失效：
a、在不同SqlSession中查询数据;

public class Test {
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
			
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select();
			System.out.println(list.size());
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
			
			//打开了一个新的SqlSession
			sqlSession = sqlSessionFactory.openSession();
			userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

运行代码结果如下：

DEBUG 03-07 21:05:41,772 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:05:41,828 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:05:41,850 <==      Total: 7  (BaseJdbcLogger.java:159) 
7
7
DEBUG 03-07 21:05:41,852 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:05:41,852 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:05:41,854 <==      Total: 7  (BaseJdbcLogger.java:159) 
7

b、相同SqlSession中查询数据，但查询条件不同

public class Test {
	
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select("%小%");
			System.out.println(list.size());
			list = userInfoDao.select("%黑%");
			System.out.println(list.size());
			sqlSession.close();
			
			
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

运行结果如下：

DEBUG 03-07 21:07:39,461 ==>  Preparing: select * from user_info WHERE name like ?   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:07:39,501 ==> Parameters: %小%(String)  (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:07:39,525 <==      Total: 6  (BaseJdbcLogger.java:159) 
6
DEBUG 03-07 21:07:39,526 ==>  Preparing: select * from user_info WHERE name like ?   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:07:39,526 ==> Parameters: %黑%(String)  (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:07:39,527 <==      Total: 1  (BaseJdbcLogger.java:159) 
1

c、相同SqlSession中查询数据，但两次查询之间执行了增删改操作

public class Test {
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select();
			System.out.println(list.size());
			
			boolean flag = userInfoDao.delete(7);
			System.out.println(flag);
			
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

结果如下：

DEBUG 03-07 21:13:01,235 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,273 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,295 <==      Total: 7  (BaseJdbcLogger.java:159) 
7
DEBUG 03-07 21:13:01,302 ==>  Preparing: delete from user_info where id=?   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,302 ==> Parameters: 7(Integer)  (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,304 <==    Updates: 1  (BaseJdbcLogger.java:159) 
true
DEBUG 03-07 21:13:01,305 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,305 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:13:01,307 <==      Total: 6  (BaseJdbcLogger.java:159) 
6

d、相同SqlSession中查询数据，但第二次查询前，程序调用SqlSession对象clearCache()方法手动清除了一级缓存

public class Test {
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select();
			System.out.println(list.size());
			
			sqlSession.clearCache();
			
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

结果如下：

DEBUG 03-07 21:14:44,325 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:14:44,368 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:14:44,387 <==      Total: 7  (BaseJdbcLogger.java:159) 
7
DEBUG 03-07 21:14:44,388 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:14:44,389 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:14:44,391 <==      Total: 7  (BaseJdbcLogger.java:159) 
7

二级缓存
1、该级缓存默认不开启，但如果使用二级缓存需要在每个XML映射文件中添加以配置该级缓存。二级缓存可以通过在全局配置文件配置setting标签来关闭该级缓存。
cache标签属性：

			eviction：缓存回收策略：LRU – 最近最少使用的：移除最长时间不被使用的对象，默认值；FIFO – 先进先出：按对象进入缓存的顺序来移除它们；SOFT – 软引用：移除基于垃圾回收器状态和软引用规则的对象；WEAK – 弱引用：更积极地移除基于垃圾收集器状态和弱引用规则的对象；
			flushInterval：刷新间隔，单位毫秒，默认情况是不设置，也就是没有刷新间隔，缓存仅仅调用语句时刷新
			size：引用数目，正整数，代表缓存最多可以存储多少个对象，太大容易导致内存溢出
			readOnly：只读，默认为false。true：只读缓存；会给所有调用者返回缓存对象的相同实例，速度快；false：读写缓存；会返回缓存对象的拷贝（通过序列化），速度慢但安全。

2、该级缓存为namespace级别的缓存
3、工作机制：通过SqlSession查询数据，这些数据将会放到当前会话的一级缓存中；如果当前会话关闭，则一级缓存中的数据会被保存到二级缓存中，此后新的SqlSession将从二级缓存中查找数据；

public class Test {
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select();
			System.out.println(list.size());
			
			sqlSession.close();
			
			sqlSession = sqlSessionFactory.openSession();
			userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

结果如下：

DEBUG 03-07 21:17:09,983 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:17:10,021 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:17:10,043 <==      Total: 7  (BaseJdbcLogger.java:159) 
7
DEBUG 03-07 21:17:10,045 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:17:10,045 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:17:10,047 <==      Total: 7  (BaseJdbcLogger.java:159) 
7

4、select标签的useCache属性用于设置是否使用二级缓存；insert、update、delete或select标签均有flushCache属性，其中增删改默认true，即sql执行以后，会同时清空一级和二级缓存，查询默认false。

public class Test {
	public static void main(String[] args) {
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			IUserInfoDao userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			List<UserInfo> list = userInfoDao.select();
			System.out.println(list.size());
			
			sqlSession.close();
			
			sqlSession = sqlSessionFactory.openSession();
			userInfoDao = sqlSession.getMapper(IUserInfoDao.class);
			boolean flag = userInfoDao.delete(5);//清空二级缓存
			System.out.println(flag);
			
			list = userInfoDao.select();
			System.out.println(list.size());
			sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

运行结果如下：

DEBUG 03-07 21:18:38,945 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:38,981 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:39,002 <==      Total: 7  (BaseJdbcLogger.java:159) 
7
DEBUG 03-07 21:18:39,007 ==>  Preparing: delete from user_info where id=?   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:39,007 ==> Parameters: 5(Integer)  (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:39,015 <==    Updates: 1  (BaseJdbcLogger.java:159) 
true
DEBUG 03-07 21:18:39,015 ==>  Preparing: select * from user_info   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:39,016 ==> Parameters:   (BaseJdbcLogger.java:159) 
DEBUG 03-07 21:18:39,018 <==      Total: 6  (BaseJdbcLogger.java:159) 
6

这样清空缓存很不方便，会把缓存全部删除，缓存框架redis就很灵活，可以只删除需要的那一条缓存，不影响其他无关缓存，从缓存和数据库来删除这条数据。

5、为了提高扩展性，MyBatis定义了Cache缓存接口，可以通过实现该缓存接口自定义二级缓存，jar包下载：https://github.com/mybatis。

明月夜～

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MyBatis框架一级缓存与二级缓存

为了提升查询效率，提高用户体验，MyBatis提供了数据缓存支持，依据数据缓存的有效范围默认定义了一级缓存和二级缓存一级缓存：1、该级缓存默认开启，不能关闭；2、该级缓存为SqlSession级别的缓存，也称为本地缓存；3、以下4种情况将会导致该级缓存失效：a、在不同SqlSession中查询数据;public class Test { public static void main...
复制链接

扫一扫