1、编写application.properties
#高版本 jdbc.url=jdbc:mysql:///***?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///***?useUnicode=true&characterEncoding=utf-8
jdbc.username=***
jdbc.password=***
2.java配置
方式一
//阿里巴巴数据源导包
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
@Bean
@ConfigurationProperties(prefix = "jdbc") //默认装配
public DataSource dataSource(){
DruidDataSource ds = new DruidDataSource();
return ds;
}
方式二
//java配置类
package com.sun.config;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.stereotype.Component;
@Component
@ConfigurationProperties(prefix = "jdbc")
@EnableConfigurationProperties(JdbcProperties.class)
public class JdbcProperties {
private String driverClassName;
private String url;
private String userName;
private String password;
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
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;
}
public String getDriverClassName() {
return driverClassName;
}
public void setDriverClassName(String driverClassName) {
this.driverClassName = driverClassName;
}
}
//系统配置类自动赋值
@Configuration
public class SysConfig {
@Bean
public DataSource dataSource(JdbcProperties jdbcProperties){
DruidDataSource ds = new DruidDataSource();
ds.setDriverClassName(jdbcProperties.getDriverClassName());
ds.setUrl(jdbcProperties.getUrl());
ds.setUsername(jdbcProperties.getUserName());
ds.setPassword(jdbcProperties.getPassword());
return ds;
}
}