JDBC (connection, basic addition, deletion, modification and query, PrepareStatement and Statement)

Interface oriented programming Programming steps Get connection Before that, to obtain the mysql driver, you need to put the corresponding jar package under the project: Mode 1 import org.junit.Test; import java.sql.Connection; import java.sql.Driver; import java.sql.SQLException; import java.util.Properties; public class Connectio ...

Posted by toysrfive on Fri, 13 May 2022 08:40:54 +0300

Analysis of MySQL lock in MySQL database

preface In his work, the author encountered inserting a piece of data into the MySQL table, but he couldn't insert it. And the same operation can be inserted in Oracle, so I specially studied MySQL 5 7 lock logic. Introduction of lock Before introducing locks, you need to understand the transaction isolation level: https://www.cnblogs.com/jssj/ ...

Posted by ephmynus on Fri, 13 May 2022 07:43:21 +0300

Spring Boot uses mybatis with TK Mybatis for database operation

Use mybatis with TK Mybatis for database operation This is a spring cloud project. mybatis uses TK Myabtis general mapper summary blog Use TK Mybatis is very simple, but there are some pits. Now let's talk about introducing mybatis, which is also very simple 1. First, introduce the dependency of mybatis, jdbc and mysql connecteor into the Co ...

Posted by podja on Fri, 13 May 2022 06:30:58 +0300

Create a mybaits from scratch

catalogue 1: Create project maven 2: Import mybaits dependent package 3: Configure 4: Write mybaits tool class mybaits tool class 5: Interface between code entity class and mapper/dao layer 6: Test 7: Attention items SqlsessionFactoryBuilder class SqlSessionFactory interface SqlSession interface 1: Create maven project ...

Posted by 2705ap on Thu, 12 May 2022 21:06:11 +0300

Based on Spring+SpringMVC+Mybatis distributed agile development system architecture source code sharing

Based on Spring+SpringMVC+Mybatis distributed agile development system architecture, it provides a complete set of public microservice service modules: centralized authority management (single sign-on), content management, payment center, user management (support third-party login), WeChat platform, storage system , configuration center, log an ...

Posted by njm on Thu, 12 May 2022 14:30:35 +0300

Mysql backup and recovery and xtrabackup backup

[transfer] Mysql backup recovery and xtrabackup backup 🎉 New Year greetings 🎉 2017 is about to pass, and the bell of the new year is about to ring. At this beautiful moment of farewell to the old and ushering in the new year, I would like to extend new year's greetings to the people of all ethnic groups across the country, compatriots in the ...

Posted by titeroy on Thu, 12 May 2022 11:10:13 +0300

MySQL backup and recovery

preface In enterprises, the value of data is very important, and data ensures the normal operation of enterprise business. Therefore, data security and data Reliability is the top priority of operation and maintenance. Any loss of data may have serious consequences for the enterprise. 1: Classification of database backup 1.1: what are t ...

Posted by corsc on Thu, 12 May 2022 07:41:45 +0300

Master slave replication of a database that has been running for a period of time

Master slave replication of a database that has been running for a period of time Preface: a few days ago, the master-slave replication of MySQL database that has been running for a period of time and has not opened bin log was made. Hereby, the detailed operation steps and instructions are recorded. Note that this synchronization does not use ...

Posted by virtuexru on Wed, 11 May 2022 23:14:11 +0300

Development oriented memory debugging artifact, how to use ASAN to detect memory leakage, stack overflow and other problems

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...

Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300

MySQL common statements

MySQL common instructions Modify table structure service mysql start #Start the MySQL service. mysql55 is the server name specified when installing the MySQL server net start mysql55 #Stop mysql service net stop mysql55 Create database #Create database Set character set Set collation create database Database name character set gb2 ...

Posted by a94060 on Wed, 11 May 2022 00:09:32 +0300