Nacos+Springcloud+mybatis-plus+oracle的整合

已于 2023-02-02 11:46:39 修改
阅读量834 收藏 1
点赞数
分类专栏： 笔记 文章标签： mybatis spring cloud oracle
于 2023-02-02 10:44:03 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_48319193/article/details/128844863
版权

Nacos+Springcloud+mybatis-plus+oracle的整合

1、项目结构在这里插入图片描述

2、父类的依赖

<?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>

    <groupId>com.ycz</groupId>
    <artifactId>Nacos-study</artifactId>
    <packaging>pom</packaging>
    <version>${revision}</version>
    <name>Nacos-study</name>
    <description>Nacos-study</description>
    <properties>
        <!-- 指定项目版本 -->
        <revision>1.0-SNAPSHOT</revision>

        <!-- 指定SpringBoot版本 -->
        <spring-boot.version>2.2.5.RELEASE</spring-boot.version>
        <!-- 指定SpringCloud版本 -->
        <spring-cloud.version>Hoxton.SR3</spring-cloud.version>
        <!-- 指定SpringCloudAlibaba版本 -->
        <spring-cloud-alibaba.version>2.2.1.RELEASE</spring-cloud-alibaba.version>
        <!-- 指定JDK版本 -->
        <java-jdk.version>1.8</java-jdk.version>
        <!--指定pageHelper-->
        <pageHelper.version>5.3.0</pageHelper.version>
        <!--ojdbc8-->
        <ojdbc8.version>21.8.0.0</ojdbc8.version>
        <!--orai18n-->
        <orai18n.version>19.7.0.0</orai18n.version>
        <!--lombok-->
        <lombok.version>1.18.24</lombok.version>
    </properties>

    <modules>
        <module>nacos-config</module>
        <module>nacos-provider</module>
        <module>nacos-consumer</module>
        <module>nacos-feign-api</module>
        <module>nacos-geteway</module>
        <module>nacos-commons</module>
    </modules>

    <dependencyManagement>
        <dependencies>
            <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>${lombok.version}</version>
                <scope>provided</scope>
            </dependency>
            <!-- 声明依赖 springBoot -->
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <!-- 声明依赖 springCloud -->
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>${spring-cloud.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <!-- 声明依赖 springCloudAlibaba -->
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-alibaba-dependencies</artifactId>
                <version>${spring-cloud-alibaba.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>

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

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

            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.4.2</version>
            </dependency>

            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>${pageHelper.version}</version>
            </dependency>


            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
                <version>${spring-boot.version}</version>
            </dependency>

            <!-- https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8 -->
            <dependency>
                <groupId>com.oracle.database.jdbc</groupId>
                <artifactId>ojdbc8</artifactId>
                <version>${ojdbc8.version}</version>
            </dependency>

            <dependency>
                <groupId>com.oracle.database.nls</groupId>
                <artifactId>orai18n</artifactId>
                <version>${orai18n.version}</version>
            </dependency>

            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.21</version>
            </dependency>



        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>

        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>


    <profiles>
        <profile>
            <id>dev</id>
            <activation>
                <activeByDefault>true</activeByDefault>
            </activation>
            <properties>
                <profileActive>dev</profileActive>
            </properties>
        </profile>

        <profile>
            <id>prod</id>
            <activation>
                <activeByDefault>true</activeByDefault>
            </activation>
            <properties>
                <profileActive>prod</profileActive>
            </properties>
        </profile>

        <profile>
            <id>home</id>
            <activation>
                <activeByDefault>true</activeByDefault>
            </activation>
            <properties>
                <profileActive>home</profileActive>
            </properties>
        </profile>

    </profiles>



</project>

3、nacos-config

（1）新建一个配置

在这里插入图片描述
在这里插入图片描述

（2）依赖

<?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>com.ycz</groupId>
        <artifactId>Nacos-study</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>nacos-config</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>nacos-config</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>8</java.version>
    </properties>
    <dependencies>
        <!-- 父项目中我们已经指定了对应的版本, 这里直接使用就行, 不用在引用版本 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

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

        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

（3）bootstrap.yml

spring:
  profiles:
    active: @profileActive@

（4）application-dev.yml

server:
  port: 7001
spring:
  application:
    name: nacos-config
  cloud:
    nacos:
      config:
        server-addr: localhost:8848

（5）controller测试

package com.ycz.Controller;

import com.ycz.config.CommonConfig;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController

public class UserController {

    @Autowired
    private CommonConfig config;

    @GetMapping("test")
    public String test(){
        return config.getUsername() + config.getPassword();
    }

}


package com.ycz.config;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.cloud.context.config.annotation.RefreshScope;
import org.springframework.stereotype.Component;

@RefreshScope
@Component
public class CommonConfig {

    @Value(value = "${oracle.username}")
    private String username;

    @Value(value =  "${oracle.password}")
    private String password;

    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;
    }
}


package com.ycz;

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

@SpringBootApplication
public class NacosConfigApplication {


    public static void main(String[] args) {


        SpringApplication.run(NacosConfigApplication.class, args);
    }

}

4、nacos-commons

（1）依赖

<?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>Nacos-study</artifactId>
        <groupId>com.ycz</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.ycz</groupId>
    <artifactId>nacos-commons</artifactId>
    <version>0.0.1-SNAPSHOT</version>

    <name>nacos-commons</name>
    <description>nacos-commons</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>


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

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>

    </dependencies>



</project>

（2）代码

实体类

@Data
public class HotApps {
    private Integer appOid;

    private String appName;

    private String serviceRyCategoryOid;

    private String appSubName;

    private String businessTag;

}

请求param

@Data
public class HotAppsParams extends BaseParams{

    private Integer appOid;

    private String appName;

    private String serviceRyCategoryOid;

    private String appSubName;

    private String businessTag;

}

5、nacos-provider

（1）依赖

<?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>com.ycz</groupId>
        <artifactId>Nacos-study</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>nacos-provider</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>nacos-provider</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>8</java.version>
    </properties>

    <dependencies>
        <!-- 引入commons -->
        <dependency>
            <groupId>com.ycz</groupId>
            <artifactId>nacos-commons</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>


        <!-- 父项目中我们已经指定了对应的版本, 这里直接使用就行, 不用在引用版本 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

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

        <!-- 服务注册与发现 -->
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
        </dependency>


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

        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
        </dependency>

        <dependency>
            <groupId>com.oracle.database.nls</groupId>
            <artifactId>orai18n</artifactId>
        </dependency>

        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
        </dependency>

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
        </dependency>


    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>7</source>
                    <target>7</target>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

（2）bootstrap.yml

spring:
  profiles:
    active: @profileActive@

（3）application-dev.yml

server:
  port: 8001
spring:
  application:
    name: nacos-provider
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848
#      config:
#        server-addr: localhost:8848
#        file-extension: yaml
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@ip:1521:XE
    username: admin
    password: admin
mybatis-plus:
  mapper-locations: classpath*:/mapper/**/*Mapper.xml
  configuration:
    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl

（3）配置

package com.ycz.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.boot.autoconfigure.condition.ConditionalOnClass;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author alex
 * @date 2023/01/13 1:44
 * @Version 1.0
 */
@Configuration
@ConditionalOnClass(value = {PaginationInterceptor.class})
public class MybatisPlusConfig {

    // 最新版
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
//        数据库的配置DbType.ORACLE 根据自己的数据库选择
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE));
        return interceptor;
    }

}

mapper

package com.ycz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycz.entity.HotApps;
import org.springframework.stereotype.Repository;

/**
 * HotAppMapper
 * <p>
 * Description 
 * <p>
 * Creation Time: 2023/1/17 下午3:45
 *
 * @author yang chao zhen
 */
@Repository
public interface HotAppsMapper extends BaseMapper<HotApps> {


}

（4）service

package com.ycz.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycz.entity.HotApps;
import com.ycz.params.HotAppsParams;

/**
 * HotAppService
 * <p>
 * Description 
 * <p>
 * Creation Time: 2023/1/17 下午3:46
 *
 * @author yang chao zhen
 */
public interface HotAppService {

    IPage<HotApps> getHotApps(HotAppsParams params);

    Object insert(HotApps hotApps);
}

（5）serviceimpl

package com.ycz.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycz.entity.HotApps;
import com.ycz.mapper.HotAppsMapper;
import com.ycz.params.HotAppsParams;
import com.ycz.service.HotAppService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * HotAppService
 * <p>
 * Description
 * <p>
 * Creation Time: 2023/1/17 下午3:46
 *
 * @author yang chao zhen
 */
@Service
public class HotAppServiceImpl implements HotAppService {

    @Autowired
    private HotAppsMapper mapper;

    @Override
    public IPage<HotApps> getHotApps(HotAppsParams params) {
        QueryWrapper<HotApps> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq(params.getAppOid()!= null , "APP_OID" ,params.getAppOid());
        return mapper.selectPage(new Page<HotApps>(params.getCurrent(), params.getSize()), queryWrapper);
    }

    @Override
    public Object insert(HotApps hotApps) {
        System.out.println(hotApps);
        return mapper.insert(hotApps);
    }
}

（6）controller

package com.ycz.controller;

import com.ycz.entity.HotApps;
import com.ycz.params.HotAppsParams;
import com.ycz.service.HotAppService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * HotAppsController
 * <p>
 * Description
 * <p>
 * Creation Time: 2023/1/17 下午3:51
 *
 * @author yang chao zhen
 */
@RequestMapping("/hotApps")
@RestController
public class HotAppsController {

    @Autowired
    private HotAppService service;

    @GetMapping("/page")
    public Object getPage(HotAppsParams params){
        return service.getHotApps(params);
    }

    @PostMapping("/insert")
    public Object insert(HotApps hotApps){
        return service.insert(hotApps);
    }


}

6、naoos-feign-api

（1）依赖

<?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>com.ycz</groupId>
        <artifactId>Nacos-study</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <groupId>com.ycz</groupId>
    <artifactId>nacos-feign-api</artifactId>
    <version>0.0.1-SNAPSHOT</version>

    <name>nacos-feign-api</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>

        <!-- 引入commons -->
        <dependency>
            <groupId>com.ycz</groupId>
            <artifactId>nacos-commons</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-openfeign</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

（2）HotAppService

package com.ycz.service;

import com.ycz.params.HotAppsParams;
import org.springframework.cloud.openfeign.FeignClient;
import org.springframework.cloud.openfeign.SpringQueryMap;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;

/**
 * HotAppsService
 * <p>
 * Description
 * <p>
 * Creation Time: 2023/1/17 下午3:52
 *
 * @author yang chao zhen
 */
@FeignClient(name = "${nacos.product.name}" , contextId = "hotService")
public interface HotAppsService {

    @GetMapping(path = "/hotApps/page/")
    Object getPage(@SpringQueryMap HotAppsParams params);

    @PostMapping(path = "/hotApps/insert/")
    Object insert(@SpringQueryMap HotAppsParams params);
}

7、nacos-consumer

（1）依赖

<?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>com.ycz</groupId>
        <artifactId>Nacos-study</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <groupId>com.ycz</groupId>
    <artifactId>nacos-consumer</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>nacos-consumer</name>
    <description>nacos-consumer</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <!-- 引入feign -->
        <dependency>
            <groupId>com.ycz</groupId>
            <artifactId>nacos-feign-api</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>

        <!-- 引入commons -->
        <dependency>
            <groupId>com.ycz</groupId>
            <artifactId>nacos-commons</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>

        <!-- 父项目中我们已经指定了对应的版本, 这里直接使用就行, 不用在引用版本 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

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

        <!-- 服务注册与发现 -->
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-openfeign</artifactId>
        </dependency>

        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
    <repositories>
        <repository>
            <id>spring-milestones</id>
            <name>Spring Milestones</name>
            <url>https://repo.spring.io/milestone</url>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </repository>
        <repository>
            <id>spring-snapshots</id>
            <name>Spring Snapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <releases>
                <enabled>false</enabled>
            </releases>
        </repository>
    </repositories>
    <pluginRepositories>
        <pluginRepository>
            <id>spring-milestones</id>
            <name>Spring Milestones</name>
            <url>https://repo.spring.io/milestone</url>
            <snapshots>
                <enabled>false</enabled>
            </snapshots>
        </pluginRepository>
        <pluginRepository>
            <id>spring-snapshots</id>
            <name>Spring Snapshots</name>
            <url>https://repo.spring.io/snapshot</url>
            <releases>
                <enabled>false</enabled>
            </releases>
        </pluginRepository>
    </pluginRepositories>

</project>

（2）bootstrap.yml

spring:
  profiles:
    active: @profileActive@

（3）application-dev.yml

server:
  port: 5001
spring:
  application:
    name: nacos-comsumer
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:XE # 假的，为了前面commons里面的@TableName错误
    username: admin
    password: admin

nacos:
  product:
    name: nacos-provider

（4）配置

package com.ycz.config;

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

/**
 * RestTemplateConfig
 * <p>
 * Description 
 * <p>
 * Creation Time: 2023/1/16 下午12:24
 *
 * @author yang chao zhen
 */
@Configuration
public class RestTemplateConfig {
    @LoadBalanced
    @Bean
    public RestTemplate restTemplate() {
        return new RestTemplate();
    }
}

（5）controller

package com.ycz.controller;

import com.ycz.entity.HotApps;
import com.ycz.params.HotAppsParams;
import com.ycz.service.HotAppsService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.Map;

@RestController
public class TestController {
    @Autowired
    private HotAppsService hotAppsService;
    @RequestMapping(value = "/hotApps/page" , method = RequestMethod.GET)
    public Object getPage(HotAppsParams params){
        return hotAppsService.getPage(params);
    }

    @RequestMapping(value = "/hotApps/insert" , method = RequestMethod.POST)
    public Object insert(@RequestBody HotAppsParams params){
        HotApps hotApps = new HotApps();
        BeanUtils.copyProperties(params  , hotApps);
        return hotAppsService.insert(params);
    }

}

8、nacos-geteway

（1）依赖

<?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>com.ycz</groupId>
        <artifactId>Nacos-study</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <groupId>com.ycz</groupId>
    <artifactId>nacos-geteway</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>nacos-gateway</name>
    <description>nacos-geteway</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <!-- 服务注册与发现 -->
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>

        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-gateway</artifactId>
        </dependency>


    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

（2）bootstrap.yml

spring:
  profiles:
    active: @profileActive@

（3）application-dev.yml

spring:
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848
      config:
        server-addr: localhost:8848
        enabled: false
    gateway:
      routes:
        - id: user
          uri: lb://nacos-comsumer
          predicates:
            - Path=/gateWay/** #以city开头的请求都负载到consumer服务
          filters:
            - RewritePath=/gateWay/(?<segment>.*), /$\{segment} #过滤掉url里的user,例如http://ip:port/city/getCity -> http://ip:port/getCity
  application:
    name: nacos-gateway
server:
  port: 8000

（4）启动

package com.ycz.nacosgeteway;

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

@SpringBootApplication
public class NacosGetewayApplication {

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

}

启动

先启动nacos-config，再nacos-provider，再nacos-consumer，再nacos-geteway

测试

在这里插入图片描述

成功

Alex镇
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SpringCloud整合Gateway+Nacos+Sentinel+OpenFeign+Mybatis+Mybatis-Plus （一：概述）
Huge.YounG`s Blog
05-21 2271
SpringCloud整合Gateway+Nacos+Sentinel+OpenFeign+Mybatis+Mybatis-Plus初衷框架说明技术栈安装要求平台解析项目规则（待完善）项目启动顺序项目访问相关控制台 初衷 项目更换架构也是对以往技术进行总结，但是技术来源过于零散、碎片，查找费时费事，很多缺少验证，入坑无数，，这次整理的是利用SpringCloud，整合了主流的阿里系插件服务–Nacos、Sentinel，结合Gateway网关及openFeign的微服务调用，持久层整合了“魂斗罗”兄弟等等。
SpringCloud-Alibaba整合Nacos+Seata+Mybatis-Plus
Autism、陌亡
04-30 2538
SpringCloud-Alibaba整合Nacos+Seata+Mybatis-PlusSeata Example项目说明准备工作配置数据库创建 undo_log 表创建 示例中 业务所需要的数据库表启动 Seata Server运行示例如何验证分布式事务成功？Xid 信息是否成功传递数据库中数据是否一致对 Spring Cloud 支持点Seata 服务端配置Nacos启动配置Seata之配置...
Nacos 2.x 系列【15】数据源插件支持达梦、Oracel、PostgreSQL......
记录知识、锤炼自我
06-20 1580
在 Nacos 2.2 之前的版本中，所有的 SQL 操作的执行是通过直接使用 JdbcTemplate 执行固定 SQL 语句的形式，使得 SQL 语句与业务逻辑高度耦合，并且只支持 Derby 与 MySQL 两种数据源。
SpringCloud+Nacos+Mybatis Plus+OpenFeign+Seata整合分布式脚手架
一人码农
05-23 795
SpringCloud+Nacos+Mybatis Plus+OpenFeign+Seata整合分布式脚手架准备seata环境在nacos-config, nacos-server里配置seata随便设计两个服务进行调用, 一个事务里面包含两个数据源的处理上，保证nacos-config， nacos-server两个要么全部成功， 要么全部失败我要代码，必须是源码：[源码来了](https://gitee.com/chen123b_admin/spring-cloud-scaffolding) 本篇文章继
Idea+maven+spring-cloud项目搭建系列--13 整合MyBatis-Plus多数据源dynamic-datasource
拽着尾巴的鱼儿的博客
04-01 3171
Idea+maven+spring-cloud项目搭建系列--13 整合MyBatis-Plus多数据源dynamic-datasource
SpringCloud+Eureka+Mybatis-Plus+Seata最新搭建
thomas.he
07-27 1973
环境准备 Seata简介 项目介绍 项目搭建 Seata服务端安装 数据库准备 项目目录说明 Eureka项目 Seata客户端项目搭建 运行结果 参考资料 源码下载地址
Springboot+MyBatis-plus+postgresSQL 的整合
热门推荐
傲视苍穹
08-15 1万+
磨叨一下 MyBatis-plus 请参看https://mp.baomidou.com/，之前也有写过一个较简单的入门级文章，可以参看 在整合的过程中遇到了一些坑，来扒一扒。 (1) 首先在利用MyBatis-plus-generator 的AutoGenerator类生成代码阶段，死活不生成相应的类。换成MYSQL也是OK的， Oracle也是没有问题。写了一个PostresSQL的直连操作也...
Spring Cloud + Nacos + MybatisPlus 集成 Seata
法号钦尘的博客
08-18 427
架构依赖包版本说明 S...
SpringCloud(Springboot)+Mybatis Plus
一人码农
05-23 857
SpringCloud整合Mybqtis Plus 即Springboot 整合Mybatis PlusSpringboot 整合Mybatis Plus主要是通过Springboot 整合Mybatis Plus主要问题mapper注入失败， 主要原因有以下几点： Springboot 整合Mybatis Plus 本篇文章就是为SpringCloud 整合seata 准备， 代码内容承接： SpringCloud+nacos. 主要是通过Springboot 整合Mybatis Plus 1. 引入相关
Spring cloud Alibaba 分布式微服务，配置 nacos + gateway + feign + hystrix
zhf_123666的博客
09-29 997
Spring cloud Alibaba 分布式微服务，配置 nacos + gateway + feign + hystrix - 根目录97 - 博客园 Spring cloud Alibaba 分布式微服务，配置 nacos + gateway + feign + hystrix 这篇随笔本人2021/04/09 原创，应该目前看了这篇博客的人都能搭成功。 环境：IDEA ，JDK 1.8， Mysql 5.* 项目配置：nacos + gateway + feign.
SpringBoot+SpringCloud+nacos+gateway+mybatis搭建微服务
11-09
在构建分布式系统时，Spring Boot、Spring Cloud、Nacos、Gateway和MyBatis这五大组件是常见的技术选型。下面将详细阐述它们的功能、如何整合以及在微服务架构中的作用。 1. Spring Boot：作为核心启动框架，Spring...
cloud-seata-nacos：springcloud + mybatis plus + nacos +伪装+ mysql
03-03
这个项目架构由自己建造使用架构为主流的Spring Cloud Alibaba主要用于尝试新技术并进行整合测试，最终用于实践 环境 杰克1.8 Maven 3.6.3 工具 想法2020.3 吉特邮差导航外壳MobaXterm Mobaxterm redis-desktop-...
SpringBoot整合Mybatis-Plus+Oracle+Mysql
01-05
本教程将深入探讨如何利用SpringBoot整合Mybatis-Plus，同时支持Oracle和MySQL数据库，并通过Nacos作为注册中心，以及使用Swagger2进行API文档的生成。 首先，让我们了解SpringBoot的核心优势。SpringBoot简化了...
SpringBoot+nacos+websocket+redis+mysql+mybatis-plus微服务项目实战
01-11
- MyBatis-Plus是MyBatis的扩展插件，简化了MyBatis的开发，提供了丰富的CRUD操作以及条件构造器。 - MyBatis-Plus可以帮助开发者快速地进行数据库操作，减少手写SQL的工作量，同时保持灵活的数据库交互能力。 在...
springcloud+dobbo+nacos +spring-cloud-config整合
06-03
整合Spring Cloud、Dubbo、Nacos和Spring Cloud Config的过程主要包括以下几个步骤： 1. **初始化项目**：创建一个基于Spring Boot的项目，并引入Spring Cloud和Dubbo的相关依赖。 2. **配置Nacos**：在Nacos...
mysql数据库：数据库，表和列的基本概念
mohanyelong的博客
08-04 709
数据库，表和列的基本概念以及导入和导出文件。
多租户系统数据隔离方案
最新发布
记录工作中遇到的问题以及解决方案
08-04 435
多租户系统是一种将多个客户的数据和应用程序分开的系统，每个客户被视为一个独立的租户，互不干扰。实现多租户系统的关键之一是确保数据的隔离。之前公司的产品是一个多租户的SAAS平台，是一个面向企业办公的平台，每个企业其实就相当于一个租户。实际使用中采用可 数据行+数据表 混合的数据隔离方案，大多数业务场景中是数据行级别，即所有的数据都在同一张表下，用租户ID来区分。少部分业务场景则是数据表级别，每个租户都有自己的数据表，表名使用租户ID做后缀区分。
MySQL数据管理 - 查询语句
今晚看星星的博客
08-04 520
运行的逻辑，在行上进行相加，然后在列上进行求平均，聚合函数还是聚合的列，聚合函数和分组常常在一起使用。根据两个表和多个表之间的关系进行查询和展示数据，使用JOIN语句实现。数据库最常用的操作就是查询，也是数据操作的基础，进行重点学习介绍。求平均值，最大值，最小值，求和，都是对查询的列的值进行运算。子查询将一个查询的结果用作数据库语句的条件。展示仓库和工人的关系，使用了工作关系联结。如果需要对多列进行聚合，此时需要使用。【注意】对每个学生进行分组查询，使用。，对不同列的数采取运算操作。
Spring Cloud Alibaba + Spring Boot +dubbo+ Nacos + Mybatis Plus + MySQL 项目搭建步骤
05-10
下面是Spring Cloud Alibaba + Spring Boot + Dubbo + Nacos + Mybatis Plus + MySQL 项目搭建步骤： 1. 创建一个Spring Boot项目，并添加以下依赖： ```xml <!--Spring Boot依赖--> <groupId>org.spring...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值