springboot结合mysql和redis数据库进行数据读取和缓存的demo
结尾有项目代码的gitee下载路径。
依赖的导入,本案例需要的依赖在下方
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-cache</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
数据表sql
/*
Navicat MySQL Data Transfer
Source Server : MySQL80
Source Server Version : 80026
Source Host : 127.0.0.1:3306
Source Database : cheshi
Target Server Type : MYSQL
Target Server Version : 80026
File Encoding : 65001
Date: 2022-05-05 20:46:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for users