[contents] (the rest are knowledge)
Three Affairs (mastery)
Four stored procedures
Vi. process control
7, Index theory
1. What is a view
A view is a virtual table (non real existence). Its essence is to get a dynamic data set according to SQL statements and name it. When users use it, they only ne ...
Added by csplrj on Fri, 08 May 2020 11:46:25 +0300
The charge system in the computer room is half developed. From blind helplessness at the beginning to being able to proceed slowly now, it is a small progress. The basic data setting window in the computer room charging system is a very important window in the whole software. When I open the database software, I see that there are many pieces o ...
Added by aquilla on Wed, 06 May 2020 03:28:31 +0300
(1) The first way: use < foreach > tag to generate virtual data through UNION ALL for the list set of incoming parameters, so as to realize batch insertion (verified)
1 <insert id="insertBatchLaTContactRecord" parameterType="java.util.Map">
2 <selectKey resultType="java.lang.Long" keyProperty="dto.id" order="BE ...
Added by halex on Tue, 05 May 2020 14:32:13 +0300
jar package used
Database connection configuration
JDBC configuration file
JDBC (Java database connectivity) is a Java API used to execute SQL statements. It can provide unified access to a variety of relationa ...
Added by asdf on Sun, 03 May 2020 15:38:15 +0300
If you like, you can give a star for more people to see.
tyboot is a springboot-based service-side scaffold for the rapid development of single services. You need a micro-service solution to see another project, tycloud (still under improveme ...
Added by peterg012 on Sun, 03 May 2020 14:28:45 +0300
Queries are often used to < if > < choose > < when > < otherwise > < trim > tags, and they all support ognl expressions --|The < if > condition judgment is the same as if in Java, such as
<if test="id!=null and id!=''">
--|< choose > is just like Java's switch with break, which is used with < ...
Added by clio-stylers on Sun, 03 May 2020 09:51:47 +0300
1, Copy table structure
mysql> create table a like users; //Copy table structure
Query OK, 0 rows affected (0.50 sec)
mysql> show tables;
| Tables_in_test |
| a |
| users |
2 rows ...
Added by Dj_Lord on Sun, 03 May 2020 04:02:36 +0300
The charge system of the computer room has entered the registration window. I feel that the computer room is the same as many places of the students, but because the computer room is completed by myself, and the help from the outside is less, I have to sort out the logic by myself and design the code by myself (most of them are to fin ...
Added by Stevis2002 on Sun, 03 May 2020 03:38:23 +0300
Druid is a database connection pool implementation on Alibaba open source platform. It combines the advantages of C3P0, DBCP, PROXOOL and other DB pools, and adds log monitoring. It can monitor the connection of DB pool and the execution of SQL. It can be said that Druid is a DB connectio ...
Added by hpg4815 on Sun, 03 May 2020 00:27:55 +0300
This case almost uses all the contents of the first 50 articles to realize a simple family accounting software
Function: add, delete, modify, query by criteria
Required jar package:
Database table creation:
Added by yashvant on Sat, 02 May 2020 22:52:29 +0300