springboot集成druid数据源

 1         <!--web场景支持-->
 2         <dependency>
 3             <groupId>org.springframework.boot</groupId>
 4             <artifactId>spring-boot-starter-web</artifactId>
 5         </dependency>
 6 
 7         <!--mybatis场景支持-->
 8         <dependency>
 9             <groupId>org.mybatis.spring.boot</groupId>
10             <artifactId>mybatis-spring-boot-starter</artifactId>
11             <version>2.1.2</version>
12         </dependency>
13         <dependency>
14             <groupId>mysql</groupId>
15             <artifactId>mysql-connector-java</artifactId>
16             <scope>runtime</scope>
17         </dependency>
18 
19         <dependency>
20             <groupId>org.springframework.boot</groupId>
21             <artifactId>spring-boot-starter-test</artifactId>
22             <scope>test</scope>
23             <exclusions>
24                 <exclusion>
25                     <groupId>org.junit.vintage</groupId>
26                     <artifactId>junit-vintage-engine</artifactId>
27                 </exclusion>
28             </exclusions>
29         </dependency>
30         <!--druid数据源-->
31         <dependency>
32             <groupId>com.alibaba</groupId>
33             <artifactId>druid-spring-boot-starter</artifactId>
34             <version>1.1.17</version>
35        </dependency>

package com.example.springboot5.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;

@Configuration
public class DruidConfig {

    @Bean
    @Primary
    public DataSource dataSource(){
         //指定使用数据源
        DruidDataSource dataSource = new DruidDataSource();
        //数据库连接信息
        dataSource.setUrl("jdbc:mysql://localhost:3306/test");
        //数据库用户名和密码
        dataSource.setName("root");
        dataSource.setPassword("123456");
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        try{
            //配置默认拦截
            dataSource.setFilters("stat,wall,slf4j");
        }catch (Exception e){ }

        return dataSource;
    }

    @Bean
    public FilterRegistrationBean filterRegistrationBean(){
        //创建过滤器
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
        filterRegistrationBean.setFilter(new WebStatFilter());
        filterRegistrationBean.setEnabled(true);
        Map<String,Object> intiParams = new HashMap<>();
        //忽略过滤的文件
        intiParams.put("exclusions","*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*");
        filterRegistrationBean.setInitParameters(intiParams);
        //设置过滤路径
        filterRegistrationBean.addUrlPatterns("/*");
        return filterRegistrationBean;
    }



}

 1 package com.example.springboot5.web;
 2 
 3 import com.example.springboot5.entity.Emp;
 4 import com.example.springboot5.service.EmpService;
 5 import org.springframework.beans.factory.annotation.Autowired;
 6 import org.springframework.web.bind.annotation.RequestMapping;
 7 import org.springframework.web.bind.annotation.ResponseBody;
 8 import org.springframework.web.bind.annotation.RestController;
 9 
10 import java.util.HashMap;
11 import java.util.List;
12 import java.util.Map;
13 
14 //官方推荐注解
15 @RestController
16 public class WebController {
17 
18     @Autowired
19     private EmpService empService;
20 
21     @RequestMapping("/emplist")
22     @ResponseBody
23     private Map<String,Object> empList(){
24         Map<String,Object> model = new HashMap<>();
25         //大家可以使用静态数据
26         List<Emp> emps =  empService.findEmpList();
27         model.put("emps",emps);
28         model.put("success",true);
29         return model;
30     }
31 
32 
33 }