MyBatis根据数据库字段生成实体类和对应的mapper接口及mapper.xml

最新推荐文章于 2023-09-13 11:58:08 发布

那人好像一条猿

最新推荐文章于 2023-09-13 11:58:08 发布

阅读量2.7k

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/changhangshi/article/details/84615331

版权

mybatis 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

（1）这个generatorConfig..xml文件放在resource。

<?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>
    <properties resource="application.properties"/>
    <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"> <!--处理sql中的`符号-->
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/> <!--添加自定义的继承接口-->
        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
        </plugin> <!--数据源配置-->
        <jdbcConnection driverClass="${spring.datasource.select.driver-class-name}" connectionURL="${spring.datasource.select.jdbc-url}"
                        userId="${spring.datasource.select.username}"
                        password="${spring.datasource.select.password}"></jdbcConnection> <!--model包路径-->
        <javaModelGenerator targetPackage="com.lly.goodscenter.client.bean" targetProject="src/main/java"/> <!--mapper.xml包路径-->
        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/> <!--mapper包路径-->
        <javaClientGenerator targetPackage="com.lly.goodscenter.dao" targetProject="src/main/java"
                             type="XMLMAPPER"/> <!--表配置，tableName支持%，表示全部生成-->
        <table tableName="sku" domainObjectName="Sku"> <!--mysql 配置-->
            <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
        </table>
    </context>
</generatorConfiguration>

（2）三个注意点，生成对的实体路径com.lly.goodscenter.client.bean，对应的表名sku，生成的实体名Sku

（3）要在pom文件加入插件

    <build>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>5.1.47</version>
                    </dependency>
                    <dependency>
                        <groupId>tk.mybatis</groupId>
                        <artifactId>mapper</artifactId>
                        <version>3.4.3</version>
                    </dependency>

                </dependencies>
            </plugin>
        </plugins>

    </build>

（4）找到下面红色标记点，点击执行即可生成