mybatis-generator自动映射数据库，生成mapper.xml、mapperDao、entity

1、导入jar包

 

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>${mybatis-generator.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>

 

 

2.配置文件

创建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" >
<!--使用方法:mvn mybatis-generator:generate-->
<generatorConfiguration>
    <!--读取配置文件地址-->
    <properties resource="application.properties"/>
    <!--连接驱动要确定地址-->
    <classPathEntry  location="F:/talk/src/main/resources/mysql-connector-java-5.1.36.jar"/>
    <context id="context1" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
　　　　　　<!--配置数据连接-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/myservice"
                        userId="root"
                        password="ok">
        </jdbcConnection>
        <!--实体类也不用提前，建立，会自动根据数据库生成，对应数据库中字段-->
        <javaModelGenerator targetPackage="pterosaur.account.domain" targetProject="src/main/java/com/example/demo/entity"/>
        <!--映射的mapper.xml文件-->
        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/java/com/example/demo/mapper"/>
        <!--映射文件，目标不必提前生成，会自动生成-->
        <javaClientGenerator targetPackage="pterosaur.account.mapper" targetProject="src/main/java/com/example/demo/mapper"
                             type="XMLMAPPER"/>

        <table tableName="user"></table>
        <table tableName="chat_records"></table>

    </context>
</generatorConfiguration>

3.创建好路径下面的文件夹

4.maven运行