使用druid【使用官方的stater】||集成JdbcTemplate

修改pom.xml加入druid starter

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.21</version>
</dependency>

修改yml

server:
  port: 8080
spring:
  datasource: #数据源配置
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/dd?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC
    username: root
    password: root
    druid:
      max-active: 10
      min-idle: 5
      max-wait: 5000
      initial-size: 5
      validation-query: select 1
      stat-view-servlet:
        enabled: true
        login-username: admin
        login-password: admin
        allow:
        deny:
        url-pattern: "/druid/*"

排除默认的数据自动配置

---

---

---

集成JdbcTemplate

package com.sxt;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

@SpringBootTest
class ApplicationTests {

   @Autowired
   private JdbcTemplate jdbcTemplate;

    @Test
    void contextLoads() {
        Map<String, Object> map = jdbcTemplate.queryForMap("select * from teacher where teacher_id=1");
        System.out.println(map);
    }

    @Test
    void contextLoads2() {
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from teacher");
        System.out.println(list);
    }
}