Springboot整合mybatis开启二级缓存的实现示例

< dependencies >

    < dependency >

        < groupId >org.mybatis.spring.boot</ groupId >

        < artifactId >mybatis-spring-boot-starter</ artifactId >

        < version >2.2.2</ version >

    </ dependency >

    < dependency >

        < groupId >mysql</ groupId >

        < artifactId >mysql-connector-java</ artifactId >

        < scope >runtime</ scope >

    </ dependency >

    < dependencies >    

spring.datasource.type=com.zaxxer.hikari.HikariDataSource

#Spring jdbc 数据源配置 需要mysql-connector-java驱动依赖

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/gefrm?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&serverTimezone=Asia/Shanghai&autoReconnect=true&failOverReadOnly=false

spring.datasource.username=root

spring.datasource.password=123456

#mybatis配置

mybatis.mapper-locations=classpath:mapper/*.xml

mybatis.type-aliases-package=com.example.mybatis_cache.bean

mybatis.configuration.map-underscore-to-camel-case=true

#mybatis缓存

mybatis.configuration.cache-enabled=true

#mybatisSQL执行打印

logging.level测试数据.example.mybatis_cache.mapper=debug

<? 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.example.mybatis_cache.mapper.BscDictInfoTestMapper" >

    <!-- 这个cache 是关键 -->

    < cache eviction = "LRU" flushInterval = "100000" readOnly = "true" size = "1024" />

    <!--可以通过设置useCache来规定这个sql是否开启缓存，ture是开启，false是关闭,刷新缓存：flushCache="true"  useCache="true"-->

    < select id = "selectAll" resultType = "com.example.mybatis_cache.bean.BscDictInfoTestDO" >

        select *

        from bsc_dict_info_test

    </ select >

    <!-- 多个命名空间缓存共享 级联标签 cache-ref 指定namespace即可 -->

    <!--<cache-ref namespace=""/> -->

</ mapper >

< cache

         eviction = "FIFO"

         flushInterval = "60000"

         size = "512"

         readOnly = "true" />

< cache-ref namespace = "com.someone.application.data.SomeMapper" />

/*

  Navicat Premium Data Transfer

  Source Server         : localhost_3306

  Source Server Type    : MySQL

  Source Server Version : 80015

  Source Host           : localhost:3306

  Source Schema         : gefrm

  Target Server Type    : MySQL

  Target Server Version : 80015

  File Encoding         : 65001

  Date : 17/05/2022 16:02:21

*/

SET NAMES utf8mb4;

SET

FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for bsc_dict_info_test

-- ----------------------------

DROP TABLE IF EXISTS `bsc_dict_info_test`;

CREATE TABLE `bsc_dict_info_test`

(

    `dict_id`         varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci   NOT NULL DEFAULT ' ' COMMENT '字典标识' ,

    `dict_name`       varchar (256) CHARACTER SET utf8 COLLATE utf8_general_ci   NOT NULL DEFAULT ' ' COMMENT '字典名称' ,

    `dict_sitm_id`   varchar (32) CHARACTER SET utf8 COLLATE utf8_general_ci   NOT NULL DEFAULT ' ' COMMENT '字典子项标识' ,

    `dict_sitm_name` varchar (256) CHARACTER SET utf8 COLLATE utf8_general_ci   NOT NULL DEFAULT ' ' COMMENT '字典子项名称' ,

    `suse_flag`       char (1) CHARACTER SET utf8 COLLATE utf8_general_ci       NOT NULL DEFAULT '0' COMMENT '启用标志' ,

    `disp_orde`       int (11) NOT NULL DEFAULT 0 COMMENT '展示顺序' ,

    `memo`           varchar (4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '备注'

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic ;

-- ----------------------------

-- Records of bsc_dict_info_test

-- ----------------------------

INSERT INTO `bsc_dict_info_test`

VALUES ( 'bbbbbtest' , '担保人/被担保人与上市公司关联关系' , '999' , '无关联关系' , '0' , 190, '1' );

INSERT INTO `bsc_dict_info_test`

VALUES ( 'aaaaatest' , '担保人/被担保人与上市公司关联关系' , '999' , '无关联关系' , '0' , 190, '1' );

INSERT INTO `bsc_dict_info_test`

VALUES ( 'bbbbbtest' , '担保人/被担保人与上市公司关联关系' , '999' , '无关联关系' , '0' , 190, '1' );

INSERT INTO `bsc_dict_info_test`

VALUES ( 'aaaaatest' , '担保人/被担保人与上市公司关联关系' , '999' , '无关联关系' , '0' , 190, '1' );

INSERT INTO `bsc_dict_info_test`

VALUES ( 'bbbbbtest' , '担保人/被担保人与上市公司关联关系' , '999' , '无关联关系' , '0' , 190, '\'0\'' );

SET

FOREIGN_KEY_CHECKS = 1;

package com.example.mybatis_cache.bean;

import lombok.Builder;

import lombok.Data;

import java.io.Serializable;

/**

  * @author 起凤

  * @description: TODO

  * @date 2022/4/15

  */

@Data

@Builder

public class BscDictInfoTestDO implements Serializable {

    private String dictId;

    private String dictName;

    private String dictSitmId;

    private String dictSitmName;

    private String suseFlag;

    private String dispOrde;

    private String memo;

}

package com.example.mybatis_cache.mapper;

import com.example.mybatis_cache.bean.BscDictInfoTestDO;

import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**

  * @author 起凤

  * @description: TODO

  * @date 2022/4/15

  */

@Mapper

public interface BscDictInfoTestMapper {

    /**

      * 查询所有

      *

      * @return

      */

    List<BscDictInfoTestDO> selectAll();

}

package com.example.mybatis_cache.service;

/**

  * 测试服务

  *

  * @author 起凤

  * @description: TODO

  * @date 2022/4/15

  */

public interface BscDictService {

    void info(String name, int age);

}

package com.example.mybatis_cache.service.impl;

import com.example.mybatis_cache.bean.BscDictInfoTestDO;

import com.example.mybatis_cache.mapper.BscDictInfoTestMapper;

import com.example.mybatis_cache.service.BscDictService;

import lombok.extern.slf4j.Slf4j;

import org.springframework.stereotype.Component;

import javax.annotation.Resource;

import java.util.List;

/**

  * @author 起凤

  * @description: TODO

  * @date 2022/4/15

  */

@Slf4j

@Component

public class BscDictServiceImpl implements BscDictService {

    @Resource

    BscDictInfoTestMapper mapper;

    @Override

    public void info(String name, int age) {

        log.warn( "name:{}, age:{}" , name, age);

        List<BscDictInfoTestDO> list = mapper.selectAll();

        list.forEach(item -> {

            log.error( "{}" , item);

        });

    }

}

package com.example.mybatis_cache.service.impl;

import com.example.mybatis_cache.service.BscDictService;

import com.mysql.cj.xdevapi.SessionFactory;

import lombok.extern.slf4j.Slf4j;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.junit.jupiter.api.Test;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import static org.junit.jupiter.api.Assertions.*;

/**

  * @author 起凤

  * @description: TODO

  * @date 2022/5/16

  */

@Slf4j

@SpringBootTest

class BscDictServiceImplTest {

    @Autowired

    private BscDictService dictService;

    @Test

    void levelOneCacheTest() {

        dictService.info( "a" , 1 );

        log.warn( "======================== 分割线  ======================" );

        dictService.info( "a" , 2 );

    }

    @Test

    void testRawLevelOne() {

    }

}

< dependency >

     < groupId >org.springframework.boot</ groupId >

     < artifactId >spring-boot-starter-cache</ artifactId >

</ dependency >

spring.cache.ehcache.config=classpath:ehcache.xml