逆向生成mybatis- mySQL 8.0.26

  • STS工具栏Help ---> Eclipse Marketplace---> 搜索 MyBatis


    1627744928(1).png

    image.png

    点击install ,同意协议, install always 重启 安装成功了[图片上传中...(1627745170(1).png-4558b8-1627745175355-0)]

  • Run Configurations--->找到MyBatis Generator-->右击New Configuration

1627745170(1).png

image.png
  • 填写Name和配置文件generatorConfig的位置,点击apply 然后点击close


    image.png
  • 执行配置文件generatorConfig.xml(在运行中选择generator)
    Run Configurations--->找到MyBatis Generator-->
    image.png

    报了1个错,修改如下
    image.png

    在pom.xml文件中添加下方代码,对应自己mysql的版本-8.0.26
    maven包版本
    下载mysql-connector-java-8.0.26.jar
<classPathEntry location="D:/CCCode/store/sql/mysql-connector-java-8.0.26.jar"/>

报了2个错:MyBatis Generator: Project does not exist
由下方代码改为:

 <sqlMapGenerator targetPackage="mapper"  targetProject="src\main\resources"/>

到:

<sqlMapGenerator targetPackage="mapper"  targetProject="store/src/main/resources"/>

targetProject代表项目名

下方写明笔者配置文件

<?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="D:/CCCode/store/sql/mysql-connector-java-8.0.26.jar"/>
    <context id="MysqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>

        <commentGenerator>
            <property name="suppressDate" value="true"/>
        </commentGenerator>

        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/store?serverTimezone=UTC&amp;useSSL=false"
                        userId="root"
                        password="xueliwei">
               <property name="nullCatalogMeansCurrent" value="true" />
        </jdbcConnection>

        <javaModelGenerator targetPackage="com.xlw.store.entity" targetProject="store">
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <sqlMapGenerator targetPackage="mapper"  targetProject="store/src/main/resources"/>

        <javaClientGenerator type="XMLMAPPER" targetPackage="com.xlw.store.dao"  targetProject="store"/>

        <!-- <table tableName="%"> -->
        <table tableName="test">
            <generatedKey column="id" sqlStatement="Mysql"/>
        </table>
    </context>
</generatorConfiguration>
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容