使用Druid监控功能-SQL监控Druid监控功能-WEB关联监控Druid监控功能-SQL防火墙Druid监控功能-session监控Druid

Spring

1.创建src/main/java/com/zzw/springboot/servlet/Servlet_.java

/***

{resp.getWriter().write(Servlet_);}

}2.修改启动类

ServletComponentScan(com.zzw.springboot)

public

SpringApplication.run(Application.class,

args);}

4.创建src/main/java/com/zzw/springboot/filter/Filter_.java

/***

servletRequest;log.info(过滤器处理的uri{},

request.getRequestURI());filterChain.doFilter(servletRequest,

servletResponse);//放行}Overridepublic

void

过滤器配置的urlPatterns也会经过SpringBoot拦截器.

请在拦截器配置中放行

localhost:8080/images/logo.png时拦截器不会拦截

6.创建src/main/java/com/zzw/springboot/listener/Listener_.java

Slf4j

contextInitialized(ServletContextEvent

sce)

contextDestroyed(ServletContextEvent

sce)

ServletComponentScan(com.zzw.springboot)

public

SpringApplication.run(Application.class,

前提:

1.创建src/main/java/com/zzw/springboot/config/RegisterConfig_.java

/***

(默认)保证每个Bean方法被调用多少次返回的组件都是单例的,

true)

{//使用RegistrationBean方法注入ServletBeanpublic

servlet_()

ServletRegistrationBean对象///Servlet_1,

/Servlet_2

ServletRegistrationBean(servlet,

/Servlet_1,

/Servlet_2);}//使用RegistrationBean方法注入FilterBeanpublic

filter_()

Filter_();FilterRegistrationBean

new

FilterRegistrationBean(filter);//设置filter的url-patternsfilterRegistrationBean.setUrlPatterns(Arrays.asList(/css/*,

filterRegistrationBean;}//使用RegistrationBean方法注入ListenerBeanpublic

ServletListenerRegistrationBean

listener_()

ServletListenerRegistrationBean(listener);}

}2.证明

1.请求Servlet时不会到达DispatcherServlet因此也不会到达拦截器。

2.原因分析

注入的Servlet会存在于Spring容器DispatcherServlet也会存在于Spring容器。

3.会议Tomcat在对Servlet

url匹配的原则多个servlet都能处理到同一层路径精确优先原则/最长前缀匹配原则。

6.源码分析

1)DispatcherServlet在SpringBoot是如何配置和注入的

DispatcherServletAutoConfiguration完成对DispatcherServlet自动配置。

内置Tomcat配置和切换

1.SpringBoot支持的webServerTomcatJettyUndertow。

3.支持对Tomcat也可以是JettyUndertow)的配置和切换。

内置Tomcat配置

#tomat是ServerProperties的静态内部类对tomcat配置threads:max:

#max是threads静态内部类的属性默认是200min-spare:

#Minimum

#当tomcat启动的线程达到最大值后接受排队的请求个数默认是100max-connections:

2000

2.创建src/main/java/com/zzw/springboot/config/CustomizationBean.java

Component

WebServerFactoryCustomizerConfigurableServletWebServerFactory

{Overridepublic

customize(ConfigurableServletWebServerFactory

server)

{//手动修改的server.setPort(9092);//设置server的端口

9092}

#tomat是ServerProperties的静态内部类对tomcat配置

threads:

#当tomcat启动的线程达到最大值后接受排队的请求个数默认是100

max-connections:

o.s.b.w.embedded.tomcat.TomcatWebServer

Tomcat

dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId!--排除tomcat

server--exclusionsexclusiongroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-tomcat/artifactId/exclusion/exclusions

dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-undertow/artifactId/dependency

3.测试

需求演示SpringBoot如何通过jdbcHikariDataSource

说明HikariDataSource目前市面上非常优秀的数据源是SpringBoot2默认数据源。

应用实例

assets/images/product-image/6.jpg);INSERT

INTO

assets/images/product-image/4.jpg);INSERT

INTO

assets/images/product-image/14.jpg);INSERT

INTO

assets/images/product-image/16.jpg);--

SELECT

furn;2.进行数据库开发在pom.xml引入data-jdbc-starter.

参考离线文档

dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-jdbc/artifactId

/dependency3.需要在pom.xml指定导入数据库驱动,

并指定对应版本.

mysql.version8.0.26/mysql.version

2.我们指定版本

dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.49/version

/dependency4.application.xml配置数据源信息

xml文件里使用amp;防止出现乱码,

jdbc:mysql://localhost:3306/spring_boot?useSSLtrueuseUnicodetruecharacterEncodingUTF-8username:

rootpassword:

com.mysql.jdbc.Driver5.新建src/main/java/com/zzw/springboot/bean/Furn.java

public

imagePath;}6.测试E:\idea_project\zzw_springboot\springboot-usersys\src\test\java\com\zzw\springboot\ApplicationTest.java

需要引入starter-test--

dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactId

/dependency//演示一下如何在SpringBoot中开发测试类

SpringBootTest

{//自动注入JdbcTemplate对象Resourceprivate

JdbcTemplate

BeanPropertyRowMapper(Furn.class);//调用ListFurn

furnList

{System.out.println(furn);}//查看底层使用的是什么数据源类型[HikariDataSource]System.out.println(jdbcTemplate.getDataSource());}

}整合Druid到SpringBoot

https://github.com/alibaba/druid

中文手册:

https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

基本介绍

dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.1.17/version

/dependency2.创建src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java

Setter

driverClassName;//编写方法注入DruidDataSourceBeanpublic

DruidDataSource

DruidDataSource();druidDataSource.setUrl(url);druidDataSource.setUsername(username);druidDataSource.setPassword(password);druidDataSource.setDriverClassName(driverClassName);return

druidDataSource;}

默认的HikariDataSource失效了?//1.默认的数据源是如何配置的?//解读:

DataSource.class,

就不注入默认的HikariDataSource//2.debug源码ConfigurationProperties(prefix

DruidDataSource

ConfigurationProperties(spring.datasource)//

就可以读取到application.yml的配置//2.我们就不需要显示地调用DruidDataSource

setXxx,

需求配置Druid的监控功能包括SQL监控SQL防火墙Web应用Session监控等。

[参考官方文档]

1.修改src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java,

//配置druid监控页功能

StatViewServlet();ServletRegistrationBean

new

ServletRegistrationBean(statViewServlet,

druid/*);MapString,

HashMap();initParameters.put(loginUsername,

druid);//允许清空统计数据initParameters.put(loginPassword,

druid);//用户名initParameters.put(resetEnable,

true);//密码servletRegistrationBean.setInitParameters(initParameters);return

}3.修改src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java/druidDataSource(),加入SQL监控

//加入监控功能

druidDataSource.setFilters(stat);4.增加src/main/java/com/zzw/springboot/controller/DruidSqlController.java,

模拟操作DB请求

jdbcTemplate;ResponseBodyGetMapping(sql)public

ListFurn

BeanPropertyRowMapper(Furn.class);ListFurn

furnList

1.修改src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java/druidDataSource(),加入WEB监控

//WebStatFilter用于采集web-jdbc关联监控的数据。

Bean

WebStatFilter();FilterRegistrationBeanWebStatFilter

new

FilterRegistrationBean(webStatFilter);filterRegistrationBean.setUrlPatterns(Arrays.asList(/*));MapString,

String

HashMap();initParameters.put(exclusions,

*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*);filterRegistrationBean.setInitParameters(initParameters);return

}2.测试

1.修改src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java/druidDataSource(),加入SQL防火墙

//加入监控功能,

druidDataSource.setFilters(stat,wall);2.测试

Druid监控功能-session监控

1.前面我们使用的是自己引入druid配置类方式整合Druid和监控。

2.Druid

2.注销src/main/java/com/zzw/springboot/config/DruidDataSourceConfig.java全部

4.在

项目中加入druid-spring-boot-starter依赖

dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-starter/artifactIdversion1.1.17/version

/dependency5.添加配置

*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*filter:

1000

#启用sql防火墙(不在白名单那就在黑名单,看你的拦截规则)drop-table-allowed:

false

#禁止删除表config:select-all-column-allow:

false

ListenerTomcat切换数据库操作HiKariDataSource

DruidDataSource),

2.目前是一些比较散的知识点同学们学习时如果想不起来一定要回顾在前面那个章节中讲过做一个简单快速的巩固从而达到融会贯通。