Spring Cloud Server 使用MySQL数据库存储配置内容

一、简介

在SpringCloud Server Config配置服务器中配置文件存储的方式有很多，在查看Dalston SR5版本的文档时发现 只介绍了如下几种存储方式如何使用：本地仓储，Git仓库，Vault，SVN。

查看类org.springframework.cloud.config.server.config.EnvironmentRepositoryConfiguration时，发现还有数据库的存储方式

接下来将介绍如何去时使用数据库的方式存储配置文件，其实使用上大致上和Git一样

一、环境

1、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>com.wallfacers</groupId>
	<artifactId>spring-cloud-jdbc-config</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>spring-cloud-lesson-3-jdbc-config</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.16.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
		<spring-cloud.version>Edgware.SR4</spring-cloud.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-actuator</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.cloud</groupId>
			<artifactId>spring-cloud-config-server</artifactId>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</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>
		</dependencies>
	</dependencyManagement>

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


</project>

2、配置application.properties文件

# 指定profile为jdbc是为了激活以数据库存储配置的方式生效默认是Git
spring.profiles.active=jdbc

# 数据源配置
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root

3、bootstrap.properties配置文件

# 相当于Git存储方式的url
spring.cloud.config.server.jdbc.sql=SELECT tp_key,tp_value FROM tb_properties WHERE tp_application=? and tp_profile=? and tp_label=?

 

4、在启动类上加注解

@EnableConfigServer

 

5、创建对应配置文件的库和表，下图为表中的内容

6、查看是否配置成功

二、总结

1、在配置的过程一定要指定spring.profiles.active否则数据库的存储方式不会生效

依据：查看类org.springframework.cloud.config.server.config.EnvironmentRepositoryConfiguration发现默认方式是Git