Project A jumps to project B. when project A logs in as, it also needs to enter the account of project B when logging in to project B. the user experience is not good. Therefore, the two items need to be bound. After logging in to item A, you can log in directly when jumping to item b. This project is to maintain other peo ...
Posted by kellydigital on Sun, 26 Sep 2021 01:42:56 +0200
Introduction to common classes of database operation in QT
Create entity class
Create database access class
About how to get errors in database execution and judge whether SQL statement execution is successful
About parameterized ...
Posted by madhukar_garg on Sat, 25 Sep 2021 11:00:11 +0200
mysql transaction In MySQL, transaction is actually the smallest and indivisible unit of work. Transactions can ensure the integrity of a business. Such as bank transfer
update user set money = money-100 where name'a';
updata user set money=money +100 where name='b';
In the actual program. If only one ...
Posted by newbiehacker on Sat, 25 Sep 2021 06:25:24 +0200
[Oracle] CentOS 7.4 installation and deployment Oracle19c
In the production environment, according to the business development and project requirements of the enterprise, the business database will be selected according to the importance of the business, and the data model and database design ...
Posted by delfa on Fri, 24 Sep 2021 11:06:27 +0200
Transaction processing in Spring
1. What is a transaction
speak mysql When a transaction is proposed, a transaction refers to a group sql A collection of statements with multiple entries in the collection sql sentence
It may be insert, update, select, delete or a combination. We hope these multiple sql statements can suc ...
Posted by pearllysun on Fri, 24 Sep 2021 10:17:06 +0200
In September, datawhale teamed up to learn task05 advanced SQL operations
1, Window function
1. Concept, basic usage
Window function (OLAP function)
Online AnalyticalProcessingReal time analysis and processing of database Window function allows us to selectively summarize, calculate and sort some data
Conventional SELECT statemen ...
Posted by KenGR on Thu, 23 Sep 2021 16:51:52 +0200
Teach you how to use sharding JDBC to realize the database sub database and sub table.
Sub database and sub table
Database and table splitting is a reasonable splitting of databases and tables when the amount of data is large to a certain extent. Take MySQL as an example: it is recommended that the maximum amount ...
Posted by sbroad on Thu, 23 Sep 2021 15:15:51 +0200
What is Mybatis?
MyBatis is an excellent persistence layer framework.It supports custom SQL, stored procedures, and advanced mapping.MyBatis eliminates almost all JDBC code and the work of setting parameters and obtaining result sets.MyBatis can configure and map primitive types, interfaces and Java POJO s (Plain Old Java O ...
Posted by ClyssaN on Wed, 22 Sep 2021 15:44:35 +0200
Introduction to Codis
Codis is a distributed Redis solution. For upper tier applications, there is no obvious difference between connecting to the Codis Proxy and connecting to the native Redis Server (unsupported command list). Upper tier applications can be used like stand-alone Redis. The lower tier of Codis will handle r ...
Posted by rulinus on Wed, 22 Sep 2021 15:26:29 +0200
1 Overview2 example description
2.1 flashback query2.2 flashback version query2.3 flashback transaction query2.4 flashback table2.5 flashback deletion 3 expansion
In order to recover Oracle database from misoperation quickly, Oracle has introduced flashback technology.This blog mainly shares the flashbac ...
Posted by Taneya on Wed, 22 Sep 2021 02:16:23 +0200