动态sql
<sql id="finalExamAttribute">
<if test="course!=null">
courseId = #{course.id}
</if>
<if test="tclass!=null">
, classId = #{tclass.id}
</if>
<if test="teacher!=null">
, tid=#{teacher.id}
</if>
<if test="score!=null">
, score=#{score}
</if>
<if test="signer!=null">
, signer=#{signer}
</if>
</sql>
修改语句
<update id="updateFinalExamList">
UPDATE finalExamList SET
<include refid="finalExamAttribute" />
WHERE id=#{id}
</update>