Shulou(Shulou.com)06/02 Report--

This article mainly explains "the use of SpringBoot integrated MyMatis-Generator". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the use of SpringBoot integrated MyMatis-Generator".

SpringBoot integrates MyMatis-Generator1. Create a SpringBoot project using Spring Initializr

POM dependence

Org.springframework.boot spring-boot-starter-web org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.3 mysql mysql-connector-java runtime 5.1.40 org.projectlombok Lombok true org.springframework.boot spring-boot-starter-test test org.junit.vintage junit-vintage-engine 2. Configure application.yml

Configure according to the actual data source

Spring: datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/spring_mybatis_dljd?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&serverTimezone=GMT%2B8&useSSL=false username: root password: 1234563. Add plug-in coordinates org.springframework.boot spring-boot-maven-plugin org.mybatis.generator mybatis-generator-maven-plugin 1.4.0 to POM Mysql mysql-connector-java 5.1.40 ${project.basedir} / src/main/resources/generatorConfig.xml true True src/main/java * * / .xml src/main/resources * * / * .yml * * / .properties

Note:

1. The mysql-connector-java used in the plug-in is consistent with the application.yml

The location of the generator configuration file generatorConfig.xml is specified in 2.configurationFile

3. In order to import the sql mapping file xml in the mapper package into the resource file, add resources at the time of release. As a result, the default resource configuration has been reconfigured, requiring additional imports of * .yml,*.properties

4. Create a generator profile

Path:

Src\ main\ resources\ generatorConfig.xml

Content:

1. JavaModelGenerator entity and Example file specified location

2. Location of sqlMapGenerator SQL mapping file * .Mapper.xml

3. Location of javaClientGenerator API file

4. TableName= "%" to generate all tables

JdbcConnection driverClass: need to be consistent with application.yml

5. Test generation results

5.1 Click

5.2. Generate

6. Configure the scanning interface and mapping configuration file @ SpringBootApplication@MapperScan ("com.zhl.springmybatis.mapper") public class SpringMybatisApplication {public static void main (String [] args) {SpringApplication.run (SpringMybatisApplication.class, args);}} 7 in the startup class. Add toString () to the generated entity to facilitate testing, and the generated Mapper interface Example does not need to move @ Data@ToStringpublic class Student {....} 9. Write Service and ServiceImpl

StudentService:

Package com.zhl.springmybatis.service;import com.zhl.springmybatis.pojo.Student;import java.util.List;public interface StudentService {List getList ();}

StudentServiceImpl

@ Servicepublic class StudentServiceImpl implements StudentService {@ Resource private StudentMapper studentMapper; @ Override public List getList () {StudentExample studentExample=new StudentExample (); List list= studentMapper.selectByExample (studentExample); for (Student s:list) {System.out.println (s);} return list;}} 10. Test class

The Mapper API is referenced here and @ Resource is used to avoid warning red lines.

@ SpringBootTestclass SpringMybatisApplicationTests {@ Resource private StudentMapper studentMapper; @ Test void contextLoads () {} @ Test public void GetList () {StudentExample studentExample=new StudentExample (); List list= studentMapper.selectByExample (studentExample); for (Student s:list) {System.out.println (s);}} 11. Test result

twelve。 Solve the red mark problem of dtd files. Download the file locally according to the address of the constraint file

Mybatis-3-mapper.dtd

Mybatis-generator-config_1_0.dtd

12.2. Set in IDEA

Path File | Settings | Languages & Frameworks | Schemas and DTDs

URI is the network address

Location is the local file address

13. Compile-time problem package org.apache.ibatis.annotations does not exist

Introduced into pom

Org.apache.ibatis ibatis-core 3.0Thank you for your reading, the above is the content of "the use of SpringBoot integrated MyMatis-Generator". After the study of this article, I believe you have a deeper understanding of the use of SpringBoot integrated MyMatis-Generator, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.