druiddatasource配置通过SpringBoot配置文件配置Druid数据源

2022-07-23 08:25:44

点击上方“ 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


  • 作者:weixin_39654619
  • 原文链接:https://blog.csdn.net/weixin_39654619/article/details/111169802
    更新时间:2022-07-23 08:25:44