SELECT * FROM portal_sys_module_DETAIL WHERE MODULE_ID_=#{moduleId} AND TYPE_=#{type} order by SN_ DELETE FROM portal_sys_module_DETAIL WHERE MODULE_ID_=#{moduleId,jdbcType=VARCHAR}