SpringBoot集成阿里巴巴Druid监控的示例代码

druid是阿里巴巴开源的数据库连接池，提供了优秀的对数据库操作的监控功能，本文要讲解一下springboot项目怎么集成druid。

本文在基于jpa的项目下开发，首先在pom文件中额外加入druid依赖，pom文件如下：

<?xml version="1.0" encoding="utf-8"?>

<project xmlns="http://maven.apache.org/pom/4.0.0" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xsi:schemalocation="http://maven.apache.org/pom/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelversion>4.0.0</modelversion>

<groupid>com.dalaoyang</groupid>

<artifactid>springboot_druid</artifactid>

<version>0.0.1-snapshot</version>

<packaging>jar</packaging>

<name>springboot_druid</name>

<description>springboot_druid</description>

<parent>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-starter-parent</artifactid>

<version>1.5.12.release</version>

<relativepath/> 

</parent>

<properties>

<project.build.sourceencoding>utf-8</project.build.sourceencoding>

<project.reporting.outputencoding>utf-8</project.reporting.outputencoding>

<java.version>1.8</java.version>

</properties>

<dependencies>

<dependency>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-starter-data-jpa</artifactid>

</dependency>

<dependency>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-starter-web</artifactid>

</dependency>

<dependency>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-devtools</artifactid>

<scope>runtime</scope>

</dependency>

<dependency>

<groupid>mysql</groupid>

<artifactid>mysql-connector-java</artifactid>

<scope>runtime</scope>

</dependency>

<dependency>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-starter-test</artifactid>

<scope>test</scope>

</dependency>

<dependency>

<groupid>com.alibaba</groupid>

<artifactid>druid</artifactid>

<version>1.0.28</version>

</dependency>

</dependencies>

<build>

<plugins>

<plugin>

<groupid>org.springframework.boot</groupid>

<artifactid>spring-boot-maven-plugin</artifactid>

</plugin>

</plugins>

</build>

</project>

application.properties上半段和整合jpa一点没变，下面加入了一些druid的配置，如果对druid的配置有什么不理解的，可以去网上查一下。（这篇文章我觉得写的很好，传送门）

#端口号

server.port=8888

##validate 加载hibernate时，验证创建数据库表结构

##create 每次加载hibernate，重新创建数据库表结构，这就是导致数据库表数据丢失的原因。

##create-drop 加载hibernate时创建，退出是删除表结构

##update 加载hibernate自动更新数据库结构

##validate 启动时验证表的结构，不会创建表

##none 启动时不做任何操作

spring.jpa.hibernate.ddl-auto=create

##控制台打印sql

spring.jpa.show-sql=true

##数据库配置

##数据库地址

spring.datasource.url=jdbc:mysql://localhost:3306/test?characterencoding=utf8&usessl=false

##数据库用户名

spring.datasource.username=root

##数据库密码

spring.datasource.password=root

##数据库驱动

spring.datasource.driver-class-name=com.mysql.jdbc.driver

#这里是不同的

#使用druid的话需要多配置一个属性spring.datasource.type

spring.datasource.type=com.alibaba.druid.pool.druiddatasource

# 连接池的配置信息

# 初始化大小，最小，最大

spring.datasource.initialsize=5

spring.datasource.minidle=5

spring.datasource.maxactive=20

# 配置获取连接等待超时的时间

spring.datasource.maxwait=60000

# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒

spring.datasource.timebetweenevictionrunsmillis=60000

# 配置一个连接在池中最小生存的时间，单位是毫秒

spring.datasource.minevictableidletimemillis=300000

spring.datasource.validationquery=select 1 from dual

spring.datasource.testwhileidle=true

spring.datasource.testonborrow=false

spring.datasource.testonreturn=false

# 打开pscache，并且指定每个连接上pscache的大小

spring.datasource.poolpreparedstatements=true

spring.datasource.maxpoolpreparedstatementperconnectionsize=20

# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙

spring.datasource.filters=stat,wall,log4j

# 通过connectproperties属性来打开mergesql功能；慢sql记录

然后在项目中加入druidconfig，简单讲解一下，这个配置文件主要是加载application.properties的配置，代码如下：

100

101

102

103

104

105

package com.dalaoyang.config;

import java.sql.sqlexception;

import javax.sql.datasource;

import org.apache.log4j.logger;

import org.springframework.beans.factory.annotation.value;

import org.springframework.context.annotation.bean;

import org.springframework.context.annotation.configuration;

import org.springframework.context.annotation.primary;

import com.alibaba.druid.pool.druiddatasource;

/**

* @author dalaoyang

* @description

* @project springboot_learn

* @package com.dalaoyang.config

* @email yangyang@dalaoyang.cn

* @date 2018/4/12

*/

@configuration

public class druidconfig {

private logger logger = logger.getlogger(this.getclass());

@value("${spring.datasource.url}")

private string dburl;

@value("${spring.datasource.username}")

private string username;

@value("${spring.datasource.password}")

private string password;

@value("${spring.datasource.driver-class-name}")

private string driverclassname;

@value("${spring.datasource.initialsize}")

private int initialsize;

@value("${spring.datasource.minidle}")

private int minidle;

@value("${spring.datasource.maxactive}")

private int maxactive;

@value("${spring.datasource.maxwait}")

private int maxwait;

@value("${spring.datasource.timebetweenevictionrunsmillis}")

private int timebetweenevictionrunsmillis;

@value("${spring.datasource.minevictableidletimemillis}")

private int minevictableidletimemillis;

@value("${spring.datasource.validationquery}")

private string validationquery;

@value("${spring.datasource.testwhileidle}")

private boolean testwhileidle;

@value("${spring.datasource.testonborrow}")

private boolean testonborrow;

@value("${spring.datasource.testonreturn}")

private boolean testonreturn;

@value("${spring.datasource.poolpreparedstatements}")

private boolean poolpreparedstatements;

@value("${spring.datasource.maxpoolpreparedstatementperconnectionsize}")

private int maxpoolpreparedstatementperconnectionsize;

@value("${spring.datasource.filters}")

private string filters;

@value("{spring.datasource.connectionproperties}")

private string connectionproperties;

@bean

@primary //主数据源

public datasource datasource(){

druiddatasource datasource = new druiddatasource();

datasource.seturl(this.dburl);

datasource.setusername(username);

datasource.setpassword(password);

datasource.setdriverclassname(driverclassname);

//configuration

datasource.setinitialsize(initialsize);

datasource.setminidle(minidle);

datasource.setmaxactive(maxactive);

datasource.setmaxwait(maxwait);

datasource.settimebetweenevictionrunsmillis(timebetweenevictionrunsmillis);

datasource.setminevictableidletimemillis(minevictableidletimemillis);

datasource.setvalidationquery(validationquery);

datasource.settestwhileidle(testwhileidle);

datasource.settestonborrow(testonborrow);

datasource.settestonreturn(testonreturn);

datasource.setpoolpreparedstatements(poolpreparedstatements);

datasource.setmaxpoolpreparedstatementperconnectionsize(maxpoolpreparedstatementperconnectionsize);

try {

datasource.setfilters(filters);

} catch (sqlexception e) {

logger.error("druid configuration exception", e);

}

datasource.setconnectionproperties(connectionproperties);

return datasource;

}

然后创建druidfilter，代码如下：

SpringBoot集成阿里巴巴Druid监控的示例代码

相关文章

快网idc优惠网

相关文章

微信

快网idc优惠网

QQ交流群