Record website visits

1. Create a table in the database to store the hits 2. Create a listener (MyWebListener) to implement the ServletContextListener interface. When the project is started, the hits are obtained through the dao layer (ContextMapper) and stored in the ServletContext. 3. Increase the number of visits when vi ...

Posted on Tue, 30 Jun 2020 02:50:41 -0400 by Derokorian

Necessary knowledge points of MySQL development log file

Necessary knowledge points of MySQL log file development Reference source: juejin.im/post/5b7c0aabf265da438415b9eb preface Log files record all kinds of activities that affect MySQL database. Common log files in MySQL database include error log, binary log, slow query log and query log. They are i ...

Posted on Tue, 30 Jun 2020 02:24:32 -0400 by flyersun

Design of simple database application system in Experiment 6 of SQL Server Database Principle

SQL Server experiment series Design and implementation of simple database application system in Experiment 6 The aim of the experiment was to observe the effect of the treatment on the quality of the patients (1) Understand and use common steps of database design to design conceptual model (ER model ...

Posted on Tue, 30 Jun 2020 00:50:15 -0400 by habanero25

Application of partition table in MySQL database

What is partition table First of all, let's look at the normal storage of tables The upper part is innodb engine, the lower part is myISAM engine customer_login_log.frm #The metadata of each table is saved, including the table structure and the corresponding definition, regardless of the number Acc ...

Posted on Tue, 30 Jun 2020 00:40:43 -0400 by ghostrider1

Spring security

The mind map is as follows RBAC authority analysis RBAC is the full name of role-based permission control. This section will describe RBAC from the following aspects: what is RBAC, model classification, what is permission, the use of user groups, and case analysis Mind map Draw a mind map as follows ...

Posted on Mon, 29 Jun 2020 23:20:10 -0400 by Ward

After the upgrade of Spring Boot, the initialization SQL does not run?

Spring Boot unit tests automatically execute test scripts cause Recently, we are upgrading our microservices from SpringBoot 1.5.x to 2.x. During this period, some configuration changes were made, and the configuration changes of SpringBoot itself made it impossible to run the unit test after the up ...

Posted on Mon, 29 Jun 2020 03:22:12 -0400 by Hurklefish

[RabbitMQ] takes you through the RabbitMQ Delay Queue

Text taste: shredded fish-flavored meat. Read expected: 10 minutes 1. Description In the previous article, you described what the dead letter queue in RabbitMQ is, when to use it, and how to use it.I believe that through the previous study, you already know more about the Dead Letter Queue, and the content of this article is closely related ...

Posted on Sun, 28 Jun 2020 19:57:00 -0400 by bajer

009 - generation method of distributed ID

effect Unique identification of data and information in distributed cluster system target Global uniqueness: duplicate ID number is not allowed. Since it is the only identification, this is the most basic requirement. Trend increasing: in MySQL InnoDB engine, clustered index is used. Because most ...

Posted on Sun, 28 Jun 2020 01:06:53 -0400 by plzhelpme

Encapsulating rapid JSON for database and network data transmission

background I want to complete json as the data medium to operate the database and network transmission. Looking up the data, we found that rapid json is a popular json library, and it is fast. But in my way of use, it's very cumbersome to use, and my purpose is data exchange. Rapid json is very common. It seems that it should be a value transfe ...

Posted on Sat, 27 Jun 2020 21:28:01 -0400 by rajeevbharti

java source learning - Mybatis creates statement and result set generation

Mybatis creates statement and result set generation statementHandler Result set processing Postscript Previous: Mybatis(3) executes sql procedure statementHandler In the Configuration class of Mybatis, there are the following three methods. If we want to generate a statement, we need to use a statement processor publ ...

Posted on Sat, 27 Jun 2020 05:40:32 -0400 by maxpouliot