【完美】SpringBoot+Mybatis-Generator自动生成

冷不防 2022-05-31 00:44 121阅读 0赞

**版本**

Spring Boot 1.5.10

mybatis-generator-core 1.3.5

mybatis-generator-maven-plugin 1.3.5

**项目目录结构**

**![SouthEast][]**

**配置pom.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    
    	<groupId>com.baixin</groupId>
    	<artifactId>pms</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>jar</packaging>
    
    	<name>pms</name>
    	<description>Demo project for Spring Boot</description>
    
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.9.RELEASE</version>
    		<relativePath /> 
    	</parent>
    
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    		<java.version>1.8</java.version>
    	</properties>
    
    	<dependencies>
    		
    		<dependency>
    			<groupId>com.zaxxer</groupId>
    			<artifactId>HikariCP</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.github.pagehelper</groupId>
    			<artifactId>pagehelper</artifactId>
    			<version>5.1.2</version>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.generator</groupId>
    			<artifactId>mybatis-generator-core</artifactId>
    			<version>1.3.5</version>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.0</version>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-devtools</artifactId>
    			<optional>true</optional>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter</artifactId>
    			<exclusions>
    				
    				<exclusion>
    					<groupId>org.apache.tomcat</groupId>
    					<artifactId>tomcat-jdbc</artifactId>
    				</exclusion>
    			</exclusions>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    	</dependencies>
    
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<version>1.3.5</version>
    				<executions>
    					<execution>
    						<id>Generate MyBatis Artifacts</id>
    						<phase>package</phase>
    						<goals>
    							<goal>generate</goal>
    						</goals>
    					</execution>
    				</executions>
    				<configuration>
    					
    					<configurationFile>src/main/resources/mybatis/generatorConfig.xml</configurationFile>
    					
    					<verbose>true</verbose>
    					
    					<overwrite>true</overwrite>
    				</configuration>
    			</plugin>
    
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    				<configuration>
    					<fork>true</fork> 
    				</configuration>
    			</plugin>
    		</plugins>
    	</build>
    </project>

**配置自动生成配置文件generatorConfig.xml**

<?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>
    	<context id="MySQL2Tables" targetRuntime="MyBatis3"
    		defaultModelType="flat">
    		<commentGenerator>
    			<property name="suppressDate" value="true" />
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://192.168.1.180:3306/pms?useSSL=false"
    			userId="root" password="123456">
    		</jdbcConnection>
    
    		
    		
    		<javaTypeResolver
    			type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl">
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.baixin.pms.entity"
    			targetProject="src/main/java">
    			
    			<property name="enableSubPackages" value="true" />
    			
    			<property name="trimStrings" value="true" />
    
    			
    			<property name="constructorBased" value="false" />
    			
    			<property name="immutable" value="false" />
    		</javaModelGenerator>
    
    		
    		<sqlMapGenerator targetPackage="mappers"
    			targetProject="src/main/resources">
    			<property name="enableSubPackages" value="true" />
    		</sqlMapGenerator>
    
    		
    		<javaClientGenerator type="XMLMAPPER"
    			targetPackage="com.baixin.pms.dao" targetProject="src/main/java">
    			<property name="enableSubPackages" value="true" />
    		</javaClientGenerator>
    
    		
    		<table tableName="%" enableCountByExample="false"
    			enableUpdateByExample="false" enableDeleteByExample="false"
    			enableSelectByExample="false" selectByExampleQueryId="false">
    			<property name="useActualColumnNames" value="true" />
    			
    			<generatedKey column="id" sqlStatement="MySql" identity="true" />
    		</table>
    	</context>
    </generatorConfiguration>

**创建自动生成启动类**

package com.baixin.pms.config.util;
    
    import java.io.File;
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.List;
    
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.exception.InvalidConfigurationException;
    import org.mybatis.generator.exception.XMLParserException;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class MyBatisGeneratorUtil {
    	public static void main(String[] args) {
    		List<String> warnings = new ArrayList<String>();
    		boolean overwrite = true;
    		String genCfg = "/generatorConfig.xml";
    		File configFile = new File(MyBatisGeneratorUtil.class.getResource(genCfg).getFile());
    		ConfigurationParser cp = new ConfigurationParser(warnings);
    		Configuration config = null;
    		try {
    			config = cp.parseConfiguration(configFile);
    		} catch (IOException e) {
    			e.printStackTrace();
    		} catch (XMLParserException e) {
    			e.printStackTrace();
    		}
    		DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    		MyBatisGenerator myBatisGenerator = null;
    		try {
    			myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
    		} catch (InvalidConfigurationException e) {
    			e.printStackTrace();
    		}
    		try {
    			myBatisGenerator.generate(null);
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} catch (IOException e) {
    			e.printStackTrace();
    		} catch (InterruptedException e) {
    			e.printStackTrace();
    		}
    	}
    }

**Run As Java Application**

刷新看效果，有问题请留言

[SouthEast]: /images/20220531/0e8689dbd17d43ef8abb74f64a669ccb.png