7.springboot+mybatis+redis整合

 

选择生成的依赖

 

 

选择保存的工程路径

 

 

查询已经生成的依赖，并修改mysql的版本

<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-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>
        <!--修改mysql的驱动版本-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

 

项目结构如下：

 

 

 

编辑属性文件application.properties

server.port=8080

#spring.application.name=springboot-redis

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/kgc
spring.datasource.username=root
spring.datasource.password=ok


#redis
#redis的服务所在的ip地址
spring.redis.host=192.168.117.143
#redis的端口号
spring.redis.port=6379   
#  redis数据库索引（默认为0) 密码默认是没有的，可以不写
spring.redis.database=0

#打印sql语句，改为自己的mapper包路径
logging.level.cn.kgc.mapper=debug

 

 

创建持久化类Student.java

package cn.kgc.vo;

import java.io.Serializable;

/**
 * Created by Administrator on 2019/7/22.
 */
public class Student implements Serializable{
    private Integer sid;
    private String sname;
    private String password;
    private String subject;
    private String result;
    private Integer cid;

    public Student() {
    }

    public Student(Integer sid, String sname, String password, String subject, String result, Integer cid) {
        this.sid = sid;
        this.sname = sname;
        this.password = password;
        this.subject = subject;
        this.result = result;
        this.cid = cid;
    }

    public Integer getSid() {
        return sid;
    }

    public void setSid(Integer sid) {
        this.sid = sid;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getSubject() {
        return subject;
    }

    public void setSubject(String subject) {
        this.subject = subject;
    }

    public String getResult() {
        return result;
    }

    public void setResult(String result) {
        this.result = result;
    }

    public Integer getCid() {
        return cid;
    }

    public void setCid(Integer cid) {
        this.cid = cid;
    }

    @Override
    public String toString() {
        return "Student{" +
                "sid=" + sid +
                ", sname='" + sname + '\'' +
                ", password='" + password + '\'' +
                ", subject='" + subject + '\'' +
                ", result='" + result + '\'' +
                ", cid=" + cid +
                '}';
    }
}

 

创建数据访问层接口StudentMapper.java

package cn.kgc.mapper;

import cn.kgc.vo.Student;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * Created by Administrator on 2019/7/22.
 */
public interface StudentMapper {
    @Select("select * from student")
    List<Student> findAll();

    @Select("select * from student where sid=#{sid}")
    Student findBySid(Integer sid);

    @Delete("delete from student where sid=#{sid}")
    int del(Integer sid);

    @Update("update student set sname=#{sname},password=#{password},subject=#{subject},result=#{result},cid=#{cid} where sid=#{sid}")
    int modify(Student student);

    @Insert("insert into student(sname,password,subject,result,cid) values(#{sname},#{password},#{subject},#{result},#{cid})")
    int add(Student student);

}

 

创建业务层接口StudentService.java

package cn.kgc.service;

import cn.kgc.vo.Student;

import java.util.List;

/**
 * Created by Administrator on 2019/7/22.
 */
public interface StudentService {
    List<Student> findAll();

    Student findBySid(Integer sid);

    int del(Integer sid);

    int modify(Student student);

    int add(Student student);
}

 

创建业务层接口实现类StudentServiceImpl.java

package cn.kgc.service;

import cn.kgc.mapper.StudentMapper;
import cn.kgc.vo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.ListOperations;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.core.ValueOperations;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
@Transactional
public class StudentServiceImpl implements StudentService{
    @Autowired
    StudentMapper studentMapper;

    @Autowired
    RedisTemplate redisTemplate;

    @Override
    public List<Student> findAll() {
        String key="student";
        ListOperations<String,Student> operations= redisTemplate.opsForList();

        //缓存存在
        if (redisTemplate.hasKey(key)){
            return operations.range(key,0,-1);
        }else{
            //得到学生集合
            List<Student> list=studentMapper.findAll();
            operations.leftPushAll(key,list);
            return list;
        }
    }

    @Override
    public Student findBySid(Integer sid) {
        String key = "student_" + sid;
        ValueOperations<String, Student> operations = redisTemplate.opsForValue();

        //缓存存在
        if (redisTemplate.hasKey(key)) {
            System.out.println("redis-siddata");
            return operations.get(key);
        } else {
            //得到学生对象
            Student student = studentMapper.findBySid(sid);
            //添加到缓存
            operations.set(key, student);
            System.out.println("student-siddata");
            return student;
        }
    }

    @Override
    public int del(Integer sid) {
        //删除数据库中的数据
        int count = studentMapper.del(sid);

        //缓存存在
        String key = "student_" + sid;
        if (redisTemplate.hasKey(key)) {
            //删除对应缓存
            redisTemplate.delete(key);
        }
        return count;
    }

    @Override
    public int modify(Student student) {
        //修改数据库中的数据
        int count = studentMapper.modify(student);

        ValueOperations operations = redisTemplate.opsForValue();
        //缓存存在
        String key = "student_" + student.getSid();
        if (redisTemplate.hasKey(key)) {
            //更新缓存
            Student stu = studentMapper.findBySid(student.getSid());
            operations.set(key, stu);
        }
        return count;
    }

    @Override
    public int add(Student student) {
        //添加数据
        int count = studentMapper.add(student);
        return count;
    }
}

 

 

创建控制层StudentController.java

package cn.kgc.controller;

import cn.kgc.service.StudentService;
import cn.kgc.vo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
public class StudentController {

    @Autowired
    StudentService studentService;

    @GetMapping("/student")
    public List<Student> findAll() {
        return studentService.findAll();
    }

  /*  @GetMapping("/student/{sid}")
    public Student findById(@PathVariable("sid") Integer sid) {
        return studentService.findBySid(sid);
    }
*/
  @GetMapping("/findById")
  public Student findById(Integer sid) {
      return studentService.findBySid(sid);
  }

    @PostMapping("/student/{sid}")
    public int del(@PathVariable("sid") Integer sid) {
        return studentService.del(sid);
    }

    @PutMapping("/student")
    public int modify(Student student) {
        return studentService.modify(student);
    }

}

 

启动类

package cn.kgc;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
//指定要扫描的mapper包
@MapperScan("cn.kgc.mapper")
@SpringBootApplication
public class SpringbootMybatisRedisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootMybatisRedisApplication.class, args);
    }

}

 

 

测试如下：

 

 

第一次访问

 

 

查看redis

 

 

 

 第二次访问