Programmer Think

The Foundation of MyBatis Series (10) Dynamic SQL Statements in Mybatis 1. Overview of Dynamic SQL Referring to the official documents, it is described as follows: They are: if choose (when, otherwise) trim (where, set) foreach 2. Label of ...

I. Environmental deployment Operating System: Windows 10 Professional Edition jdk:1.8.0_144 IDE: eclipse-oxygen Server: tomcat 9.0 Database: mysql 5.7.18 Maven: 3.54 "If you want to do a good job, you must first use your tools." The environment must be built in advance. II. New Maven Project In the menu bar, click File-New- ...

1. Optimizing code Let's start with a little optimization of yesterday's code. Test methods written in test classes. If we write one test method at a time, we need to build factories or something, and there will be a lot of repetitive code.Modify the test method Mybatis Test public class MybatisTest { ...

rely on Be careful The database connection pool is used here, the Druid is used here, and the Druid is used here is com.alibaba.druid-spring-boot-starter. The starter is provided by a third party. The names of MyBatis and Druid depend on are different from those of other libraries, but the mysql it supp ...

Data Interaction between Multiple Tables In fact, one-to-one and one-to-many mappings have already been touched on in the previous configuration. I explained directly in the log because I wanted to write a summary log (that is, this article) after that to summarize the configuration of these advance ...

Guide reading Spring Boot project development has gradually become the mainstream framework in the field of Java application development. It can not only create production-level Spring applications easily, but also easily integrate with the hot micro-service framework Spring Cloud through some annotation configurations. The ...

The SSM framework - S-Spring S-Spring mvc M-mybatis requires the following configuration files to be placed under the resources folder: db.properties is the configuration file of the database connection pool, which has the connection information of the database jdbc: # JDBC jdbc.driverClass=com.mysql.jdbc.Driver jdbc.connectionURL=jdbc: ...

Java simulates and solves cache penetrationWhat is Cache PenetrationCache penetration only occurs in high concurrency, that is, when there are 10,000 concurrent query data, we usually go to redis to query data first, but if there is no such data in redis, then a large part of the 10,000 concurrent data will go to mysql at once. Queried in the d ...

PageHelper Speaking of PageHelper, friends who have used Mybatis may not be unfamiliar. As a paging plugin developed by a Chinese, it basically meets our daily needs.But when I wanted to go to the official documentation and see how it worked with Spring Boot, I found this: So I spent an evening exploring how to play this sensibly. quick get st ...

Introduction to Mybatis Mybatis is a persistence framework, ORM framework, is the top-level project under Apache, supporting customized SQL, stored procedures and advanced mapping. Mybatis avoids all JDBC code and manual parameter setting and result set acquisition in the JDBC programming process. Mai ...