MyBatis：缓存（狂神）

 

操作步骤：

 

 

 

 

 

 

 

 do.properties：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=&useUnicode=true&characterEncoding=utf-8
username=root
password=123456

mybatis-config.xml:

<?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核心配置文件-->
<configuration>

<!--    引入外部配置文件-->
    <properties resource="db.properties">
        <property name="username" value="root"/>
        <!--默认优先使用外部的db.properties配置文件中的-->
        <property name="password" value="111"/>
    </properties>


<!--    设置日志-->
    <settings>
        <!-- 标准的日志工厂实现：STDOUT_LOGGING控制台输出0-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!--log4j日志-->
<!--     <setting name="logImpl" value="LOG4J"/>-->
    </settings>


    
<!--    可以给实体类起别名 指定包默认包下实体类别名为小写字母开头-->
    <typeAliases>
        <package name="com.kuang.pojo" />
    </typeAliases>

    <environments default="development"><!--default：默认的环境这里可以配置：多个环境-->
        <environment id="development">
            <!--事务管理-->
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

<!-- 映射器   每一个Mapper.xml文件，都需要在Mybatis核心配置文件中注册:指定包下的所有Mapper文件-->
    <mappers>
        <mapper class="com.kuang.dao.UserMapper"/>
    </mappers>


</configuration>

User:

package com.kuang.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User implements Serializable {
    private int id;
    private String name;
    private String pwd;
}

UserMapper:

package com.kuang.dao;

import com.kuang.pojo.User;
import org.apache.ibatis.annotations.Param;

public interface UserMapper {
    //查询指定用户
    User queryUserById(@Param("id") int id);

    int updateUser(User user);
}

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.kuang.dao.UserMapper">
    <!--使用insert，update，delete，select标签来写sql语句-->

    <!-- 在当前Mapper.xml中使用二级缓存-->
    <cache/>

<!--    单个查询语句可以设置使用缓存useCache="true"-->
    <select id="queryUserById" resultType="user" useCache="true">
         select * from user11 where id=#{id}
    </select>

    <update id="updateUser" parameterType="user">
        update mybatis.user11 set name=#{name},pwd=#{pwd} where id=#{id}
    </update>
</mapper>

MyTest:

import com.kuang.dao.UserMapper;
import com.kuang.pojo.User;
import com.kuang.utils.MybaitsUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

public class MyTest {
    //一级缓存
    @Test
    public void queryUserById(){
        SqlSession sqlSession= MybaitsUtils.getSqlSession();
        UserMapper mapper=sqlSession.getMapper(UserMapper.class);

        User user = mapper.queryUserById(1);
        System.out.println(user);
        //mapper.updateUser(new User(2,"张三2","123456"));//增删改会更新缓存

        sqlSession.clearCache();//手动清理缓存

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

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

        sqlSession.close();
    }
    //二级缓存
    @Test
    public void test2(){
        SqlSession sqlSession= MybaitsUtils.getSqlSession();
        SqlSession sqlSession2= MybaitsUtils.getSqlSession();
        UserMapper mapper=sqlSession.getMapper(UserMapper.class);

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

        System.out.println("================");
        UserMapper mapper2=sqlSession2.getMapper(UserMapper.class);
        User user2=mapper2.queryUserById(1);//从二级缓存中获取
        System.out.println(user2);

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

        User user4=mapper2.queryUserById(2);
        System.out.println(user4);//一级缓存中获取
        

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


    }
}

一次sqlSession开启一级缓存 

 添加更新操作，打开注释，刷新缓存：

手动清理缓存，注释更新，打开注释： 

 二级缓存：

缓存原理

 自定义缓存：

 需要创建一个ehcache.xml：

<?xml version="1.0" encoding="UTF-8"?>
<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:noNamespaceSchemaLocation="http://ehcache.org/ehcache.xsd"
         updateCheck="false">

    <diskStore path="./tmpdir/Tmp_EhCache"/>

    <defaultCache
            eternal="false"
            maxElementsInMemory="10000"
            overflowToDisk="false"
            diskPersistent="false"
            timeToIdleSeconds="1800"
            timeToLiveSeconds="259200"
            memoryStoreEvictionPolicy="LRU"/>

    <cache
            name="cloud_user"
            eternal="false"
            maxElementsInMemory="5000"
            overflowToDisk="false"
            diskPersistent="false"
            timeToIdleSeconds="1800"
            timeToLiveSeconds="1800"
            memoryStoreEvictionPolicy="LRU"/>
</ehcache>