[2020Python cultivation] MySQL view, trigger, transaction, stored procedure and function

[contents] (the rest are knowledge) A view Two triggers Three Affairs (mastery) Four stored procedures Five functions Vi. process control 7, Index theory   1, View 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

Computer room charging system (2)

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

Oracle+Mybatis bulk insert, update and delete

1. Insert (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

Enum, generics, reflection, JDBC integration

brief introduction Environmental preparation Project directory jar package used Database connection configuration JDBC configuration file Run tests brief introduction 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

tyboot - Rapid development of scaffolding based on Spring Boot

tyboot Source code: https://gitee.com/magintursh/tyboot https://github.com/magintursh/tyboot If you like, you can give a star for more people to see. introduce 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

Mybatis dynamic SQL query and update

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

Three methods of mysql copying table data and table structure

1, Copy table structure Method 1: 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

Registration form of computer room charging system

Preface 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

Spring boot (9): spring boot uses Druid data source

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

Java learning notes 51 (integrated project: home accounting system)

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: commons-dbcp-1.4.jar commons-pool-1.5.6.jar mysql-connector-java-5.1.37-bin.jar commons-dbutils-1.6.jar   Database table creation: /* Create database Name gjp ...

Added by yashvant on Sat, 02 May 2020 22:52:29 +0300