mybatis Generator (复制粘贴可用)

165 阅读1分钟
  • 在pom里添加插件
<plugin>
				<groupId>org.mybatis.generator</groupId>
				<artifactId>mybatis-generator-maven-plugin</artifactId>
				<version>1.3.6</version>
				<dependencies>
					<dependency>
						<groupId>mysql</groupId>
						<artifactId>mysql-connector-java</artifactId>
						<version>8.0.17</version>
					</dependency>
				</dependencies>
			</plugin>

注意version和上面mysql-connector-java 版本一致

其中mysql-connector-java的版本和springboot有默认版本

image.png

image.png

  • 下面是生成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="mysqlTables" targetRuntime="MyBatis3">
		<commentGenerator>
			<!-- 是否去除自动生成的注释 true:是 : false:否 -->
			<property name="suppressAllComments" value="true" />
		</commentGenerator>
		<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
						connectionURL="jdbc:mysql://10.110.60.8:3306/sky_pm?characterEncoding=utf-8&amp;nullCatalogMeansCurrent=true"
						userId="sky" password="Sky123456!"><!--数据库连接信息。具体参看mybatis-generator -->
		</jdbcConnection>

		<!--自动生成的实体的存放包路径 -->
		<javaModelGenerator
				targetPackage="com.inspur.tech.project.mgt.common.review.data"
				targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>


		<!--自动生成的*Mapper.xml文件存放路径 -->
		<sqlMapGenerator
				targetPackage="review"
				targetProject="src/main/resources/mapper">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>
		<!--自动生成的*Mapper.java存放路径 -->
		<javaClientGenerator type="XMLMAPPER"
							 targetPackage="com.inspur.tech.project.mgt.common.review.dao"
							 targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>

		<table tableName="spm_review_expert_match"
			   domainObjectName="ReviewExpertMatch"
			   enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
			   enableSelectByExample="false" selectByExampleQueryId="false">
			<!--&lt;!&ndash;            主键自增&ndash;&gt;
			<generatedKey column="id" sqlStatement="MySql"
						  identity="true"/>-->
		</table>
	</context>
</generatorConfiguration>

运行插件

    idea:
        在maven视图下 找到 maven > spm-boot > Plugins > ybatis-generator-maven-plugin
        右键 运行
    eclipse:
       执行run as:maven build在goals中输入mybatis-generator:generate  

image.png