No login for project jump

Article introduction 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 QT database access technology

  catalogue Background introduction Functional comparison Introduction to common classes of database operation in QT Usage example Data preparation Create entity class Create database access class Personal summary 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 transactions

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 a-> -100 update user set money = money-100 where name'a'; b-> +100 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

[Oracle] CentOS 7.4 installation and deployment Oracle19c Project requirements         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

Beginners learn spring transaction processing

Transaction processing in Spring question answering 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 the advanced operation of task05SQL

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

ShardingSphere actual combat: SpringBoot integrates sharding JDBC to realize sub database and sub table

preface Teach you how to use sharding JDBC to realize the database sub database and sub table. 1, Concept 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

Mybatis study notes

brief introduction 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

codis cluster deployment

Introduction to Codis codis cluster 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

Oracle flashback Technology (flashback)

Article catalog 1 Overview2 example description 2.1 flashback query2.2 flashback version query2.3 flashback transaction query2.4 flashback table2.5 flashback deletion 3 expansion 1 Overview 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