先使用 `<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>