SpringBoot——SpringData中druid监听器的使用(课时十九)

作者：mobiledu2502889521 | 来源：互联网 | 2023-06-22 13:39

Druid数据库Java程序很大一部分要操作数据库，为了提高性能操作数据库的时候，又不得不使用数据库连接池。Druid是阿里巴巴开源平台上一个数据库连接

Druid数据库

Java程序很大一部分要操作数据库，为了提高性能操作数据库的时候，又不得不使用数据库连接池。

Druid 是阿里巴巴开源平台上一个数据库连接池实现，结合了 C3P0、DBCP 等 DB 池的优点，同时加入了日志监控。

Druid 可以很好的监控 DB 池连接和 SQL 的执行情况，天生就是针对监控而生的 DB 连接池。

Druid已经在阿里巴巴部署了超过600个应用，经过一年多生产环境大规模部署的严苛考验。

Spring Boot 2.0 以上默认使用 Hikari 数据源，可以说 Hikari 与 Driud 都是当前 Java Web 上最优秀的数据源，我们来重点介绍 Spring Boot 如何集成 Druid 数据源，如何实现数据库监控。

Github地址：https://github.com/alibaba/druid/

spring:datasource:username: rootpassword: 123456url: jdbc:mysql://localhost:3306/mybatis?serverTimezOne=UTC&useUnicode=true&characterEncoding=utf-8driver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSourceinitial-size: 5min-idle: 5max-active: 20# 配置获取连接等待超时的时间max-wait: 60000# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒time-between-eviction-runs-millis: 60000# 配置一个连接在池中最小生存的时间，单位是毫秒min-evictable-idle-time-millis: 300000validation-query: SELECT 1 FROM DUALtest-while-idle: truetest-on-borrow: falsetest-on-return: false# 打开PSCache，并且指定每个连接上PSCache的大小pool-prepared-statements: true# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，&＃39;wall&＃39;用于防火墙最好的功能max-pool-prepared-statement-per-connection-size: 20filters: stat,walluse-global-data-source-stat: true# 通过connectProperties属性来打开mergeSql功能；慢SQL记录connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

type: com.alibaba.druid.pool.DruidDataSource

package com.alibaba.druid.pool;/*** @author ljw [ljw2083@alibaba-inc.com]* @author wenshao [szujobs@hotmail.com]*/ public class DruidDataSource extends DruidAbstractDataSource implements DruidDataSourceMBean, ManagedDataSource, Referenceable, Closeable, Cloneable, ConnectionPoolDataSource, MBeanRegistration {private final static Log LOG = LogFactory.getLog(DruidDataSource.class);private static final long serialVersiOnUID= 1L;// statsprivate volatile long recycleErrorCount = 0L;private long cOnnectCount= 0L;private long closeCount = 0L;private volatile long cOnnectErrorCount= 0L;private long recycleCount = 0L;private long removeAbandOnedCount= 0L;private long notEmptyWaitCount = 0L;private long notEmptySignalCount = 0L;private long notEmptyWaitNanos = 0L;private int keepAliveCheckCount = 0;private int activePeak = 0;private long activePeakTime = 0;private int poolingPeak = 0;private long poolingPeakTime = 0;// storeprivate volatile DruidConnectionHolder[] connections;private int poolingCount = 0;private int activeCount = 0;private volatile long discardCount = 0;private int notEmptyWaitThreadCount = 0;private int notEmptyWaitThreadPeak = 0;//private DruidConnectionHolder[] evictConnections;private DruidConnectionHolder[] keepAliveConnections;// threadsprivate volatile ScheduledFuture destroySchedulerFuture;private DestroyTask destroyTask;private volatile Future createSchedulerFuture;private CreateConnectionThread createConnectionThread;private DestroyConnectionThread destroyConnectionThread;private LogStatsThread logStatsThread;private int createTaskCount;private volatile long createTaskIdSeed = 1L;private long[] createTasks;private final CountDownLatch initedLatch = new CountDownLatch(2);private volatile boolean enable = true;private boolean resetStatEnable = true;private volatile long resetCount = 0L;private String initStackTrace;private volatile boolean closing = false;private volatile boolean closed = false;private long closeTimeMillis = -1L;protected JdbcDataSourceStat dataSourceStat;private boolean useGlobalDataSourceStat = false;private boolean mbeanRegistered = false;public static ThreadLocal waitNanosLocal = new ThreadLocal();private boolean logDifferentThread = true;private volatile boolean keepAlive = false;private boolean asyncInit = false;protected boolean killWhenSocketReadTimeout = false;protected boolean checkExecuteTime = false;private static List autoFilters = null;private boolean loadSpifilterSkip = false;private volatile DataSourceDisableException disableException = null;

# 下面为连接池的补充设置，应用到上面所有数据源中

     # 初始化大小，最小，最大
      initial-size: 5
      min-idle: 5
      max-active: 20
      # 配置获取连接等待超时的时间
      max-wait: 60000
      # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
      time-between-eviction-runs-millis: 60000
      # 配置一个连接在池中最小生存的时间，单位是毫秒
      min-evictable-idle-time-millis: 300000
      validation-query: SELECT 1 FROM DUAL
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      # 打开PSCache，并且指定每个连接上PSCache的大小
      pool-prepared-statements: true
      #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，&＃39;wall&＃39;用于防火墙最好的功能
      max-pool-prepared-statement-per-connection-size: 20
      filters: stat,wall
      use-global-data-source-stat: true
      # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
      connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

package com.springdate.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(prefix = "spring.datasource")@Beanpublic DataSource dataSource() {return new DruidDataSource();}//配置 Druid 监控管理后台的Servlet；//因为SpringBoot内置 Servlet 容器时没有web.xml文件，所以使用 Spring Boot 的注册 Servlet 方式@Beanpublic ServletRegistrationBean statViewServlet() {ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");// 这些参数可以在 com.alibaba.druid.support.http.StatViewServlet// druid数据库 http://localhost:8080/druid/login.html// 的父类 com.alibaba.druid.support.http.ResourceServlet 中找到Map initParams = new HashMap<>();initParams.put("loginUsername", "admin");//后台管理界面的登录账号initParams.put("loginPassword", "123456");//后台管理界面的登录密码 }

//后台允许谁可以访问//initParams.put("allow", "localhost")：表示只有本机可以访问//initParams.put("allow", "")：为空或者为null时，表示允许所有访问initParams.put("allow", "");//deny：Druid 后台拒绝谁访问//initParams.put("kuangshen", "192.168.1.20");表示禁止此ip访问//设置初始化参数bean.setInitParameters(initParams);return bean; }

//过滤的功能@Beanpublic FilterRegistrationBean WebStatFilter() {FilterRegistrationBean bean = new FilterRegistrationBean();//设置过滤器bean.setFilter(new WebStatFilter());//可以有啥请求呀HashMap initparamenters = new HashMap<>();//这些内容不进行统计initparamenters.put("exclusions", "*.js,*.css,/druid/*");return bean;}

package com.springdate.Controller; //测试 /*** 整合jdbcTemplate*/import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RestController;import java.util.List; import java.util.Map;@RestController public class jdbc {@AutowiredJdbcTemplate jdbcTemplate;//查询书籍看所有信息@GetMapping("/userlist")public List> userList(){String sql = "SELECT * FROM account";List> lists_maps = jdbcTemplate.queryForList(sql);return lists_maps;}

官网地址:http://localhost:8080/druid/login.html

// 的父类 com.alibaba.druid.support.http.ResourceServlet 中找到Map initParams = new HashMap<>();initParams.put("loginUsername", "admin");//后台管理界面的登录账号initParams.put("loginPassword", "123456");//后台管理界面的登录密码

启动程序

package com.springdate;import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication public class SpringbootSpringdate04Application {public static void main(String[] args) {SpringApplication.run(SpringbootSpringdate04Application.class, args);}}

"C:\Program Files\Java\jdk1.8.0_171\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\IDEA\com.text\IntelliJ IDEA 2020.1.2\lib\idea_rt.jar=52650:D:\IDEA\com.text\IntelliJ IDEA 2020.1.2\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_171\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_171\jre\lib\rt.jar;D:\maven-workspace\spaceVideospringboot\springboot-springdate04\target\classes;C:\Users\MZFAITHDREAM\.m2\repository\com\jpattern\jporm-jdbctemplate\5.3.0\jporm-jdbctemplate-5.3.0.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\jpattern\jporm\5.3.0\jporm-5.3.0.jar;C:\Users\MZFAITHDREAM\.m2\repository\log4j\log4j\1.2.14\log4j-1.2.14.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\alibaba\druid-spring-boot-starter\1.2.9\druid-spring-boot-starter-1.2.9.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\alibaba\druid\1.2.9\druid-1.2.9.jar;C:\Users\MZFAITHDREAM\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.7.4\spring-boot-autoconfigure-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot\2.7.4\spring-boot-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.7.4\spring-boot-starter-web-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter\2.7.4\spring-boot-starter-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.7.4\spring-boot-starter-logging-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\ch\qos\logback\logback-classic\1.2.11\logback-classic-1.2.11.jar;C:\Users\MZFAITHDREAM\.m2\repository\ch\qos\logback\logback-core\1.2.11\logback-core-1.2.11.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar;C:\Users\MZFAITHDREAM\.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.7.4\spring-boot-starter-json-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.13.4\jackson-databind-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.4\jackson-annotations-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.13.4\jackson-core-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.4\jackson-datatype-jdk8-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.4\jackson-datatype-jsr310-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.4\jackson-module-parameter-names-2.13.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.7.4\spring-boot-starter-tomcat-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.65\tomcat-embed-core-9.0.65.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.65\tomcat-embed-el-9.0.65.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.65\tomcat-embed-websocket-9.0.65.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-web\5.3.23\spring-web-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-beans\5.3.23\spring-beans-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-webmvc\5.3.23\spring-webmvc-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-aop\5.3.23\spring-aop-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-context\5.3.23\spring-context-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-expression\5.3.23\spring-expression-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.7.4\spring-boot-starter-jdbc-2.7.4.jar;C:\Users\MZFAITHDREAM\.m2\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-jdbc\5.3.23\spring-jdbc-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-tx\5.3.23\spring-tx-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\mysql\mysql-connector-java\8.0.30\mysql-connector-java-8.0.30.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-core\5.3.23\spring-core-5.3.23.jar;C:\Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-jcl\5.3.23\spring-jcl-5.3.23.jar" com.springdate.SpringbootSpringdate04Application. ____ _ __ _ _/\\ / ___&＃39;_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | &＃39;_ | &＃39;_| | &＃39;_ \/ _` | \ \ \ \\\/ ___)| |_)| | | | | || (_| | ) ) ) )&＃39; |____| .__|_| |_|_| |_\__, | / / / /=========|_|==============|___/=/_/_/_/:: Spring Boot :: (v2.7.4)2022-10-03 10:21:26.173 INFO 21568 --- [ main] c.s.SpringbootSpringdate04Application : Starting SpringbootSpringdate04Application using Java 1.8.0_171 on HELLOWWORLD with PID 21568 (D:\maven-workspace\spaceVideospringboot\springboot-springdate04\target\classes started by MZFAITHDREAM in D:\maven-workspace\spaceVideospringboot\springboot-springdate04) 2022-10-03 10:21:26.177 INFO 21568 --- [ main] c.s.SpringbootSpringdate04Application : No active profile set, falling back to 1 default profile: "default" 2022-10-03 10:21:27.310 INFO 21568 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2022-10-03 10:21:27.310 INFO 21568 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2022-10-03 10:21:27.310 INFO 21568 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.65] 2022-10-03 10:21:27.610 INFO 21568 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2022-10-03 10:21:27.610 INFO 21568 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1383 ms 2022-10-03 10:21:28.031 INFO 21568 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path &＃39;&＃39; 2022-10-03 10:21:28.047 INFO 21568 --- [ main] c.s.SpringbootSpringdate04Application : Started SpringbootSpringdate04Application in 2.418 seconds (JVM running for 3.73) 2022-10-03 10:21:44.286 INFO 21568 --- [nio-8080-exec-9] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet &＃39;dispatcherServlet&＃39; 2022-10-03 10:21:44.286 INFO 21568 --- [nio-8080-exec-9] o.s.web.servlet.DispatcherServlet : Initializing Servlet &＃39;dispatcherServlet&＃39; 2022-10-03 10:21:44.289 INFO 21568 --- [nio-8080-exec-9] o.s.web.servlet.DispatcherServlet : Completed initialization in 3 ms

监听器的记录在上面图片的

C \Program Files\Java\jdk1.8.0_171\jre\lib\charsets.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\deploy.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\access-bridge-64.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\cldrdata.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\dnsns.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\jaccess.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\jfxrt.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\localedata.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\nashorn.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunec.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunjce_provider.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunmscapi.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\sunpkcs11.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\ext\zipfs.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\javaws.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\jce.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\jfr.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\jfxswt.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\jsse.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\management-agent.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\plugin.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\resources.jar C \Program Files\Java\jdk1.8.0_171\jre\lib\rt.jar D \maven-workspace\spaceVideospringboot\springboot-springdate04\target\classes C \Users\MZFAITHDREAM\.m2\repository\com\jpattern\jporm-jdbctemplate\5.3.0\jporm-jdbctemplate-5.3.0.jar C \Users\MZFAITHDREAM\.m2\repository\com\jpattern\jporm\5.3.0\jporm-5.3.0.jar C \Users\MZFAITHDREAM\.m2\repository\log4j\log4j\1.2.14\log4j-1.2.14.jar C \Users\MZFAITHDREAM\.m2\repository\com\alibaba\druid-spring-boot-starter\1.2.9\druid-spring-boot-starter-1.2.9.jar C \Users\MZFAITHDREAM\.m2\repository\com\alibaba\druid\1.2.9\druid-1.2.9.jar C \Users\MZFAITHDREAM\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar C \Users\MZFAITHDREAM\.m2\repository\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.7.4\spring-boot-autoconfigure-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot\2.7.4\spring-boot-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.7.4\spring-boot-starter-web-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter\2.7.4\spring-boot-starter-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.7.4\spring-boot-starter-logging-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\ch\qos\logback\logback-classic\1.2.11\logback-classic-1.2.11.jar C \Users\MZFAITHDREAM\.m2\repository\ch\qos\logback\logback-core\1.2.11\logback-core-1.2.11.jar C \Users\MZFAITHDREAM\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar C \Users\MZFAITHDREAM\.m2\repository\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar C \Users\MZFAITHDREAM\.m2\repository\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar C \Users\MZFAITHDREAM\.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar C \Users\MZFAITHDREAM\.m2\repository\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.7.4\spring-boot-starter-json-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.13.4\jackson-databind-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.4\jackson-annotations-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.13.4\jackson-core-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.4\jackson-datatype-jdk8-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.4\jackson-datatype-jsr310-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.4\jackson-module-parameter-names-2.13.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.7.4\spring-boot-starter-tomcat-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.65\tomcat-embed-core-9.0.65.jar C \Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.65\tomcat-embed-el-9.0.65.jar C \Users\MZFAITHDREAM\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.65\tomcat-embed-websocket-9.0.65.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-web\5.3.23\spring-web-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-beans\5.3.23\spring-beans-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-webmvc\5.3.23\spring-webmvc-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-aop\5.3.23\spring-aop-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-context\5.3.23\spring-context-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-expression\5.3.23\spring-expression-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.7.4\spring-boot-starter-jdbc-2.7.4.jar C \Users\MZFAITHDREAM\.m2\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-jdbc\5.3.23\spring-jdbc-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-tx\5.3.23\spring-tx-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\mysql\mysql-connector-java\8.0.30\mysql-connector-java-8.0.30.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-core\5.3.23\spring-core-5.3.23.jar C \Users\MZFAITHDREAM\.m2\repository\org\springframework\spring-jcl\5.3.23\spring-jcl-5.3.23.jar D \IDEA\com.text\IntelliJ IDEA 2020.1.2\lib\idea_rt.jar

推荐阅读

request
postman测试登录后的接口_使用postman进行接口测试的方法(测试用户管理模块)

本文介绍了使用postman进行接口测试的方法，以测试用户管理模块为例。首先需要下载并安装postman，然后创建基本的请求并填写用户名密码进行登录测试。接下来可以进行用户查询和新增的测试。在新增时，可以进行异常测试，包括用户名超长和输入特殊字符的情况。通过测试发现后台没有对参数长度和特殊字符进行检查和过滤。 ... [详细]

蜡笔小新 2023-12-14 10:29:45
io
如何限制php数据库链接数和连接超时时间？

本文介绍了如何使用php限制数据库插入的条数并显示每次插入数据库之间的数据数目，以及避免重复提交的方法。同时还介绍了如何限制某一个数据库用户的并发连接数，以及设置数据库的连接数和连接超时时间的方法。最后提供了一些关于浏览器在线用户数和数据库连接数量比例的参考值。 ... [详细]

蜡笔小新 2023-12-14 14:06:10
io
javascript – 概述在Firefox上无法正常工作

我试图提出一些自定义大纲,以达到一些Web可访问性建议.但我不能用Firefox制作.这就是它在Chrome上的外观：而那个图标实际上是一个锚点.在Firefox上,它只概述了整个 ... [详细]

蜡笔小新 2023-12-14 10:20:38
int
Java String与StringBuffer的区别及其应用场景

本文主要介绍了Java中String和StringBuffer的区别，String是不可变的，而StringBuffer是可变的。StringBuffer在进行字符串处理时不生成新的对象，内存使用上要优于String类。因此，在需要频繁对字符串进行修改的情况下，使用StringBuffer更加适合。同时，文章还介绍了String和StringBuffer的应用场景。 ... [详细]

蜡笔小新 2023-12-13 19:21:06
io
FileNotFoundException: File does not exist

ubuntu用sqoop将数据从hive导入mysql时，命令： ... [详细]

蜡笔小新 2023-12-12 18:56:13
io
Skywalking系列博客1安装单机版 Skywalking的快速安装方法

本文介绍了如何快速安装单机版的Skywalking，包括下载、环境需求和端口检查等步骤。同时提供了百度盘下载地址和查询端口是否被占用的命令。 ... [详细]

蜡笔小新 2023-12-14 19:05:47
int
Android 新闻App的本地服务器搭建教程

本文介绍了在开发Android新闻App时，搭建本地服务器的步骤。通过使用XAMPP软件，可以一键式搭建起开发环境，包括Apache、MySQL、PHP、PERL。在本地服务器上新建数据库和表，并设置相应的属性。最后，给出了创建new表的SQL语句。这个教程适合初学者参考。 ... [详细]

蜡笔小新 2023-12-14 17:15:19
io
如何在MySQL中将零值替换为先前的非零值？

本文介绍了如何在MySQL中将零值替换为先前的非零值的方法，包括使用内联查询和更新查询。同时还提供了选择正确值的方法。 ... [详细]

蜡笔小新 2023-12-14 16:59:24
const
Hibernate基础映射

在说Hibernate映射前，我们先来了解下对象关系映射ORM。ORM的实现思想就是将关系数据库中表的数据映射成对象，以对象的形式展现。这样开发人员就可以把对数据库的操作转化为对 ... [详细]

蜡笔小新 2023-12-14 10:57:47
io
MysqlDump_mysqldump全库备份相关知识详解

本文详细介绍了MysqlDump和mysqldump进行全库备份的相关知识，包括备份命令的使用方法、my.cnf配置文件的设置、binlog日志的位置指定、增量恢复的方式以及适用于innodb引擎和myisam引擎的备份方法。对于需要进行数据库备份的用户来说，本文提供了一些有价值的参考内容。 ... [详细]

蜡笔小新 2023-12-14 10:03:27
php
PHP中的MySQL函数库及其常用函数介绍

本文由编程笔记小编整理，介绍了PHP中的MySQL函数库及其常用函数，包括mysql_connect、mysql_error、mysql_select_db、mysql_query、mysql_affected_row、mysql_close等。希望对读者有一定的参考价值。 ... [详细]

蜡笔小新 2023-12-14 08:19:53
int
ASP.NET Tips: 获取插入记录的ID的方法详解

本文详细介绍了在ASP.NET中获取插入记录的ID的几种方法，包括使用SCOPE_IDENTITY()和IDENT_CURRENT()函数，以及通过ExecuteReader方法执行SQL语句获取ID的步骤。同时，还提供了使用这些方法的示例代码和注意事项。对于需要获取表中最后一个插入操作所产生的ID或马上使用刚插入的新记录ID的开发者来说，本文提供了一些有用的技巧和建议。 ... [详细]

蜡笔小新 2023-12-13 17:03:18
int
VB.NET在线急等问题解决方法，如何统计数据库字段下的数据并显示在文本框里？

本文介绍了一个在线急等问题解决方法，即如何统计数据库中某个字段下的所有数据，并将结果显示在文本框里。作者提到了自己是一个菜鸟，希望能够得到帮助。作者使用的是ACCESS数据库，并且给出了一个例子，希望得到的结果是560。作者还提到自己已经尝试了使用"select sum(字段2) from 表名"的语句，得到的结果是650，但不知道如何得到560。希望能够得到解决方案。 ... [详细]

蜡笔小新 2023-12-13 15:15:30
int
如何查看mysql的安装路径

本文介绍了通过mysql命令查看mysql的安装路径的方法，提供了相应的sql语句，并希望对读者有参考价值。 ... [详细]

蜡笔小新 2023-12-13 13:23:09
int
Android 7自学笔记总结、移动架构视频、安卓面试真题、项目实战源码讲义

本文介绍了Android 7的学习笔记总结，包括最新的移动架构视频、大厂安卓面试真题和项目实战源码讲义。同时还分享了开源的完整内容，并提醒读者在使用FileProvider适配时要注意不同模块的AndroidManfiest.xml中配置的xml文件名必须不同，否则会出现问题。 ... [详细]

蜡笔小新 2023-12-13 10:06:58

mobiledu2502889521

这个家伙很懒，什么也没留下！

Tags | 热门标签

RankList | 热门文章