springboot使用Druid来连接数据库

最新推荐文章于 2024-09-26 09:34:24 发布

liubingle

最新推荐文章于 2024-09-26 09:34:24 发布

阅读量502

点赞数

分类专栏： springboot学习随笔文章标签： java

本文链接：https://blog.csdn.net/liubingle/article/details/108466474

版权

springboot学习随笔专栏收录该内容

20 篇文章 0 订阅

订阅专栏

springboot使用Druid来连接数据库
(一):引入Druid依赖

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

(二):application.yml

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/jdbc?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
	initialization-mode: always//别忘记
    initialSize: 5
    minIdle: 5
    maxActive: 20
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
    filters: stat,wall,slf4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

(三):编写DruidConfig：

@Configuration
public class DruidConfig {

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

    }
    @Bean
    public ServletRegistrationBean servletRegistrationBean(){

       ServletRegistrationBean<StatViewServlet> bean= new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        Map<String,String> init=new HashMap<>();
        init.put("loginUsername","admin");
        init.put("loginPassword","123456");
        init.put("allow","localhost");
        bean.setInitParameters(init);
       return bean;
   }

   @Bean
    public FilterRegistrationBean filterRegistrationBean(){
       FilterRegistrationBean<Filter> bean = new FilterRegistrationBean<>();
      bean.setFilter(new WebStatFilter());
       Map<String, String> init = new HashMap<>();
       init.put("exclusions","*.js,*.css,/druid/*");
       bean.setInitParameters(init);
       bean.setUrlPatterns(Arrays.asList("/*"));
       return bean;

   }


}

修改对应的WebStatFilter.class：

public static final String PARAM_NAME_PROFILE_ENABLE = "profileEnable";
    public static final String PARAM_NAME_SESSION_STAT_ENABLE = "sessionStatEnable";
    public static final String PARAM_NAME_SESSION_STAT_MAX_COUNT = "sessionStatMaxCount";
    public static final String PARAM_NAME_EXCLUSIONS = "exclusions";
    public static final String PARAM_NAME_PRINCIPAL_SESSION_NAME = "principalSessionName";
    public static final String PARAM_NAME_PRINCIPAL_COOKIE_NAME = "principalCookieName";
    public static final String PARAM_NAME_REAL_IP_HEADER = "realIpHeader";

和ResourceServlet.class：

private static final Log LOG = LogFactory.getLog(ResourceServlet.class);
    public static final String SESSION_USER_KEY = "druid-user";
    public static final String PARAM_NAME_USERNAME = "loginUsername";
    public static final String PARAM_NAME_PASSWORD = "loginPassword";
    public static final String PARAM_NAME_ALLOW = "allow";
    public static final String PARAM_NAME_DENY = "deny";
    public static final String PARAM_REMOTE_ADDR = "remoteAddress";

最后是test：

@SpringBootTest
class Springboot06DataJdbcApplicationTests {

    @Autowired
    DataSource dataSource;
    @Test
    public void contextLoads()  throws SQLException{
        System.out.println(dataSource.getClass());
        Connection connection = dataSource.getConnection();
        System.out.println(connection);
        connection.close();
    }

}