Programmer Think

1. What is MyBatis MyBatis is an excellent persistence layer framework, which supports customized SQL, stored procedures and advanced mapping. MyBatis avoids almost all JDBC code and manually setting parameters and getting result sets. MyBatis can use simple XML or annotations to configure and map native information, and map interfaces and ...

In the project development, with the continuous development of business, the data increases day by day. At this time, the database and table splitting operation of the data table will appear. Once the database and table are divided. The traditional ID loses its meaning. Therefore, a distributed global ID is required. Characteristics of distrib ...

catalogue 1. Overview of stored procedures and functions 2. Create stored procedure 3. Call stored procedure 4. View stored procedures 5. Delete stored procedure 6. Grammar 6.1 variables 6.2 if condition judgment 6.3 transfer parameters 6.4 case structure 6.5 while loop 6.6 repeat structure 6.7 loop statement 6.8 leave state ...

preface: Previous article We have introduced the usage of some common data types, such as int, char, varchar, etc. Blob and text types have not been introduced in detail. Although these two types of data types are not commonly used, they are still used in some scenarios. This article will mainly introduce the related knowledge of blob and text ...

Getting started with JDBC Take notes according to the pictures and texts of the course for your review when necessary 1.JDBC concept Java DataBase Connectivity: Java database connection, Java language operation databaseJDBC essence: actually, it is a set of rules defined by the official (sun company) to operate all relational databases, ...

SQL Injection(blind) 1. Low Manual injection method The server will only return and not display the search value. This kind of SQL injection without echo is called SQL blind injection. This question will only return whether the user exists or not, that is, true or false. This kind of blind note becomes Boolean blind note. The injection ...

Personal home page: 💖 A Niu💖 Note: Most of the key knowledge in this article is in the code comments, you must look carefully! I suggest you follow me! Wishing you all full harvest! Here's the point! Here's the point!!💗💗💗 Pull out your computer and start typing, buddies! (To be in full spirits~) 1. ...

summary Project address: github.com/snower/slock What is a state and atomic operations database? Unlike redis, which is mainly used to save data and can efficiently synchronize data between multiple nodes and systems, slock is designed to only save synchronization status and can hardly carry data. The high-performance asynchronous binary proto ...

Dead Lock refers to two or more computing units (processes, threads or coroutines) that are waiting for the other party to stop execution to obtain system resources, but none of them exits in advance. The deadlock example code is as follows: public class DeadLockExample { public static void main(String[] args) { Object lockA = ne ...

catalogue 1, Read write separation configuration 2, Verify read / write separation 1. Write verification 2. Read verification 3, Force read Master Library 4, References 1, Read write separation configuration Note that the configuration is database / Table + read / write separation. ShardingSphere version 3 x,4.0. 1,4.1. 1,5.0. There ar ...