请看下面的代码示例：
<select id="dynamicSelectGuanglu" parameterClass="Guanglu" resultMap="GuangluResult">
SELECT
gid,
xianxin_sidepoint_ids,
start_jizhan_id,
stop_jizhan_id,
functionality
FROM guanglu
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="start_jizhan_id">
start_jizhan_id = #start_jizhan_id#
</isNotNull>
<isNotNull prepend="AND" property="stop_jizhan_id">
stop_jizhan_id = #stop_jizhan_id#
</isNotNull>
<isNotNull prepend="AND" property="functionality">
functionality LIKE #functionality#
</isNotNull>
</dynamic>
</select>
