DruidDataSource配置

桃扇骨 2022-11-22 00:00 171阅读 0赞

package com.linkcheers.config.datasource;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.alibaba.druid.support.http.WebStatFilter;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.boot.web.servlet.FilterRegistrationBean;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    
    import javax.sql.DataSource;
    import java.util.Arrays;
    import java.util.HashMap;
    import java.util.Map;
    
    @Configuration
    @MapperScan(basePackages = "com.linkcheers.dao")
    public class DruidSourceConfig {
    
        @ConfigurationProperties(prefix = "spring.datasource")
        @Bean("nacos")
        public DataSource dataSource(){
            return new DruidDataSource();
        }
    
        /**
         * 配置 Druid 监控 之  管理后台的 Servlet
         */
        @Bean
        public ServletRegistrationBean statViewServlet() {
            ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),
                    "/druid/*");
    
            servletRegistrationBean.addInitParameter("resetEnable", "false");
            /**
             * loginUsername：Druid 后台管理界面的登录账号
             * loginPassword：Druid 后台管理界面的登录密码
             * allow：Druid 后台允许谁可以访问
             *      initParams.put("allow", "localhost")：表示只有本机可以访问
             *      initParams.put("allow", "")：为空或者为null时，表示允许所有访问
             * deny：Druid 后台拒绝谁访问
             *      initParams.put("deny", "192.168.1.20");表示禁止此ip访问
             */
            /** 设置初始化参数*/
            Map<String, String> initParams = new HashMap<>();
            initParams.put("loginUsername", "admin");
            initParams.put("loginPassword", "admin");
            initParams.put("allow", "");
    
    
            servletRegistrationBean.setInitParameters(initParams);
            return servletRegistrationBean;
        }
    
        /**
         * 配置 Druid 监控 之  web 监控的 filter
         * WebStatFilter：用于配置Web和Druid数据源之间的管理关联监控统计
         */
        @Bean
        public FilterRegistrationBean webStatFilter() {
            FilterRegistrationBean bean = new FilterRegistrationBean();
            bean.setFilter(new WebStatFilter());
    
            /** exclusions：设置哪些请求进行过滤排除掉，从而不进行统计*/
            Map<String, String> initParams = new HashMap<>();
            initParams.put("exclusions", "*.js,*.css,/druid/*");
            bean.setInitParameters(initParams);
    
            /** "/*" 表示过滤所有请求*/
            bean.setUrlPatterns(Arrays.asList("/*"));
            return bean;
        }
    
        // 配置事物管理器
        @Bean(name="transactionManager")
        public DataSourceTransactionManager transactionManager(){
            return new DataSourceTransactionManager(dataSource());
        }
    
    }