mybatis逆向工程生成dao和mapper层

1. mybatis逆向工程生成  dao和mapper层

MyBatis Generator官网: http://mbg.cndocs.ml/index.html

idea使用:https://blog.csdn.net/qq_23703157/article/details/78681088

Eclipse使用:https://blog.csdn.net/opera95/article/details/78296120

转载使用教程：https://blog.csdn.net/isea533/article/details/42102297

 

 

pox.xml

依赖

      <!-- mybatis-generator自动生成代码 -->
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.2</version>
        </dependency>

插件

<build>
        <plugins>
            <!-- mybatis-generator自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
            </plugin>
        </plugins>
    </build>

 

在resources文件下创建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>
	<!-- 数据库驱动包位置 -->  
    <!-- 由于在pom.xml中加入插件时已经配置数据库驱动包，所以此处不必配置了-->
    <!-- <classPathEntry
            location="/Users/yehaixiao/Maven/mysql/mysql-connector-java/5.1.30/mysql-connector-java.jar"/> -->
	<context id="my" targetRuntime="MyBatis3">
		<commentGenerator>
			<property name="suppressDate" value="false" />
			<property name="suppressAllComments" value="true" />
		</commentGenerator>
		<!-- mysql数据库连接 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://127.0.0.1:3306/xx" userId="root"
			password="123456" />

		<!-- 生成model实体类文件位置 -->
		<javaModelGenerator
			targetPackage="com.xx.xx.entity"
			targetProject="src/main/java">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!-- 生成mapper.xml配置文件位置 -->
		<sqlMapGenerator
			targetPackage="mapper"
			targetProject="src/main/resources">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!-- 生成mapper接口文件位置 -->
		<javaClientGenerator
			targetPackage="com.xx.xx.mapper"
			targetProject="src/main/java"
			type="XMLMAPPER">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>
		<!-- 需要生成的实体类对应的表名，多个实体类复制多份该配置即可 -->
		<table tableName="数据库的表名" domainObjectName="创建类的名字"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">
		</table>

	</context>
</generatorConfiguration>

idea用maven projects执行命令即可生成

 

eclipse:

  右键