mybatis依赖配置
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>runtime</scope>
</dependency>
mybatis-generator pom配置
<build>
<plugins>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.4.0</version>
<configuration>
<configurationFile>${basedir}/src/main/resources/mybatis-generator/mybatis-generator.xml</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
<dependencies>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.14</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
mybatis-generator配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator
Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- targetRuntime: 1 MyBatis3DynamicSql(默认值)。忽略defaultModelType的设置,采用FLAT,主键不会抽取成独立的一个类。
忽略javaClientGenerator的type配置,生成注解方式的sql,不会生成xml。 2 MyBatis3。会有by
example的方法生成 3 MyBatis3Simple。没有by example的方法生成 -->
<!-- defaultModelType: 1 conditional(默认值),如果主键是多个字段,将会抽取成单独的一个类。2 flat,一个表对应一个类,包含所有属性。
3 hierarchical,主键会抽取成一个单独的类。 -->
<context id="book" targetRuntime="MyBatis3"
defaultModelType="flat">
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<jdbcConnection
connectionURL="jdbc:postgresql://localhost:5432/common-test?serverTimezone=UTC"
password="yunzhong" userId="postgres"
driverClass="org.postgresql.Driver" />
<javaModelGenerator
targetPackage="org.yunzhong.CommonTest.library.model"
targetProject="src/main/java" />
<sqlMapGenerator
targetPackage="org.yunzhong.CommonTest.library.dao.mapper"
targetProject="src/main/java">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator
targetPackage="org.yunzhong.CommonTest.library.dao"
targetProject="src/main/java" type="XMLMAPPER" />
<table schema="public" tableName="book"
domainObjectName="Book" enableCountByExample="false"
enableUpdateByExample="false" enableDeleteByExample="false"
enableSelectByExample="false"/>
</context>
</generatorConfiguration>
命令
mvn mybatis-generator:generate