1,在pom.xml文件中导入依赖
<!--阿里Druid数据源引入项目即可-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.21</version>
</dependency>
2,在yml文件中编写连接数据源
#配置数据源
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/world
driver-class-name: com.mysql.cj.jdbc.Driver
3,编写一个连接数据库需要的属性的类JdbcProperties
package com.sm.pojo;
import lombok.Data;
@Data
public class JdbcProperties {
private String username;
private String password;
private String url;
private String driverClassName;
}
4,在yml中加一句话
type: com.alibaba.druid.pool.DruidDataSource
5,创建一个Jdbc配置文件类
package com.sm.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
@Configuration
public class JdbcConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource getData(){
DruidDataSource dataSource=new DruidDataSource();
return dataSource;
}
}
6,在控制器中编写代码
package com.sm.controller;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import javax.sql.DataSource;
@RestController
@Slf4j
public class TestController {
@Resource
private DataSource dataSource;
@RequestMapping("/index")
public String index(){
log.info(dataSource.getClass().getName());
return dataSource.getClass().getName();
}
}
7,运行引导类即可