关于SpringBoot整合数据库

Hikari+jdbcTemplate+mysql

pom.xml

<!--        连接池，jdbc，事务相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
<!--        mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>

yaml

spring:
#  连接源配置
  datasource:
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: 333
    driver-class-name: com.mysql.jdbc.Driver
#    template配置
  jdbc:
    template:
      query-timeout: 3

Druid+jdbcTemplate+mysql

自定义

pom.xml

<!--        连接池，jdbc，事务相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
<!--        mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>
        <!--        druid数据源-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.17</version>
        </dependency>

yaml

spring:
#  连接源配置
  datasource:
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: 333
    driver-class-name: com.mysql.jdbc.Driver
#    template配置
  jdbc:
    template:
      query-timeout: 3

configuration

@Configuration
public class DataSourceConfiguration {
   
   
    /**
     * 添加druid数据源到容器中
     * @return
     */
    @Bean
    @ConfigurationProperties(value = "spring.datasource")
    public DataSource dataSource(){
   
   
        return new DruidDataSource();
    }

    /**
     * 配置监控页面的Servlet
     * @return
     */
     @Bean
    public ServletRegistrationBean statViewServlet(){
   
   
        StatViewServlet statViewServlet = new StatViewServlet();
        return new ServletRegistrationBean<StatViewServlet>(statViewServlet,"/druid/*");
    }
}