Programming VIP

1. Use of mybatis public static void main(String[] args) throws IOException { //1.Get profile stream InputStream is = Resources.getResourceAsStream("mybatis-config.xml"); //2.structure SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is); //3.establish SqlSession SqlSession sq ...

Firstly, the mybatis framework encapsulates sql statements and executes them through tag and attribute parsing in the form of xml. We know that the sql statements inserted into the table are: INSERT INTO table name (column 1, column 2,...) VALUES (value 1, value 2,...) During the insertion process, the database will add transactions by d ...

1 delayed loading concept Delayed loading: Data is loaded only when it is needed. Data is not loaded when it is not needed. Lazy loading is also called lazy loading. Benefits: query from a single table first, and then associate the query from the associated table when necessary, which greatly improves the database performance, because querying ...

spring integrates mytabis Is to use the function of mybatis in the spring architecture It is equal to the mybatis tar package imported from the code written in non spring architecture to do the operation of the core configuration file, mapping configuration file and dynamic proxy interface of mybatis. Then there are operations such as dao, se ...

reference resources: MyBatis-Plus 1, Quick start 1.0 preparation reference resources MyBatis-Plus Create table statement in! 1.1 add dependency & profile During springboot consolidation: <!-- springboot Unit test dependencies for --> <dependency> <groupId>org.springframework.boot</groupId> ...

MyBatis 1, Framework introduction 1.1 concept of framework Framework is a semi-finished product of software, which completes the general operation in the process of software development. Programmers can realize specific functions with little or no processing, so as to simplify the development process and improve efficiency. 1.2 common ...

1, Construction of complex query environment ​ mybatis-config.xml file configuration <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <!--<setting name=" ...

1. pom.xmlDetailed POM XML file reference blogger source codeWhere h2's scope can be test.2. Spring boot uses mybatis for database operationWhen using mybatis, you need org mybatis. spring. boot:mybatis-spring-boot-starter:2.1. 3 [compile] dependency.Then create an interface and use the @ Mapper tag. mybatis will search for this tag and parse t ...

preface Previously, in the process of using SpringBoot to build background services, we usually access a database and a data source The MQTT service used in the new project needs authentication, but the MQTT service is used by multiple projects, so its authentication database is in a separate database. At this time, we need to configure ...

1 Mybatis connection pool In Mybatis's sqlmapconfig XML configuration file to configure the connection pool in Mybatis Generally, POOLED data source is used The data source configuration is in sqlmapconfig In the XML file, the specific configuration is as follows: <!-- Configure data source (connection pool) information --> <dataSo ...