Programming VIP

IDEA teaches you how to integrate Springboot+mybatis+maven Recently, I encountered a series of problems when trying to write an introductory springboot project with IDEA. I read a lot of articles on the Internet, but I didn't find a perfect solution, so I plan to write a little white tutorial and take this opportunity to consolidate it. I Pro ...

(1) Read the configuration file of MyBatis. mybatis-config.xml is the global configuration file of MyBatis, which is used to configure database connection information. (2) Load mapping file. The mapping file is the SQL mapping file, in which the SQL statements for operating the database are configured, which needs to be in the MyBatis config ...

Preface: introduce a simple MyBatis encryption and decryption method. This method is rarely mentioned in daily study and work, so let's talk about it. If you already know this method, ignore this article 1, Background Sometimes in our database, some sensitive information of users, such as mobile phone number, bank card and other information, ...

Video link: https://www.bilibili.com/video/BV1VP4y1c7j7?p=48&spm_id_from=pageDriver preparation (1) New maven project See the following steps for details: https://editor.csdn.net/md/?articleId=123185097 (2) Create two forms in sql: t_emp,t_dept t_dept form: t_emp form: Add a did to connect with the primary key of the ...

The previous article mentioned that the cache will be used when querying. Its built-in two-level cache is as follows:// The L1 cache is bound to sqlsession in the executor // org.apache.ibatis.executor.BaseExecutor#localCache // Point to org apache. ibatis. cache. impl. PerpetualCache#cache private Map<Object, Object> cache = new HashMap& ...

Problem description Because spring boot usually simplifies the configuration and feels a little handmade, I handwritten JDBC and Mybatis in Mybatis class today. At the same time, there were several problems, which are recorded here. 0x01 JDBC insert Chinese garbled code The code is as follows The characters are still normal when the con ...

1, Important tags in xml 1.1. where label Query criteria entity class public class QueryTeamVO { private String name; private Date beginTime; private Date endTime; private String location; public QueryTeamVO() { } public QueryTeamVO(String name, Date beginTime, Date endTime, String location) { this.n ...

Official learning documents Introduction to MyBatis mybatis is a persistence layer framework written in Java. He encapsulates many details of jdbc operation, so that developers only need to care about the sql statement itself, without paying attention to the complex processes such as registering drivers and creating connections. It uses t ...

Dynamic SQL introduce In the mapping file of Mybatis, our SQL is relatively simple. Sometimes when the business logic is complex, our SQL changes dynamically. At this time, our SQL can not meet the requirements in the previous study. The official document on dynamic SQL reference is described as follows: Previous problems Example of mult ...

Dao interface proxy Case project skeleton What is agent development? Mapper interface development needs to follow the following specifications Write StudentMapper interface Case demonstration Source code analysis Analyze how dynamic proxy objects are generated? How is the analysis method performed? Dao interface proxy Case project sk ...