Solution with empty list in foreach tag in Mybatis

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

web front-end project integrates both JSP and FreeMaker_u_Multi-view Parser Configuration

*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

mybatis Series IV: Dynamic SQL

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

Introduction to spring boot project

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

The use of reverse engineering in Mybatis Generator

​​ 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

Spring boot + durid + mybatis + docker for mysql read-write separation-2 preface Project structure Code interpretation Data source configuration DataSourceType DBContextHolder RouteDataSource DataSourceConfig SqlSessionFactoryConfig ReadOnly ReadOnlyAop mapper related classes Business test New use ...

Added by prakash on Wed, 17 Jun 2020 08:59:58 +0300

Notes on Mybatis source code: from the perspective of cache system, the distribution mode of responsibility chain and enterprise level practice of circular dependence

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

Detailed process of springboot framework building

1. Create 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

Responsibility chain model of behavior model

1 General 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

Introduce mybatis-plus to report an Invalid bound statement error. Move your finger to change one place

error 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