天天看点

Mybatis配置generator代码生成器插件

1.新建Mavne项目,pom.xml加入如下代码:

<dependencies>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.46</version>
		</dependency>
	</dependencies>

	<build>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                	<!-- 配置gneratorConfig.xml的路径,默认是resource路径 -->
                	<configurationFile>src/main/resources/mybatis-generator/generatorConfig.xml</configurationFile>
                  <verbose>true</verbose>
                  <overwrite>false</overwrite>
                </configuration>
                <dependencies>
				        <dependency>
				            <groupId>org.mybatis.generator</groupId>
				            <artifactId>mybatis-generator-core</artifactId>
				            <version>1.3.2</version>
				        </dependency>
				    </dependencies>
            </plugin>
        </plugins>
    </build>
           

2.在resouce下新建一个Folder:mybatis-generator

Mybatis配置generator代码生成器插件

3.在mybatis-generator下新建一个xml文件:generatorConfig.xml

3.1.需要修改的地方,mysql配置,mapper,xml,entity的包路径,数据库表名,表对应的entity名称 

3.2在本地D:\Java\mysql-connector-java-5.1.46.jar放入一个jar包

<?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>

	<properties resource="mysql.properties"/>

	<classPathEntry location="D:\Java\mysql-connector-java-5.1.46.jar" />
	<context id="my" targetRuntime="MyBatis3">
		<commentGenerator>
			<property name="suppressDate" value="false" />
			<property name="suppressAllComments" value="true" />
		</commentGenerator>

		<!-- Oracle -->
		<!-- <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
			connectionURL="jdbc:oracle:thin:@172.20.16.***:1521:CARGO"
			userId="***" password="***" /> -->
			
		<!-- Mysql -->
		<jdbcConnection driverClass="${spring.datasource.driver-class-name}"
			connectionURL="${spring.datasource.url}"
			userId="${spring.datasource.username}" 
			password="${spring.datasource.password}" />

		<!--自动生成的实体的存放包路径 -->
		<javaModelGenerator targetPackage="com.itmayiedu.entity"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!--自动生成的*Mapper.xml文件存放路径 -->
		<sqlMapGenerator targetPackage="com.itmayiedu.xml"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!--自动生成的*Mapper.java存放路径 -->
		<javaClientGenerator targetPackage="com.itmayiedu.mapper"
			targetProject="src/main/java" type="XMLMAPPER">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>

		<!--<table tableName="T_FEE_AGTBILL" domainObjectName="FeeAgentBill" enableCountByExample="false" 
			enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" 
			selectByExampleQueryId="false"/> -->

		<!-- 如果有多个表,复制这一段,改下表名即可 -->
		<table tableName="m_app" domainObjectName="MApp"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">
			<!--<columnRenamingRule searchString="^D_" replaceString=""/> -->
		</table>

	</context>
</generatorConfiguration>
           

4.在resource下新建一个mysql.properties文件 ,修改相应数据库的配置

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=root
           

5.右键项目Run As  --> Run Configurations

Mybatis配置generator代码生成器插件

看到如下界面:

Goals输入命令:mybatis-generator:generate

Mybatis配置generator代码生成器插件

 看到如下说明代码生成成功了:

Mybatis配置generator代码生成器插件

 最后刷新项目: 

Mybatis配置generator代码生成器插件