Maven之mybatis-generator插件自动生成mapper及其实体模型配置

最新推荐文章于 2021-04-26 14:33:42 发布

WindBlows风

最新推荐文章于 2021-04-26 14:33:42 发布

阅读量492

点赞数

本文链接：https://blog.csdn.net/whenthewindblows/article/details/88887441

版权

Mybatis 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

SpringBoot

1 篇文章 0 订阅

订阅专栏

本文介绍了如何在SpringBoot项目中使用Maven和mybatis-generator插件自动生成Mapper接口、实体模型类和XML映射文件。通过配置pom.xml和application.properties，执行Maven命令后，可以一键生成所需代码，简化开发流程。

摘要由CSDN通过智能技术生成

目录结构：创建如下文件夹及配置文件（springBoot）。内容见下：
在这里插入图片描述
pom.xml

<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.liu</groupId>
<artifactId>testSpringBoot</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>2.0.5.RELEASE</version>
</parent>
<dependencies>
	<dependency>
		<groupId>org.apache.maven.plugins</groupId>
		<artifactId>maven-resources-plugin</artifactId>
		<version>2.6</version>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-test</artifactId>
		<version>2.0.5.RELEASE</version>
		<scope>test</scope>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
		<version>2.0.5.RELEASE</version>
	</dependency>
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.41</version>
	</dependency>
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.1.3</version>
	</dependency>
	<dependency>
		<groupId>org.mybatis.spring.boot</groupId>
		<artifactId>mybatis-spring-boot-starter</artifactId>
		<version>1.3.2</version>
	</dependency>
	<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
	<dependency>
		<groupId>org.mybatis.generator</groupId>
		<artifactId>mybatis-generator-core</artifactId>
		<version>1.3.5</version>
	</dependency>
	<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-maven-plugin -->
</dependencies>
<build>
	<plugins>
		<plugin>
			<groupId>org.mybatis.generator</groupId>
			<artifactId>mybatis-generator-maven-plugin</artifactId>
			<version>1.3.5</version>
			<executions>
				<execution>
					<id>mybatisgenerator</id>
					<phase>package</phase>
					<goals>
						<goal>generate</goal>
					</goals>
				</execution>
			</executions>
			<configuration>
				<verbose>true</verbose>
				<overwrite>false</overwrite>
				<configurationFile>
					src/main/resources/mybatis-generator.xml
				</configurationFile>
			</configuration>
			<dependencies>
				<dependency>
					<groupId>mysql</groupId>
					<artifactId>mysql-connector-java</artifactId>
					<version>5.1.41</version>
				</dependency>
				<dependency>
					<groupId>org.mybatis.generator</groupId>
					<artifactId>mybatis-generator-core</artifactId>
					<version>1.3.5</version>
				</dependency>
			</dependencies>
		</plugin>

	</plugins>
</build>
</project>

application.properties

server.port=8081  //修改项目运行时tomcat的端口号
mybatis.mapperLocations=classpath:mapping/*.xml     //指定实体-数据库映射文件路径及其文件。

mybatis-gengerator

<?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="DB2Tables" targetRuntime="MyBatis3">
	<!-- 数据库连接 -->
	<jdbcConnection driverClass="com.mysql.jdbc.Driver"
		connectionURL="jdbc:mysql://localhost/testLiu?useUnicode=true&amp;characterEncoding=utf-8"
		userId="root" password="123456"></jdbcConnection>
	<!-- 生成模型的包名和位置 -->
	<javaModelGenerator targetPackage="code.dataObject"
		targetProject="src\main\java">
		<property name="enableSubPackages" value="true" />
		<property name="trimStrings" value="true" />
	</javaModelGenerator>
	<!-- 生成映射文件的包名和位置 -->
	<sqlMapGenerator targetPackage="mapping"
		targetProject="src\main\resources">
		<property name="enableSubPackages" value="true" />
	</sqlMapGenerator>
	<javaClientGenerator type="XMLMAPPER"
		targetPackage="code.dao" targetProject=".\src\main\java">
		<property name="enableSubPackages" value="true" />
	</javaClientGenerator>
	<!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名 -->
	<table tableName="code_userinfo" domainObjectName="UserDo" enableCountByExample="false"  
        enableDeleteByExample="false" enableSelectByExample="false"  
        enableUpdateByExample="false"></table>
	<table tableName="code_password" domainObjectName="UserPass" enableCountByExample="false"  
        enableDeleteByExample="false" enableSelectByExample="false"  
        enableUpdateByExample="false"></table>
</context>
</generatorConfiguration>

配置三处后：选择项目，右键Run As ,选择Maven build, 设置goals为
mybatis-generator:generate
点击run, 控制台显示“build success”时，按F5，刷新，即可在dao层，实体模型层，以及mapping文件下生产对应的文件。
优点：
（1）springBoot减少了配置文件的配置。
（2）mybatis的gengertor插件，免去了sql映射文件、实体类vo、dao层mapper代码的创建。