In the previous article Optimizing Mybatis in-query through interceptor Interceptor In, we have resolved the case of an empty in() list in the mybatis query.
However, because the list in the foreach tag is empty, not only is an in() empty list, but another common situation occurs when data is inserted in batches, as follows:
INSERT INTO table1( ...
Added by noirsith on Mon, 13 Jul 2020 18:31:17 +0300
*In 2017, at the request of the company, responsible for research and development of intelligent analysis platform, using OLAP technology to analyze tax data from multiple dimensions, levels and cross-business domains, discover data characteristics, summarize tax laws, and support leadership decision-making. After nearly a year, it was finally ...
Added by xxxzom_biexxx on Wed, 08 Jul 2020 17:29:29 +0300
Dynamic SQL is a powerful feature of MyBatis.When using JDBC to manipulate data, concatenating conditions into SQL strings can be painful if there are too many query conditions. The usual solution is to write a lot of if-else conditional statements and strings to concatenate, and make sure you don't forget spaces or omit commas at the end of fi ...
Added by jaikar on Tue, 07 Jul 2020 18:08:09 +0300
Recently, I watched a lot of spring boot teaching videos. I felt they were too long, and there was no actual combat of the project. Today, according to a blogger to write a simple user system to add, delete, modify and check, the source code can refer to the second issue of the article. This project use ...
Added by ecco on Sun, 28 Jun 2020 08:52:33 +0300
1, About MyBatis Generator
MyBatis Generator (MBG) is the code generator of MyBatis and iBATIS. It will generate code for all versions of MyBatis and versions of iBATIS after 2.2.0. It reviews database tables (or many tables) and generates artifacts that can be used to access tables. This reduces the initial hassle of setting up objects an ...
Added by Doyley on Fri, 19 Jun 2020 06:20:27 +0300
Spring boot + durid + mybatis + docker for mysql read-write separation-2
Data source configuration
mapper related classes
New use ...
Added by prakash on Wed, 17 Jun 2020 08:59:58 +0300
1, Cache overview
The design of Mybatis cache system follows the principle of single responsibility, opening and closing, and high decoupling. It is exquisite and fully layered, and its unique features can be applied to many similar businesses. Here is a brief analysis of the main caching system. With the help of the learning of Mybatis cache ...
Added by php_b34st on Tue, 16 Jun 2020 11:41:24 +0300
1.1 Create a new springboot project, as shown in the figure.
1.2 Select Spring Initializr.
1.3 Fill in Group, Artifact, and Name, where you choose the default, then click next, as shown in the following image.
1.4 Choose the components you want: The basic components are the web and web s ...
Added by Jax2 on Thu, 11 Jun 2020 19:19:20 +0300
Chain of responsibility pattern is a common behavior pattern. It encapsulates the processor into a processing chain, so that the request can be delivered on the chain. The processor on the chain decides whether to process the request or not.
2 responsibility chain mode
A typical usage scenario of responsibility chain mode is when an e ...
Added by Nymphetamine on Sat, 06 Jun 2020 13:17:26 +0300
Mybatis-Plus (MP) is an enhancement tool for mybatis. On the basis of mybatis, only enhancements are made without changes, which simplifies the development efficiency.This is to help us encapsulate some simple curd methods that can be called directly without rewriting these simple sql statements, just like JPA.
A new project was created t ...
Added by zenix on Thu, 28 May 2020 06:02:40 +0300