AI 助理
文档备案控制台
开发者社区 开发与运维 文章 正文

mybatis-generator扩展教程系列 -- 自定义sql xml文件

2016-12-15 1284
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：          今天抽空写一下生成器比较重要的环节,如何自定义mybatis生成器的sql xml文件,因为原生出来的格式不好看,命名也不符合我们日常使用习惯,很多冗余的sql节点,下面我直接直入主题演示代码了,还是老规矩使用之前教程延续下来的项目用例1.

         今天抽空写一下生成器比较重要的环节,如何自定义mybatis生成器的sql xml文件,因为原生出来的格式不好看,命名也不符合我们日常使用习惯,很多冗余的sql节点,下面我直接直入主题演示代码了,还是老规矩使用之前教程延续下来的项目用例


1.先看看我们原始生成出来的mapper.xml文件,1.节点间没有空行不符合我们日常格式 2.CRUD方法太累赘,我们其实只需要insert,update,delete,select

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.dao.QfdSketchMapper">
  <resultMap id="BaseResultMap" type="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="courseName" jdbcType="VARCHAR" property="coursename" />
    <result column="courseReq" jdbcType="VARCHAR" property="coursereq" />
    <result column="teaId" jdbcType="VARCHAR" property="teaid" />
    <result column="teaName" jdbcType="VARCHAR" property="teaname" />
    <result column="stuId" jdbcType="VARCHAR" property="stuid" />
    <result column="stuName" jdbcType="VARCHAR" property="stuname" />
    <result column="stuPhone" jdbcType="VARCHAR" property="stuphone" />
    <result column="textbookId" jdbcType="BIGINT" property="textbookid" />
    <result column="creator" jdbcType="VARCHAR" property="creator" />
    <result column="lastModifier" jdbcType="VARCHAR" property="lastmodifier" />
    <result column="countDate" jdbcType="INTEGER" property="countdate" />
    <result column="countTime" jdbcType="INTEGER" property="counttime" />
    <result column="countStu" jdbcType="INTEGER" property="countstu" />
    <result column="sketchType" jdbcType="INTEGER" property="sketchtype" />
    <result column="courseStyle" jdbcType="INTEGER" property="coursestyle" />
    <result column="classType" jdbcType="INTEGER" property="classtype" />
    <result column="process" jdbcType="INTEGER" property="process" />
    <result column="courseStatus" jdbcType="INTEGER" property="coursestatus" />
    <result column="pay" jdbcType="VARCHAR" property="pay" />
    <result column="perPay" jdbcType="VARCHAR" property="perpay" />
    <result column="couponPay" jdbcType="VARCHAR" property="couponpay" />
    <result column="originalPay" jdbcType="VARCHAR" property="originalpay" />
    <result column="couponRule" jdbcType="INTEGER" property="couponrule" />
    <result column="beginDate" jdbcType="BIGINT" property="begindate" />
    <result column="endDate" jdbcType="BIGINT" property="enddate" />
    <result column="courseNum" jdbcType="INTEGER" property="coursenum" />
    <result column="hasNum" jdbcType="INTEGER" property="hasnum" />
    <result column="cancelNum" jdbcType="INTEGER" property="cancelnum" />
    <result column="courseNumInput" jdbcType="INTEGER" property="coursenuminput" />
    <result column="orderNum" jdbcType="INTEGER" property="ordernum" />
    <result column="fav" jdbcType="BIGINT" property="fav" />
    <result column="vipLevel" jdbcType="INTEGER" property="viplevel" />
    <result column="cancelReason" jdbcType="INTEGER" property="cancelreason" />
    <result column="createDate" jdbcType="BIGINT" property="createdate" />
    <result column="lastModDate" jdbcType="BIGINT" property="lastmoddate" />
    <result column="formatter" jdbcType="VARCHAR" property="formatter" />
    <result column="status" jdbcType="TINYINT" property="status" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    id, courseName, courseReq, teaId, teaName, stuId, stuName, stuPhone, textbookId, 
    creator, lastModifier, countDate, countTime, countStu, sketchType, courseStyle, classType, 
    process, courseStatus, pay, perPay, couponPay, originalPay, couponRule, beginDate, 
    endDate, courseNum, hasNum, cancelNum, courseNumInput, orderNum, fav, vipLevel, cancelReason, 
    createDate, lastModDate, formatter, status
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from qfd_sketch
    where id = #{id,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from qfd_sketch
    where id = #{id,jdbcType=BIGINT}
  </delete>
  <insert id="insert" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into qfd_sketch (id, courseName, courseReq, 
      teaId, teaName, stuId, 
      stuName, stuPhone, textbookId, 
      creator, lastModifier, countDate, 
      countTime, countStu, sketchType, 
      courseStyle, classType, process, 
      courseStatus, pay, perPay, 
      couponPay, originalPay, couponRule, 
      beginDate, endDate, courseNum, 
      hasNum, cancelNum, courseNumInput, 
      orderNum, fav, vipLevel, 
      cancelReason, createDate, lastModDate, 
      formatter, status)
    values (#{id,jdbcType=BIGINT}, #{coursename,jdbcType=VARCHAR}, #{coursereq,jdbcType=VARCHAR}, 
      #{teaid,jdbcType=VARCHAR}, #{teaname,jdbcType=VARCHAR}, #{stuid,jdbcType=VARCHAR}, 
      #{stuname,jdbcType=VARCHAR}, #{stuphone,jdbcType=VARCHAR}, #{textbookid,jdbcType=BIGINT}, 
      #{creator,jdbcType=VARCHAR}, #{lastmodifier,jdbcType=VARCHAR}, #{countdate,jdbcType=INTEGER}, 
      #{counttime,jdbcType=INTEGER}, #{countstu,jdbcType=INTEGER}, #{sketchtype,jdbcType=INTEGER}, 
      #{coursestyle,jdbcType=INTEGER}, #{classtype,jdbcType=INTEGER}, #{process,jdbcType=INTEGER}, 
      #{coursestatus,jdbcType=INTEGER}, #{pay,jdbcType=VARCHAR}, #{perpay,jdbcType=VARCHAR}, 
      #{couponpay,jdbcType=VARCHAR}, #{originalpay,jdbcType=VARCHAR}, #{couponrule,jdbcType=INTEGER}, 
      #{begindate,jdbcType=BIGINT}, #{enddate,jdbcType=BIGINT}, #{coursenum,jdbcType=INTEGER}, 
      #{hasnum,jdbcType=INTEGER}, #{cancelnum,jdbcType=INTEGER}, #{coursenuminput,jdbcType=INTEGER}, 
      #{ordernum,jdbcType=INTEGER}, #{fav,jdbcType=BIGINT}, #{viplevel,jdbcType=INTEGER}, 
      #{cancelreason,jdbcType=INTEGER}, #{createdate,jdbcType=BIGINT}, #{lastmoddate,jdbcType=BIGINT}, 
      #{formatter,jdbcType=VARCHAR}, #{status,jdbcType=TINYINT})
  </insert>
  <insert id="insertSelective" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into qfd_sketch
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="coursename != null">
        courseName,
      </if>
      <if test="coursereq != null">
        courseReq,
      </if>
      <if test="teaid != null">
        teaId,
      </if>
      <if test="teaname != null">
        teaName,
      </if>
      <if test="stuid != null">
        stuId,
      </if>
      <if test="stuname != null">
        stuName,
      </if>
      <if test="stuphone != null">
        stuPhone,
      </if>
      <if test="textbookid != null">
        textbookId,
      </if>
      <if test="creator != null">
        creator,
      </if>
      <if test="lastmodifier != null">
        lastModifier,
      </if>
      <if test="countdate != null">
        countDate,
      </if>
      <if test="counttime != null">
        countTime,
      </if>
      <if test="countstu != null">
        countStu,
      </if>
      <if test="sketchtype != null">
        sketchType,
      </if>
      <if test="coursestyle != null">
        courseStyle,
      </if>
      <if test="classtype != null">
        classType,
      </if>
      <if test="process != null">
        process,
      </if>
      <if test="coursestatus != null">
        courseStatus,
      </if>
      <if test="pay != null">
        pay,
      </if>
      <if test="perpay != null">
        perPay,
      </if>
      <if test="couponpay != null">
        couponPay,
      </if>
      <if test="originalpay != null">
        originalPay,
      </if>
      <if test="couponrule != null">
        couponRule,
      </if>
      <if test="begindate != null">
        beginDate,
      </if>
      <if test="enddate != null">
        endDate,
      </if>
      <if test="coursenum != null">
        courseNum,
      </if>
      <if test="hasnum != null">
        hasNum,
      </if>
      <if test="cancelnum != null">
        cancelNum,
      </if>
      <if test="coursenuminput != null">
        courseNumInput,
      </if>
      <if test="ordernum != null">
        orderNum,
      </if>
      <if test="fav != null">
        fav,
      </if>
      <if test="viplevel != null">
        vipLevel,
      </if>
      <if test="cancelreason != null">
        cancelReason,
      </if>
      <if test="createdate != null">
        createDate,
      </if>
      <if test="lastmoddate != null">
        lastModDate,
      </if>
      <if test="formatter != null">
        formatter,
      </if>
      <if test="status != null">
        status,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="coursename != null">
        #{coursename,jdbcType=VARCHAR},
      </if>
      <if test="coursereq != null">
        #{coursereq,jdbcType=VARCHAR},
      </if>
      <if test="teaid != null">
        #{teaid,jdbcType=VARCHAR},
      </if>
      <if test="teaname != null">
        #{teaname,jdbcType=VARCHAR},
      </if>
      <if test="stuid != null">
        #{stuid,jdbcType=VARCHAR},
      </if>
      <if test="stuname != null">
        #{stuname,jdbcType=VARCHAR},
      </if>
      <if test="stuphone != null">
        #{stuphone,jdbcType=VARCHAR},
      </if>
      <if test="textbookid != null">
        #{textbookid,jdbcType=BIGINT},
      </if>
      <if test="creator != null">
        #{creator,jdbcType=VARCHAR},
      </if>
      <if test="lastmodifier != null">
        #{lastmodifier,jdbcType=VARCHAR},
      </if>
      <if test="countdate != null">
        #{countdate,jdbcType=INTEGER},
      </if>
      <if test="counttime != null">
        #{counttime,jdbcType=INTEGER},
      </if>
      <if test="countstu != null">
        #{countstu,jdbcType=INTEGER},
      </if>
      <if test="sketchtype != null">
        #{sketchtype,jdbcType=INTEGER},
      </if>
      <if test="coursestyle != null">
        #{coursestyle,jdbcType=INTEGER},
      </if>
      <if test="classtype != null">
        #{classtype,jdbcType=INTEGER},
      </if>
      <if test="process != null">
        #{process,jdbcType=INTEGER},
      </if>
      <if test="coursestatus != null">
        #{coursestatus,jdbcType=INTEGER},
      </if>
      <if test="pay != null">
        #{pay,jdbcType=VARCHAR},
      </if>
      <if test="perpay != null">
        #{perpay,jdbcType=VARCHAR},
      </if>
      <if test="couponpay != null">
        #{couponpay,jdbcType=VARCHAR},
      </if>
      <if test="originalpay != null">
        #{originalpay,jdbcType=VARCHAR},
      </if>
      <if test="couponrule != null">
        #{couponrule,jdbcType=INTEGER},
      </if>
      <if test="begindate != null">
        #{begindate,jdbcType=BIGINT},
      </if>
      <if test="enddate != null">
        #{enddate,jdbcType=BIGINT},
      </if>
      <if test="coursenum != null">
        #{coursenum,jdbcType=INTEGER},
      </if>
      <if test="hasnum != null">
        #{hasnum,jdbcType=INTEGER},
      </if>
      <if test="cancelnum != null">
        #{cancelnum,jdbcType=INTEGER},
      </if>
      <if test="coursenuminput != null">
        #{coursenuminput,jdbcType=INTEGER},
      </if>
      <if test="ordernum != null">
        #{ordernum,jdbcType=INTEGER},
      </if>
      <if test="fav != null">
        #{fav,jdbcType=BIGINT},
      </if>
      <if test="viplevel != null">
        #{viplevel,jdbcType=INTEGER},
      </if>
      <if test="cancelreason != null">
        #{cancelreason,jdbcType=INTEGER},
      </if>
      <if test="createdate != null">
        #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmoddate != null">
        #{lastmoddate,jdbcType=BIGINT},
      </if>
      <if test="formatter != null">
        #{formatter,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        #{status,jdbcType=TINYINT},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update qfd_sketch
    <set>
      <if test="coursename != null">
        courseName = #{coursename,jdbcType=VARCHAR},
      </if>
      <if test="coursereq != null">
        courseReq = #{coursereq,jdbcType=VARCHAR},
      </if>
      <if test="teaid != null">
        teaId = #{teaid,jdbcType=VARCHAR},
      </if>
      <if test="teaname != null">
        teaName = #{teaname,jdbcType=VARCHAR},
      </if>
      <if test="stuid != null">
        stuId = #{stuid,jdbcType=VARCHAR},
      </if>
      <if test="stuname != null">
        stuName = #{stuname,jdbcType=VARCHAR},
      </if>
      <if test="stuphone != null">
        stuPhone = #{stuphone,jdbcType=VARCHAR},
      </if>
      <if test="textbookid != null">
        textbookId = #{textbookid,jdbcType=BIGINT},
      </if>
      <if test="creator != null">
        creator = #{creator,jdbcType=VARCHAR},
      </if>
      <if test="lastmodifier != null">
        lastModifier = #{lastmodifier,jdbcType=VARCHAR},
      </if>
      <if test="countdate != null">
        countDate = #{countdate,jdbcType=INTEGER},
      </if>
      <if test="counttime != null">
        countTime = #{counttime,jdbcType=INTEGER},
      </if>
      <if test="countstu != null">
        countStu = #{countstu,jdbcType=INTEGER},
      </if>
      <if test="sketchtype != null">
        sketchType = #{sketchtype,jdbcType=INTEGER},
      </if>
      <if test="coursestyle != null">
        courseStyle = #{coursestyle,jdbcType=INTEGER},
      </if>
      <if test="classtype != null">
        classType = #{classtype,jdbcType=INTEGER},
      </if>
      <if test="process != null">
        process = #{process,jdbcType=INTEGER},
      </if>
      <if test="coursestatus != null">
        courseStatus = #{coursestatus,jdbcType=INTEGER},
      </if>
      <if test="pay != null">
        pay = #{pay,jdbcType=VARCHAR},
      </if>
      <if test="perpay != null">
        perPay = #{perpay,jdbcType=VARCHAR},
      </if>
      <if test="couponpay != null">
        couponPay = #{couponpay,jdbcType=VARCHAR},
      </if>
      <if test="originalpay != null">
        originalPay = #{originalpay,jdbcType=VARCHAR},
      </if>
      <if test="couponrule != null">
        couponRule = #{couponrule,jdbcType=INTEGER},
      </if>
      <if test="begindate != null">
        beginDate = #{begindate,jdbcType=BIGINT},
      </if>
      <if test="enddate != null">
        endDate = #{enddate,jdbcType=BIGINT},
      </if>
      <if test="coursenum != null">
        courseNum = #{coursenum,jdbcType=INTEGER},
      </if>
      <if test="hasnum != null">
        hasNum = #{hasnum,jdbcType=INTEGER},
      </if>
      <if test="cancelnum != null">
        cancelNum = #{cancelnum,jdbcType=INTEGER},
      </if>
      <if test="coursenuminput != null">
        courseNumInput = #{coursenuminput,jdbcType=INTEGER},
      </if>
      <if test="ordernum != null">
        orderNum = #{ordernum,jdbcType=INTEGER},
      </if>
      <if test="fav != null">
        fav = #{fav,jdbcType=BIGINT},
      </if>
      <if test="viplevel != null">
        vipLevel = #{viplevel,jdbcType=INTEGER},
      </if>
      <if test="cancelreason != null">
        cancelReason = #{cancelreason,jdbcType=INTEGER},
      </if>
      <if test="createdate != null">
        createDate = #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmoddate != null">
        lastModDate = #{lastmoddate,jdbcType=BIGINT},
      </if>
      <if test="formatter != null">
        formatter = #{formatter,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        status = #{status,jdbcType=TINYINT},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update qfd_sketch
    set courseName = #{coursename,jdbcType=VARCHAR},
      courseReq = #{coursereq,jdbcType=VARCHAR},
      teaId = #{teaid,jdbcType=VARCHAR},
      teaName = #{teaname,jdbcType=VARCHAR},
      stuId = #{stuid,jdbcType=VARCHAR},
      stuName = #{stuname,jdbcType=VARCHAR},
      stuPhone = #{stuphone,jdbcType=VARCHAR},
      textbookId = #{textbookid,jdbcType=BIGINT},
      creator = #{creator,jdbcType=VARCHAR},
      lastModifier = #{lastmodifier,jdbcType=VARCHAR},
      countDate = #{countdate,jdbcType=INTEGER},
      countTime = #{counttime,jdbcType=INTEGER},
      countStu = #{countstu,jdbcType=INTEGER},
      sketchType = #{sketchtype,jdbcType=INTEGER},
      courseStyle = #{coursestyle,jdbcType=INTEGER},
      classType = #{classtype,jdbcType=INTEGER},
      process = #{process,jdbcType=INTEGER},
      courseStatus = #{coursestatus,jdbcType=INTEGER},
      pay = #{pay,jdbcType=VARCHAR},
      perPay = #{perpay,jdbcType=VARCHAR},
      couponPay = #{couponpay,jdbcType=VARCHAR},
      originalPay = #{originalpay,jdbcType=VARCHAR},
      couponRule = #{couponrule,jdbcType=INTEGER},
      beginDate = #{begindate,jdbcType=BIGINT},
      endDate = #{enddate,jdbcType=BIGINT},
      courseNum = #{coursenum,jdbcType=INTEGER},
      hasNum = #{hasnum,jdbcType=INTEGER},
      cancelNum = #{cancelnum,jdbcType=INTEGER},
      courseNumInput = #{coursenuminput,jdbcType=INTEGER},
      orderNum = #{ordernum,jdbcType=INTEGER},
      fav = #{fav,jdbcType=BIGINT},
      vipLevel = #{viplevel,jdbcType=INTEGER},
      cancelReason = #{cancelreason,jdbcType=INTEGER},
      createDate = #{createdate,jdbcType=BIGINT},
      lastModDate = #{lastmoddate,jdbcType=BIGINT},
      formatter = #{formatter,jdbcType=VARCHAR},
      status = #{status,jdbcType=TINYINT}
    where id = #{id,jdbcType=BIGINT}
  </update>
</mapper>

2.根据已知问题,我们先处理一下问题吧,保留insert,update,delete方法作为示例,顺便给他们增加隔行的格式化

先看看XMLMapperGenerator.java这个类的getSqlMapElement()方法,可以看到很多addxxx方法,这里就是拼接sql xml文件的逻辑,我们只保留必须的方法

protected XmlElement getSqlMapElement() {
        FullyQualifiedTable table = introspectedTable.getFullyQualifiedTable();
        progressCallback.startTask(getString(
                "Progress.12", table.toString())); //$NON-NLS-1$
        XmlElement answer = new XmlElement("mapper"); //$NON-NLS-1$
        String namespace = introspectedTable.getMyBatis3SqlMapNamespace();
        answer.addAttribute(new Attribute("namespace", //$NON-NLS-1$
                namespace));

        context.getCommentGenerator().addRootComment(answer);

        addResultMapWithoutBLOBsElement(answer);
        addResultMapWithBLOBsElement(answer);
        addExampleWhereClauseElement(answer);
        addMyBatis3UpdateByExampleWhereClauseElement(answer);
        addBaseColumnListElement(answer);
        addBlobColumnListElement(answer);
        addSelectByExampleWithBLOBsElement(answer);
        addSelectByExampleWithoutBLOBsElement(answer);
        addSelectByPrimaryKeyElement(answer);
        addDeleteByPrimaryKeyElement(answer);
        addDeleteByExampleElement(answer);
        addInsertElement(answer);
        addInsertSelectiveElement(answer);
        addCountByExampleElement(answer);
        addUpdateByExampleSelectiveElement(answer);
        addUpdateByExampleWithBLOBsElement(answer);
        addUpdateByExampleWithoutBLOBsElement(answer);
        addUpdateByPrimaryKeySelectiveElement(answer);
        addUpdateByPrimaryKeyWithBLOBsElement(answer);
        addUpdateByPrimaryKeyWithoutBLOBsElement(answer);
        
        return answer;
    }

修改后的方法 

protected XmlElement getSqlMapElement() {
        FullyQualifiedTable table = introspectedTable.getFullyQualifiedTable();
        progressCallback.startTask(getString(
                "Progress.12", table.toString())); //$NON-NLS-1$
        XmlElement answer = new XmlElement("mapper"); //$NON-NLS-1$
        String namespace = introspectedTable.getMyBatis3SqlMapNamespace();
        answer.addAttribute(new Attribute("namespace", //$NON-NLS-1$
                namespace));

        context.getCommentGenerator().addRootComment(answer);

//        addResultMapWithoutBLOBsElement(answer);
//        addResultMapWithBLOBsElement(answer);
//        addExampleWhereClauseElement(answer);
//        addMyBatis3UpdateByExampleWhereClauseElement(answer);
//        addBaseColumnListElement(answer);
//        addBlobColumnListElement(answer);
//        addSelectByExampleWithBLOBsElement(answer);
//        addSelectByExampleWithoutBLOBsElement(answer);
//        addSelectByPrimaryKeyElement(answer);
//        addDeleteByPrimaryKeyElement(answer);
//        addDeleteByExampleElement(answer);
//        addInsertElement(answer);
//        addInsertSelectiveElement(answer);
//        addCountByExampleElement(answer);
//        addUpdateByExampleSelectiveElement(answer);
//        addUpdateByExampleWithBLOBsElement(answer);
//        addUpdateByExampleWithoutBLOBsElement(answer);
//        addUpdateByPrimaryKeySelectiveElement(answer);
//        addUpdateByPrimaryKeyWithBLOBsElement(answer);
//        addUpdateByPrimaryKeyWithoutBLOBsElement(answer);
        
        addResultMapWithoutBLOBsElement(answer);
        addBaseColumnListElement(answer);
        addInsertSelectiveElement(answer);
        addUpdateByPrimaryKeySelectiveElement(answer);
        addDeleteByPrimaryKeyElement(answer);

        return answer;
    }

3.修改这个方法后,我们运行下生成文件看看效果 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.dao.QfdSketchMapper">
  <resultMap id="BaseResultMap" type="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="courseName" jdbcType="VARCHAR" property="coursename" />
    <result column="courseReq" jdbcType="VARCHAR" property="coursereq" />
    <result column="teaId" jdbcType="VARCHAR" property="teaid" />
    <result column="teaName" jdbcType="VARCHAR" property="teaname" />
    <result column="stuId" jdbcType="VARCHAR" property="stuid" />
    <result column="stuName" jdbcType="VARCHAR" property="stuname" />
    <result column="stuPhone" jdbcType="VARCHAR" property="stuphone" />
    <result column="textbookId" jdbcType="BIGINT" property="textbookid" />
    <result column="creator" jdbcType="VARCHAR" property="creator" />
    <result column="lastModifier" jdbcType="VARCHAR" property="lastmodifier" />
    <result column="countDate" jdbcType="INTEGER" property="countdate" />
    <result column="countTime" jdbcType="INTEGER" property="counttime" />
    <result column="countStu" jdbcType="INTEGER" property="countstu" />
    <result column="sketchType" jdbcType="INTEGER" property="sketchtype" />
    <result column="courseStyle" jdbcType="INTEGER" property="coursestyle" />
    <result column="classType" jdbcType="INTEGER" property="classtype" />
    <result column="process" jdbcType="INTEGER" property="process" />
    <result column="courseStatus" jdbcType="INTEGER" property="coursestatus" />
    <result column="pay" jdbcType="VARCHAR" property="pay" />
    <result column="perPay" jdbcType="VARCHAR" property="perpay" />
    <result column="couponPay" jdbcType="VARCHAR" property="couponpay" />
    <result column="originalPay" jdbcType="VARCHAR" property="originalpay" />
    <result column="couponRule" jdbcType="INTEGER" property="couponrule" />
    <result column="beginDate" jdbcType="BIGINT" property="begindate" />
    <result column="endDate" jdbcType="BIGINT" property="enddate" />
    <result column="courseNum" jdbcType="INTEGER" property="coursenum" />
    <result column="hasNum" jdbcType="INTEGER" property="hasnum" />
    <result column="cancelNum" jdbcType="INTEGER" property="cancelnum" />
    <result column="courseNumInput" jdbcType="INTEGER" property="coursenuminput" />
    <result column="orderNum" jdbcType="INTEGER" property="ordernum" />
    <result column="fav" jdbcType="BIGINT" property="fav" />
    <result column="vipLevel" jdbcType="INTEGER" property="viplevel" />
    <result column="cancelReason" jdbcType="INTEGER" property="cancelreason" />
    <result column="createDate" jdbcType="BIGINT" property="createdate" />
    <result column="lastModDate" jdbcType="BIGINT" property="lastmoddate" />
    <result column="formatter" jdbcType="VARCHAR" property="formatter" />
    <result column="status" jdbcType="TINYINT" property="status" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    id, courseName, courseReq, teaId, teaName, stuId, stuName, stuPhone, textbookId, 
    creator, lastModifier, countDate, countTime, countStu, sketchType, courseStyle, classType, 
    process, courseStatus, pay, perPay, couponPay, originalPay, couponRule, beginDate, 
    endDate, courseNum, hasNum, cancelNum, courseNumInput, orderNum, fav, vipLevel, cancelReason, 
    createDate, lastModDate, formatter, status
  </sql>
  <insert id="insertSelective" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into qfd_sketch
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="coursename != null">
        courseName,
      </if>
      <if test="coursereq != null">
        courseReq,
      </if>
      <if test="teaid != null">
        teaId,
      </if>
      <if test="teaname != null">
        teaName,
      </if>
      <if test="stuid != null">
        stuId,
      </if>
      <if test="stuname != null">
        stuName,
      </if>
      <if test="stuphone != null">
        stuPhone,
      </if>
      <if test="textbookid != null">
        textbookId,
      </if>
      <if test="creator != null">
        creator,
      </if>
      <if test="lastmodifier != null">
        lastModifier,
      </if>
      <if test="countdate != null">
        countDate,
      </if>
      <if test="counttime != null">
        countTime,
      </if>
      <if test="countstu != null">
        countStu,
      </if>
      <if test="sketchtype != null">
        sketchType,
      </if>
      <if test="coursestyle != null">
        courseStyle,
      </if>
      <if test="classtype != null">
        classType,
      </if>
      <if test="process != null">
        process,
      </if>
      <if test="coursestatus != null">
        courseStatus,
      </if>
      <if test="pay != null">
        pay,
      </if>
      <if test="perpay != null">
        perPay,
      </if>
      <if test="couponpay != null">
        couponPay,
      </if>
      <if test="originalpay != null">
        originalPay,
      </if>
      <if test="couponrule != null">
        couponRule,
      </if>
      <if test="begindate != null">
        beginDate,
      </if>
      <if test="enddate != null">
        endDate,
      </if>
      <if test="coursenum != null">
        courseNum,
      </if>
      <if test="hasnum != null">
        hasNum,
      </if>
      <if test="cancelnum != null">
        cancelNum,
      </if>
      <if test="coursenuminput != null">
        courseNumInput,
      </if>
      <if test="ordernum != null">
        orderNum,
      </if>
      <if test="fav != null">
        fav,
      </if>
      <if test="viplevel != null">
        vipLevel,
      </if>
      <if test="cancelreason != null">
        cancelReason,
      </if>
      <if test="createdate != null">
        createDate,
      </if>
      <if test="lastmoddate != null">
        lastModDate,
      </if>
      <if test="formatter != null">
        formatter,
      </if>
      <if test="status != null">
        status,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="coursename != null">
        #{coursename,jdbcType=VARCHAR},
      </if>
      <if test="coursereq != null">
        #{coursereq,jdbcType=VARCHAR},
      </if>
      <if test="teaid != null">
        #{teaid,jdbcType=VARCHAR},
      </if>
      <if test="teaname != null">
        #{teaname,jdbcType=VARCHAR},
      </if>
      <if test="stuid != null">
        #{stuid,jdbcType=VARCHAR},
      </if>
      <if test="stuname != null">
        #{stuname,jdbcType=VARCHAR},
      </if>
      <if test="stuphone != null">
        #{stuphone,jdbcType=VARCHAR},
      </if>
      <if test="textbookid != null">
        #{textbookid,jdbcType=BIGINT},
      </if>
      <if test="creator != null">
        #{creator,jdbcType=VARCHAR},
      </if>
      <if test="lastmodifier != null">
        #{lastmodifier,jdbcType=VARCHAR},
      </if>
      <if test="countdate != null">
        #{countdate,jdbcType=INTEGER},
      </if>
      <if test="counttime != null">
        #{counttime,jdbcType=INTEGER},
      </if>
      <if test="countstu != null">
        #{countstu,jdbcType=INTEGER},
      </if>
      <if test="sketchtype != null">
        #{sketchtype,jdbcType=INTEGER},
      </if>
      <if test="coursestyle != null">
        #{coursestyle,jdbcType=INTEGER},
      </if>
      <if test="classtype != null">
        #{classtype,jdbcType=INTEGER},
      </if>
      <if test="process != null">
        #{process,jdbcType=INTEGER},
      </if>
      <if test="coursestatus != null">
        #{coursestatus,jdbcType=INTEGER},
      </if>
      <if test="pay != null">
        #{pay,jdbcType=VARCHAR},
      </if>
      <if test="perpay != null">
        #{perpay,jdbcType=VARCHAR},
      </if>
      <if test="couponpay != null">
        #{couponpay,jdbcType=VARCHAR},
      </if>
      <if test="originalpay != null">
        #{originalpay,jdbcType=VARCHAR},
      </if>
      <if test="couponrule != null">
        #{couponrule,jdbcType=INTEGER},
      </if>
      <if test="begindate != null">
        #{begindate,jdbcType=BIGINT},
      </if>
      <if test="enddate != null">
        #{enddate,jdbcType=BIGINT},
      </if>
      <if test="coursenum != null">
        #{coursenum,jdbcType=INTEGER},
      </if>
      <if test="hasnum != null">
        #{hasnum,jdbcType=INTEGER},
      </if>
      <if test="cancelnum != null">
        #{cancelnum,jdbcType=INTEGER},
      </if>
      <if test="coursenuminput != null">
        #{coursenuminput,jdbcType=INTEGER},
      </if>
      <if test="ordernum != null">
        #{ordernum,jdbcType=INTEGER},
      </if>
      <if test="fav != null">
        #{fav,jdbcType=BIGINT},
      </if>
      <if test="viplevel != null">
        #{viplevel,jdbcType=INTEGER},
      </if>
      <if test="cancelreason != null">
        #{cancelreason,jdbcType=INTEGER},
      </if>
      <if test="createdate != null">
        #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmoddate != null">
        #{lastmoddate,jdbcType=BIGINT},
      </if>
      <if test="formatter != null">
        #{formatter,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        #{status,jdbcType=TINYINT},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.test.domain.QfdSketch">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update qfd_sketch
    <set>
      <if test="coursename != null">
        courseName = #{coursename,jdbcType=VARCHAR},
      </if>
      <if test="coursereq != null">
        courseReq = #{coursereq,jdbcType=VARCHAR},
      </if>
      <if test="teaid != null">
        teaId = #{teaid,jdbcType=VARCHAR},
      </if>
      <if test="teaname != null">
        teaName = #{teaname,jdbcType=VARCHAR},
      </if>
      <if test="stuid != null">
        stuId = #{stuid,jdbcType=VARCHAR},
      </if>
      <if test="stuname != null">
        stuName = #{stuname,jdbcType=VARCHAR},
      </if>
      <if test="stuphone != null">
        stuPhone = #{stuphone,jdbcType=VARCHAR},
      </if>
      <if test="textbookid != null">
        textbookId = #{textbookid,jdbcType=BIGINT},
      </if>
      <if test="creator != null">
        creator = #{creator,jdbcType=VARCHAR},
      </if>
      <if test="lastmodifier != null">
        lastModifier = #{lastmodifier,jdbcType=VARCHAR},
      </if>
      <if test="countdate != null">
        countDate = #{countdate,jdbcType=INTEGER},
      </if>
      <if test="counttime != null">
        countTime = #{counttime,jdbcType=INTEGER},
      </if>
      <if test="countstu != null">
        countStu = #{countstu,jdbcType=INTEGER},
      </if>
      <if test="sketchtype != null">
        sketchType = #{sketchtype,jdbcType=INTEGER},
      </if>
      <if test="coursestyle != null">
        courseStyle = #{coursestyle,jdbcType=INTEGER},
      </if>
      <if test="classtype != null">
        classType = #{classtype,jdbcType=INTEGER},
      </if>
      <if test="process != null">
        process = #{process,jdbcType=INTEGER},
      </if>
      <if test="coursestatus != null">
        courseStatus = #{coursestatus,jdbcType=INTEGER},
      </if>
      <if test="pay != null">
        pay = #{pay,jdbcType=VARCHAR},
      </if>
      <if test="perpay != null">
        perPay = #{perpay,jdbcType=VARCHAR},
      </if>
      <if test="couponpay != null">
        couponPay = #{couponpay,jdbcType=VARCHAR},
      </if>
      <if test="originalpay != null">
        originalPay = #{originalpay,jdbcType=VARCHAR},
      </if>
      <if test="couponrule != null">
        couponRule = #{couponrule,jdbcType=INTEGER},
      </if>
      <if test="begindate != null">
        beginDate = #{begindate,jdbcType=BIGINT},
      </if>
      <if test="enddate != null">
        endDate = #{enddate,jdbcType=BIGINT},
      </if>
      <if test="coursenum != null">
        courseNum = #{coursenum,jdbcType=INTEGER},
      </if>
      <if test="hasnum != null">
        hasNum = #{hasnum,jdbcType=INTEGER},
      </if>
      <if test="cancelnum != null">
        cancelNum = #{cancelnum,jdbcType=INTEGER},
      </if>
      <if test="coursenuminput != null">
        courseNumInput = #{coursenuminput,jdbcType=INTEGER},
      </if>
      <if test="ordernum != null">
        orderNum = #{ordernum,jdbcType=INTEGER},
      </if>
      <if test="fav != null">
        fav = #{fav,jdbcType=BIGINT},
      </if>
      <if test="viplevel != null">
        vipLevel = #{viplevel,jdbcType=INTEGER},
      </if>
      <if test="cancelreason != null">
        cancelReason = #{cancelreason,jdbcType=INTEGER},
      </if>
      <if test="createdate != null">
        createDate = #{createdate,jdbcType=BIGINT},
      </if>
      <if test="lastmoddate != null">
        lastModDate = #{lastmoddate,jdbcType=BIGINT},
      </if>
      <if test="formatter != null">
        formatter = #{formatter,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        status = #{status,jdbcType=TINYINT},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from qfd_sketch
    where id = #{id,jdbcType=BIGINT}
  </delete>
</mapper>


4.看到上面的文件后发现已经达到我们一个目的了,把多余的方法给去掉,但是格式不够好看,我们来完成下面一个目标,增加sql节点隔行以及修改sql语句缩进格式

继续看XMLMapperGenerator.java类的initializeAndExecuteGenerator()方法

protected void initializeAndExecuteGenerator(
            AbstractXmlElementGenerator elementGenerator,
            XmlElement parentElement) {
        elementGenerator.setContext(context);
        elementGenerator.setIntrospectedTable(introspectedTable);
        elementGenerator.setProgressCallback(progressCallback);
        elementGenerator.setWarnings(warnings);
        elementGenerator.addElements(parentElement);
    }

修改后的方法 

protected void initializeAndExecuteGenerator(
            AbstractXmlElementGenerator elementGenerator,
            XmlElement parentElement) {
        elementGenerator.setContext(context);
        elementGenerator.setIntrospectedTable(introspectedTable);
        elementGenerator.setProgressCallback(progressCallback);
        elementGenerator.setWarnings(warnings);
        parentElement.addElement(new TextElement("")); // 增加一行空白的隔行
        elementGenerator.addElements(parentElement);
    }


打开OutputUtilities.java方法看

public static void xmlIndent(StringBuilder sb, int indentLevel) {
        for (int i = 0; i < indentLevel; i++) {
            sb.append("  "); //$NON-NLS-1$
        }
    }

把两个空格符变成4个空格符 

public static void xmlIndent(StringBuilder sb, int indentLevel) {
        for (int i = 0; i < indentLevel; i++) {
        	// sb.append("  "); //$NON-NLS-1$
        	sb.append("    "); // 4个空格符
        }
    }


5.修改方法后我们重新生成下xml文件看看效果

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.dao.QfdSketchMapper">
    
    <resultMap id="BaseResultMap" type="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        <id column="id" jdbcType="BIGINT" property="id" />
        <result column="courseName" jdbcType="VARCHAR" property="coursename" />
        <result column="courseReq" jdbcType="VARCHAR" property="coursereq" />
        <result column="teaId" jdbcType="VARCHAR" property="teaid" />
        <result column="teaName" jdbcType="VARCHAR" property="teaname" />
        <result column="stuId" jdbcType="VARCHAR" property="stuid" />
        <result column="stuName" jdbcType="VARCHAR" property="stuname" />
        <result column="stuPhone" jdbcType="VARCHAR" property="stuphone" />
        <result column="textbookId" jdbcType="BIGINT" property="textbookid" />
        <result column="creator" jdbcType="VARCHAR" property="creator" />
        <result column="lastModifier" jdbcType="VARCHAR" property="lastmodifier" />
        <result column="countDate" jdbcType="INTEGER" property="countdate" />
        <result column="countTime" jdbcType="INTEGER" property="counttime" />
        <result column="countStu" jdbcType="INTEGER" property="countstu" />
        <result column="sketchType" jdbcType="INTEGER" property="sketchtype" />
        <result column="courseStyle" jdbcType="INTEGER" property="coursestyle" />
        <result column="classType" jdbcType="INTEGER" property="classtype" />
        <result column="process" jdbcType="INTEGER" property="process" />
        <result column="courseStatus" jdbcType="INTEGER" property="coursestatus" />
        <result column="pay" jdbcType="VARCHAR" property="pay" />
        <result column="perPay" jdbcType="VARCHAR" property="perpay" />
        <result column="couponPay" jdbcType="VARCHAR" property="couponpay" />
        <result column="originalPay" jdbcType="VARCHAR" property="originalpay" />
        <result column="couponRule" jdbcType="INTEGER" property="couponrule" />
        <result column="beginDate" jdbcType="BIGINT" property="begindate" />
        <result column="endDate" jdbcType="BIGINT" property="enddate" />
        <result column="courseNum" jdbcType="INTEGER" property="coursenum" />
        <result column="hasNum" jdbcType="INTEGER" property="hasnum" />
        <result column="cancelNum" jdbcType="INTEGER" property="cancelnum" />
        <result column="courseNumInput" jdbcType="INTEGER" property="coursenuminput" />
        <result column="orderNum" jdbcType="INTEGER" property="ordernum" />
        <result column="fav" jdbcType="BIGINT" property="fav" />
        <result column="vipLevel" jdbcType="INTEGER" property="viplevel" />
        <result column="cancelReason" jdbcType="INTEGER" property="cancelreason" />
        <result column="createDate" jdbcType="BIGINT" property="createdate" />
        <result column="lastModDate" jdbcType="BIGINT" property="lastmoddate" />
        <result column="formatter" jdbcType="VARCHAR" property="formatter" />
        <result column="status" jdbcType="TINYINT" property="status" />
    </resultMap>
    
    <sql id="Base_Column_List">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        id, courseName, courseReq, teaId, teaName, stuId, stuName, stuPhone, textbookId, 
        creator, lastModifier, countDate, countTime, countStu, sketchType, courseStyle, classType, 
        process, courseStatus, pay, perPay, couponPay, originalPay, couponRule, beginDate, 
        endDate, courseNum, hasNum, cancelNum, courseNumInput, orderNum, fav, vipLevel, cancelReason, 
        createDate, lastModDate, formatter, status
    </sql>
    
    <insert id="insertSelective" parameterType="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        insert into qfd_sketch
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="coursename != null">
                courseName,
            </if>
            <if test="coursereq != null">
                courseReq,
            </if>
            <if test="teaid != null">
                teaId,
            </if>
            <if test="teaname != null">
                teaName,
            </if>
            <if test="stuid != null">
                stuId,
            </if>
            <if test="stuname != null">
                stuName,
            </if>
            <if test="stuphone != null">
                stuPhone,
            </if>
            <if test="textbookid != null">
                textbookId,
            </if>
            <if test="creator != null">
                creator,
            </if>
            <if test="lastmodifier != null">
                lastModifier,
            </if>
            <if test="countdate != null">
                countDate,
            </if>
            <if test="counttime != null">
                countTime,
            </if>
            <if test="countstu != null">
                countStu,
            </if>
            <if test="sketchtype != null">
                sketchType,
            </if>
            <if test="coursestyle != null">
                courseStyle,
            </if>
            <if test="classtype != null">
                classType,
            </if>
            <if test="process != null">
                process,
            </if>
            <if test="coursestatus != null">
                courseStatus,
            </if>
            <if test="pay != null">
                pay,
            </if>
            <if test="perpay != null">
                perPay,
            </if>
            <if test="couponpay != null">
                couponPay,
            </if>
            <if test="originalpay != null">
                originalPay,
            </if>
            <if test="couponrule != null">
                couponRule,
            </if>
            <if test="begindate != null">
                beginDate,
            </if>
            <if test="enddate != null">
                endDate,
            </if>
            <if test="coursenum != null">
                courseNum,
            </if>
            <if test="hasnum != null">
                hasNum,
            </if>
            <if test="cancelnum != null">
                cancelNum,
            </if>
            <if test="coursenuminput != null">
                courseNumInput,
            </if>
            <if test="ordernum != null">
                orderNum,
            </if>
            <if test="fav != null">
                fav,
            </if>
            <if test="viplevel != null">
                vipLevel,
            </if>
            <if test="cancelreason != null">
                cancelReason,
            </if>
            <if test="createdate != null">
                createDate,
            </if>
            <if test="lastmoddate != null">
                lastModDate,
            </if>
            <if test="formatter != null">
                formatter,
            </if>
            <if test="status != null">
                status,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=BIGINT},
            </if>
            <if test="coursename != null">
                #{coursename,jdbcType=VARCHAR},
            </if>
            <if test="coursereq != null">
                #{coursereq,jdbcType=VARCHAR},
            </if>
            <if test="teaid != null">
                #{teaid,jdbcType=VARCHAR},
            </if>
            <if test="teaname != null">
                #{teaname,jdbcType=VARCHAR},
            </if>
            <if test="stuid != null">
                #{stuid,jdbcType=VARCHAR},
            </if>
            <if test="stuname != null">
                #{stuname,jdbcType=VARCHAR},
            </if>
            <if test="stuphone != null">
                #{stuphone,jdbcType=VARCHAR},
            </if>
            <if test="textbookid != null">
                #{textbookid,jdbcType=BIGINT},
            </if>
            <if test="creator != null">
                #{creator,jdbcType=VARCHAR},
            </if>
            <if test="lastmodifier != null">
                #{lastmodifier,jdbcType=VARCHAR},
            </if>
            <if test="countdate != null">
                #{countdate,jdbcType=INTEGER},
            </if>
            <if test="counttime != null">
                #{counttime,jdbcType=INTEGER},
            </if>
            <if test="countstu != null">
                #{countstu,jdbcType=INTEGER},
            </if>
            <if test="sketchtype != null">
                #{sketchtype,jdbcType=INTEGER},
            </if>
            <if test="coursestyle != null">
                #{coursestyle,jdbcType=INTEGER},
            </if>
            <if test="classtype != null">
                #{classtype,jdbcType=INTEGER},
            </if>
            <if test="process != null">
                #{process,jdbcType=INTEGER},
            </if>
            <if test="coursestatus != null">
                #{coursestatus,jdbcType=INTEGER},
            </if>
            <if test="pay != null">
                #{pay,jdbcType=VARCHAR},
            </if>
            <if test="perpay != null">
                #{perpay,jdbcType=VARCHAR},
            </if>
            <if test="couponpay != null">
                #{couponpay,jdbcType=VARCHAR},
            </if>
            <if test="originalpay != null">
                #{originalpay,jdbcType=VARCHAR},
            </if>
            <if test="couponrule != null">
                #{couponrule,jdbcType=INTEGER},
            </if>
            <if test="begindate != null">
                #{begindate,jdbcType=BIGINT},
            </if>
            <if test="enddate != null">
                #{enddate,jdbcType=BIGINT},
            </if>
            <if test="coursenum != null">
                #{coursenum,jdbcType=INTEGER},
            </if>
            <if test="hasnum != null">
                #{hasnum,jdbcType=INTEGER},
            </if>
            <if test="cancelnum != null">
                #{cancelnum,jdbcType=INTEGER},
            </if>
            <if test="coursenuminput != null">
                #{coursenuminput,jdbcType=INTEGER},
            </if>
            <if test="ordernum != null">
                #{ordernum,jdbcType=INTEGER},
            </if>
            <if test="fav != null">
                #{fav,jdbcType=BIGINT},
            </if>
            <if test="viplevel != null">
                #{viplevel,jdbcType=INTEGER},
            </if>
            <if test="cancelreason != null">
                #{cancelreason,jdbcType=INTEGER},
            </if>
            <if test="createdate != null">
                #{createdate,jdbcType=BIGINT},
            </if>
            <if test="lastmoddate != null">
                #{lastmoddate,jdbcType=BIGINT},
            </if>
            <if test="formatter != null">
                #{formatter,jdbcType=VARCHAR},
            </if>
            <if test="status != null">
                #{status,jdbcType=TINYINT},
            </if>
        </trim>
    </insert>
    
    <update id="updateByPrimaryKeySelective" parameterType="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        update qfd_sketch
        <set>
            <if test="coursename != null">
                courseName = #{coursename,jdbcType=VARCHAR},
            </if>
            <if test="coursereq != null">
                courseReq = #{coursereq,jdbcType=VARCHAR},
            </if>
            <if test="teaid != null">
                teaId = #{teaid,jdbcType=VARCHAR},
            </if>
            <if test="teaname != null">
                teaName = #{teaname,jdbcType=VARCHAR},
            </if>
            <if test="stuid != null">
                stuId = #{stuid,jdbcType=VARCHAR},
            </if>
            <if test="stuname != null">
                stuName = #{stuname,jdbcType=VARCHAR},
            </if>
            <if test="stuphone != null">
                stuPhone = #{stuphone,jdbcType=VARCHAR},
            </if>
            <if test="textbookid != null">
                textbookId = #{textbookid,jdbcType=BIGINT},
            </if>
            <if test="creator != null">
                creator = #{creator,jdbcType=VARCHAR},
            </if>
            <if test="lastmodifier != null">
                lastModifier = #{lastmodifier,jdbcType=VARCHAR},
            </if>
            <if test="countdate != null">
                countDate = #{countdate,jdbcType=INTEGER},
            </if>
            <if test="counttime != null">
                countTime = #{counttime,jdbcType=INTEGER},
            </if>
            <if test="countstu != null">
                countStu = #{countstu,jdbcType=INTEGER},
            </if>
            <if test="sketchtype != null">
                sketchType = #{sketchtype,jdbcType=INTEGER},
            </if>
            <if test="coursestyle != null">
                courseStyle = #{coursestyle,jdbcType=INTEGER},
            </if>
            <if test="classtype != null">
                classType = #{classtype,jdbcType=INTEGER},
            </if>
            <if test="process != null">
                process = #{process,jdbcType=INTEGER},
            </if>
            <if test="coursestatus != null">
                courseStatus = #{coursestatus,jdbcType=INTEGER},
            </if>
            <if test="pay != null">
                pay = #{pay,jdbcType=VARCHAR},
            </if>
            <if test="perpay != null">
                perPay = #{perpay,jdbcType=VARCHAR},
            </if>
            <if test="couponpay != null">
                couponPay = #{couponpay,jdbcType=VARCHAR},
            </if>
            <if test="originalpay != null">
                originalPay = #{originalpay,jdbcType=VARCHAR},
            </if>
            <if test="couponrule != null">
                couponRule = #{couponrule,jdbcType=INTEGER},
            </if>
            <if test="begindate != null">
                beginDate = #{begindate,jdbcType=BIGINT},
            </if>
            <if test="enddate != null">
                endDate = #{enddate,jdbcType=BIGINT},
            </if>
            <if test="coursenum != null">
                courseNum = #{coursenum,jdbcType=INTEGER},
            </if>
            <if test="hasnum != null">
                hasNum = #{hasnum,jdbcType=INTEGER},
            </if>
            <if test="cancelnum != null">
                cancelNum = #{cancelnum,jdbcType=INTEGER},
            </if>
            <if test="coursenuminput != null">
                courseNumInput = #{coursenuminput,jdbcType=INTEGER},
            </if>
            <if test="ordernum != null">
                orderNum = #{ordernum,jdbcType=INTEGER},
            </if>
            <if test="fav != null">
                fav = #{fav,jdbcType=BIGINT},
            </if>
            <if test="viplevel != null">
                vipLevel = #{viplevel,jdbcType=INTEGER},
            </if>
            <if test="cancelreason != null">
                cancelReason = #{cancelreason,jdbcType=INTEGER},
            </if>
            <if test="createdate != null">
                createDate = #{createdate,jdbcType=BIGINT},
            </if>
            <if test="lastmoddate != null">
                lastModDate = #{lastmoddate,jdbcType=BIGINT},
            </if>
            <if test="formatter != null">
                formatter = #{formatter,jdbcType=VARCHAR},
            </if>
            <if test="status != null">
                status = #{status,jdbcType=TINYINT},
            </if>
        </set>
        where id = #{id,jdbcType=BIGINT}
    </update>
    
    <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        delete from qfd_sketch
        where id = #{id,jdbcType=BIGINT}
    </delete>
</mapper>


6.可以通过上面的修改后文件可以看到已经实现了我们的要求,但是sql id还是不满足我们的要求,应该改成纯粹的insert,update,delete

找到IntrospectedTable.java类的calculateXmlAttributes()方法,可以看到很多的setxxx方法带了具体的字符串参数,这个就是对应sql文件里面的sql id我们把对应的改改

protected void calculateXmlAttributes() {
        setIbatis2SqlMapPackage(calculateSqlMapPackage());
        setIbatis2SqlMapFileName(calculateIbatis2SqlMapFileName());
        setMyBatis3XmlMapperFileName(calculateMyBatis3XmlMapperFileName());
        setMyBatis3XmlMapperPackage(calculateSqlMapPackage());

        setIbatis2SqlMapNamespace(calculateIbatis2SqlMapNamespace());
        setMyBatis3FallbackSqlMapNamespace(calculateMyBatis3FallbackSqlMapNamespace());
        
        setSqlMapFullyQualifiedRuntimeTableName(calculateSqlMapFullyQualifiedRuntimeTableName());
        setSqlMapAliasedFullyQualifiedRuntimeTableName(calculateSqlMapAliasedFullyQualifiedRuntimeTableName());

        setCountByExampleStatementId("countByExample"); //$NON-NLS-1$
        setDeleteByExampleStatementId("deleteByExample"); //$NON-NLS-1$
        setDeleteByPrimaryKeyStatementId("deleteByPrimaryKey"); //$NON-NLS-1$
        setInsertStatementId("insert"); //$NON-NLS-1$
        setInsertSelectiveStatementId("insertSelective"); //$NON-NLS-1$
        setSelectAllStatementId("selectAll"); //$NON-NLS-1$
        setSelectByExampleStatementId("selectByExample"); //$NON-NLS-1$
        setSelectByExampleWithBLOBsStatementId("selectByExampleWithBLOBs"); //$NON-NLS-1$
        setSelectByPrimaryKeyStatementId("selectByPrimaryKey"); //$NON-NLS-1$
        setUpdateByExampleStatementId("updateByExample"); //$NON-NLS-1$
        setUpdateByExampleSelectiveStatementId("updateByExampleSelective"); //$NON-NLS-1$
        setUpdateByExampleWithBLOBsStatementId("updateByExampleWithBLOBs"); //$NON-NLS-1$
        setUpdateByPrimaryKeyStatementId("updateByPrimaryKey"); //$NON-NLS-1$
        setUpdateByPrimaryKeySelectiveStatementId("updateByPrimaryKeySelective"); //$NON-NLS-1$
        setUpdateByPrimaryKeyWithBLOBsStatementId("updateByPrimaryKeyWithBLOBs"); //$NON-NLS-1$
        setBaseResultMapId("BaseResultMap"); //$NON-NLS-1$
        setResultMapWithBLOBsId("ResultMapWithBLOBs"); //$NON-NLS-1$
        setExampleWhereClauseId("Example_Where_Clause"); //$NON-NLS-1$
        setBaseColumnListId("Base_Column_List"); //$NON-NLS-1$
        setBlobColumnListId("Blob_Column_List"); //$NON-NLS-1$
        setMyBatis3UpdateByExampleWhereClauseId("Update_By_Example_Where_Clause"); //$NON-NLS-1$
    }

修改后方法 

protected void calculateXmlAttributes() {
        setIbatis2SqlMapPackage(calculateSqlMapPackage());
        setIbatis2SqlMapFileName(calculateIbatis2SqlMapFileName());
        setMyBatis3XmlMapperFileName(calculateMyBatis3XmlMapperFileName());
        setMyBatis3XmlMapperPackage(calculateSqlMapPackage());

        setIbatis2SqlMapNamespace(calculateIbatis2SqlMapNamespace());
        setMyBatis3FallbackSqlMapNamespace(calculateMyBatis3FallbackSqlMapNamespace());
        
        setSqlMapFullyQualifiedRuntimeTableName(calculateSqlMapFullyQualifiedRuntimeTableName());
        setSqlMapAliasedFullyQualifiedRuntimeTableName(calculateSqlMapAliasedFullyQualifiedRuntimeTableName());

        setCountByExampleStatementId("countByExample"); //$NON-NLS-1$
        setDeleteByExampleStatementId("deleteByExample"); //$NON-NLS-1$
        // setDeleteByPrimaryKeyStatementId("deleteByPrimaryKey"); //$NON-NLS-1$
        setDeleteByPrimaryKeyStatementId("delete"); // deleteByPrimaryKey改成delete
        setInsertStatementId("insert"); //$NON-NLS-1$
        // setInsertSelectiveStatementId("insertSelective"); //$NON-NLS-1$
        setInsertSelectiveStatementId("insert"); // insertSelective改成insert
        setSelectAllStatementId("selectAll"); //$NON-NLS-1$
        setSelectByExampleStatementId("selectByExample"); //$NON-NLS-1$
        setSelectByExampleWithBLOBsStatementId("selectByExampleWithBLOBs"); //$NON-NLS-1$
        setSelectByPrimaryKeyStatementId("selectByPrimaryKey"); //$NON-NLS-1$
        setUpdateByExampleStatementId("updateByExample"); //$NON-NLS-1$
        setUpdateByExampleSelectiveStatementId("updateByExampleSelective"); //$NON-NLS-1$
        setUpdateByExampleWithBLOBsStatementId("updateByExampleWithBLOBs"); //$NON-NLS-1$
        setUpdateByPrimaryKeyStatementId("updateByPrimaryKey"); //$NON-NLS-1$
        // setUpdateByPrimaryKeySelectiveStatementId("updateByPrimaryKeySelective"); //$NON-NLS-1$
        setUpdateByPrimaryKeySelectiveStatementId("update"); // updateByPrimaryKeySelective改成update
        setUpdateByPrimaryKeyWithBLOBsStatementId("updateByPrimaryKeyWithBLOBs"); //$NON-NLS-1$
        setBaseResultMapId("BaseResultMap"); //$NON-NLS-1$
        setResultMapWithBLOBsId("ResultMapWithBLOBs"); //$NON-NLS-1$
        setExampleWhereClauseId("Example_Where_Clause"); //$NON-NLS-1$
        setBaseColumnListId("Base_Column_List"); //$NON-NLS-1$
        setBlobColumnListId("Blob_Column_List"); //$NON-NLS-1$
        setMyBatis3UpdateByExampleWhereClauseId("Update_By_Example_Where_Clause"); //$NON-NLS-1$
    }

7.修改方法后我们再重新生成文件看看效果

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.dao.QfdSketchMapper">
    
    <resultMap id="BaseResultMap" type="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        <id column="id" jdbcType="BIGINT" property="id" />
        <result column="courseName" jdbcType="VARCHAR" property="coursename" />
        <result column="courseReq" jdbcType="VARCHAR" property="coursereq" />
        <result column="teaId" jdbcType="VARCHAR" property="teaid" />
        <result column="teaName" jdbcType="VARCHAR" property="teaname" />
        <result column="stuId" jdbcType="VARCHAR" property="stuid" />
        <result column="stuName" jdbcType="VARCHAR" property="stuname" />
        <result column="stuPhone" jdbcType="VARCHAR" property="stuphone" />
        <result column="textbookId" jdbcType="BIGINT" property="textbookid" />
        <result column="creator" jdbcType="VARCHAR" property="creator" />
        <result column="lastModifier" jdbcType="VARCHAR" property="lastmodifier" />
        <result column="countDate" jdbcType="INTEGER" property="countdate" />
        <result column="countTime" jdbcType="INTEGER" property="counttime" />
        <result column="countStu" jdbcType="INTEGER" property="countstu" />
        <result column="sketchType" jdbcType="INTEGER" property="sketchtype" />
        <result column="courseStyle" jdbcType="INTEGER" property="coursestyle" />
        <result column="classType" jdbcType="INTEGER" property="classtype" />
        <result column="process" jdbcType="INTEGER" property="process" />
        <result column="courseStatus" jdbcType="INTEGER" property="coursestatus" />
        <result column="pay" jdbcType="VARCHAR" property="pay" />
        <result column="perPay" jdbcType="VARCHAR" property="perpay" />
        <result column="couponPay" jdbcType="VARCHAR" property="couponpay" />
        <result column="originalPay" jdbcType="VARCHAR" property="originalpay" />
        <result column="couponRule" jdbcType="INTEGER" property="couponrule" />
        <result column="beginDate" jdbcType="BIGINT" property="begindate" />
        <result column="endDate" jdbcType="BIGINT" property="enddate" />
        <result column="courseNum" jdbcType="INTEGER" property="coursenum" />
        <result column="hasNum" jdbcType="INTEGER" property="hasnum" />
        <result column="cancelNum" jdbcType="INTEGER" property="cancelnum" />
        <result column="courseNumInput" jdbcType="INTEGER" property="coursenuminput" />
        <result column="orderNum" jdbcType="INTEGER" property="ordernum" />
        <result column="fav" jdbcType="BIGINT" property="fav" />
        <result column="vipLevel" jdbcType="INTEGER" property="viplevel" />
        <result column="cancelReason" jdbcType="INTEGER" property="cancelreason" />
        <result column="createDate" jdbcType="BIGINT" property="createdate" />
        <result column="lastModDate" jdbcType="BIGINT" property="lastmoddate" />
        <result column="formatter" jdbcType="VARCHAR" property="formatter" />
        <result column="status" jdbcType="TINYINT" property="status" />
    </resultMap>
    
    <sql id="Base_Column_List">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        id, courseName, courseReq, teaId, teaName, stuId, stuName, stuPhone, textbookId, 
        creator, lastModifier, countDate, countTime, countStu, sketchType, courseStyle, classType, 
        process, courseStatus, pay, perPay, couponPay, originalPay, couponRule, beginDate, 
        endDate, courseNum, hasNum, cancelNum, courseNumInput, orderNum, fav, vipLevel, cancelReason, 
        createDate, lastModDate, formatter, status
    </sql>
    
    <insert id="insert" parameterType="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        insert into qfd_sketch
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="coursename != null">
                courseName,
            </if>
            <if test="coursereq != null">
                courseReq,
            </if>
            <if test="teaid != null">
                teaId,
            </if>
            <if test="teaname != null">
                teaName,
            </if>
            <if test="stuid != null">
                stuId,
            </if>
            <if test="stuname != null">
                stuName,
            </if>
            <if test="stuphone != null">
                stuPhone,
            </if>
            <if test="textbookid != null">
                textbookId,
            </if>
            <if test="creator != null">
                creator,
            </if>
            <if test="lastmodifier != null">
                lastModifier,
            </if>
            <if test="countdate != null">
                countDate,
            </if>
            <if test="counttime != null">
                countTime,
            </if>
            <if test="countstu != null">
                countStu,
            </if>
            <if test="sketchtype != null">
                sketchType,
            </if>
            <if test="coursestyle != null">
                courseStyle,
            </if>
            <if test="classtype != null">
                classType,
            </if>
            <if test="process != null">
                process,
            </if>
            <if test="coursestatus != null">
                courseStatus,
            </if>
            <if test="pay != null">
                pay,
            </if>
            <if test="perpay != null">
                perPay,
            </if>
            <if test="couponpay != null">
                couponPay,
            </if>
            <if test="originalpay != null">
                originalPay,
            </if>
            <if test="couponrule != null">
                couponRule,
            </if>
            <if test="begindate != null">
                beginDate,
            </if>
            <if test="enddate != null">
                endDate,
            </if>
            <if test="coursenum != null">
                courseNum,
            </if>
            <if test="hasnum != null">
                hasNum,
            </if>
            <if test="cancelnum != null">
                cancelNum,
            </if>
            <if test="coursenuminput != null">
                courseNumInput,
            </if>
            <if test="ordernum != null">
                orderNum,
            </if>
            <if test="fav != null">
                fav,
            </if>
            <if test="viplevel != null">
                vipLevel,
            </if>
            <if test="cancelreason != null">
                cancelReason,
            </if>
            <if test="createdate != null">
                createDate,
            </if>
            <if test="lastmoddate != null">
                lastModDate,
            </if>
            <if test="formatter != null">
                formatter,
            </if>
            <if test="status != null">
                status,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=BIGINT},
            </if>
            <if test="coursename != null">
                #{coursename,jdbcType=VARCHAR},
            </if>
            <if test="coursereq != null">
                #{coursereq,jdbcType=VARCHAR},
            </if>
            <if test="teaid != null">
                #{teaid,jdbcType=VARCHAR},
            </if>
            <if test="teaname != null">
                #{teaname,jdbcType=VARCHAR},
            </if>
            <if test="stuid != null">
                #{stuid,jdbcType=VARCHAR},
            </if>
            <if test="stuname != null">
                #{stuname,jdbcType=VARCHAR},
            </if>
            <if test="stuphone != null">
                #{stuphone,jdbcType=VARCHAR},
            </if>
            <if test="textbookid != null">
                #{textbookid,jdbcType=BIGINT},
            </if>
            <if test="creator != null">
                #{creator,jdbcType=VARCHAR},
            </if>
            <if test="lastmodifier != null">
                #{lastmodifier,jdbcType=VARCHAR},
            </if>
            <if test="countdate != null">
                #{countdate,jdbcType=INTEGER},
            </if>
            <if test="counttime != null">
                #{counttime,jdbcType=INTEGER},
            </if>
            <if test="countstu != null">
                #{countstu,jdbcType=INTEGER},
            </if>
            <if test="sketchtype != null">
                #{sketchtype,jdbcType=INTEGER},
            </if>
            <if test="coursestyle != null">
                #{coursestyle,jdbcType=INTEGER},
            </if>
            <if test="classtype != null">
                #{classtype,jdbcType=INTEGER},
            </if>
            <if test="process != null">
                #{process,jdbcType=INTEGER},
            </if>
            <if test="coursestatus != null">
                #{coursestatus,jdbcType=INTEGER},
            </if>
            <if test="pay != null">
                #{pay,jdbcType=VARCHAR},
            </if>
            <if test="perpay != null">
                #{perpay,jdbcType=VARCHAR},
            </if>
            <if test="couponpay != null">
                #{couponpay,jdbcType=VARCHAR},
            </if>
            <if test="originalpay != null">
                #{originalpay,jdbcType=VARCHAR},
            </if>
            <if test="couponrule != null">
                #{couponrule,jdbcType=INTEGER},
            </if>
            <if test="begindate != null">
                #{begindate,jdbcType=BIGINT},
            </if>
            <if test="enddate != null">
                #{enddate,jdbcType=BIGINT},
            </if>
            <if test="coursenum != null">
                #{coursenum,jdbcType=INTEGER},
            </if>
            <if test="hasnum != null">
                #{hasnum,jdbcType=INTEGER},
            </if>
            <if test="cancelnum != null">
                #{cancelnum,jdbcType=INTEGER},
            </if>
            <if test="coursenuminput != null">
                #{coursenuminput,jdbcType=INTEGER},
            </if>
            <if test="ordernum != null">
                #{ordernum,jdbcType=INTEGER},
            </if>
            <if test="fav != null">
                #{fav,jdbcType=BIGINT},
            </if>
            <if test="viplevel != null">
                #{viplevel,jdbcType=INTEGER},
            </if>
            <if test="cancelreason != null">
                #{cancelreason,jdbcType=INTEGER},
            </if>
            <if test="createdate != null">
                #{createdate,jdbcType=BIGINT},
            </if>
            <if test="lastmoddate != null">
                #{lastmoddate,jdbcType=BIGINT},
            </if>
            <if test="formatter != null">
                #{formatter,jdbcType=VARCHAR},
            </if>
            <if test="status != null">
                #{status,jdbcType=TINYINT},
            </if>
        </trim>
    </insert>
    
    <update id="update" parameterType="com.test.domain.QfdSketch">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        update qfd_sketch
        <set>
            <if test="coursename != null">
                courseName = #{coursename,jdbcType=VARCHAR},
            </if>
            <if test="coursereq != null">
                courseReq = #{coursereq,jdbcType=VARCHAR},
            </if>
            <if test="teaid != null">
                teaId = #{teaid,jdbcType=VARCHAR},
            </if>
            <if test="teaname != null">
                teaName = #{teaname,jdbcType=VARCHAR},
            </if>
            <if test="stuid != null">
                stuId = #{stuid,jdbcType=VARCHAR},
            </if>
            <if test="stuname != null">
                stuName = #{stuname,jdbcType=VARCHAR},
            </if>
            <if test="stuphone != null">
                stuPhone = #{stuphone,jdbcType=VARCHAR},
            </if>
            <if test="textbookid != null">
                textbookId = #{textbookid,jdbcType=BIGINT},
            </if>
            <if test="creator != null">
                creator = #{creator,jdbcType=VARCHAR},
            </if>
            <if test="lastmodifier != null">
                lastModifier = #{lastmodifier,jdbcType=VARCHAR},
            </if>
            <if test="countdate != null">
                countDate = #{countdate,jdbcType=INTEGER},
            </if>
            <if test="counttime != null">
                countTime = #{counttime,jdbcType=INTEGER},
            </if>
            <if test="countstu != null">
                countStu = #{countstu,jdbcType=INTEGER},
            </if>
            <if test="sketchtype != null">
                sketchType = #{sketchtype,jdbcType=INTEGER},
            </if>
            <if test="coursestyle != null">
                courseStyle = #{coursestyle,jdbcType=INTEGER},
            </if>
            <if test="classtype != null">
                classType = #{classtype,jdbcType=INTEGER},
            </if>
            <if test="process != null">
                process = #{process,jdbcType=INTEGER},
            </if>
            <if test="coursestatus != null">
                courseStatus = #{coursestatus,jdbcType=INTEGER},
            </if>
            <if test="pay != null">
                pay = #{pay,jdbcType=VARCHAR},
            </if>
            <if test="perpay != null">
                perPay = #{perpay,jdbcType=VARCHAR},
            </if>
            <if test="couponpay != null">
                couponPay = #{couponpay,jdbcType=VARCHAR},
            </if>
            <if test="originalpay != null">
                originalPay = #{originalpay,jdbcType=VARCHAR},
            </if>
            <if test="couponrule != null">
                couponRule = #{couponrule,jdbcType=INTEGER},
            </if>
            <if test="begindate != null">
                beginDate = #{begindate,jdbcType=BIGINT},
            </if>
            <if test="enddate != null">
                endDate = #{enddate,jdbcType=BIGINT},
            </if>
            <if test="coursenum != null">
                courseNum = #{coursenum,jdbcType=INTEGER},
            </if>
            <if test="hasnum != null">
                hasNum = #{hasnum,jdbcType=INTEGER},
            </if>
            <if test="cancelnum != null">
                cancelNum = #{cancelnum,jdbcType=INTEGER},
            </if>
            <if test="coursenuminput != null">
                courseNumInput = #{coursenuminput,jdbcType=INTEGER},
            </if>
            <if test="ordernum != null">
                orderNum = #{ordernum,jdbcType=INTEGER},
            </if>
            <if test="fav != null">
                fav = #{fav,jdbcType=BIGINT},
            </if>
            <if test="viplevel != null">
                vipLevel = #{viplevel,jdbcType=INTEGER},
            </if>
            <if test="cancelreason != null">
                cancelReason = #{cancelreason,jdbcType=INTEGER},
            </if>
            <if test="createdate != null">
                createDate = #{createdate,jdbcType=BIGINT},
            </if>
            <if test="lastmoddate != null">
                lastModDate = #{lastmoddate,jdbcType=BIGINT},
            </if>
            <if test="formatter != null">
                formatter = #{formatter,jdbcType=VARCHAR},
            </if>
            <if test="status != null">
                status = #{status,jdbcType=TINYINT},
            </if>
        </set>
        where id = #{id,jdbcType=BIGINT}
    </update>
    
    <delete id="delete" parameterType="java.lang.Long">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        delete from qfd_sketch
        where id = #{id,jdbcType=BIGINT}
    </delete>
</mapper>

8.已经改成比较符合我们规范和使用的xml文件了,看着很让人舒服不别扭;小结:这些修改代码都是源码生成器必经的逻辑,所以有兴趣继续改造的同学可以继续断点查看并按自己的习惯修改,我只是大概讲了那些部分都是关键地方,下一篇我应该会讲解如何增加自定义sql了,大家有兴趣继续学习的请不要错过咯,再次谢谢大家的支持


文章标签：
SQL
Java
mybatis
数据库连接
数据格式
测试技术
XML
关键词：
MyBatis sql
XML sql
MyBatis xml
MyBatis文件
MyBatis自定义
aielves
目录
相关文章
游客kufrkwrbkmpsa
|
12月前
|
SQL Java 数据库连接
【YashanDB知识库】解决mybatis的mapper文件sql语句结尾加分号";"报错
【YashanDB知识库】解决mybatis的mapper文件sql语句结尾加分号";"报错
游客kufrkwrbkmpsa
332 1
Quan_Chen
|
12月前
|
XML Java 数据库连接
微服务——SpringBoot使用归纳——Spring Boot集成MyBatis——基于 xml 的整合
本教程介绍了基于XML的MyBatis整合方式。首先在`application.yml`中配置XML路径，如`classpath:mapper/*.xml`，然后创建`UserMapper.xml`文件定义SQL映射，包括`resultMap`和查询语句。通过设置`namespace`关联Mapper接口，实现如`getUserByName`的方法。Controller层调用Service完成测试，访问`/getUserByName/{name}`即可返回用户信息。为简化Mapper扫描，推荐在Spring Boot启动类用`@MapperScan`注解指定包路径避免逐个添加`@Mapper`
Quan_Chen
711 0
Bluening
|
10月前
|
SQL XML Java
菜鸟之路Day35一一Mybatis之XML映射与动态SQL
本文介绍了MyBatis框架中XML映射与动态SQL的使用方法，作者通过实例详细解析了XML映射文件的配置规范，包括namespace、id和resultType的设置。文章还对比了注解与XML映射的优缺点，强调复杂SQL更适合XML方式。在动态SQL部分，重点讲解了`&lt;if&gt;`、`&lt;where&gt;`、`&lt;set&gt;`、`&lt;foreach&gt;`等标签的应用场景，如条件查询、动态更新和批量删除，并通过代码示例展示了其灵活性与实用性。最后，通过`&lt;sql&gt;`和`&lt;include&gt;`实现代码复用，优化维护效率。
Bluening
965 5
刘大猫.
|
12月前
|
XML Java 数据库连接
二、搭建MyBatis采用xml方式，验证CRUD（增删改查操作）
二、搭建MyBatis采用xml方式，验证CRUD（增删改查操作）
刘大猫.
377 21
游客pb5c4iyea3ani
|
12月前
|
SQL Java 数据库连接
【YashanDB 知识库】解决 mybatis 的 mapper 文件 sql 语句结尾加分号";"报错
【YashanDB 知识库】解决 mybatis 的 mapper 文件 sql 语句结尾加分号";"报错
游客pb5c4iyea3ani
426 6
蓝染-惣右介
|
SQL 缓存 Java
【详细实用のMyBatis教程】获取参数值和结果的各种情况、自定义映射、动态SQL、多级缓存、逆向工程、分页插件
本文详细介绍了MyBatis的各种常见用法MyBatis多级缓存、逆向工程、分页插件 包括获取参数值和结果的各种情况、自定义映射resultMap、动态SQL
蓝染-惣右介
648 1
【详细实用のMyBatis教程】获取参数值和结果的各种情况、自定义映射、动态SQL、多级缓存、逆向工程、分页插件
Apache_Tomcat_Nignx
|
SQL 关系型数据库 MySQL
MySQL导入.sql文件后数据库乱码问题
本文分析了导入.sql文件后数据库备注出现乱码的原因，包括字符集不匹配、备注内容编码问题及MySQL版本或配置问题，并提供了详细的解决步骤，如检查和统一字符集设置、修改客户端连接方式、检查MySQL配置等，确保导入过程顺利。
Apache_Tomcat_Nignx
1114 3
刘大猫.
|
SQL 缓存 Java
MyBatis如何关闭一级缓存(分注解和xml两种方式)
MyBatis如何关闭一级缓存(分注解和xml两种方式)
刘大猫.
666 5
计蒙不吃鱼
|
10月前
|
Android开发 开发者
Android自定义View之不得不知道的文件attrs.xml（自定义属性）
本文详细介绍了如何通过自定义 `attrs.xml` 文件实现 Android 自定义 View 的属性配置。以一个包含 TextView 和 ImageView 的 DemoView 为例，讲解了如何使用自定义属性动态改变文字内容和控制图片显示隐藏。同时，通过设置布尔值和点击事件，实现了图片状态的切换功能。代码中展示了如何在构造函数中解析自定义属性，并通过方法 `setSetting0n` 和 `setbackeguang` 实现功能逻辑的优化与封装。此示例帮助开发者更好地理解自定义 View 的开发流程与 attrs.xml 的实际应用。
计蒙不吃鱼
276 2
Android自定义View之不得不知道的文件attrs.xml（自定义属性）
nanshaws
|
XML 前端开发 Java
讲解SSM的xml文件
本文详细介绍了SSM框架中的xml配置文件，包括springMVC.xml和applicationContext.xml，涉及组件扫描、数据源配置、事务管理、MyBatis集成以及Spring MVC的视图解析器配置。
nanshaws
323 1

热门文章

最新文章

  • 1
    SQL Server 2008 过期
  • 2
    SQL技巧(二) - CTE(公用表达式)初步接触
  • 3
    SQL2005中时，Diagrams的问题
  • 4
    sql server 安装缺少adventureworks解决办法
  • 5
    【Hive SQL 每日一题】行列转换
  • 6
    SQL中存储过程中使用事务,并且加入异常处理机制.
  • 7
    防SQL注入：生成参数化的通用分页查询语句
  • 8
    如何让Log shipping成功的备份信息不出现在SQL Server error log
  • 9
    解决sql update 1292 - Truncated incorrect DOUBLE value:
  • 10
    sql server 查询数据库所有的表名+字段
  • 1
    Mybatis基础使用知识（注解）
    441
  • 2
    MyBatis分页
    227
  • 3
    MyBatis 持久层框架技术详解与实践指南
    224
  • 4
    MyBatis 的映射关系
    367
  • 5
    MyBatis的常见配置
    597
  • 6
    区分iBatis与MyBatis：两个Java数据库框架的比较
    436
  • 7
    通过MyBatis的XML配置实现灵活的动态SQL查询
    434
  • 8
    SSM相关问题-1--#{}和${}有什么区别吗？--Mybatis都有哪些动态sql？能简述一下动 态sql的执行原理吗？--Spring支持的几种bean的作用域 Scope
    195
  • 9
    MyBatis框架如何处理字符串相等的判断条件。
    545
  • 10
    踩坑与成长：WordPress、MyBatis-Plus 及前端依赖问题解决记录
    343

    • 相关课程

    更多
  • 如何在 PolarDB-X 中优化慢 SQL
  • SQL完全自学手册
  • SQL Server on Linux入门教程
  • SQL入门与实践
  • 数据库及SQL/MySQL基础
  • SQL进阶及查询

    • 相关电子书

    更多
  • SQL Server在电子商务中的应用与实践
  • GeoMesa on Spark SQL
  • 原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili
    • 下一篇
    ECS账号安全防护最佳实践