mybatis mapper 技巧

先使用 `<sql id="BaseColumn">` 来保存所有属性。

后面再用 `<include refid="BaseColumn"/>` 来作为代替。

这样可以避免写一堆属性

    <sql id="BaseColumn">

        ID,FLOW_ID,SYS_INSTANCE_ID,CREATE_DATE,RESULT_ CODE,RESULT_MSG,CREATOR_NAME,CREATOR_ID,PROCESS_STATUS,FLOW_NAME,EXTEND

    </sql>

    <insert id="insert" parameterType="com.yotop.fams.data.model.DiantouyiUniteTodo.DiantouyiUniteTodoInstanceDAO">

        insert into DIANTOUYI_UNITE_TODO_INSTANCE (UNITE_TODO_FLOWID,SYS_INSTANCE_ID,CREATE_DATE,RESULT_ CODE,RESULT_MSG,CREATOR_NAME,CREATOR_ID,PROCESS_STATUS,FLOW_NAME,EXTEND)

        values (#{diantouyiUniteTodoFlowId,jdbcType=VARCHAR},#{sysInstanceId,jdbcType=VARCHAR},

                #{createDate,jdbcType=TIMESTAMP},#{resultCode,jdbcType=INTEGER},#{resultMsg,jdbcType=VARCHAR},

            #{creatorName,jdbcType=VARCHAR},#{creatorId,jdbcType=VARCHAR},#{processStatus,jdbcType=TINYINT},

            #{flowName,jdbcType=VARCHAR},#{extend,jdbcType=VARCHAR})

    </insert>

    <select id="findAllByFormId" resultMap="BaseResultMap">

        select

        <include refid="BaseColumn"/>

        from DIANTOUYI_UNITE_TODO_INSTANCE

        where SYS_INSTANCE_ID = #{sysInstanceId,jdbcType=VARCHAR}

    </select>