一,改造cache-client
1.1 基于上一篇Spring cloud学习之路(九,Redis的使用)https://blog.csdn.net/Zhang_Jackson/article/details/103309627,我们进行进一步的改造,在pom.xml 文件中,我们加入对项目进行打包成jar包的标注:<packaging>jar</packaging>代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.7.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.zhanghq</groupId>
<artifactId>cache-client</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>cache-client</name>
<packaging>jar</packaging>
<description>Demo project for Spring Boot</description>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.8</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
1.2 点击package,对项目进行打成jar包,(这一步可以不进行)
二,对producer工程进行改造
备注:基于第四工程 Spring cloud学习之路(三,服务提供者 )https://blog.csdn.net/Zhang_Jackson/article/details/103289720进行大改造,引入mybaits,对数据进行操作;实现功能是:
1)用户访问数据
2)服务端先从Redis缓存中寻找数据
3)判断是否存在此数据
存在:直接从Redis中获取数据并返回
不存在:从数据库中获取数据,然后在Redis中缓存一份,再返回数据
工程结构如图:
2.1 在producer工程的pom.xml文件中,我们加入cache-client 依赖和mybaitis依赖,代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.7.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.zhanghq</groupId>
<artifactId>producer</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>producer</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<spring-cloud.version>Greenwich.SR2</spring-cloud.version>
</properties>
<dependencies>
<dependency>
<groupId>com.zhanghq</groupId>
<artifactId>common</artifactId>
<version>0.0.1-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>com.zhanghq</groupId>
<artifactId>cache-client</artifactId>
<version>0.0.1-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.0</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.0</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.28</version>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-netflix-hystrix</artifactId>
</dependency>
<!-- Hystrix Dashboard是作为断路器状态的一个组件,提供了数据监控和友好的图形化界面。-->
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-netflix-hystrix-dashboard</artifactId>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>${spring-cloud.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.2 对application.yml 进行改造,添加redis所需要的配置和数据库的配置,代码如下:
eureka:
instance:
hostname: localhost
client:
serviceUrl:
defaultZone: http://localhost:8761/eureka/
server:
port: 8762
spring:
application:
name: producer
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
username: root
password: qq199511
driver-class-name: com.mysql.cj.jdbc.Driver
redis:
database: 0 # Redis数据库索引(默认为0)
host: localhost # Redis服务器地址
port: 6379 # Redis服务器连接端口
max-wait: 30000 # 连接池最大阻塞等待时间(使用负值表示没有限制)
max-active: 100 # 连接池最大连接数(使用负值表示没有限制)
max-idle: 20 # 连接池中的最大空闲连接
min-idle: 0 # 连接池中的最小空闲连接
timeout: 3000 # 连接超时时间(毫秒)
mybatis:
mapper-locations: classpath:mapping/*.xml #mapper文件路径
type-aliases-package: com.zhanghq.producer.entity #实体类的包路径
#解决http://localhost:8762/actuator/hystrix.stream无法访问的问题
management:
endpoints:
web:
exposure:
include: "*"
2.3 实体类 Book,我已经抽取出来作为公共部分使用了,在pom.xml文件引入common依赖,代码如下:
package com.zhanghq.common.entity;
import java.io.Serializable;
import java.util.Date;
public class Book implements Serializable {
private Integer id;
private String name;
private String author;
private Double pay;
private Date buyTime;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author == null ? null : author.trim();
}
public Double getPay() {
return pay;
}
public void setPay(Double pay) {
this.pay = pay;
}
public Date getBuyTime() {
return buyTime;
}
public void setBuyTime(Date buyTime) {
this.buyTime = buyTime;
}
}
2.4 添加BookService接口:
public interface BookService {
int deleteByPrimaryKey(Integer id);
int insert(Book record);
int insertSelective(Book record);
Book selectByPrimaryKey(Integer id);
int updateByPrimaryKeySelective(Book record);
int updateByPrimaryKey(Book record);
List<Book> selectAllBooks();
}
2.5 添加BookMapper映射接口:
public interface BookMapper {
int deleteByPrimaryKey(Integer id);
int insert(Book record);
int insertSelective(Book record);
Book selectByPrimaryKey(Integer id);
int updateByPrimaryKeySelective(Book record);
int updateByPrimaryKey(Book record);
List<Book> selectAllBooks();
}
2.6 添加BookMapper.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.zhanghq.producer.mapper.BookMapper">
<resultMap id="BaseResultMap" type="com.zhanghq.common.entity.Book" >
<id column="id" property="id" jdbcType="INTEGER" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="author" property="author" jdbcType="VARCHAR" />
<result column="pay" property="pay" jdbcType="DOUBLE" />
<result column="buy_time" property="buyTime" jdbcType="TIMESTAMP" />
</resultMap>
<sql id="Base_Column_List" >
id, name, author, pay, buy_time
</sql>
<select id="selectAllBooks" resultType="com.zhanghq.common.entity.Book">
select
<include refid="Base_Column_List"/>
from book;
</select>
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select
<include refid="Base_Column_List" />
from book
where id = #{id,jdbcType=INTEGER}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
delete from book
where id = #{id,jdbcType=INTEGER}
</delete>
<insert id="insert" parameterType="com.zhanghq.common.entity.Book" >
insert into book (id, name, author,
pay, buy_time)
values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{author,jdbcType=VARCHAR},
#{pay,jdbcType=DOUBLE}, #{buyTime,jdbcType=TIMESTAMP})
</insert>
<insert id="insertSelective" parameterType="com.zhanghq.common.entity.Book" >
insert into book
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="id != null" >
id,
</if>
<if test="name != null" >
name,
</if>
<if test="author != null" >
author,
</if>
<if test="pay != null" >
pay,
</if>
<if test="buyTime != null" >
buy_time,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="id != null" >
#{id,jdbcType=INTEGER},
</if>
<if test="name != null" >
#{name,jdbcType=VARCHAR},
</if>
<if test="author != null" >
#{author,jdbcType=VARCHAR},
</if>
<if test="pay != null" >
#{pay,jdbcType=DOUBLE},
</if>
<if test="buyTime != null" >
#{buyTime,jdbcType=TIMESTAMP},
</if>
</trim>
</insert>
<update id="updateByPrimaryKeySelective" parameterType="com.zhanghq.common.entity.Book" >
update book
<set >
<if test="name != null" >
name = #{name,jdbcType=VARCHAR},
</if>
<if test="author != null" >
author = #{author,jdbcType=VARCHAR},
</if>
<if test="pay != null" >
pay = #{pay,jdbcType=DOUBLE},
</if>
<if test="buyTime != null" >
buy_time = #{buyTime,jdbcType=TIMESTAMP},
</if>
</set>
where id = #{id,jdbcType=INTEGER}
</update>
<update id="updateByPrimaryKey" parameterType="com.zhanghq.common.entity.Book" >
update book
set name = #{name,jdbcType=VARCHAR},
author = #{author,jdbcType=VARCHAR},
pay = #{pay,jdbcType=DOUBLE},
buy_time = #{buyTime,jdbcType=TIMESTAMP}
where id = #{id,jdbcType=INTEGER}
</update>
</mapper>
2.7 添加BookService实现类BookServiceImpl:
@Service
public class BookServiceImpl implements BookService {
private static final Logger LOGGER = LoggerFactory.getLogger(BookServiceImpl.class);
@Autowired(required = false)
private BookMapper bookMapper;
@Resource
private RedisUtil redisUtil;
@Override
public int deleteByPrimaryKey(Integer id) {
return 0;
}
@Override
public int insert(Book record) {
return 0;
}
@Override
public int insertSelective(Book record) {
return bookMapper.insertSelective(record);
}
@Override
public Book selectByPrimaryKey(Integer id) {
String key = "book_" + id;
// 判断缓存是否存在数据
boolean hasKey = redisUtil.hasKey(key);
if(hasKey){
Book bookCache = (Book)redisUtil.get(key);
LOGGER.info("从缓存里寻找数据" + bookCache.toString());
return bookCache;
}
Book book = bookMapper.selectByPrimaryKey(id);
if(null!=book){
String keyCache = "book_" + book.getId();
LOGGER.info("从DB里获取数据" + book.toString());
redisUtil.set(keyCache, book);
LOGGER.info("把数据插入缓存中。。。");
return book;
}
return null;
}
@Override
public int updateByPrimaryKeySelective(Book record) {
return 0;
}
@Override
public int updateByPrimaryKey(Book record) {
return 0;
}
@Override
public List<Book> selectAllBooks() {
return bookMapper.selectAllBooks();
}
}
2.8 添加controller对外访问层BookController类:
@RestController
@RequestMapping("book")
public class BookController {
@Autowired
BookService bookService;
@RequestMapping(value = "/insert", method = RequestMethod.GET)
public void insertBook(Book book){
bookService.insertSelective(book);
}
@ResponseBody
@RequestMapping(value = "/selectAllBooks", method = RequestMethod.GET)
private List<Book> sllectAllBooks(){
return bookService.selectAllBooks();
}
@ResponseBody
@RequestMapping(value = "/getBook", method = RequestMethod.GET)
private Book getBook(@RequestParam String id){
return bookService.selectByPrimaryKey(new Integer(id));
}
@RequestMapping(value = "/insertAllBooks", method = RequestMethod.GET)
public void insertBooks(){
String bookName = "book";
String author = "jackson";
for (int i = 0; i < 10; i++) {
Book book = new Book();
book.setName(bookName + i);
book.setAuthor(author + i);
book.setPay(5.5*i);
insertBook(book);
}
}
}
2.9 修改启动类,代码:
@SpringBootApplication
@EnableEurekaClient
@EnableHystrix //注解开启断路器
@EnableHystrixDashboard //开启HystrixDashboard
@EnableCircuitBreaker //
@MapperScan("com.zhanghq.producer.mapper")
@ComponentScan(basePackages={"com.zhanghq"}) // 默认扫描是本模块Application同级的包
public class ProducerApplication {
public static void main(String[] args) {
SpringApplication.run(ProducerApplication.class, args);
}
}
2.10 依次启动 eureka-server,producer,feign-consermer 项目
打开posman工具测试,也可以用浏览器或其他工具测试。
输入:http://localhost:8764/getBook?id=1 第一次测试:
第二次测试:
两个圈出来的时间进行对比,明显第二次测试比第一次测试的时间少很多;我查看一下日志:
第一次是从数据中获取的数据,第二次从Redis缓存获取,所以造成了时间明显少了很多。
上一篇:Spring cloud学习之路(九,Redis的使用)https://blog.csdn.net/Zhang_Jackson/article/details/103309627
下一篇:
代码已经放在了GitHub上:https://github.com/JacksonZhangHuaQuan/SpringCloudDemo