springboot整合Druid数据源

步骤：
1.导入Druid依赖

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.19</version>
 </dependency>

2.数据源配置

spring:
  datasource:
    username: root
    password: 151630
    url: jdbc:mysql://localhost:3306/mybqtis?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

3.导入druid数据源

@Configuration
public class DruidConfig {
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druid(){
        return new DruidDataSource();
    }

    //配置Druid的监控
    //配置一个后台的servlet
    @Bean
    public ServletRegistrationBean staViewServlet(){

        ServletRegistrationBean registrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        Map<String,Object> initParams=new HashMap<>();
        initParams.put("loginUsername","admin");
        initParams.put("loginPassword","151630");
        initParams.put("allow","");//默认允许所有访问
        registrationBean.setInitParameters(initParams);
        return  registrationBean;
    }

    //2、配置一个web监控的filter
    @Bean
    public FilterRegistrationBean webFilter(){

        FilterRegistrationBean filterRegistrationBean=new FilterRegistrationBean();
        filterRegistrationBean.setFilter(new WebStatFilter());
        Map<String,Object> initParams=new HashMap<>();
        initParams.put("exclusions","*.js,*.css,/druid/*");
        filterRegistrationBean.setInitParameters(initParams);
        filterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
        return  filterRegistrationBean;

    }
}

输入配置的用用户名和密码，登录。

进入Druid后台管理页面

编写一个Comtroller

@Controller
public class JdbcController {
    @Autowired
    JdbcTemplate jdbcTemplate;

    @RequestMapping("/query")
    @ResponseBody
    public Map<String,Object> map(){
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from tbl_user ");
            return  list.get(0);
    }
}

访问/query后，可以看到已经监控到了一个url。