【进击全栈 1】SpringCloud项目起步、nacos、gateway、Redis、mybatis组件搭建

r囧r小猫 2021-09-07 15:34 379阅读 0赞

## 一、前期准备 ##

本项目暂定项目名GooReeyProject，SpringBoot + Vue构建，具体项目内容未定。

基本架构nacos、gateway、Linux、Redis、rabbitMQ、MySQL、docker、Vue。

### 1、安装MySQL5.7 ###

### 2、安装nacos ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70][]

我安装的是window版的nacos和MySQL，安装nacos时需要注意，要讲配置文件中的集群版改为单机版，才能启动！

### 3、安装Redis ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 1][]

## 二、创建父工程 ##

我觉得主要是pom文件

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.guor</groupId>
        <artifactId>GooReeyProject</artifactId>
        <version>1.0-SNAPSHOT</version>
        <modules>
            <module>01common</module>
            <module>02gateway</module>
        </modules>
    
        <properties>
            <system.version>1.0.0</system.version>
            <system.ip>127.0.0.1</system.ip>
            <system.sport>808</system.sport>
            <system.mode>http</system.mode>
            <java.version>1.8</java.version>
            <spring-cloud.version>Greenwich.SR1</spring-cloud.version>
            <skipTests>true</skipTests>
            <nacos.version>0.2.2.RELEASE</nacos.version>
        </properties>
    
        <packaging>pom</packaging>
        <name>GooReeyProject</name>
        <description>This is parent project</description>
    
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.4.RELEASE</version>
        </parent>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <scope>provided</scope>
            </dependency>
    
            <dependency>
                <groupId>commons-lang</groupId>
                <artifactId>commons-lang</artifactId>
                <version>2.6</version>
            </dependency>
    
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.5</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.23</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
                <version>0.2.1.RELEASE</version>
            </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>
                <dependency>
                    <groupId>org.springframework.cloud</groupId>
                    <artifactId>spring-cloud-alibaba-dependencies</artifactId>
                    <version>${nacos.version}</version>
                    <type>pom</type>
                    <scope>import</scope>
                </dependency>
            </dependencies>
        </dependencyManagement>
    
        <build>
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.*</include>
                    </includes>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.yml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.xml</include>
                    </includes>
                </resource>
            </resources>
        </build>
    </project>

## 三、创建gateway子工程 ##

### 1、pom文件 ###

### 2、配置文件 ###

spring:
      application:
        name: gateway
      cloud:
        nacos:
          discovery:
            server-addr: 127.0.0.1:8848
          config:
            server-addr: 127.0.0.1:8848
            file-extension: yml
            ext-config:
              - data-id: datasource-share-config.yml
                group: SHARE_GROUP
                refresh: true
              - data-id: log-share-config.yml
                group: SHARE_GROUP
                refresh: true

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 2][]

（1）gateway.yml

server:
      port: 8080
          
    spring:
      application:
        name: gateway
        version: 1.0.0
      cloud:
        gateway:                      
          discovery:
            locator:
              enabled: true
              lowerCaseServiceId: true
              filters: 
                - StripPrefix=1     
          routes:
            - id: management
              uri: lb:management   # 服务端 service_id
              predicates:
                - Path=/management/**
              filters: 
                - name: Hystrix 
                  args: 
                    name: fallbackcmd
                    fallbackUri: forward:/defaultFallback
            - id: demo
              uri: lb://demo
              predicates:
                - Path=/demo/**
                
    hystrix:
      command:
        default:
          execution:
            isolation:
              strategy: SEMAPHORE
              thread:
                timeoutInMilliseconds: 1500
      shareSecurityContext: true
                    
    config: 
      scheduleThreadPool: 5
      restTemplateTimeout: 3000
     
    setting: 
      loginAccessPath: /permission
     
    login: 
      tokenCheckFrequency: 600000

（2）datasource-share-config.yml

spring:
      datasource:
        url: jdbc:mysql://localhost:3306/blue?serverTimezone=UTC
        driverClassName: com.mysql.cj.jdbc.Driver
        username: root
        password: root
    mybatis:
      typeAliasesPackage: com.guor.*.bean.**
      mapperLocations: classpath*:**/com/guor/**/dao/mapping/*Mapper.xml
      configuration:
        map-underscore-to-camel-case: true

（3）log-share-config.yml

logging: 
      path: logs
      level:
        root: info
        com.panasonic.mes: debug
        com.panasonic.mes.editor: debug
        com.alibaba.nacos.client.naming: warn 
      file: 
        max-size: 20MB
        max-history: 30
      pattern: 
        file: "%d{${LOG_DATEFORMAT_PATTERN:yyyy-MM-dd HH:mm:ss.SSS}} ${LOG_LEVEL_PATTERN:%5p} ${PID:- } --- [%15.15t] %-40.40logger{39} [%5.5line] : %m%n${LOG_EXCEPTION_CONVERSION_WORD:%wEx}"
        console: "%d{${LOG_DATEFORMAT_PATTERN:yyyy-MM-dd HH:mm:ss.SSS}} %clr(${LOG_LEVEL_PATTERN:%5p}) %clr(${PID:- }){magenta} --- %clr([%15.15t]){faint} %clr(%-40.40logger{39}){cyan} %clr([%5.5line]){cyan} : %m%n${LOG_EXCEPTION_CONVERSION_WORD:%wEx}"

### 3、启动类 ###

package com.guor;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
    import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    import org.springframework.cloud.context.config.annotation.RefreshScope;
    import org.springframework.scheduling.annotation.EnableScheduling;
    
    @SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
    @EnableDiscoveryClient
    @EnableScheduling
    @RefreshScope
    public class GatewayApplication {
        public static void main(String[] args) {
            SpringApplication.run(GatewayApplication.class, args);
            System.out.println("hello world");
        }
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 3][]

## 四、创建management管理模块 ##

### 1、pom文件 ###

### 2、配置文件 ###

spring:
      application:
        name: management
      cloud:
        nacos:
          discovery:
            server-addr: 127.0.0.1:8848
          config:
            server-addr: 127.0.0.1:8848
            file-extension: yml
            ext-config:
              - data-id: datasource-share-config.yml
                group: SHARE_GROUP
                refresh: true
              - data-id: log-share-config.yml
                group: SHARE_GROUP
                refresh: true

server:
      port: 8081
     
    spring:
      application:
        name: management
        version: 1.0.0
      mvc:
       static-path-pattern: /management/**
      resources:
        static-locations: 
        - file:../../web/management
        - file:../../web/common

### 3、启动类 ###

package com.guor;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    import org.springframework.cloud.context.config.annotation.RefreshScope;
    
    @EnableDiscoveryClient
    @SpringBootApplication(scanBasePackages = "com.guor")
    @MapperScan("com.guor.management.dao")
    @RefreshScope
    public class ManagementApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(ManagementApplication.class, args);
        }
    
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 4][]

## 五、整合mybatis ##

### 1、user表设计 ###

数据库选择的是最常用的MySQL

CREATE TABLE `user` (
      `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `username` varchar(100) NOT NULL,
      `password` varchar(40) NOT NULL,
      `age` int(11) DEFAULT NULL,
      `sex` int(11) DEFAULT NULL,
      `telephone` varchar(100) DEFAULT NULL,
      `address` varchar(100) DEFAULT NULL,
      `create_date` date DEFAULT NULL,
      `update_date` date DEFAULT NULL,
      `deleted` int(11) DEFAULT NULL,
      `version` int(11) DEFAULT NULL,
      PRIMARY KEY (`user_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

### 2、UserController ###

package com.guor.management.controller;
    
    import com.guor.management.bean.User;
    import com.guor.management.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.PutMapping;
    import org.springframework.web.bind.annotation.RequestBody;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    @RestController
    public class UserController {
        @Autowired
        private UserService userService;
    
        @GetMapping("/getUserList")
        public List<User> getUserList(){
            return userService.getUserList();
        }
    
        @PutMapping("/insertUser")
        public void insertUser(@RequestBody User user){
            userService.insertUser(user);
        }
    }

### 3、UserService ###

package com.guor.management.service;
    
    import com.guor.management.bean.User;
    
    import java.util.List;
    
    public interface UserService {
        List<User> getUserList();
        void insertUser(User user);
    }

package com.guor.management.service.impl;
    
    import com.guor.management.bean.User;
    import com.guor.management.dao.UserMapper;
    import com.guor.management.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class UserServiceImpl implements UserService {
        @Autowired
        private UserMapper userMapper;
    
        @Override
        public List<User> getUserList() {
            return userMapper.getUserList();
        }
    
        @Override
        public void insertUser(User user) {
            userMapper.insertUser(user);
        }
    }

### 4、UserMapper ###

package com.guor.management.dao;
    
    import com.guor.management.bean.User;
    
    import java.util.List;
    
    public interface UserMapper {
        public List<User> getUserList();
    
        public void insertUser(User user);
    }

<?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.guor.management.dao.UserMapper">
        <select id="getUserList" resultType="java.util.LinkedHashMap">
            select * from user;
        </select>
    
        <insert id="insertUser" parameterType="com.guor.management.bean.User">
            INSERT INTO gooreey.`user` (username, password) VALUES (#{username}, #{password});
        </insert>
    </mapper>

### 5、User ###

package com.guor.management.bean;
    
    import com.guor.base.bean.BaseBean;
    import lombok.Data;
    
    @Data
    public class User extends BaseBean {
       private Integer userId;
       private String username;
       private String password;
       private Integer age;
       private Integer sex;
       private String telephone;
       private String address;
    }

package com.guor.base.bean;
    
    import lombok.Data;
    
    import java.util.Date;
    
    @Data
    public class BaseBean {
        private Date createDate;
        private Date updateDate;
        private Integer deleted;
        private Integer version;
    }

### 6、postman接口测试 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 6][]

往期精彩内容：

[Java知识体系总结（2021版）][Java_2021]

[Java多线程基础知识总结][Java]

[【全栈最全Java框架总结】SSH、SSM、Springboot][Java_SSH_SSM_Springboot]

[超详细的springBoot学习笔记][springBoot]

[常见数据结构与算法整理总结][Link 1]

[Java设计模式：23种设计模式全面解析][Java_23]

[Java面试题总结（附答案）][Java 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70]: /images/20210813/adf37a831cf54c7f90039743adec650a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 1]: /images/20210813/1190b85ac1254ff6a043ededa1804e60.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 2]: /images/20210813/7a88cd774a6d4ba4991e8bcddd3a1562.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 3]: /images/20210813/a8f868703488415ca20e3411ab87a2bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 4]: /images/20210813/4f1dc8c9ebc74735a57555b5ac5aa7c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 5]: /images/20210813/57941652074044609cf810adb19c05d6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b3J1aV9qYXZh_size_16_color_FFFFFF_t_70 6]: /images/20210813/a82552aa8837494f91283cf467d42ae3.png
[Java_2021]: https://blog.csdn.net/guorui_java/article/details/112391105
[Java]: https://blog.csdn.net/guorui_java/article/details/107599455
[Java_SSH_SSM_Springboot]: https://blog.csdn.net/guorui_java/article/details/104018528
[springBoot]: https://blog.csdn.net/guorui_java/article/details/104137262
[Link 1]: https://blog.csdn.net/guorui_java/article/details/106217472
[Java_23]: https://blog.csdn.net/guorui_java/article/details/104026988
[Java 1]: https://blog.csdn.net/guorui_java/article/details/107803283