• Springboot从数据库读取配置文件

    springboot常规的项目是直接读取resources/application.properties文件或者application.yml或者bootstrap.properties文件。还有常见的玩法是把nacos或eureka或zookeeper来实现远程读取配置文件。

    ----------------------------------------正文开始-------------------------------------------------

    今天我们在cloud的基础上从数据库读取配置文件信息。在开始之前，我们需要知道三个大的概念，springboot，spring-cloud-config-server，spring-cloud-starter-config。

    概念1，springboot是常规的java开发框架，这里不多说。

    概念2，spring-cloud-config-server，是在常规的springboot基础上，把这个项目变成一个config-server，这个config-server可以理解为就是把数据库的配置文件读取出来，然后其余的项目的配置文件只要请求的地址是这个地址就能读取到数据库的配置信息。还可以扩展到native，jdbc，git，svn。这里我们只讲jdbc的，其余的请自行研究。

    ----------------------------------------服务端  config server--------------------------------------

    1、新建一个普通的springboot项目，名字随便叫一个springboot-config-server。

    2、pom的配置文件如下，大家可以参照下，这里的重点是springboot的版本和spring-cloud的版本，自己要注意，版本不兼容也会导致启动失败。本文的版本是经过测试和验证可用的版本。

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4. 	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5. 	<modelVersion>4.0.0</modelVersion>
    6.  
    7. 	<groupId>cn.renkai721</groupId>
    8. 	<artifactId>ncs</artifactId>
    9. 	<version>1.0.0</version>
    10. 	<packaging>jar</packaging>
    11.  
    12. 	<name>ncs</name>
    13.  
    14. 	<parent>
    15. 		<groupId>org.springframework.boot</groupId>
    16. 		<artifactId>spring-boot-starter-parent</artifactId>
    17. 		<version>2.4.2</version>
    18. 		<relativePath/>
    19. 	</parent>
    20.  
    21. 	<properties>
    22. 		<encoding>UTF-8</encoding>
    23. 		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    24. 		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    25. 		<java.version>1.8</java.version>
    26. 		<maven.compiler.source>${java.version}</maven.compiler.source>
    27. 		<maven.compiler.target>${java.version}</maven.compiler.target>
    28. 		<lombok.version>1.18.0</lombok.version>
    29. 		<spring-cloud.version>Finchley.RELEASE</spring-cloud.version>
    30. 	</properties>
    31.  
    32. 	<repositories>
    33. 		<!--阿里云仓库 -->
    34. 		<repository>
    35. 			<id>aliyun</id>
    36. 			<url>https://maven.aliyun.com/repository/public/</url>
    37. 		</repository>
    38. 	</repositories>
    39.  
    40. 	<dependencies>
    41. 		<!-- Spring Boot Web 依赖 -->
    42. 		<dependency>
    43. 			<groupId>org.springframework.boot</groupId>
    44. 			<artifactId>spring-boot-starter-web</artifactId>
    45. 		</dependency>
    46. 		<!-- 配置文件从数据库读取 -->
    47. 		<dependency>
    48. 			<groupId>org.springframework.cloud</groupId>
    49. 			<artifactId>spring-cloud-config-server</artifactId>
    50. 			<version>3.0.6</version>
    51. 		</dependency>
    52. 		<dependency>
    53. 			<groupId>org.springframework.boot</groupId>
    54. 			<artifactId>spring-boot-starter-jdbc</artifactId>
    55. 		</dependency>
    56. 		<dependency>
    57. 			<groupId>mysql</groupId>
    58. 			<artifactId>mysql-connector-java</artifactId>
    59. 			<version>8.0.11</version>
    60. 		</dependency>
    61. 		<!-- 数据库连接池 -->
    62. 		<dependency>
    63. 			<groupId>com.alibaba</groupId>
    64. 			<artifactId>druid</artifactId>
    65. 			<version>1.2.6</version>
    66. 		</dependency>
    67.  
    68. 		<!-- config server需要用户名和密码才可以访问 -->
    69. 		<dependency>
    70. 			<groupId>org.springframework.boot</groupId>
    71. 			<artifactId>spring-boot-starter-security</artifactId>
    72. 		</dependency>
    73.  
    74. 	</dependencies>
    75.  
    76.  
    77. 	<build>
    78. 		<plugins>
    79. 			<plugin>
    80. 				<groupId>org.springframework.boot</groupId>
    81. 				<artifactId>spring-boot-maven-plugin</artifactId>
    82. 				<configuration>
    83. 					<mainClass>cn.renkai721.NcsApplication</mainClass>
    84. 				</configuration>
    85. 			</plugin>
    86. 		</plugins>
    87. 	</build>
    88.  
    89.  
    90. </project>

    3、新建一个NcsApplication.java文件，这个项目下只有这一个文件。注意必须导入@EnableConfigServer。

    1. package cn.renkai721;
    2.  
    3. import org.springframework.boot.SpringApplication;
    4. import org.springframework.boot.autoconfigure.SpringBootApplication;
    5. import org.springframework.cloud.config.server.EnableConfigServer;
    6.  
    7. @SpringBootApplication
    8. @EnableConfigServer
    9. public class NcsApplication {
    10.  
    11.  
    12. 	public static void main(String[] args) {
    13. 		SpringApplication.run(NcsApplication.class, args);
    14. 		System.out.println("naturobot-config-server项目启动成功！");
    15. 	}
    16.  
    17.  
    18. }
    4、新建一个application.properties文件。
# active selection value=native、jdbc、git、svn
# 如果是从数据库读取，这里必须是jdbc
    1. server.servlet.context-path=/ncs
    2. spring.application.name=ncs
    3.  
    4. # active selection value=native、jdbc、git、svn
    5. # 如果是从数据库读取，这里必须是jdbc
    6. spring.profiles.active=jdbc
    7.  
    8.  
    9. #test
    10. server.port=9092
    11. spring.datasource.url=jdbc:mysql://192.168.1.123:3306/springbootconfig?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false&allowMultiQueries=true
    12. spring.datasource.username=root
    13. spring.datasource.password=123456
    14.  
    15. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    16. spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    17. spring.datasource.initialSize=1
    18. spring.datasource.minIdle=3
    19. spring.datasource.maxActive=20
    20. spring.datasource.maxWait=60000
    21. spring.datasource.timeBetweenEvictionRunsMillis=60000
    22. spring.datasource.minEvictableIdleTimeMillis=30000
    23. spring.datasource.testWhileIdle=true
    24. spring.datasource.testOnBorrow=false
    25. spring.datasource.testOnReturn=false
    26. spring.datasource.validationQuery=select 1
    27. spring.jpa.hibernate.ddl-auto=update
    28.  
    29. # 下面的关键配置
    30. spring.cloud.config.label=master
    31. spring.cloud.config.server.jdbc=true
    32. # 动态从数据库读取配置信息
    33. spring.cloud.config.server.jdbc.sql=SELECT propname, propvalue from config_properties where application=? and profile=? and label=? and isdel=0
    34.  
    35. #访问该服务需要用户名和密码
    36. # config server username and password
    37. spring.security.user.name=admin
    38. spring.security.user.password=admin

    5、数据库脚本

    1. CREATE TABLE `config_properties` (
    2.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    3.   `propname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '配置文件的key',
    4.   `propvalue` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '配置文件的value',
    5.   `application` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '对应访问地址中的config-server',
    6.   `profile` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'dev开发环境配置文件,test测试环境,prod正式环境',
    7.   `label` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '指明远程仓库的分支',
    8.   `isdel` int DEFAULT '0' COMMENT '是否删除，1=删除，0=没有删除，可用',
    9.   PRIMARY KEY (`id`)
    10. ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='springboot项目从数据库读取配置文件';

    6、数据库脚本数据

    1.  
    2. -- ----------------------------
    3. -- Records of config_properties
    4. -- ----------------------------
    5. INSERT INTO `config_properties` VALUES (1, 'server.servlet.context-path', '/qywxzj', 'qywxzj', 'test', 'master', 0);
    6. INSERT INTO `config_properties` VALUES (2, 'server.port', '9091', 'qywxzj', 'test', 'master', 0);
    7. INSERT INTO `config_properties` VALUES (3, 'server.servlet.jsp.init-parameters.development', 'TRUE', 'qywxzj', 'test', 'master', 0);
    8. INSERT INTO `config_properties` VALUES (4, 'server.tomcat.uri-encoding', 'UTF-8', 'qywxzj', 'test', 'master', 0);
    9. INSERT INTO `config_properties` VALUES (5, 'server.servlet.session.timeout', '7200', 'qywxzj', 'test', 'master', 0);
    10. INSERT INTO `config_properties` VALUES (6, 'logging.level.org.springframework.web', 'ERROR', 'qywxzj', 'test', 'master', 0);
    11. INSERT INTO `config_properties` VALUES (7, 'logging.level.com.github.binarywang.demo.wx.cp', 'INFO', 'qywxzj', 'test', 'master', 0);
    12. INSERT INTO `config_properties` VALUES (8, 'logging.level.me.chanjar.weixin', 'INFO', 'qywxzj', 'test', 'master', 0);
    13. INSERT INTO `config_properties` VALUES (9, 'myApp.server', 'http://192.168.1.120:9091/qywxzj/', 'qywxzj', 'test', 'master', 0);
    14. INSERT INTO `config_properties` VALUES (10, 'server.servlet.encoding.force', 'TRUE', 'qywxzj', 'test', 'master', 0);
    15. INSERT INTO `config_properties` VALUES (11, 'server.servlet.encoding.charset', 'UTF-8', 'qywxzj', 'test', 'master', 0);
    16. INSERT INTO `config_properties` VALUES (12, 'server.servlet.encoding.enabled', 'TRUE', 'qywxzj', 'test', 'master', 0);
    17. INSERT INTO `config_properties` VALUES (13, 'spring.mvc.view.prefix', '/WEB-INF/views/', 'qywxzj', 'test', 'master', 0);
    18. INSERT INTO `config_properties` VALUES (14, 'spring.mvc.view.suffix', '.jsp', 'qywxzj', 'test', 'master', 0);
    19. INSERT INTO `config_properties` VALUES (15, 'spring.thymeleaf.cache', 'FALSE', 'qywxzj', 'test', 'master', 0);
    20. INSERT INTO `config_properties` VALUES (16, 'spring.thymeleaf.enabled', 'FALSE', 'qywxzj', 'test', 'master', 0);
    21. INSERT INTO `config_properties` VALUES (17, 'spring.jpa.database', 'MYSQL', 'qywxzj', 'test', 'master', 0);
    22. INSERT INTO `config_properties` VALUES (18, 'spring.datasource.driver-class-name', 'com.mysql.cj.jdbc.Driver', 'qywxzj', 'test', 'master', 0);
    23. INSERT INTO `config_properties` VALUES (19, 'spring.datasource.url', 'jdbc:mysql://192.168.1.123:3306/student?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false&allowMultiQueries=true', 'qywxzj', 'test', 'master', 0);
    24. INSERT INTO `config_properties` VALUES (20, 'spring.datasource.username', 'root', 'qywxzj', 'test', 'master', 0);
    25. INSERT INTO `config_properties` VALUES (21, 'spring.datasource.password', '123456', 'qywxzj', 'test', 'master', 0);
    26. INSERT INTO `config_properties` VALUES (22, 'spring.datasource.type', 'com.alibaba.druid.pool.DruidDataSource', 'qywxzj', 'test', 'master', 0);
    27. INSERT INTO `config_properties` VALUES (23, 'spring.datasource.initialSize', '1', 'qywxzj', 'test', 'master', 0);
    28. INSERT INTO `config_properties` VALUES (24, 'spring.datasource.minIdle', '3', 'qywxzj', 'test', 'master', 0);
    29. INSERT INTO `config_properties` VALUES (25, 'spring.datasource.maxActive', '20', 'qywxzj', 'test', 'master', 0);
    30. INSERT INTO `config_properties` VALUES (26, 'spring.datasource.maxWait', '60000', 'qywxzj', 'test', 'master', 0);
    31. INSERT INTO `config_properties` VALUES (27, 'spring.datasource.timeBetweenEvictionRunsMillis', '60000', 'qywxzj', 'test', 'master', 0);
    32. INSERT INTO `config_properties` VALUES (28, 'spring.datasource.minEvictableIdleTimeMillis', '30000', 'qywxzj', 'test', 'master', 0);
    33. INSERT INTO `config_properties` VALUES (29, 'spring.datasource.validationQuery', 'select \'x\'', 'qywxzj', 'test', 'master', 0);
    34. INSERT INTO `config_properties` VALUES (30, 'spring.datasource.testWhileIdle', 'TRUE', 'qywxzj', 'test', 'master', 0);
    35. INSERT INTO `config_properties` VALUES (31, 'spring.datasource.testOnBorrow', 'FALSE', 'qywxzj', 'test', 'master', 0);
    36. INSERT INTO `config_properties` VALUES (32, 'spring.datasource.testOnReturn', 'FALSE', 'qywxzj', 'test', 'master', 0);
    37. INSERT INTO `config_properties` VALUES (33, 'spring.jpa.hibernate.ddl-auto', 'update', 'qywxzj', 'test', 'master', 0);
    38. INSERT INTO `config_properties` VALUES (34, 'mybatis-plus.type-aliases-package', 'cn.renkai721.*.*Entity', 'qywxzj', 'test', 'master', 0);
    39. INSERT INTO `config_properties` VALUES (35, 'mybatis-plus.global-config.id-type', '0', 'qywxzj', 'test', 'master', 0);
    40. INSERT INTO `config_properties` VALUES (36, 'mybatis-plus.global-config.field-strategy', '2', 'qywxzj', 'test', 'master', 0);
    41. INSERT INTO `config_properties` VALUES (37, 'mybatis-plus.global-config.db-column-underline', 'TRUE', 'qywxzj', 'test', 'master', 0);
    42. INSERT INTO `config_properties` VALUES (38, 'mybatis-plus.global-config.refresh-mapper', 'TRUE', 'qywxzj', 'test', 'master', 0);
    43. INSERT INTO `config_properties` VALUES (39, 'mybatis-plus.configuration.map-underscore-to-camel-case', 'FALSE', 'qywxzj', 'test', 'master', 0);
    44. INSERT INTO `config_properties` VALUES (40, 'mybatis-plus.configuration.cache-enabled', 'FALSE', 'qywxzj', 'test', 'master', 0);
    45. INSERT INTO `config_properties` VALUES (41, 'mybatis-plus.configuration.call-setters-on-nulls', 'TRUE', 'qywxzj', 'test', 'master', 0);
    46. INSERT INTO `config_properties` VALUES (42, 'mybatis-plus.global-config.db-config.id-type', 'id_worker', 'qywxzj', 'test', 'master', 0);
    47. INSERT INTO `config_properties` VALUES (43, 'mybatis-plus.mapper-locations', 'classpath*:mapper/*Mapper.xml', 'qywxzj', 'test', 'master', 0);
    48. INSERT INTO `config_properties` VALUES (44, 'redisson.singleServerConfig.address', '192.168.1.124:6380', 'qywxzj', 'test', 'master', 0);
    49. INSERT INTO `config_properties` VALUES (45, 'redisson.singleServerConfig.database', '6', 'qywxzj', 'test', 'master', 0);
    50. INSERT INTO `config_properties` VALUES (46, 'redisson.password', '123456', 'qywxzj', 'test', 'master', 0);
    51. INSERT INTO `config_properties` VALUES (47, 'redisson.model', 'SINGLE', 'qywxzj', 'test', 'master', 0);
    52. INSERT INTO `config_properties` VALUES (48, 'springfox.documentation.swagger.use-model-v3', 'FALSE', 'qywxzj', 'test', 'master', 0);
    53. INSERT INTO `config_properties` VALUES (49, 'spring.mvc.pathmatch.matching-strategy', 'ant_path_matcher', 'qywxzj', 'test', 'master', 0);
    54. INSERT INTO `config_properties` VALUES (50, 'management.endpoints.web.exposure.include', '\'*\'', 'qywxzj', 'test', 'master', 0);
    55. INSERT INTO `config_properties` VALUES (51, 'server.tomcat.basedir', 'qywxzj', 'qywxzj', 'test', 'master', 0);
    56. INSERT INTO `config_properties` VALUES (52, 'server.tomcat.accesslog.enabled', 'TRUE', 'qywxzj', 'test', 'master', 0);
    57. INSERT INTO `config_properties` VALUES (53, 'server.tomcat.accesslog.pattern', '%t [%I] %{X-Forwarded-For}i %a \'%r\' %s (%D ms)', 'qywxzj', 'test', 'master', 0);
    58. INSERT INTO `config_properties` VALUES (54, 'boiler.quartz.corePoolSize', '10', 'qywxzj', 'test', 'master', 0);
    59. INSERT INTO `config_properties` VALUES (55, 'boiler.quartz.maxPoolSize', '30', 'qywxzj', 'test', 'master', 0);
    60. INSERT INTO `config_properties` VALUES (56, 'boiler.quartz.queueCapacity', '40', 'qywxzj', 'test', 'master', 0);
    61. INSERT INTO `config_properties` VALUES (57, 'boiler.timeout.connectionRequestTimeout', '3000', 'qywxzj', 'test', 'master', 0);
    62. INSERT INTO `config_properties` VALUES (58, 'boiler.timeout.connectTimeout', '3000', 'qywxzj', 'test', 'master', 0);
    63. INSERT INTO `config_properties` VALUES (59, 'boiler.timeout.readTimeout', '6000', 'qywxzj', 'test', 'master', 0);
    64. INSERT INTO `config_properties` VALUES (60, 'ali.rocketmq.accessKeyId', 'LTAI5t9sdf33FDSFSVS', 'qywxzj', 'test', 'master', 0);
    65. INSERT INTO `config_properties` VALUES (61, 'ali.rocketmq.accessKeySecret', 'C73svKpdfgdfg646GFDGDsx2kwba7H7CYJvbPq', 'qywxzj', 'test', 'master', 0);
    66. INSERT INTO `config_properties` VALUES (62, 'ali.rocketmq.endpoint', 'http://1235689754123656.mqrest.cn-shanghai.aliyuncs.com', 'qywxzj', 'test', 'master', 0);
    67. INSERT INTO `config_properties` VALUES (63, 'ali.rocketmq.qwzj.topic', 'qywx_selfMessage', 'qywxzj', 'test', 'master', 0);
    68. INSERT INTO `config_properties` VALUES (64, 'ali.rocketmq.qwzj.consumerGroupName', 'GID_selfsf', 'qywxzj', 'test', 'master', 0);
    69. INSERT INTO `config_properties` VALUES (65, 'ali.rocketmq.qwzj.instanceId', 'MQ_INST_6464s6df6646werew_BYET1yoq', 'qywxzj', 'test', 'master', 0);
    70. INSERT INTO `config_properties` VALUES (66, 'spring.main.allow-bean-definition-overriding', 'true', 'qywxzj', 'test', 'master', 0);

    7、然后启动server-config项目。在浏览器输入http://localhost:9092/ncs/qywxzj/test/master，然后输入admin/admin。就会看到从数据库中读取到的配置文件。返回的json如下。

    SQL说明

    SELECT KEY, VALUE from PROPERTIES where APPLICATION=? and PROFILE=? and LABEL=?

    第一个?: 对应访问地址中的config-server

    第二个?: 对应访问地址中的dev,test,prod等

    第三个?: 可以为空,可以用来表示版本号

    1. {
    2.     "name": "qywxzj", 
    3.     "profiles": [
    4.         "test"
    5.     ], 
    6.     "label": "master", 
    7.     "version": null, 
    8.     "state": null, 
    9.     "propertySources": [
    10.         {
    11.             "name": "qywxzj-test", 
    12.             "source": {
    13.                 "server.servlet.context-path": "/qywxzj", 
    14.                 "server.port": "9091", 
    15.                 "server.servlet.jsp.init-parameters.development": "TRUE", 
    16.                 "server.tomcat.uri-encoding": "UTF-8", 
    17.                 "server.servlet.session.timeout": "7200", 
    18.                 "logging.level.org.springframework.web": "ERROR", 
    19.                 "logging.level.com.github.binarywang.demo.wx.cp": "INFO", 
    20.                 "logging.level.me.chanjar.weixin": "INFO", 
    21.                 "myApp.server": "http://192.168.1.120:9091/qywxzj/", 
    22.                 "server.servlet.encoding.force": "TRUE", 
    23.                 "server.servlet.encoding.charset": "UTF-8", 
    24.                 "server.servlet.encoding.enabled": "TRUE", 
    25.                 "spring.mvc.view.prefix": "/WEB-INF/views/", 
    26.                 "spring.mvc.view.suffix": ".jsp", 
    27.                 "spring.thymeleaf.cache": "FALSE", 
    28.                 "spring.thymeleaf.enabled": "FALSE", 
    29.                 "spring.jpa.database": "MYSQL", 
    30.                 "spring.datasource.driver-class-name": "com.mysql.cj.jdbc.Driver", 
    31.                 "spring.datasource.url": "jdbc:mysql://192.168.1.123:3306/student?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false&allowMultiQueries=true", 
    32.                 "spring.datasource.username": "root", 
    33.                 "spring.datasource.password": "123456", 
    34.                 "spring.datasource.type": "com.alibaba.druid.pool.DruidDataSource", 
    35.                 "spring.datasource.initialSize": "1", 
    36.                 "spring.datasource.minIdle": "3", 
    37.                 "spring.datasource.maxActive": "20", 
    38.                 "spring.datasource.maxWait": "60000", 
    39.                 "spring.datasource.timeBetweenEvictionRunsMillis": "60000", 
    40.                 "spring.datasource.minEvictableIdleTimeMillis": "30000", 
    41.                 "spring.datasource.validationQuery": "select 'x'", 
    42.                 "spring.datasource.testWhileIdle": "TRUE", 
    43.                 "spring.datasource.testOnBorrow": "FALSE", 
    44.                 "spring.datasource.testOnReturn": "FALSE", 
    45.                 "spring.jpa.hibernate.ddl-auto": "update", 
    46.                 "mybatis-plus.type-aliases-package": "cn.renkai721.*.*Entity", 
    47.                 "mybatis-plus.global-config.id-type": "0", 
    48.                 "mybatis-plus.global-config.field-strategy": "2", 
    49.                 "mybatis-plus.global-config.db-column-underline": "TRUE", 
    50.                 "mybatis-plus.global-config.refresh-mapper": "TRUE", 
    51.                 "mybatis-plus.configuration.map-underscore-to-camel-case": "FALSE", 
    52.                 "mybatis-plus.configuration.cache-enabled": "FALSE", 
    53.                 "mybatis-plus.configuration.call-setters-on-nulls": "TRUE", 
    54.                 "mybatis-plus.global-config.db-config.id-type": "id_worker", 
    55.                 "mybatis-plus.mapper-locations": "classpath*:mapper/*Mapper.xml", 
    56.                 "redisson.singleServerConfig.address": "192.168.1.124:6380", 
    57.                 "redisson.singleServerConfig.database": "6", 
    58.                 "redisson.password": "123456", 
    59.                 "redisson.model": "SINGLE", 
    60.                 "springfox.documentation.swagger.use-model-v3": "FALSE", 
    61.                 "spring.mvc.pathmatch.matching-strategy": "ant_path_matcher", 
    62.                 "management.endpoints.web.exposure.include": "'*'", 
    63.                 "server.tomcat.basedir": "qywxzj", 
    64.                 "server.tomcat.accesslog.enabled": "TRUE", 
    65.                 "server.tomcat.accesslog.pattern": "%t [%I] %{X-Forwarded-For}i %a '%r' %s (%D ms)", 
    66.                 "boiler.quartz.corePoolSize": "10", 
    67.                 "boiler.quartz.maxPoolSize": "30", 
    68.                 "boiler.quartz.queueCapacity": "40", 
    69.                 "boiler.timeout.connectionRequestTimeout": "3000", 
    70.                 "boiler.timeout.connectTimeout": "3000", 
    71.                 "boiler.timeout.readTimeout": "6000", 
    72.                 "ali.rocketmq.accessKeyId": "LTAI5t9sdf33FDSFSVS", 
    73.                 "ali.rocketmq.accessKeySecret": "C73svKpdfgdfg646GFDGDsx2kwba7H7CYJvbPq", 
    74.                 "ali.rocketmq.endpoint": "http://1235689754123656.mqrest.cn-shanghai.aliyuncs.com", 
    75.                 "ali.rocketmq.qwzj.topic": "qywx_selfMessage", 
    76.                 "ali.rocketmq.qwzj.consumerGroupName": "GID_selfsf", 
    77.                 "ali.rocketmq.qwzj.instanceId": "MQ_INST_6464s6df6646werew_BYET1yoq", 
    78.                 "spring.main.allow-bean-definition-overriding": "true"
    79.             }
    80.         }
    81.     ]
    82. }

    ----------------------------------------服务端  config client--------------------------------------

    1、新建一个普通的springboot项目，名字随便叫一个springboot-config-client。这个client只是一个概念，就是你需要用的实际的项目，刚才的server只是做一个从数据库读取配置文件的服务而已，因为你自己不能直接读取数据库，所以需要它来中转一下。

    2、pom.xml文件依赖的jar。

    1.  
    2. <?xml version="1.0" encoding="UTF-8"?>
    3. <project xmlns="http://maven.apache.org/POM/4.0.0"
    4. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    5. 	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    6. 	<modelVersion>4.0.0</modelVersion>
    7.  
    8. 	<groupId>cn.renkai721</groupId>
    9. 	<artifactId>qywxzj</artifactId>
    10. 	<version>1.0.0</version>
    11. 	<packaging>jar</packaging>
    12.  
    13. 	<name>qywxzj</name>
    14.  
    15. 	<parent>
    16. 		<groupId>org.springframework.boot</groupId>
    17. 		<artifactId>spring-boot-starter-parent</artifactId>
    18. 		<version>2.4.2</version>
    19. 		<relativePath/>
    20.  
    21. 	<properties>
    22. 		<encoding>UTF-8</encoding>
    23. 		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    24. 		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    25. 		<java.version>1.8</java.version>
    26. 		<maven.compiler.source>${java.version}</maven.compiler.source>
    27. 		<maven.compiler.target>${java.version}</maven.compiler.target>
    28. 		<lombok.version>1.18.0</lombok.version>
    29. 		<spring-cloud.version>Finchley.RELEASE</spring-cloud.version>
    30. 	</properties>
    31.  
    32. 	<repositories>
    33. 		<!--阿里云仓库 -->
    34. 		<repository>
    35. 			<id>aliyun</id>
    36. 			<url>https://maven.aliyun.com/repository/public/</url>
    37. 		</repository>
    38. 	</repositories>
    39.  
    40. 	<dependencies>
    41. 		<!-- Spring Boot Web 依赖 -->
    42. 		<dependency>
    43. 			<groupId>org.springframework.boot</groupId>
    44. 			<artifactId>spring-boot-starter-web</artifactId>
    45. 		</dependency>
    46. 		<dependency>
    47. 			<groupId>mysql</groupId>
    48. 			<artifactId>mysql-connector-java</artifactId>
    49. 			<version>8.0.11</version>
    50. 		</dependency>
    51. 		<!-- 数据库连接池 -->
    52. 		<dependency>
    53. 			<groupId>com.alibaba</groupId>
    54. 			<artifactId>druid</artifactId>
    55. 			<version>1.2.6</version>
    56. 		</dependency>
    57. 		<dependency>
    58. 			<groupId>org.springframework.cloud</groupId>
    59. 			<artifactId>spring-cloud-starter-config</artifactId>
    60. 			<version>3.0.6</version>
    61. 		</dependency>
    62.  
    63.         <--如果springboot的版本是2.1.6.RELEASE，就不需要下面的bootstrap依赖 -->
    64.         <--springboot2.1.6.RELEASE，对应spring-cloud-starter-config版本2.0.0.RELEASE -->
    65. 		<dependency>
    66. 			<groupId>org.springframework.cloud</groupId>
    67. 			<artifactId>spring-cloud-starter-bootstrap</artifactId>
    68. 			<version>3.1.0</version>
    69. 		</dependency>
    70.  
    71. 	</dependencies>
    72.  
    73. 	<build>
    74. 		<finalName>qywxzj</finalName>
    75. 		<plugins>
    76. 			<plugin>
    77. 				<groupId>org.springframework.boot</groupId>
    78. 				<artifactId>spring-boot-maven-plugin</artifactId>
    79. 			</plugin>
    80. 		</plugins>
    81. 		
    82. 	</build>
    83.  
    84.  
    85. </project>

    3、resource/bootstrap.properties文件配置如下。这里必须要注意，不能使用application.properties，否则系统是无法读取到配置信息的，原因未知。

    1. # read mysql db
    2. spring.application.name=qywxzj
    3.  
    4.  
    5. ## quote config server
    6. spring.cloud.config.uri=http://localhost:9092/ncs
    7. spring.cloud.config.fail-fast=true
    8. spring.cloud.config.name=qywxzj
    9. spring.cloud.config.label=master
    10. spring.cloud.config.profile=test
    11. spring.cloud.config.username=admin
    12. spring.cloud.config.password=admin

    4、启动类上必须添加@EnableDiscoveryClient

    1. package cn.renkai721;
    2.  
    3. import org.mybatis.spring.annotation.MapperScan;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6. import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
    7. import org.springframework.transaction.annotation.EnableTransactionManagement;
    8.  
    9. import lombok.extern.slf4j.Slf4j;
    10. import springfox.documentation.oas.annotations.EnableOpenApi;
    11.  
    12.  
    13. @SpringBootApplication(scanBasePackages = "cn.renkai721")
    14. @EnableTransactionManagement
    15. @MapperScan("cn.**.dao")
    16. @Slf4j
    17. @EnableOpenApi
    18. @EnableDiscoveryClient
    19. public class QywxzjApplication {
    20.  
    21.  
    22. 	public static void main(String[] args) {
    23. 		SpringApplication.run(QywxzjApplication.class, args);
    24. 		log.info("swagger api=http://ip:port/qywxzj/swagger-ui.html");
    25. 		log.info("swagger api=http://ip:port/qywxzj/doc.html");
    26. 	}
    27.  
    28.  
    29. }

    5、新建一个配置文件类。

    1. package cn.renkai721.configuration;
    2.  
    3. import lombok.Data;
    4. import org.springframework.beans.factory.annotation.Value;
    5. import org.springframework.cloud.context.config.annotation.RefreshScope;
    6. import org.springframework.context.annotation.Configuration;
    7. import org.springframework.stereotype.Component;
    8.  
    9.  
    10. @Configuration
    11. @Data
    12. @Component
    13. public class QywxProperties {
    14.  
    15.     // 第三方应用
    16.     public static String myApp = "myApp";
    17.  
    18.     @Value("${myApp.server}")
    19.     private String myAppServer;
    20.     @Value("${ali.rocketmq.qwzj.instanceId}")
    21.     private String instanceId;
    22.     @Value("${ali.rocketmq.qwzj.topic}")
    23.     private String topic;
    24.  
    25. }

    6、新建一个controller测试。

    1. package cn.renkai721.controller;
    2.  
    3.  
    4. import javax.annotation.Resource;
    5. import javax.servlet.http.HttpSession;
    6.  
    7. import cn.renkai721.configuration.QywxProperties;
    8. import lombok.extern.slf4j.Slf4j;
    9. import org.springframework.stereotype.Controller;
    10.  
    11. import springfox.documentation.annotations.ApiIgnore;
    12.  
    13.  
    14. @Controller
    15. @Slf4j
    16. public class IndexController {
    17.  
    18. 	@Resource
    19. 	private QywxProperties qywxProperties;
    20.  
    21. 	@ApiIgnore
    22. 	@RequestMapping(value = "/testDiZhi", method = RequestMethod.GET)
    23. 	@ResponseBody
    24. 	public String testDiZhi() {
    25. 		String callback = qywxProperties.getMyAppServer();
    26. 		return callback;
    27. 	}
    28.  
    29.  
    30. }

    7、在浏览器输入http://localhost:9091/qywxzj/testDiZhi，返回如下

    http://192.168.1.120:9091/qywxzj/

    --------------------------------------到此，springboot+springcloud从数据库读取配置文件结束

    --------------------------------------扩展

    1、如果需要从svn,git读取配置文件的，自行了解。建议使用springboot+nacos，这样比较方便简单。

    2、参照地址如下

    SpringBoot ConfigServer配置中心 | 无业游民

    spring cloud config将配置存储在数据库中-蒲公英云

    springboot-config-Server配置文件服务搭建_孟海滨的博客-CSDN博客

  • 相关阅读:
    没有杯子的世界：OOP设计思想的应用实践
    免费 AI 编程助手 Amazon CodeWhisperer 体验
    云计算 - 以阿里云为例，企业上云策略全览与最佳实践
    YOLOv5-PTQ量化部署
    深入浅出mybatis分页
    三个线程交替打印的几种实现方式
    OpenShift 4 - 用 Operator 部署 Redis 集群
    EelasticSearch使用！！！
    c#将int转为中文数字
    Flink SQL 在kerberos on yarn环境下提交
  • 原文地址：https://blog.csdn.net/renkai721/article/details/125529433