Qt connect and use SQL Sever database
Record the whole process of connecting to SQL Server database in detail
environment
System: Windows 10 professionalQt version: Qt 5.14.2 [compilation kit MinGW 32]SQL Sever: SQL Sever 2019Programming language: C++
1, Configuring ODBC data sources
1, Add a new user in SQL Sever Manger
1. Open the MSS Management Studio provided below
...
Posted by drawmack on Tue, 08 Mar 2022 03:11:55 +0100
Spring Boot transaction control
introduction
In the process of business development and database operation, we will basically involve the operation of transactions, which can ensure the integrity of business logic. All data access technologies have transaction processing mechanisms. These technologies provide API s to start transactions, commit transactions to complete data ...
Posted by phpn00bf4life on Mon, 07 Mar 2022 20:53:14 +0100
[webmaster tool] how do I save my personal website after jsdelivr hangs up (halo)
preface
As we all know, at the end of last year, jsdelivr, a well-known free CDN service provider, had no domestic CDN acceleration due to the problem of domain name filing in the mainland. At present, it can only be parsed overseas, which is not only slow, but also occasionally unable to connect to the server. Therefore, many domestic website ...
Posted by hurricane on Mon, 07 Mar 2022 19:09:00 +0100
mysql data backup and recovery
mysql data backup
I summary
The main purpose of backup is disaster recovery. Backup can also test applications, rollback data modification, query historical data, audit, etc.
II Importance of data backup
In the production environment, the security of data is very important, and any loss of data may have serious consequences.
III Causes of ...
Posted by Eddyon on Mon, 07 Mar 2022 15:24:03 +0100
Take a small notebook and remember how kubernetes ingress nginx releases blue, green and gray
Background introduction
In some cases, we are using Kubernetes as the cloud platform for business applications. We want to realize the blue-green deployment of applications to iterate the application version. lstio is too heavy and complex, and it is positioned in flow control and grid governance; Ingress nginx introduces Canary function in ve ...
Posted by hrdyzlita on Mon, 07 Mar 2022 15:22:44 +0100
Database must know and know
1. Database and SQL
1-1 introduction to database
Our common mysql, SQL Server, DB2, Oracle Database and Postgresql all belong to relational database management system (RDBMS)
The tables stored in the database are all sheets, which can be compared to excel data sheets. They are basically the same, just like that.
1-2 introduction to SQL
The ...
Posted by Hylian on Mon, 07 Mar 2022 14:00:22 +0100
Explain the process from the perspective of source code
Full text outline
It's not easy to create. I hope I can praise, comment and collect. Students who want to study together can chat privately. We can add groups and study together!!
Process is the most basic concept in the operating system. The definition of a process in Linux kernel design is "a process is a program in execution". Pr ...
Posted by 7awaka on Mon, 07 Mar 2022 08:07:08 +0100
Database connection JDBC
1. Succinct
JDBC (Java DataBase Connectivity) is a Java API for executing SQL statements. It can provide unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language. JDBC provides a benchmark by which more advanced tools and interfaces can be built to enable database develop ...
Posted by wudiemperor on Mon, 07 Mar 2022 04:03:21 +0100
MySql database backup and restore
Backup (mysqldump)
Realize the following functions:
1. Back up the specified database
2. Delete the backup file before the specified number of days. 1 day is set by default
Script example (mysql_bak.sh)
# Database backup root directory
BACKUP_DIR="/usr/local/mysqlbackups/tsmbak/"
#Specify the host name of the host where mysql resides
DB_HOST ...
Posted by rvdb86 on Mon, 07 Mar 2022 02:42:57 +0100
Element UI simple learning + add, delete, modify and check based on springboot
Element UI simple learning + add, delete, modify and check based on springboot
Sample demonstration
Springngbooy + Vue realizes simple addition, deletion, modification and query (simple separation of front and rear ends)
How to launch our vue ui
Our element ui created here is designed
We are graphical
ui (graphical interface) ...
Posted by Guardian-Mage on Sun, 06 Mar 2022 16:09:34 +0100