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，可能是路径没写对，注意是\,且从根目录开始识别