設(shè)計(jì)數(shù)據(jù)庫字段后凿跳，可直接利用mybatis工具生成Pojo類和CRUD操作的xml办桨。節(jié)省開發(fā)時(shí)間~ 但是有的代碼并不是很好用掰伸，可以自行添加或修改。

1培漏、準(zhǔn)備：

IDEA安裝mybatis plugin插件溪厘。

<img src="http://upload-images.jianshu.io/upload_images/3116838-202ed057f1e523bb.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240">

然后替換一下目錄中的batis插件的jar包（多金的可以直接付費(fèi)使用，支持正版）牌柄。
<img src="http://upload-images.jianshu.io/upload_images/3116838-42e96964fcbd6504.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240">

破解jar包分享地址：http://pan.baidu.com/s/1jHDDSqE 密碼：7gdc

2畸悬、數(shù)據(jù)庫SQL，創(chuàng)建一張簡單的用戶表：

-- DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userName` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `lastUpdateTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

3珊佣、pom.xml文件配置（依賴部分）

    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.2</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.22</version>
                <scope>runtime</scope>
            </dependency>
            <!-- mybatis generator 自動(dòng)生成代碼插件 -->
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator</artifactId>
                <version>1.3.5</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
            </dependency>
            
        </dependencies>
    </dependencyManagement>

    <build>
        <finalName>${project.artifactId}</finalName>
        <plugins>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

4蹋宦、創(chuàng)建mybatisGenerator.xml配置文件。

安裝插件后可以在resource->new中看到 'mybatis-generator-config'咒锻，生成即可冷冗。
![](http://upload-images.jianshu.io/upload_images/3116838-b406cf78e8d50c61.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240 "width=50% height=50%)

（這里如果沒有默認(rèn)起名為mybatisGenerator.xml，啟動(dòng)maven時(shí)會(huì)報(bào)錯(cuò)）惑艇。生成后修改文件蒿辙，具體內(nèi)容如下。

<?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>
    <!-- !!!! Driver Class Path !!!! -->
    <!-- mysql驅(qū)動(dòng)jar包路徑 -->
    <classPathEntry location=":/Files/repository/mysql/mysql-connector-java/5.1.38/mysql-connector-java-5.1.38.jar"/>

    <context id="context" targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressAllComments" value="false"/>
            <property name="suppressDate" value="true"/>
        </commentGenerator>

        <!-- !!!! Database Configurations !!!! -->
        <!-- 數(shù)據(jù)庫驅(qū)動(dòng)和連接配置 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost/mystudy" userId="root" password="123456"/>

        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>

        <!-- !!!! Model Configurations !!!! -->
        <javaModelGenerator targetPackage="generator.model" targetProject="src/main/java/mybatis">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!-- !!!! Mapper XML Configurations !!!! -->
        <sqlMapGenerator targetPackage="generator.mapping" targetProject="src/main/java/mybatis">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <!-- !!!! Mapper Interface Configurations !!!! -->
        <javaClientGenerator targetPackage="generator.dao" targetProject="src/main/java/mybatis" type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <!-- !!!! Table Configurations !!!! -->
        <!-- 設(shè)置數(shù)據(jù)庫表名 -->
        <table tableName="user" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               enableUpdateByExample="false"/>
    </context>
</generatorConfiguration>

5滨巴、配置maven啟動(dòng)項(xiàng)

mybatis-generator:generate -e

<img src="http://upload-images.jianshu.io/upload_images/3116838-9c111752cdcc95cd.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240">

自動(dòng)生成前的目錄結(jié)構(gòu)

<img src="http://upload-images.jianshu.io/upload_images/3116838-f64c234ee5a09775.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240">

自動(dòng)生成后的目錄結(jié)構(gòu)

<img src="http://upload-images.jianshu.io/upload_images/3116838-8f770f717e396c5d.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240">

So easy思灌，and 強(qiáng)大的不行~

以后如果增加數(shù)據(jù)庫表的字段，重新自動(dòng)生成一下代碼就好了恭取。但是如果在表中改字段名泰偿，或是有其他關(guān)聯(lián)操作，就不好說了秽荤。所以在工程中最好把自動(dòng)生成的代碼單獨(dú)拎出一份甜奄，其他業(yè)務(wù)需求的實(shí)現(xiàn)放在其他文件中柠横，盡量互不影響。