SpringBoot整合其他技术

超、凢脫俗 2021-11-09 04:06 356阅读 0赞

一、SpringBoot整合Mybatis

1.1、添加Mybatis的依赖

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.1.0</version>
    </dependency>

1.2、添加数据库驱动依赖

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

1.3、添加数据库连接信息

#数据库连接信息
    spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC
        username: waggag
        password: 225514

1.4、创建User表

CREATE TABLE `user` (
    	`id` int ( 11 ) NOT NULL AUTO_INCREMENT,
    	`username` varchar ( 50 ) DEFAULT NULL,
    	`password` varchar ( 50 ) DEFAULT NULL,
    	`name` varchar ( 50 ) DEFAULT NULL,
    	PRIMARY KEY ( `id` ) 
    ) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARSET = utf8;
    
    INSERT INTO `user`
    VALUES( '1', 'zhangsan', '123', '张三' );
    INSERT INTO `user`
    VALUES( '2', 'lisi', '123', '李四' );

1.5、创建实体类

使用lombok注解，需要引入依赖

<dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
      </dependency>

package cn.waggag.pojo;
    
    import lombok.Data;
    
    @Data
    public class User {
        // 主键
        private Long id;
        // 用户名
        private String username;
        // 密码
        private String password;
        // 姓名
        private String name;
    }

1.6、编写Mapper及映射文件

package cn.waggag.mapper;
    
    import cn.waggag.pojo.User;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    @Mapper
    public interface UserMapper {
        public List<User> queryList();
    }

<?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="cn.waggag.mapper.UserMapper">
        <select id="queryList" resultType="user">
            select * from user
        </select>
    </mapper>

1.7、在application.yml中添加mybatis的信息

#spring集成Mybatis环境
    mybatis:
      #pojo别名扫描包
      type-aliases-package: cn.waggag.pojo
      #加载Mybatis映射文件
      mapper-locations: mapper/*Mapper.xml

1.8、编写Controller

package cn.waggag.controller;
    
    import cn.waggag.mapper.UserMapper;
    import cn.waggag.pojo.User;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.List;
    
    @Controller
    public class UserController {
        @Autowired
        private UserMapper userMapper;
    
        @RequestMapping("/query")
        @ResponseBody
        public List<User> queryList(){
            List<User> userList = userMapper.queryList();
            return userList;
        }
    }

1.9、测试

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MjY0OTk5_size_16_color_FFFFFF_t_70][]

二、SpringBoot整合Junit

2.1、添加Junit的依赖

<dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-test</artifactId>
     </dependency>

2.2、编写测试类

package cn.waggag;
    
    import cn.waggag.domain.User;
    import cn.waggag.mapper.UserMapper;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    
    @SpringBootTest(classes = SpringbootQuick2Application.class)
    @RunWith(SpringRunner.class)
    public class MybatisTest {
    
        @Autowired
        private UserMapper userMapper;
    
        @Test
        public void test(){
            List<User> users = userMapper.queryList();
            System.out.println(users);
        }
    }

三、SpringBoot继承SpringDataJPA

3.1、导入Jpa的依赖

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>

3.2、添加数据库驱动依赖

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

3.3、在application.properties中配置数据库和jpa的相关属性

#DB Configuration:
    spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/springboot?serverTimezone=UTC
    spring.datasource.username=root
    spring.datasource.password=225514
    
    #JPA Configuration:
    spring.jpa.database=MySQL
    spring.jpa.show-sql=true
    spring.jpa.generate-ddl=true
    spring.jpa.hibernate.ddl-auto=update
    spring.jpa.hibernate.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy

3.4、创建实体配置实体

package cn.waggag.pojo;
    
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.GenerationType;
    import javax.persistence.Id;
    
    @Entity
    public class User {
    
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO.IDENTITY)
        private Long id;
        private String name;
        private String username;
        private String password;
    
        public Long getId() {
            return id;
        }
    
        public void setId(Long id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    '}';
        }
    }

3.5、编写UserRespository

package cn.waggag.repository;
    
    import cn.waggag.pojo.User;
    import org.springframework.data.jpa.repository.JpaRepository;
    
    import java.util.List;
    
    public interface UserRepository extends JpaRepository<User,Long> {
    
        List<User> findAll();
    
    }

3.6、编写测试类

package cn.waggag;
    
    import cn.waggag.pojo.User;
    import cn.waggag.repository.UserRepository;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    
    @RunWith(SpringRunner.class)
    @SpringBootTest(classes = JpaApplication.class)
    public class JpaTest {
    
        @Autowired
        private UserRepository userRepository;
    
        @Test
        public void test(){
            List<User> userList = userRepository.findAll();
            System.out.println(userList);
        }
    
    }

3.7、测试结果

![20190805001037623.png][]

四、Springboot整合Redis

4.1、导入Redis的依赖

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-redis</artifactId>
            </dependency>

4.2、配置Redis的连接信息

#配置Redis
    spring.redis.host=106.12.55.66
    server.port=6379

4.3、RedisTemplate操作Redis

package cn.waggag;
    
    import cn.waggag.pojo.User;
    import cn.waggag.repository.UserRepository;
    import com.fasterxml.jackson.core.JsonProcessingException;
    import com.fasterxml.jackson.databind.ObjectMapper;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.data.redis.core.RedisTemplate;
    import org.springframework.test.context.junit4.SpringRunner;
    
    import java.util.List;
    
    @RunWith(SpringRunner.class)
    @SpringBootTest(classes = JpaApplication.class)
    public class RedisTest {
    
        @Autowired
        private RedisTemplate<String,String> redisTemplate;
    
        @Autowired
        private UserRepository userRepository;
    
        @Test
        public void test() throws JsonProcessingException {
            //1.从Redis中获取数据，数据的形式为Json字符串
            String usersJson = redisTemplate.boundValueOps("user.findAll").get();
            //2.判断redis中是否存在数据
            if(usersJson == null){
                //3.不存在数据从数据库中查询
                List<User> userList = userRepository.findAll();
                //4.将查询的数据存储到Redis中
                //4.1将list集合转为json字符串
                ObjectMapper objectMapper = new ObjectMapper();
                usersJson = objectMapper.writeValueAsString(userList);
                //4.2存储到redis
                redisTemplate.boundValueOps("user.findAll").set(usersJson);
    
                System.out.println("============database============");
            }else{
                System.out.println("==============redis============");
            }
            //4.将数据输出
            System.out.println(usersJson);
        }
    }

4.4、redis测试结果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MjY0OTk5_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MjY0OTk5_size_16_color_FFFFFF_t_70]: /images/20211109/5a9f7069c0c64eaebbe4870d3f5de54d.png
[20190805001037623.png]: /images/20211109/4031db6e76df422a8d18b9174879a0b8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MjY0OTk5_size_16_color_FFFFFF_t_70 1]: /images/20211109/b1da4ee680ae4296b096b5d5e957ca4d.png