如果我的博客能够帮到大家能够点个赞,关注一下,以后还会更新更过JavaWeb的高级技术,大家的支持就是我继续更新的动力。谢谢。
今天,来做一个SpringBoot整和Druid数据源的Demo,我们知道Druid是阿里巴巴的数据源,也就是第三方数据源,需要在pom.xml文件中加入依赖,然后配置Druid的属性,开启后台性能监控功能。话不多说,开撸!
一、环境搭建
步骤:
- 创建Spring Boot工程
- 导入依赖
- 编写配置文件
- 配置application.yml
- 测试
1.创建SpringBoot工程工程,大家都会,略
2.导入依赖:pom.xml
<?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> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.1.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.nyist</groupId> <artifactId>spring-boot-06-data-jdbc</artifactId> <version>0.0.1-SNAPSHOT</version> <name>spring-boot-06-data-jdbc</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <!--jdbc 依赖引入--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--jdbc 驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <!--使用 druid 数据源--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.8</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
3.编写配置文件
package com.nyist.springboot06datajdbc.config; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet; import com.alibaba.druid.support.http.WebStatFilter; 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 javax.sql.DataSource; import java.util.HashMap; import java.util.Map; @Configuration public class DruidConfig { //@ConfigurationProperties 是将 阿里巴巴druid 的数据源 配置的属性和 属性文件绑定在一起 @ConfigurationProperties(prefix = "spring.datasource") @Bean public DataSource druid(){ return new DruidDataSource(); } //配置 Druid 的监控 //1.配置一个管理后台的Servlet @Bean public ServletRegistrationBean statViewServlet(){ ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*"); Map<String,String> map = new HashMap<>(); map.put("loginUsername","admin"); map.put("loginPassword","123456"); map.put("allow","localhost"); //不写 或者为null 默认允许所有 map.put("deny","192.168.1.122"); bean.setInitParameters(map); return bean; } //2.配置一个监控的Filter @Bean public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean initParam = new FilterRegistrationBean(); initParam.setFilter(new WebStatFilter()); Map<String,String> map = new HashMap<>(); //初始化不拦截请求的参数 map.put("exclusions","*.css,*.png,*.jpg,*.js,/druid/*"); initParam.setInitParameters(map); return initParam; } }
4.配置application.yml
spring: datasource: username: root password: root url: jdbc:mysql://localhost:3306/springdata_jdbc?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8 type: com.alibaba.druid.pool.DruidDataSource 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,logback maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500 # 建表 # schema: # - classpath:jpa_department.sql # - classpath:jpa_manager.sql
5.测试,代码如下:
package com.nyist.springboot06datajdbc; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.test.context.junit4.SpringRunner; import javax.sql.DataSource; import java.sql.Connection; import java.sql.SQLException; @RunWith(SpringRunner.class) @SpringBootTest public class SpringBoot06DataJdbcApplicationTests { @Autowired //开启自动注入 private DataSource dataSource; @Test public void contextLoads() throws SQLException { //DataSource:class com.zaxxer.hikari.HikariDataSource System.out.println("\nDataSource:" + dataSource.getClass()); Connection connection = dataSource.getConnection(); //HikariProxyConnection@749362556 wrapping com.mysql.cj.jdbc.ConnectionImpl@5e671e20 System.out.println("****************************:" + connection); connection.close(); } }