基于mybatis的技术分享

<build>
        <plugins>
            <plugin>
                <!-- 用于mybatis编译-->
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven- plugin</artifactId>
                <version>1.3.2</version>
                <dependencies>
                    <dependency>
                        <groupId>com.wisedu.amp</groupId>
                        <artifactId>amp-common-utils</artifactId>
                        <version>0.0.1</version>
                    </dependency>
                </dependencies>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>
        </plugins>
    </build>

jdbc.driverLocation=D:\\TOOLS\\mavenRepository\\mavenRepository\\mysql\\mysql-connector-java\\5.1.25\\mysql-connector-java-5.1.25.jar
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.connectionURL=jdbc:mysql://ip:端口号/数据库名
jdbc.userId=数据库账号
jdbc.password=数据库密码

<?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>
    <!--导入属性配置 -->
    <properties resource="generator.properties"></properties>

    <!--指定特定数据库的jdbc驱动jar包的位置 -->
    <classPathEntry location="${jdbc.driverLocation}"/>

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

        <plugin type="com.wisedu.amp.base.plugin.MyBatisRenameMapper2DaoPlugin">
            <property name="searchString" value="Mapper"/>
            <property name="replaceString" value="Dao"/>
        </plugin>

        <!-- optional，旨在创建class时，对注释进行控制 -->
        <commentGenerator>
            <property name="suppressDate" value="true"/>
        </commentGenerator>

        <!--jdbc的数据库连接 -->
        <jdbcConnection driverClass="${jdbc.driverClass}" connectionURL="${jdbc.connectionURL}"       userId="${jdbc.userId}"  password="${jdbc.password}">
        </jdbcConnection>

        <!-- 非必需，类型处理器，在数据库类型和java类型之间的转换控制-->
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <javaModelGenerator targetPackage="com.wisedu.amp.cloud.entity.generated" targetProject="src/main/java">
            <!-- 是否对类CHAR类型的列的数据进行trim操作 -->
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!--Mapper映射文件生成所在的目录 为每一个数据库的表生成对应的SqlMap文件 (dao)-->
        <sqlMapGenerator targetPackage="sqlMapper/generated" targetProject="src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <javaClientGenerator targetPackage="com.wisedu.amp.cloud.dao.generated" targetProject="src/main/java" type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
        <table tableName="t_ampc_app_category" domainObjectName="CategoryInfo" enableCountByExample="false">      
    </context>
</generatorConfiguration>

<resultMap id="BaseResultMap" type="com.wisedu.amp.cloud.entity.generated.SchoolInfo">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="SCHOOL_ID" jdbcType="VARCHAR" property="schoolId" />
    <result column="SCHOOL_NUM" jdbcType="VARCHAR" property="schoolNum" />
    <result column="SCHOOL_NAME" jdbcType="VARCHAR" property="schoolName" />
    <result column="SHORT_NAME" jdbcType="VARCHAR" property="shortName" />
    <result column="PLATFORM" jdbcType="INTEGER" property="platform" />
    <result column="DOMAIN_NAME" jdbcType="VARCHAR" property="domainName" />
    <result column="AREA_ID" jdbcType="VARCHAR" property="areaId" />
    <result column="IDENTITY_DOMAIN_NAME" jdbcType="VARCHAR" property="identityDomainName" />
    <result column="IDENTITY_VERSION" jdbcType="INTEGER" property="identityVersion" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    SCHOOL_ID, SCHOOL_NUM, SCHOOL_NAME, SHORT_NAME, PLATFORM, DOMAIN_NAME, AREA_ID, IDENTITY_DOMAIN_NAME, 
    IDENTITY_VERSION
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from t_ampc_school_info
    where SCHOOL_ID = #{schoolId,jdbcType=VARCHAR}
  </select>

<insert id="insertSelective" parameterType="com.wisedu.amp.cloud.entity.generated.SchoolInfo">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into t_ampc_school_info
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="schoolId != null">
        SCHOOL_ID,
      </if>
      <if test="schoolNum != null">
        SCHOOL_NUM,
      </if>
      <if test="schoolName != null">
        SCHOOL_NAME,
      </if>
      <if test="shortName != null">
        SHORT_NAME,
      </if>
      <if test="platform != null">
        PLATFORM,
      </if>
      <if test="domainName != null">
        DOMAIN_NAME,
      </if>
      <if test="areaId != null">
        AREA_ID,
      </if>
      <if test="identityDomainName != null">
        IDENTITY_DOMAIN_NAME,
      </if>
      <if test="identityVersion != null">
        IDENTITY_VERSION,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="schoolId != null">
        #{schoolId,jdbcType=VARCHAR},
      </if>
      <if test="schoolNum != null">
        #{schoolNum,jdbcType=VARCHAR},
      </if>
      <if test="schoolName != null">
        #{schoolName,jdbcType=VARCHAR},
      </if>
      <if test="shortName != null">
        #{shortName,jdbcType=VARCHAR},
      </if>
      <if test="platform != null">
        #{platform,jdbcType=INTEGER},
      </if>
      <if test="domainName != null">
        #{domainName,jdbcType=VARCHAR},
      </if>
      <if test="areaId != null">
        #{areaId,jdbcType=VARCHAR},
      </if>
      <if test="identityDomainName != null">
        #{identityDomainName,jdbcType=VARCHAR},
      </if>
      <if test="identityVersion != null">
        #{identityVersion,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>