Programmer Think

II Construction of MyBatis environment Build basic environment First, create a maven project on idea After you name it, it looks like this Go to the following website to get the required jar package mvnrepository.com After entering, the page is as follows Find the jar package you need here For single table query, the following jar ...

1, Original JDBC 1.1 query data 1.2 insert data 1.3 operation analysis The problems existing in the original JDBC development are as follows: The frequent creation and release of database connections cause a waste of system resources, which affects the system performanceSQL statements are hard coded in the code, which makes the cod ...

1. History of database operation framework 1,JDBC JDBC (Java database connection) is a Java API used to execute database SQL statements. It can provide unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language. JDBC provides a benchmark, which can build more advanc ...

📑 Content of this article: SpringBoot integration popular framework (Part I)~ 📘 Article column: Principle and project development of SpringBoot microservice 🎬 Last updated: January 26, 2022 SSM framework integrates Druid from simple to deep to SpringBoot taking over Druid configuration ~ learn the ideas and ideas of SpringBoot taking over ...

1, Review the contents of L2 cache The L2 cache is built on the L1 cache. When receiving the query request, MyBatis will query the L2 cache first. If the L2 cache is not alive In, query the level-1 cache again. If there is no level-1 cache, query the database again. L2 cache - > L1 cache - > database. Unlike the L1 Cache, the L2 Cach ...

survey In the recent report writing function, when the data is inaccurate, you need to check the SQL running on the current interface and compare whether there is a problem with the SQL. Then you need to get the SQL statement running on the interface on the business side. The realization of this function is mainly considered from two aspects. ...

1 Introduction What is Cache? There is temporary data in memory.Put the data frequently queried by users in the cache (memory), and users do not need to query from the disk (relational database data file) but from the cache to query the data, so as to improve the query efficiency and solve the performance problem of high concurrency sy ...

SSM framework is a necessary framework for Java Web. Although it is a basic operation of adding, deleting, modifying and querying, it will still be at a loss when facing some special situations. This article is used to record the application of Mybatis framework in a special scenario 1. The passed in parameter is a List object 1. Scene reprodu ...

In the world of MyBatis, the native paging is based on RowBounds. Although it can achieve the purpose of paging, it is still not so convenient to use Later, the developer added the streaming query method. Although it can solve some problems, it still doesn't feel like the desired paging method On the other hand, Java programmers have given many ...

pom <!-- Mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.8</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <arti ...