SpringBoot默认通过 spring.datasource 前缀去自动化配置mysql数据库的连接,但现在需要通过配置中心的配置实现数据库的连接。步骤如下:
1.配置中心mysql.properties如下
mysql.crm.jdbc.driver-class-name=com.mysql.jdbc.Driver
mysql.crm.jdbc.username=root
mysql.crm.jdbc.password=1234
mysql.crm.jdbc.url=jdbc:mysql://192.168.1.11:3306/crm?characterEncoding=utf-8&useSSL=false
2.springBoot启动类加载mysql.properties文件
@SpringBootApplication
@PropertySource(value = {"classpath:config/mysql.properties"})
public class Application {
public static void main(String[] args) throws IOException {
SpringApplication.run(KscrmApplication.class, args);
}
}
3.通过自定义配置类初始化 DriverManagerDataSource
@Configuration
@ComponentScan
public class PersistenceJPAConfig {
@Bean
@ConfigurationProperties(prefix="mysql.crm.jdbc")
public DataSource dataSource() {
return new DriverManagerDataSource();
}
}