Maven Helper插件的安装以及使用
File -->settings -->Plugins -->Maven Helper,安装即可
打开pom.xml,除了text视图之外,还可以看到Dependency Analyzer,可查看冲突的jar包
集成Mysql数据库
引入依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
mysql-connector-java:MYSQL连接java的驱动程序
spring-boot-starter-jdbc:支持通过JDBC连接数据库
添加数据库配置
logging.config=classpath:logback-boot.xml
#部署热部署触发文件
spring.devtools.restart.trigger-file=.trigger
### Mysql连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sys?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
### 数据源类别
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
### 初始化大小、最小、最大
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-active=20
### 配置获得连接等待超时的时间 单位毫秒
spring.datasource.druid.max-wait=60000
### 配置一个连接在池中最小的生存时间,单位是毫秒
spring.datasource.druid.time-between-eviction-runs-millis=60000
### 配置一个连接池中最小的生存时间,单位是毫秒
spring.datasource.druid.min-evictable-idle-time-millis=30000
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.tomcat.test-while-idle=true
spring.datasource.tomcat.test-on-borrow=false
spring.datasource.tomcat.test-on-return=false
### 打开PSCache
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
### 配置监控统计拦截的filters,去掉后面监控界面的SQL无法统计,'wall'用于防火墙
spring.datasource.druid.filters.commons-log.connection-logger-name=stat,wall,log4j
### 通过connectProperties属性来打开mergeSql功能,慢SQL记录
spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMills=5000
### 合并多个DruisDataSource的监控数据
#spring.datasource.druid.use-global-data-source-stat=true
server.port=8090
开启监控
开启监控功能的方式有很多种:
- 使用原生的Servlet、filter方式,然后通过@ServletComponentScan启动扫描包进行处理;
- 使用代码注册Servlet、filter的方式,spring-boot推荐是使用这种,在项目的java目录下(/src/main/java/com.example.demo.filter)
具体代码如下
package com.springboot.demo.filter;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
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;
@Configuration
public class DruidConfiguration {
@Bean
public ServletRegistrationBean druidStatViewServlet(){
//ServletRegistrationBean提供类的进行注册
ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
//添加初始化参数:initParam
//白名单
servletRegistrationBean.addInitParameter("allow","127.0.0.1");
//IP黑名单(deny优先于allow)
//如果满足deny,就提示:sorry,you are not permitted to view this page.servletRegistrationBean.addInitParameter("deny","ip");
//登录查看信息的账号和密码
servletRegistrationBean.addInitParameter("loginUserName","admin");
servletRegistrationBean.addInitParameter("loginPassWord","123456");
//是否能够重置数据
servletRegistrationBean.addInitParameter("resetEnable","false");
return servletRegistrationBean;
}
@Bean
public FilterRegistrationBean druidStatFilter(){
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
//添加过滤规则
filterRegistrationBean.addUrlPatterns("/*");
filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
return filterRegistrationBean;
}
}
在DruidConfiguration 类开发完之后,重新启动下项目,访问地址:http://localhost:8090/druid/index.html打开监控的登录界面,输入用户名和密码:admin和123456即可登陆成功