generator mysql插件_springboot集成mybatis-generator插件详解

本文基于Springboot2.1.X及Maven环境，以mysql为例，如果要用其他数据库，修改引用的包及驱动类即可，本文还采用了一个很好用的mybatis插件tk.mybatis，本例子能将数据表字段的注释同步生成到model中：

1、pom.xml中引入相关依赖包

org.mybatis.spring.boot

mybatis-spring-boot-starter

2.0.0

com.alibaba

druid-spring-boot-starter

1.1.10

mysql

mysql-connector-java

8.0.15

tk.mybatis

mapper-spring-boot-starter

2.0.4

org.mybatis

mybatis

org.mybatis

mybatis-spring

org.mybatis.generator

mybatis-generator-core

1.3.7

2、在pom.xml中添加build

${project.artifactId}

src/main/java

org.mybatis.generator

mybatis-generator-maven-plugin

1.3.7

${basedir}/src/main/resources/mybatis-generator.xml

true

true

mysql

mysql-connector-java

8.0.12

tk.mybatis

mapper

4.0.4

3、在src/main/resources下添加mybatis-generator.xml

/p>

PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"

"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

defaultModelType="flat">

value="tk.mybatis.mapper.common.Mapper" />

connectionURL="jdbc:mysql://127.0.0.1:3306/mydb_name?characterEncoding=UTF-8&useSSL=FALSE"

userId="root" password="Abc123">

targetPackage="com.test.model"

targetProject="src/main/java">

value="com.vo.BaseVo" />

targetProject="src/main/resources" />

targetPackage="com.test.mapper"

targetProject="src/main/java" type="XMLMAPPER" />

4、执行方式：在项目名上右键Run as -> maven build... 在goals输入：mybatis-generator:generate，点击运行即可