开发小计(01)
1. Mybatis中sql语句复用
<select id="getInfoById" resultType="com.seari.basicinfo.entities.model.BasicParkWayInfo" parameterType="java.lang.String">
<include refid="selectInfo"/> where WAY_ID = #{id} </select>
<update id="update">
update BASIC_TAXI_CHK_CONTENT
<set> <if test="content!=null"> CONTENT = #{content}, </if> <if test="seq!=null"> SEQ = #{seq}, </if> <if test="status!=null"> STATUS = #{status}, </if> <if test="remark!=null"> REMARK = #{remark}, </if> </set> where CHK_CONTENT_ID =#{chkContentId};
</update>