Shulou(Shulou.com)06/03 Report--

Today, I will talk to you about the custom configuration of SpringBoot and the integration of Druid, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

SpringBoot profile priority

As mentioned earlier in the SpringBoot foundation, the SpringBoot configuration file can be in properties or yaml format, but there is a priority when SpringBoot loads the application configuration file. The priorities are as follows:

File:./config/ = > file:./ under the config directory under the project path = > classpath:/config/ under the project path > classpath:/ under the config directory under the resource path classpath:/ = = > the multi-document configuration of yaml under the project path

Yaml can write multiple sets of configuration files in one file through

Server: port: 8081spring: profiles: dev-server: port: 8082spring: profiles: test

@ canditionalon annotation, the underlying annotation of Spring, is used to determine whether the condition is met, and then it will be automatically assembled if the condition is met.

Extend SpringMVC to add a custom view parser

ViewResolver attempts a parser, and any class that implements this interface can be called an attempt parser

CandidateViews candidate view, getBestView gets the optimal view

There is the getCandidateViews method, which traverses all the view parsers, then wraps them into view objects and adds them to the array of candidateViews candidate view parsers.

The custom view parser needs to implement the ViewResolver interface and override the resolveViewName method

@ Configurationpublic class MyMvcConfig implements WebMvcConfigurer {@ Bean public ViewResolver myViewResolver () {return new MyViewResolver ();} public static class MyViewResolver implements ViewResolver {@ Override public View resolveViewName (String viewNaem, Locale locale) throws Exception {return null;}}

If you want to customize other functions, just write the components according to the format and give them to SpringBoot for automatic assembly.

Custom DruidDataSourcesAbout Druid

Druid: https://github.com/alibaba/druid/

Druid is a database connection pool implementation on alibaba open source platform, which combines the advantages of DB pool such as C3P0DBCP, and also has Web monitoring interface.

Druid can well monitor DB pooled connections and SQL execution, as well as DB connection pooling for monitoring.

Hikari data source is used by default above SpringBoot2.0. Here is how to configure Druid with SpringBoot integration.

Add dependent com.alibaba druid 1.1.21 configuration data source

Because the Hikari data source is used by default above SpringBoot2.0, you need to specify the data source with spring.datasource.type.

Spring: datasource: username: root password: 123456 url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8 driver-class-name: com.mysql.cj.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource # Custom data Source

You can set up a test class to view

@ Testpublic void druidTest () throws SQLException {/ / View the default data source System.out.println (dataSource.getClass ()); / / get the database connection Connection connection = dataSource.getConnection (); System.out.println (connection); / / close connection.close ();}

Other configuration

For other configurations, please refer to the official documentation and briefly list some:

# Spring Boot does not inject these attribute values by default. You need to bind your own # druid data source proprietary configuration initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true# configure filters,stat: monitoring statistics, log4j: logging, wall: defense sql injection # if Times error java.lang.ClassNotFoundException: org.apache.log4j.Priority# is allowed, you can import log4j dependency Maven address: https://mvnrepository.com/artifact/log4j/log4jfilters: stat,wall,log4jmaxPoolPreparedStatementPerConnectionSize: 20useGlobalDataSourceStat: trueconnectionProperties: druid.stat.mergeSql=true Druid.stat.slowSqlMillis=500

The configuration of monitoring is a characteristic of Druid. Such as configurable log4j and built-in wall to prevent sql injection

Druid configuration class

Generally, under the config package, similar to custom components, it is bound to the configuration of datasource in the configuration file through the @ ConfigurationProperties annotation and handed over to SpringBoot for automatic assembly.

@ Configurationpublic class DruidConfig {/ * add a custom Druid data source to the container No longer let Spring Boot automatically create druid data source attributes in the binding global configuration file to com.alibaba.druid.pool.DruidDataSource to make them effective @ ConfigurationProperties (prefix = "spring.datasource"): the function is to inject the attribute value prefixed with spring.datasource in the global configuration file into the parameter of the same name in com.alibaba.druid.pool.DruidDataSource * / @ ConfigurationProperties (prefix = " Spring.datasource ") @ Bean public DataSource druidDataSource () {return new DruidDataSource () }} Test class @ Testpublic void druidTest () throws SQLException {/ / View the default data source System.out.println (dataSource.getClass ()); / / get the database connection Connection connection = dataSource.getConnection (); System.out.println (connection); / / close connection.close (); DruidDataSource druidDataSource = (DruidDataSource) dataSource; System.out.println ("maximum number of druidDataSource data source connections:" + druidDataSource.getMaxActive ()) System.out.println ("number of druidDataSource data source initialization connections:" + druidDataSource.getInitialSize ());}

Data source monitoring

Still written in the same configuration class file, the focus here for audit or penetration testing is actually the user name password and its access restrictions.

Package com.zh2z3ven.hellospringboot.config;import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.support.http.StatViewServlet;import org.springframework.boot.context.properties.ConfigurationProperties;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 @ Configurationpublic class DruidConfig {/ * add a custom Druid data source to the container No longer let Spring Boot automatically create druid data source attributes in the binding global configuration file to com.alibaba.druid.pool.DruidDataSource to make them effective @ ConfigurationProperties (prefix = "spring.datasource"): the function is to inject the attribute value prefixed with spring.datasource in the global configuration file into the parameter of the same name in com.alibaba.druid.pool.DruidDataSource * / @ ConfigurationProperties (prefix = " Spring.datasource ") @ Bean public DataSource druidDataSource () {return new DruidDataSource () } / / configure Servlet at the backend of Druid monitoring and management / / there is no web.xml file in the built-in Servlet container, so use Spring Boot's registration Servlet method @ Bean public ServletRegistrationBean statViewServlet () {ServletRegistrationBean bean = new ServletRegistrationBean (new StatViewServlet (), "/ druid/*"); / / these parameters can be found in the parent class com.alibaba.druid.support.http.ResourceServlet of com.alibaba.druid.support.http.StatViewServlet / / Map initParams = new HashMap () InitParams.put ("loginUsername", "admin"); / / the login account initParams.put of the backend management interface ("loginPassword", "123456") / / login password of the backend management interface / / who is allowed to access / / initParams.put ("allow", "localhost"): indicates that only the local machine can access / / initParams.put ("allow", ""): if it is empty or null, all access to initParams.put ("allow", "") is allowed. / / who is denied access to / / initParams.put by the deny:Druid backend ("kuangshen", "192.168.1.20"); disable this ip access / / set initialization parameter bean.setInitParameters (initParams); return bean;}}

Restart the project after configuration and access the test

Monitoring filter filter configuration / / configure filter//WebStatFilter for web monitoring of Druid monitoring: used to configure management association monitoring statistics between Web and Druid data sources @ Beanpublic FilterRegistrationBean webStatFilter () {FilterRegistrationBean bean = new FilterRegistrationBean (); bean.setFilter (new WebStatFilter ()); / / exclusions: set which requests are filtered and excluded, so that statistics are not carried out Map initParams = new HashMap () InitParams.put ("exclusions", "* .js,*.css,/druid/*,/jdbc/*"); bean.setInitParameters (initParams); / / "/ *" means to filter all request bean.setUrlPatterns (Arrays.asList ("/ *")); return bean;} after reading the above, do you have any further understanding of SpringBoot custom configuration and integration of Druid? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.