Programming VIP

1.MyBatis dynamic SQL One of the powerful features of MyBatis is its dynamic SQL, that is, splicing SQL strings. If you have experience using JDBC or other similar frameworks, you can realize how painful it is to splice SQL statements according to different conditions. When splicing, make sure you don't forget the necessary spaces, and pay att ...

SQL Execution of Mybatis Core Working Principles Learn the structure, working principle and main modules of Mybatis from a macro perspective, and learn the working principle and design idea of Mybatis from a micro perspective. 1. SQL Execution Let's look at the execution of Mybatis's SQL statement. List<User> list = mapper.selectUserL ...

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( ...

*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 ...

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

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

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

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

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

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