mybatis缓存文件的配置

最新推荐文章于 2024-08-27 19:31:22 发布
最新推荐文章于 2024-08-27 19:31:22 发布
阅读量6.6k 收藏 1
点赞数
分类专栏： mybatis 文章标签： mybatis缓存
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinat_32133675/article/details/76691009
版权

在java程序运行过程中，每次调用都会访问数据库吗？答案是否定的，java会有缓存将访问过的存起来下次调用时就不在连接数据库了，而是从缓存中找。

mybatis缓存详细：http://blog.csdn.net/marvel__dead/article/details/70133715   引用别人的，写的挺好

下面是我自己的测试：

一.配置文件的写法


log4 相关包是为了测试用的，主要在控制台显示程序的进程。ehcache 和 mybatis-ehcache是俩个mybatis的缓存包，外部缓存需要添加的jar包


步骤如下：

1.配置文件： conf.xml          usermapper.xml

2. conf.xml 第四行的setting标签，启用缓存（外部缓存和二级缓存都需要）

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
   <setting name="cacheEnabled" value="true"/>
</settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接信息 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/luntan" />
                <property name="username" value="root" />
                <property name="password" value="mysql" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
       <mapper resource="it/com/mapper/UserMapper.xml"/>
     
    </mappers>
    
</configuration>
3.缓存只有select有，所以那条select使用缓存，记得在标签里将 userCache改成true

    同时配置cache标签，下面代码使用的是外部缓存，被注释的是二级缓存，里面的配置标签property  ehcache.xml文件中有，外部缓存会jar包会自动调用

<?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="it.com.dao">
<!-- 缓存配置  -->
 <cache type="org.mybatis.caches.ehcache.LoggingEhcache">
<!-- <cache type="org.mybatis.caches.ehcache.EhcacheCache">  --> 
        <property name="timeToIdleSeconds" value="3600"/><!--1 hour-->
        <property name="timeToLiveSeconds" value="3600"/><!--1 hour-->
        <property name="maxEntriesLocalHeap" value="10000"/>
        <property name="maxEntriesLocalDisk" value="10000000"/>
    </cache>
   <select id="findall" resultType="Map" useCache="true"><!-- 使用缓存 -->
      select * from users
   </select>
   <select id="findById" resultType="Map" parameterType="String" useCache="true">
      select * from users where userName = #{userName}
   </select>
   <select id="findByIdPwd" resultType="Map" parameterType="Map">
      select * from users where userName = #{userName} and userPwd=#{userPwd}
   </select>
   <insert id="insertByIdPwd" parameterType="Map">
      insert into users(userName,userPwd) values (#{userName},#{userPwd})
   </insert>
</mapper>
4.在userDao中调用方法 

	public List<Map> findById(String userName){
		List<Map> list=null;
		SqlSession session = SF.getSession();
		list=session.selectList("findById",userName);
		session.commit();//使用缓存必须写
		return list;
	}

测试结果： 

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Configuring ehcache from ehcache.xml found in the classpath: file:/F:/myeclipse%20%20workspace/test08021/WebRoot/WEB-INF/classes/ehcache.xml
DEBUG - Configuring ehcache from URL: file:/F:/myeclipse%20%20workspace/test08021/WebRoot/WEB-INF/classes/ehcache.xml
DEBUG - Configuring ehcache from InputStream
DEBUG - Disk Store Path: F:\ehcache111
DEBUG - Creating new CacheManager with default config
DEBUG - propertiesString is null.
DEBUG - No CacheManagerEventListenerFactory class specified. Skipping...
DEBUG - No BootstrapCacheLoaderFactory class specified. Skipping...
DEBUG - CacheWriter factory not configured. Skipping...
DEBUG - No CacheExceptionHandlerFactory class specified. Skipping...
DEBUG - Initialized net.sf.ehcache.store.MemoryStore for it.com.dao
WARN - diskStorePath 'F:\ehcache111' is already used by an existing CacheManager either in the same VM or in a different process.
The diskStore path for this CacheManager will be set to F:\ehcache111\ehcache_auto_created7300060912575425752diskstore.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
DEBUG - Using diskstore path F:\ehcache111\ehcache_auto_created7300060912575425752diskstore
DEBUG - Holding exclusive lock on F:\ehcache111\ehcache_auto_created7300060912575425752diskstore\.ehcache-diskstore.lock
DEBUG - Failed to delete file it%002ecom%002edao.data
DEBUG - Failed to delete file it%002ecom%002edao.index
DEBUG - Matching data file missing (or empty) for index file. Deleting index file F:\ehcache111\ehcache_auto_created7300060912575425752diskstore\it%002ecom%002edao.index
DEBUG - Failed to delete file it%002ecom%002edao.index
DEBUG - Initialised cache: it.com.dao
DEBUG - CacheDecoratorFactory not configured for defaultCache. Skipping for 'it.com.dao'.
DEBUG - Cache Hit Ratio [it.com.dao]: 0.0
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1763371495.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@691ae9e7]
DEBUG - ooo Using Connection [com.mysql.jdbc.Connection@691ae9e7]
DEBUG - ==>  Preparing: select * from users where userName = ? 
DEBUG - ==> Parameters: admire(String)
TRACE - <==    Columns: userName, userPwd, Ename, Email, Logo, userId
TRACE - <==        Row: admire, 111111, 1111, 11111, 12, 1
DEBUG - <==      Total: 1
DEBUG - put added 0 on heap
[{Email=11111, Ename=1111, Logo=12, userId=1, userPwd=111111, userName=admire}]
DEBUG - fault removed 0 from heap
DEBUG - fault added 0 on disk
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
[{Email=11111, Ename=1111, Logo=12, userId=1, userPwd=111111, userName=admire}]
DEBUG - Cache Hit Ratio [it.com.dao]: 1.0
DEBUG - remove deleted 0 from heap
DEBUG - remove deleted 0 from disk

二.注解的写法

注解的写法就相对简单了，只需要在接口文件中

package it.com.db;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import org.apache.ibatis.cache.decorators.LruCache;
//配置缓存
@CacheNamespace(size=100,eviction=LruCache.class,implementation=org.mybatis.caches.ehcache.EhcacheCache.class)

public interface IUsersMapper {
	//打开缓存
	@Options(useCache=true)
	@Select("select * from users")
	public List<Map> findAll();
	
	@Select("select count(1) from users where userName=#{userName}")
	public int findById(@Param("userName") String userName);
	
	
	
	//存储过程
	@Select("call pp11()")
	public List<Map> findAll_a();
}

测试结果：

public int findById(String userName){
		SqlSession session = SF.getSession();
		IUsersMapper um = session.getMapper(IUsersMapper.class);
		int n = um.findById(userName);
		session.commit();
		return n;
	}
public static void main(String[] args) {
		// TODO Auto-generated method stub

		UsersDao user = new UsersDao();

		
		System.out.println(user.findById("admire"));
		System.out.println(user.findById("admire"));
	}

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Configuring ehcache from ehcache.xml found in the classpath: file:/F:/myeclipse%20%20workspace/test08021/WebRoot/WEB-INF/classes/ehcache.xml
DEBUG - Configuring ehcache from URL: file:/F:/myeclipse%20%20workspace/test08021/WebRoot/WEB-INF/classes/ehcache.xml
DEBUG - Configuring ehcache from InputStream
DEBUG - Disk Store Path: F:\ehcache111
DEBUG - Creating new CacheManager with default config
DEBUG - propertiesString is null.
DEBUG - No CacheManagerEventListenerFactory class specified. Skipping...
DEBUG - No BootstrapCacheLoaderFactory class specified. Skipping...
DEBUG - CacheWriter factory not configured. Skipping...
DEBUG - No CacheExceptionHandlerFactory class specified. Skipping...
DEBUG - Initialized net.sf.ehcache.store.MemoryStore for it.com.dao
WARN - diskStorePath 'F:\ehcache111' is already used by an existing CacheManager either in the same VM or in a different process.
The diskStore path for this CacheManager will be set to F:\ehcache111\ehcache_auto_created7300060912575425752diskstore.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
DEBUG - Using diskstore path F:\ehcache111\ehcache_auto_created7300060912575425752diskstore
DEBUG - Holding exclusive lock on F:\ehcache111\ehcache_auto_created7300060912575425752diskstore\.ehcache-diskstore.lock
DEBUG - Failed to delete file it%002ecom%002edao.data
DEBUG - Failed to delete file it%002ecom%002edao.index
DEBUG - Matching data file missing (or empty) for index file. Deleting index file F:\ehcache111\ehcache_auto_created7300060912575425752diskstore\it%002ecom%002edao.index
DEBUG - Failed to delete file it%002ecom%002edao.index
DEBUG - Initialised cache: it.com.dao
DEBUG - CacheDecoratorFactory not configured for defaultCache. Skipping for 'it.com.dao'.
DEBUG - Cache Hit Ratio [it.com.dao]: 0.0
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1763371495.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@691ae9e7]
DEBUG - ooo Using Connection [com.mysql.jdbc.Connection@691ae9e7]
DEBUG - ==>  Preparing: select * from users where userName = ? 
DEBUG - ==> Parameters: admire(String)
TRACE - <==    Columns: userName, userPwd, Ename, Email, Logo, userId
TRACE - <==        Row: admire, 111111, 1111, 11111, 12, 1
DEBUG - <==      Total: 1
DEBUG - put added 0 on heap
[{Email=11111, Ename=1111, Logo=12, userId=1, userPwd=111111, userName=admire}]
DEBUG - fault removed 0 from heap
DEBUG - fault added 0 on disk
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
[{Email=11111, Ename=1111, Logo=12, userId=1, userPwd=111111, userName=admire}]
DEBUG - Cache Hit Ratio [it.com.dao]: 1.0
DEBUG - remove deleted 0 from heap
DEBUG - remove deleted 0 from disk






小秋蜀黍
关注
专栏目录
mybatis-ehcache配置
a506614830om的博客
05-21 218
1.介绍 EhCache 是一个纯Java的进程内缓存框架，具有快速、精干等特点。Ehcache是一种广泛使用的开源Java分布式缓存。主要面向通用缓存,Java EE和轻量级容器。它具有内存和磁盘存储，缓存加载器,缓存扩展,缓存异常处理程序,一个gzip缓存servlet过滤器,支持REST和SOAP api等特点。ehcache 对分布式支持不够好，多个节点不能同步，通常和redis一块使用 在vm重启后，持久化到磁盘的存储可以复原数据 ehcache直接在jvm虚拟机中缓存，速度快，效率高；但是缓存共
Mybatis缓存 自定义缓存
just_learing的博客
04-03 937
Mybatis缓存 自定义缓存
mybatis添加ehcache缓存支持
01-14
mybatis添加ehcache缓存支持，基于maven项目管理
Mybatis入门实例(二)——添加ehcache缓存支持
QiuQiu0817的博客
09-01 286
接上回: Mybatis入门实例(一),地址http://qiuqiu0034.iteye.com/blog/1157768  本帖用的数据库和上面帖子中的数据库相同   为了提高MyBatis的性能,有时候我们需要加入缓存支持,目前用的比较多的缓存莫过于ehcache缓存了,ehcache性能强大,而且位各种应用都提供了解决方案,在此我们主要是做查询缓存,提高查询的效率.   在M...
Mybatis中的缓存
最新发布
ymr1843762281的博客
08-27 1137
缓存(cache）的作用是。缓存实现的原理是中，当再次需要获取该对象时，直接从内存（缓存）中直接获取，不再向数据库Mybatis 有一级缓存和二级缓存。的作用域是同一个 SqlSession，在同一个 sqlSession 中两次执行相同的 sql 语句，第一次执行完毕会将数据库中查询的数据写到缓存（内存），第二次会从缓存中获取数据将不再从数据库查询，从而提高查询效率。当一个 sqlSession 结束后该 sqlSession 中的一级缓存也就不存在了。
mybatis学习笔记(16)-mybatis整合ehcache
brianway
03-02 3211
ehcache是一个分布式缓存框架
MyBatis ehcache配置
Hern（宋兆恒）
03-23 760
需要的jar包 ehcache-core.jar、mybatis-ehcache.jar、slf4j-log4j.jar ehcache.xml配置 属性说明： l diskStore：指定数据在磁盘中的存储位置。 l defaultCache：当借助CacheManager.add("demoCache")创建Cache时，EhCache便会采用<defalutCache/>指...
mybatis缓存的配置文件
10-25
1. **开启全局缓存**：在MyBatis的主配置文件（mybatis-config.xml）中，设置`cacheEnabled`为`true`来开启缓存功能。 ```xml ``` 2. **配置二级缓存**：在Mapper接口对应的XML配置文件中，定义一个`...
Mybatis 缓存原理及失效情况解析
08-25
使用二级缓存需要在核心配置文件中添加配置，例如：，然后在每个mapper.xml中配置使用二级缓存，例如：或：。 结论是只要开启了二级缓存，我们在同一个Mapper中的查询，可以在二级缓存中拿到数据。查出的数据都会被...
MyBatis缓存功能原理及实例解析
08-19
MyBatis缓存功能原理及实例解析 MyBatis缓存功能原理及实例解析是MyBatis框架中非常重要的一部分，它可以极大的提升查询效率，解决高并发系统的性能问题。缓存机制可以将用户经常查询的数据放在缓存（内存）中，...
mybatis + ehcache 配置
fengxing_2的专栏
07-12 287
mybatis + ehcache 配置 1、引入ehcache jar包，pom.xml添加 <dependency> <groupId>net.sf.ehcache</groupId> <artifactId>ehcache</artifactId> <version>2....
mybatis 使用第三方缓存 EHCache 的配置
猎人在吃肉
12-11 477
mybatis 有一级缓存和二级缓存。其中，一级缓存是内置的，默认开启的，无法更改；由于mybatis 不是专业的缓存厂商，因此提现了二级缓存接口，便于专业的缓存厂商来实现。无论是mybatis 内置的二级缓存，还是第三方实现的二级缓存，除了缓存本身需要进行一定的配置外， 普通开发者的业务代码不需要做任何变动。存在 SLF4J 时，作为简易日志的 log4j 将失效，此时我们需要借助 SLF4J 的具体实现 logback 来打印日志。默认二级缓存是mybatis内置的，改成 EHCache 的二级缓存。
ehcache 冲突_解决Ehcache缓存警告问题
weixin_39785422的博客
01-17 1314
警告: Creating a new instance of CacheManager using the diskStorePath "D:\Apache Tomcat 6.0.18\temp" which is already used by an existing CacheManager.The source of the configuration was classpath.The d...
MyBatis（五）——MyBatis中的缓存机制
传臣、的博客
03-13 1783
一、概述 　　MyBatis 包含一个非常强大的查询缓存特性，它可以非常方便地配置和定制。MyBatis中的缓存机制可以极大的提升查询效率。 　　MyBatis系统中默认定义了两级缓存。一级缓存和二级缓存。 　　 　　1、默认情况下，只有一级缓存（SqlSession级别的缓存，也称为本地缓存）开启。 　　2、二级缓存需要手动开启和配置，他是基于namespace级别的缓存。 　　3、...
java.sql.SQLSyntaxErrorException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY...
weixin_30399797的博客
07-24 727
2019-07-24 17:24:35 下午 [Thread: http-8080-4][ Class:net.sf.ehcache.store.disk.Segment Method: net.sf.ehcache.store.disk.Segment.put(Segment.java:453) ]DEBUG:put updated, deleted 0 on heap2019-07-24 17...
Tomcat Creating a new instance of CacheManager
未央
04-15 4876
<br />项目中Tomcat 报错<br />警告: Creating a new instance of CacheManager using the diskStorePath "D:/Apache Tomcat 6.0.18/temp" which is already used by an existing CacheManager. <br />The source of the configuration was classpath. <br />The diskStore path for
MyBatis笔记——EhCache二级缓存
weixin_34174422的博客
09-22 119
介绍 ehcache是一个分布式缓存框架。 我们系统为了提高系统并发，性能、一般对系统进行分布式部署（集群部署方式） 不使用分布缓存，缓存的数据在各各服务单独存储，不方便系统开发。所以要使用分布式缓存对缓存数据进行集中管理。 mybatis无法实现分布式缓存，需要和其它分布式缓存框架进行整合。这里我主要介绍整合EhCache。下面开始实例。 实例 1.导入MyBa...
Mybatis缓存优化与Redis集成验证
"Mybatis缓存机制包括一级缓存和二级缓存，以及与Redis结合实现的DAO和服务层缓存优化。一级缓存基于SqlSession，二级缓存基于mapper映射文件，而Redis缓存则提供了更高效的分布式解决方案。本文讨论了如何配置和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值