命令+mybatis-generator插件自动生成Mapper映射文件

学mybatis的时候，自己写各种 *Mapper.xml和 *Mapper.java,注意各种sql语句中的 id 是否匹配，xml中的namespace是否正确，很麻烦有木有？今天博客内容就是高大上的自动构建~

1. 需要的工具包、文件
   
2. 下面来介绍一下generator.xml

<code class="hljs xml has-numbering"><span class="hljs-pi"><?xml version="1.0" encoding="UTF-8"?></span>
<span class="hljs-doctype"><!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"></span>
<span class="hljs-tag"><<span class="hljs-title">generatorConfiguration</span>></span>
    <span class="hljs-comment"><!-- 数据库驱动包位置 ：注意写你自己的包路径--></span>
    <span class="hljs-comment"><!-- <classPathEntry location="D:\software\lib\mysql-connector-java-5.1.21.jar" /> --></span>
    <span class="hljs-tag"><<span class="hljs-title">classPathEntry</span> <span class="hljs-attribute">location</span>=<span class="hljs-value">"E:\mysql-connector-java-5.1.29-bin.jar"</span> /></span>
    <span class="hljs-tag"><<span class="hljs-title">context</span> <span class="hljs-attribute">id</span>=<span class="hljs-value">"DB2Tables"</span> <span class="hljs-attribute">targetRuntime</span>=<span class="hljs-value">"MyBatis3"</span>></span>
        <span class="hljs-tag"><<span class="hljs-title">commentGenerator</span>></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"suppressAllComments"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"true"</span> /></span>
        <span class="hljs-tag"></<span class="hljs-title">commentGenerator</span>></span>
        <span class="hljs-comment"><!-- 数据库链接URL、用户名、密码  jdbc\:mysql\://localhost\:3306/cinema--></span>
        <span class="hljs-tag"><<span class="hljs-title">jdbcConnection</span> <span class="hljs-attribute">driverClass</span>=<span class="hljs-value">"com.mysql.jdbc.Driver"</span> <span class="hljs-attribute">connectionURL</span>=<span class="hljs-value">"jdbc:mysql://localhost:3306/cinema"</span> <span class="hljs-attribute">userId</span>=<span class="hljs-value">"root"</span> <span class="hljs-attribute">password</span>=<span class="hljs-value">"a"</span>></span>
        <span class="hljs-comment"><!-- <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa"> --></span>
        <span class="hljs-tag"></<span class="hljs-title">jdbcConnection</span>></span>
        <span class="hljs-tag"><<span class="hljs-title">javaTypeResolver</span>></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"forceBigDecimals"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"false"</span> /></span>
        <span class="hljs-tag"></<span class="hljs-title">javaTypeResolver</span>></span>
        <span class="hljs-comment"><!-- 生成模型的包名和位置 --></span>
        <span class="hljs-tag"><<span class="hljs-title">javaModelGenerator</span> <span class="hljs-attribute">targetPackage</span>=<span class="hljs-value">"com.rindy.cinema.entity"</span> <span class="hljs-attribute">targetProject</span>=<span class="hljs-value">"E:\src"</span>></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"enableSubPackages"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"true"</span> /></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"trimStrings"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"true"</span> /></span>
        <span class="hljs-tag"></<span class="hljs-title">javaModelGenerator</span>></span>
        <span class="hljs-comment"><!-- 生成的映射文件包名和位置 --></span>
        <span class="hljs-tag"><<span class="hljs-title">sqlMapGenerator</span> <span class="hljs-attribute">targetPackage</span>=<span class="hljs-value">"mapper"</span> <span class="hljs-attribute">targetProject</span>=<span class="hljs-value">"E:\src"</span>></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"enableSubPackages"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"true"</span> /></span>
        <span class="hljs-tag"></<span class="hljs-title">sqlMapGenerator</span>></span>
        <span class="hljs-comment"><!-- 生成DAO的包名和位置 --></span>
        <span class="hljs-tag"><<span class="hljs-title">javaClientGenerator</span> <span class="hljs-attribute">type</span>=<span class="hljs-value">"XMLMAPPER"</span> <span class="hljs-attribute">targetPackage</span>=<span class="hljs-value">"com.rindy.cinema.mapper"</span> <span class="hljs-attribute">targetProject</span>=<span class="hljs-value">"E:\src"</span>></span>
            <span class="hljs-tag"><<span class="hljs-title">property</span> <span class="hljs-attribute">name</span>=<span class="hljs-value">"enableSubPackages"</span> <span class="hljs-attribute">value</span>=<span class="hljs-value">"true"</span> /></span>
        <span class="hljs-tag"></<span class="hljs-title">javaClientGenerator</span>></span>
        <span class="hljs-comment"><!-- 要生成那些表(更改tableName和domainObjectName就可以)这里是生成两张表的映射文件，多表可自行增加，确保你的数据库中已经建好表，并且表名没有写错~ --></span>
        <span class="hljs-tag"><<span class="hljs-title">table</span> <span class="hljs-attribute">tableName</span>=<span class="hljs-value">"filminfo"</span> <span class="hljs-attribute">domainObjectName</span>=<span class="hljs-value">"FILMINFO"</span> <span class="hljs-attribute">enableCountByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableUpdateByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableDeleteByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableSelectByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">selectByExampleQueryId</span>=<span class="hljs-value">"false"</span> /></span>
        <span class="hljs-tag"><<span class="hljs-title">table</span> <span class="hljs-attribute">tableName</span>=<span class="hljs-value">"filmtype"</span> <span class="hljs-attribute">domainObjectName</span>=<span class="hljs-value">"FILMTYPE"</span> <span class="hljs-attribute">enableCountByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableUpdateByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableDeleteByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">enableSelectByExample</span>=<span class="hljs-value">"false"</span> <span class="hljs-attribute">selectByExampleQueryId</span>=<span class="hljs-value">"false"</span> /></span>

    <span class="hljs-tag"></<span class="hljs-title">context</span>></span>
<span class="hljs-tag"></<span class="hljs-title">generatorConfiguration</span>></span></code>

3.上图中的 src是为生成的映射文件新建的空目录，构建成功，该目录下将会有你需要的文件。

4.自动生成Mapper映射文件命令：

<code class="hljs lasso has-numbering">java <span class="hljs-attribute">-jar</span> mybatis<span class="hljs-attribute">-generator</span><span class="hljs-attribute">-core</span><span class="hljs-subst">-</span><span class="hljs-number">1.3</span><span class="hljs-number">.2</span><span class="hljs-built_in">.</span>jar <span class="hljs-attribute">-configfile</span> generator<span class="hljs-built_in">.</span><span class="hljs-built_in">xml</span> <span class="hljs-attribute">-overwrite</span></code><ul style="display: block;" class="pre-numbering"><li>1</li></ul>

5.下面来看一下我的运行结果：

6.可能有的小伙伴会因为编码格式而引发一些错误，我们来看一下下面这种情况怎么解决

改一下编码格式就可以了

ok

版权声明：本文为博主原创文章，谢谢参考！有问题的地方，欢迎纠正，一起进步。