收获：

      公司的一些框架知识，线上部署的一些文件配置

MyBatis Generator直接生成dao和基础类

在maven中加入插件

   <plugin>

       <groupId>org.mybatis.generator</groupId>

       <artifactId>mybatis-generator-maven-plugin</artifactId>

          <version>1.3.0</version>

          <executions>

            <execution>

              <id>Generate MyBatis Artifacts</id>

              <goals>

                <goal>generate</goal>

              </goals>

            </execution>

          </executions>

        </plugin>

生成文件xml配置

<?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="/Program Files/IBM/SQLLIB/java/db2java.zip" />

  <context id="DB2Tables" targetRuntime="MyBatis3">

    <jdbcConnection driverClass="COM.ibm.db2.jdbc.app.DB2Driver"

        connectionURL="jdbc:db2:TEST"

        userId="db2admin"

        password="db2admin">

    </jdbcConnection>

    <javaTypeResolver >

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

    </javaTypeResolver>

    <javaModelGenerator targetPackage="test.model" targetProject="\MBGTestProject\src">

      <property name="enableSubPackages" value="true" />

      <property name="trimStrings" value="true" />

    </javaModelGenerator>

    <sqlMapGenerator targetPackage="test.xml"  targetProject="\MBGTestProject\src">

      <property name="enableSubPackages" value="true" />

    </sqlMapGenerator>

    <javaClientGenerator type="XMLMAPPER" targetPackage="test.dao"  targetProject="\MBGTestProject\src">

      <property name="enableSubPackages" value="true" />

    </javaClientGenerator>

    <table schema="DB2ADMIN" tableName="ALLTYPES" domainObjectName="Customer" >

      <property name="useActualColumnNames" value="true"/>

      <generatedKey column="ID" sqlStatement="DB2" identity="true" />

      <columnOverride column="DATE_FIELD" property="startDate" />

      <ignoreColumn column="FRED" />

      <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" />

    </table>

  </context>

</generatorConfiguration>

老大的视频是自己写的代码生成，根据excel生成model、接口、实现类、测试类等等，感觉很强大