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

MYSQL Basics__ Query language DQL

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

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

JSP--JSTL (JSP Standard Tag Library)

JSP--JSTL (JSP Standard Tag Library) Blog description 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! concept 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

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

MySQL 8.0 window function practice and summary

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

Java design pattern -- command pattern of behavior pattern

Source address: Command mode of design mode catalog Basic introduction Fundamentals Application cases 1. Demand 2. UML class diagram 3. Code implementation Spring source code analysis summary Basic introduction 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

MySQL master-slave replication building (one master and two slaves)

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

mybatis plus pit - @ TableField(typeHandler) does not take effect when querying is null

catalog 1, Scene 2, Questions 3, Troubleshooting steps 4, Example 5, Questions 1, Scene 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 2, Questions The addition, deletion and ...

Posted on Tue, 23 Jun 2020 05:02:38 -0400 by tckephart

Java, JDBC core technology, transaction, thread pool

Article catalog JDBC core technology 1, Overview 1. Data persistence 2. Data storage technology in Java 3. Introduction to JDBC 4. JDBC architecture 5. JDBC programming steps 2, Get database connection 3, PrepareStatement 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