SpringCloud微服务_微服务 system-优快云博客

本文链接：https://blog.youkuaiyun.com/EricYYYyy_/article/details/127926261

SpringCloud微服务

新建数据库

新建第一个数据库DB-01,新建一个表，表的字段有部门编号dept_no,部门名字dept_name,数据库名字db_source，部门编号dept_no为主键。

往数据库插入数据：DATABASE()函数用于获取当前数据库名字。

insert into dept (dept_name, db_source) values ('开发部',DATABASE());
insert into dept (dept_name, db_source) values ('人事部',DATABASE());
insert into dept (dept_name, db_source) values ('财务部',DATABASE());
insert into dept (dept_name, db_source) values ('市场部',DATABASE());
insert into dept (dept_name, db_source) values ('运维部',DATABASE());

3.建立实体类

新建一个module名为spring-api，在com.yhq.springcloud。pojo下创建实体类

注意：实体类中属性应该与数据库字段名字相同，否则会出现注入不成功的问题，导致mybatis查询数据为空的问题。

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-1JCRRCzB-1668762383103)(/Users/ericyang/Library/Application Support/typora-user-images/image-20221111214152662.png)]

4.导入依赖：

父工程的pom.xml内容：

在父工程中把需要引入的依赖写好，配置好版本，则在子工程中不用指定版本号，只需要引入对应依赖。

<?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>org.example</groupId>
    <artifactId>SpringCloud</artifactId>
    <version>1.0-SNAPSHOT</version>
    <modules>
        <module>springcloud-api</module>
        <module>springcloud-provider-dept-8001</module>
    </modules>

    <!--打包方式  pom-->
    <packaging>pom</packaging>


    <!--把版本提取出来，以后需改版本只需在这修改，简洁方便-->
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
        <junit.version>4.12</junit.version>
        <lombok.version>1.16.18</lombok.version>
        <log4j.version>1.2.17</log4j.version>
    </properties>

    <dependencyManagement>
        <dependencies>
            <!--springCloud的依赖-->
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>Greenwich.SR1</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>

            <!--SpringBoot依赖-->
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>2.1.4.RELEASE</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>

            <!--连接数据库的依赖-->
            <!--数据库驱动-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.12</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.10</version>
            </dependency>
            <!--SpringBoot启动器-->
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            <!--junit-->
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>${junit.version}</version>
            </dependency>

            <!--lombok-->
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>${lombok.version}</version>
            </dependency>

            <!--log4j-->
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>${log4j.version}</version>
            </dependency>

            <!--与日志相关-->
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-core</artifactId>
                <version>1.2.3</version>
            </dependency>
        </dependencies>
    </dependencyManagement>


</project>

5.新建一个module，名为springcloud-provider-dept-8001，在里面编写dao，service和controller

引入该module需要的依赖

因为实体类不在同一个module，我们需要在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">
    <parent>
        <artifactId>SpringCloud</artifactId>
        <groupId>org.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>springcloud-provider-dept-8001</artifactId>

    <dependencies>
        <!--首先需要拿到实体类，所以需要配置api module-->
        <dependency>
            <groupId>org.example</groupId>
            <artifactId>springcloud-api</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        </dependency>

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

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
        </dependency>

        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-core</artifactId>
        </dependency>

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-test</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>
        </dependency>

        <!--jetty  类似Tomcat-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jetty</artifactId>
        </dependency>

        <!--热部署工具-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
    </dependencies>

    <build>
        <!-- 如果不添加此节点mybatis的mapper.xml文件都会被漏掉。 -->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

</project>

在resources文件夹下新建一个application.yaml文件，里面写spring和mybatis的配置

这里注意mapper-locations不要写少了一个“s"

port:指明该项目的启动端口

mapper-locations：指明dao层mapper.java对应的xml配置文件在哪

config-location：指明mybatis的配置文件在哪

server:
  port: 8001

#mybatis配置
mybatis:
   type-aliases-package: com.yhq.springcloud.pojo
   config-location: classpath:mybatis/mybatis-config.xml
   mapper-locations: classpath:mybatis/mapper/*.xml


#Spring配置
spring:
  application:
    name: springcloud-provider-dept
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource #数据源
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/db01?useSSl=false&serverTimezone=UTC&characterEncoding=utf-8
    username: root
    password: 88888888

根据7配置的位置创建mybatis-config.xml,内容如下

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!--开启二级缓存，一级缓存默认开启-->
        <setting name="cacheEnabled" value="true"/>
    </settings>
</configuration>

创建dao层，在com.yhq.springcloud.dao包下新建一个名为DeptDao的接口，名字也可以为DeptMapper。内容如下

package com.yhq.springcloud.dao;


import com.yhq.springcloud.pojo.Dept;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;


/*使用@mapper后，不需要在spring配置中设置扫描地址，
通过mapper.xml里面的namespace属性对应相关的mapper类，spring将动态的生成Bean后注入到ServiceImpl中

@Mapper注解是由Mybatis框架中定义的一个描述数据层接口的注解，注解往往起到的都是一个描述性作用，
用于告诉sprigng框架此接口的实现类由Mybatis负责创建，并将其实现类对象存储到spring容器中。
*/

@Mapper
@Repository
public interface DeptDao {
    public boolean addDept(Dept dept);

    public Dept queryById(@Param("deptNo") Long id);

    public List<Dept> queryAllDept();
}

Mapper.java中通常声明一些用于访问数据库的方法，加@Mapper注解，并加@Repository让spring托管这个类。

创建dao层的Mapper.xml文件，这个文件相当于实现mapper.java接口中声明的方法。

内容如下：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.yhq.springcloud.dao.DeptDao">

    <insert id="addDept" parameterType="Dept">
        insert into db01.dept(dname,db_source)
        values (#{deptName},DATABASE());
    </insert>

    <select id="queryById" resultType="Dept" parameterType="Long">
        select * from db01.dept where deptno=#{deptNo};
    </select>

    <select id="queryAllDept" resultType="Dept" >
        select * from db01.dept;
    </select>
</mapper>

编写service层

DeptService内容如下：

package com.yhq.springcloud.service;

import com.yhq.springcloud.pojo.Dept;

import java.util.List;

public interface DeptService {
    public boolean addDept(Dept dept);

    public Dept queryById(Long id);

    public List<Dept> queryAllDept();
}

DeptServiceImpl内容如下：

service层调用dao层。

package com.yhq.springcloud.service;

import com.yhq.springcloud.dao.DeptDao;
import com.yhq.springcloud.pojo.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class DeptServiceImpl implements DeptService {

    @Autowired//自动注入，代替了DeptDao deptDao=new DeptDao();这个操作
    private DeptDao deptDao;

    @Override
    public boolean addDept(Dept dept) {
        return deptDao.addDept(dept);
    }

    @Override
    public Dept queryById(Long id) {
        return deptDao.queryById(id);
    }

    @Override
    public List<Dept> queryAllDept() {
        //System.out.println("service"+deptDao.queryAllDept());
        return deptDao.queryAllDept();
    }
}

编写controller，内容如下：

我们写的这个子项目为服务提供者，所以controller就是向外提供服务，让用户访问一个请求就能调用到对应服务。

package com.yhq.springcloud.controller;


import com.yhq.springcloud.pojo.Dept;
import com.yhq.springcloud.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

//为了提供Restful服务
@RestController
public class DeptController {
    @Autowired
    private DeptService deptService;

    @PostMapping("dept/add")
    public boolean addDept(Dept dept){
        return deptService.addDept(dept);
    }

    @GetMapping("dept/get/{id}")//@PathVariable注解用于绑定处理方法中形参和前端传入的参数的名字
    public Dept queryById(@PathVariable("id") long id){
        System.out.println(deptService.queryById(id));
        return deptService.queryById(id);
    }

    @GetMapping("dept/getAll")
    public List<Dept> queryAll(){
        System.out.println(deptService.queryAllDept());
        return deptService.queryAllDept();
    }
}

编写springboot启动类

启动类于springcloud下，与controller，dao，service同级。内容如下：

package com.yhq.springcloud;


import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

//启动类
@SpringBootApplication
public class DeptProvider_8001 {
    public static void main(String[] args) {
        SpringApplication.run(DeptProvider_8001.class,args);
    }
}

消费者

1.创建一个新的module，名为springcloud-consumer-dept-80

2.导入依赖，pom.xml如下

<?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">
    <parent>
        <artifactId>SpringCloud</artifactId>
        <groupId>org.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>springcloud-consumer-dept-80</artifactId>

    <dependencies>
        <dependency>
            <groupId>org.example</groupId>
            <artifactId>springcloud-api</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
    </dependencies>

</project>

创建一个ConfigBean.java文件，将RestTemplate交给spring管理。

内容如下：

package com.yhq.springcloud.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.client.RestTemplate;

@Configuration//Configuration是spring的注解，相当于原来在applicationContext.xml中配置spring
public class ConfigBean {
    @Bean
    public RestTemplate getRestTemplate(){
        return new RestTemplate();
    }
}

编写消费者controller，内容如下

消费者controller不需要访问数据库，只需要调用生产者提供的服务，也就是我们上面写的dept-provider，因而也没有service层，只有controller层，controller就负责调用生产者提供的服务。

先创建一个RestTemplate对象，再创建一个静态变量REST_URL_PREFIX来存储我们需要调用的生产者服务的地址的固定前缀（http://localhost:8001）。调用restTemplate.getForObject或者restTemplate.postForObject向生产者发起请求。

package com.yhq.springcloud.controller;

import com.yhq.springcloud.pojo.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.client.RestTemplate;

import java.util.List;

@RestController
public class DeptConsumerController {

    //消费者不该有service层
    @Autowired
    private RestTemplate restTemplate;

    private static final String REST_URL_PREFIX="http://localhost:8001";

    @RequestMapping("/consumer/dept/get/{id}")
    public Dept get(@PathVariable("id") Long id){
        return restTemplate.getForObject(REST_URL_PREFIX+"/dept/get/"+id,Dept.class);
    }

    @RequestMapping("/consumer/dept/add")
    public boolean add(Dept dept){
        System.out.println(dept);
        return restTemplate.postForObject(REST_URL_PREFIX+"/dept/add",dept,Boolean.class);
    }

    @RequestMapping("/consumer/dept/getAll")
    public List<Dept> getAll(){
        return restTemplate.getForObject(REST_URL_PREFIX+"/dept/getAll",List.class);
    }
}

消费者启动类：

package com.yhq.springcloud;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

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