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
The first chapter is the basic syntax specification of SQL
1.sql is not case sensitive, but it is customary for keywords, system reserved words, function names to be uppercase, and table and column names to be lowercase
2.sql uses space or carriage return to separate each word. It is customary for ...
Posted on Mon, 29 Jun 2020 03:51:57 -0400 by weevil
Spring Boot unit tests automatically execute test scripts
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
JSP--JSTL (JSP Standard Tag Library)
The information involved in this article comes from Internet collation and personal summary, which means personal learning and experience summary. If there is any infringement, please contact me to delete, thank you!
JavaServer pages tag library JSP standard tag library
Is an open so ...
Posted on Sun, 28 Jun 2020 02:19:01 -0400 by wing_zero
Mybatis creates statement and result set generation
Result set processing
Previous: Mybatis(3) executes sql procedure
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
Posted on Sat, 27 Jun 2020 05:40:32 -0400 by maxpouliot
Before MySQL 8.0, it was quite painful to do data ranking statistics, because there was no window function like Oracle, SQL SERVER, PostgreSQL and other databases. However, with the addition of window functions in MySQL 8.0, it is no longer a problem for this kind of statistics. This paper introduces MySQL window functions with common sorting e ...
Posted on Sat, 27 Jun 2020 03:42:25 -0400 by always_confused
Source address: Command mode of design mode
2. UML class diagram
3. Code implementation
Spring source code analysis
Command Pattern: in software design, we often need to send a request to some o ...
Posted on Sat, 27 Jun 2020 02:22:40 -0400 by Kev
1, Environment introduction
The data replication between MySQL is based on binary log files. Once the binary log is enabled in MySQL database, all operations in its database will be recorded in the binary log in the form of events as Master. Other databases as Slave will keep communication with the Ma ...
Posted on Wed, 24 Jun 2020 02:45:40 -0400 by Wetzut
3, Troubleshooting steps
There are often List fields in entities that need to be mapped
mybatis plus provides annotation mode for direct injection. The portal: Portal - field type processor
The addition, deletion and ...
Posted on Tue, 23 Jun 2020 05:02:38 -0400 by tckephart
JDBC core technology
1. Data persistence
2. Data storage technology in Java
3. Introduction to JDBC
4. JDBC architecture
5. JDBC programming steps
2, Get database connection
1. Operation and access to database
2. Disadvantages of using Statement to ...
Posted on Tue, 23 Jun 2020 03:15:26 -0400 by Chris-the dude