Mybatis generator 逆向生成代码

简单介绍

生成javaben dao接口

图片

文件里面引入需要的jar的依赖 

    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; mybatis </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>org.mybatis<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>mybatis<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>3.4.0<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>

    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; mybaits-generator </span><span style="color: #008000"&gt;--></span>
    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>org.mybatis.generator<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>mybatis-generator-core<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>1.3.5<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; <a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>驱动 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>com.oracle<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;groupId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>ojdbc6<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;artifactId</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>0.0.1-SNAPSHOT<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;version</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;dependency</span><span style="color: #0000ff"&gt;></span>
<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;dependencies</span><span style="color: #0000ff"&gt;></span>
<span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;build</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;finalName</span><span style="color: #0000ff"&gt;></span>Mybaits<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;finalName</span><span style="color: #0000ff"&gt;></span>
<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;build</span><span style="color: #0000ff"&gt;></span>

配置文件

配置文件里面有些地方需要改动，需要的朋友可以根据自己的情况改动

配置文件内容

<span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;context </span><span style="color: #ff0000"&gt;id</span><span style="color: #0000ff"&gt;="DB2Tables"</span><span style="color: #ff0000"&gt; targetRuntime</span><span style="color: #0000ff"&gt;="MyBatis3"</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;commentGenerator</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="suppressAllComments"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="true"</span> <span style="color: #0000ff"&gt;/></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;commentGenerator</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; 配置<a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>连接 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;jdbcConnection </span><span style="color: #ff0000"&gt;driverClass</span><span style="color: #0000ff"&gt;="oracle.jdbc.OracleDriver"</span><span style="color: #ff0000"&gt;
        connectionURL</span><span style="color: #0000ff"&gt;="jdbc:oracle:thin:@localhost:1521:xe"</span><span style="color: #ff0000"&gt; userId</span><span style="color: #0000ff"&gt;="admin007"</span><span style="color: #ff0000"&gt;
        password</span><span style="color: #0000ff"&gt;="admin"</span><span style="color: #0000ff"&gt;></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;jdbcConnection</span><span style="color: #0000ff"&gt;></span>

    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;javaTypeResolver</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="forceBigDecimals"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="false"</span> <span style="color: #0000ff"&gt;/></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;javaTypeResolver</span><span style="color: #0000ff"&gt;></span>

    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; 指定javaBean<a href="/tag/shengcheng/" target="_blank" class="keywords">生成</a>的位置 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;javaModelGenerator </span><span style="color: #ff0000"&gt;targetPackage</span><span style="color: #0000ff"&gt;="com.bean"</span><span style="color: #ff0000"&gt;
        targetProject</span><span style="color: #0000ff"&gt;=".\src\main\java"</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="enableSubPackages"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="true"</span> <span style="color: #0000ff"&gt;/></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="trimStrings"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="true"</span> <span style="color: #0000ff"&gt;/></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;javaModelGenerator</span><span style="color: #0000ff"&gt;></span>

    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt;指定<a href="/tag/sql/" target="_blank" class="keywords">sql</a>映射<a href="/tag/wenjian/" target="_blank" class="keywords">文件</a><a href="/tag/shengcheng/" target="_blank" class="keywords">生成</a>的位置 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;<a href="/tag/sql/" target="_blank" class="keywords">sql</a>MapGenerator </span><span style="color: #ff0000"&gt;targetPackage</span><span style="color: #0000ff"&gt;="mapper"</span><span style="color: #ff0000"&gt;
        targetProject</span><span style="color: #0000ff"&gt;=".\src\main\resources"</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="enableSubPackages"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="true"</span> <span style="color: #0000ff"&gt;/></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;<a href="/tag/sql/" target="_blank" class="keywords">sql</a>MapGenerator</span><span style="color: #0000ff"&gt;></span>

    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; 指定dao接口<a href="/tag/shengcheng/" target="_blank" class="keywords">生成</a>的位置，mapper接口 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;javaClientGenerator </span><span style="color: #ff0000"&gt;type</span><span style="color: #0000ff"&gt;="XMLMAPPER"</span><span style="color: #ff0000"&gt;
        targetPackage</span><span style="color: #0000ff"&gt;="com.dao"</span><span style="color: #ff0000"&gt; targetProject</span><span style="color: #0000ff"&gt;=".\src\main\java"</span><span style="color: #0000ff"&gt;></span>
        <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;property </span><span style="color: #ff0000"&gt;name</span><span style="color: #0000ff"&gt;="enableSubPackages"</span><span style="color: #ff0000"&gt; value</span><span style="color: #0000ff"&gt;="true"</span> <span style="color: #0000ff"&gt;/></span>
    <span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;javaClientGenerator</span><span style="color: #0000ff"&gt;></span>


    <span style="color: #008000"&gt;<!--</span><span style="color: #008000"&gt; table指定每个表的<a href="/tag/shengcheng/" target="_blank" class="keywords">生成</a>策略 </span><span style="color: #008000"&gt;--></span>
    <span style="color: #0000ff"&gt;<</span><span style="color: #800000"&gt;table </span><span style="color: #ff0000"&gt;tableName</span><span style="color: #0000ff"&gt;="t_user"</span><span style="color: #ff0000"&gt; domainObjectName</span><span style="color: #0000ff"&gt;="User"</span><span style="color: #0000ff"&gt;></</span><span style="color: #800000"&gt;table</span><span style="color: #0000ff"&gt;></span>
<span style="color: #0000ff"&gt;</</span><span style="color: #800000"&gt;context</span><span style="color: #0000ff"&gt;></span>

<span style="color: #0000ff"></<span style="color: #800000">generatorConfiguration<span style="color: #0000ff">>

 

生成的启动java文件

文件内容看下面的代码

<span style="color: #0000ff">import<span style="color: #000000"> java.io.File;
<span style="color: #0000ff">import<span style="color: #000000"> java.util.ArrayList;
<span style="color: #0000ff">import<span style="color: #000000"> java.util.List;

<span style="color: #0000ff">import<span style="color: #000000"> org.mybatis.generator.api.MyBatisGenerator;
<span style="color: #0000ff">import<span style="color: #000000"> org.mybatis.generator.config.Configuration;
<span style="color: #0000ff">import<span style="color: #000000"> org.mybatis.generator.config.xml.ConfigurationParser;
<span style="color: #0000ff">import<span style="color: #000000"> org.mybatis.generator.internal.DefaultShellCallback;

<span style="color: #0000ff">public <span style="color: #0000ff">class<span style="color: #000000"> Test {

</span><span style="color: #0000ff"&gt;public</span> <span style="color: #0000ff"&gt;static</span> <span style="color: #0000ff"&gt;void</span> main(String[] args) <span style="color: #0000ff"&gt;throws</span><span style="color: #000000"&gt; Exception {
    List</span><String> warnings = <span style="color: #0000ff"&gt;new</span> ArrayList<String><span style="color: #000000"&gt;();
    </span><span style="color: #0000ff"&gt;boolean</span> overwrite = <span style="color: #0000ff"&gt;true</span><span style="color: #000000"&gt;;
    </span><span style="color: #008000"&gt;//</span><span style="color: #008000"&gt; <a href="/tag/peizhiwenjian/" target="_blank" class="keywords">配置文件</a>路径切记写对</span>
    File configFile = <span style="color: #0000ff"&gt;new</span> File("src/main/resources/mbg.xml"<span style="color: #000000"&gt;);

    ConfigurationParser cp </span>= <span style="color: #0000ff"&gt;new</span><span style="color: #000000"&gt; ConfigurationParser(warnings);
    Configuration config </span>=<span style="color: #000000"&gt; cp.parseConfiguration(configFile);
    DefaultShellCallback callback </span>= <span style="color: #0000ff"&gt;new</span><span style="color: #000000"&gt; DefaultShellCallback(overwrite);
    MyBatisGenerator myBatisGenerator </span>= <span style="color: #0000ff"&gt;new</span><span style="color: #000000"&gt; MyBatisGenerator(config,callback,warnings);
    myBatisGenerator.generate(</span><span style="color: #0000ff"&gt;null</span><span style="color: #000000"&gt;);
}

}

 

配置文件写完之后直接运行此配置文件，就可以生成代码，下面附上生成之后的效果（运行完之后，刷新项目 就可以看到生成的文件）

文章中涉及到的配置文件，启动类等都可以在mybatis官网找到。

错误，请大神指导。