点击上方“ Java资料站 ”,选择“标星公众号”
优质文章,第一时间送达
谁风霜依旧 | 作者
urlify.cn/fYfiMf | 来源
在SpringBoot 1.X 中,spring-boot-starter-jdbc启动器中默认使用的是org.apache.tomcat.jdbc.pool.DataSource作为数据源
在SpringBoot 2.X 中,spring-boot-starter-jdbc启动器中默认使用的是com.zaxxer.hikari.HikariDataSource作为数据源
引入坐标依赖
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0modelVersion> <parent> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-starter-parentartifactId> <version>2.3.3.RELEASEversion> <relativePath/> parent> <groupId>com.zjwgroupId> <artifactId>springbootjdbcartifactId> <version>0.0.1-SNAPSHOTversion> <name>springbootjdbcname> <description>Demo project for Spring Bootdescription> <properties> <java.version>1.8java.version> properties> <dependencies> <dependency> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-starter-webartifactId> dependency> <dependency> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-starter-thymeleafartifactId> dependency> <dependency> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-starter-jdbcartifactId> dependency> <dependency> <groupId>mysqlgroupId> <artifactId>mysql-connector-javaartifactId> <version>8.0.15version> dependency> <dependency> <groupId>com.alibabagroupId> <artifactId>druidartifactId> <version>1.1.12version> dependency> <dependency> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-starter-testartifactId> <scope>testscope> <exclusions> <exclusion> <groupId>org.junit.vintagegroupId> <artifactId>junit-vintage-engineartifactId> exclusion> exclusions> dependency> dependencies> <build> <plugins> <plugin> <groupId>org.springframework.bootgroupId> <artifactId>spring-boot-maven-pluginartifactId> plugin> plugins> build>project>
配置application.properties文件
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql://192.168.234.128/sb?useSSL=false&serverTimeZone=Shanghai/Asiaspring.datasource.username=rootspring.datasource.password=a@123456#指定为Druid数据源,默认为HikariDataSource数据源spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
新建一个controller观察使用的是哪一个数据源
package com.zjw.controller;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.GetMapping;import javax.annotation.Resource;import javax.sql.DataSource;@Controllerpublic class UsersController { @Resource private DataSource dataSource; @GetMapping("/showInfo") public String showInfo(){ //观察使用的是哪个数据源 System.out.println(this.dataSource.getClass()); return "OK"; }}
打印结果:
class com.alibaba.druid.pool.DruidDataSource