Intellij IDEA springboot maven 配置mybatis-generator,自动从数据库中生成代码

1.生成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>
    <classPathEntry
            location="C:\Users\xxx\.m2\repository\mysql\mysql-connector-java\5.1.38\mysql-connector-java-5.1.38.jar" />
    <context id="context1" targetRuntime="MyBatis3">
        <commentGenerator>
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true" />
            <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
        </commentGenerator>

        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/springboot?characterEncoding=UTF-8"
                        userId="xxxx" password="xxxx" />
        <javaModelGenerator targetPackage="com.example.demo.bean.po" targetProject="src\main\java" />
        <sqlMapGenerator targetPackage="com.example.demo.mapper" targetProject="src\main\java" />
        <javaClientGenerator targetPackage="com.example.demo.bean.dao" targetProject="src\main\java" type="XMLMAPPER" />
        <!-- shema 数据库 tableName表明 -->
        <table schema="springboot" tableName="user"
               enableInsert="true"
               enableCountByExample="true"
               enableSelectByPrimaryKey="true"
               enableSelectByExample="true"
               enableUpdateByPrimaryKey="true"
               enableUpdateByExample="true"
               enableDeleteByPrimaryKey="true"
               enableDeleteByExample="true">
        </table>
        </context>
</generatorConfiguration>

2.在pom.xml中添加jar包和插件

配置如下；

<dependencies>
 <dependency>

	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.38</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-maven-plugin -->
<dependency>
	<groupId>org.mybatis.generator</groupId>
	<artifactId>mybatis-generator-maven-plugin</artifactId>
	<version>1.3.5</version>
</dependency>
<!-- 添加 JSTL 支持 -->
<dependency>
	<groupId>javax.servlet</groupId>
	<artifactId>jstl</artifactId>
</dependency>
 <dependency>
 	<groupId>org.mybatis.generator</groupId>
 	<artifactId>mybatis-generator-core</artifactId>
	 <version>1.3.2</version> 
</dependency>
</dependencies>



<build>

		<plugins>
			<plugin>
				<groupId>org.mybatis.generator</groupId>
				<artifactId>mybatis-generator-maven-plugin</artifactId>
				<version>1.3.5</version>
				<configuration>
					<!--配置文件的位置-->
					<configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
					<verbose>true</verbose>
					<overwrite>true</overwrite>
				</configuration>
				<executions>
					<execution>
						<id>Generate MyBatis Artifacts</id>
						<goals>
							<goal>generate</goal>
						</goals>
					</execution>
				</executions>
			</plugin>
		</plugins>
	</build>



3.执行操作







出现The specified target project directory src\main\java does not exist，可能是路径没写对，注意是\,且从根目录开始识别