中铁建设集团门户网app_有源码如何搭建网站_百度电话客服24小时人工_深圳宝安区有什么好玩的地方
<mapper namespace="xxx.mapper.SiteExampleMapper"><resultMap type="SiteExample" id="SiteExampleResult"><result property="id" column="id" /><result property="title" column="title" /><result property="type" column="type" /><result property="content" column="content" /><result property="urlAddress" column="url_address" /><result property="iconBase64" column="icon_base64" /><result property="iconPath" column="icon_path" /><result property="createUser" column="create_user" /><result property="createTime" column="create_time" /><result property="isUse" column="is_use" /><result property="isDel" column="is_del" /><result property="remark1" column="remark1" /><result property="remark2" column="remark2" /><result property="remark3" column="remark3" /><result property="remark4" column="remark4" /><result property="remark5" column="remark5" /></resultMap><sql id="selectSiteExampleVo">select id, title, type, content, url_address, icon_base64, icon_path, create_user, create_time, is_use, is_del, remark1, remark2, remark3, remark4, remark5 from site_example</sql><select id="selectSiteExampleList" parameterType="SiteExample" resultMap="SiteExampleResult"><include refid="selectSiteExampleVo"/><where> <if test="title != null and title != ''"> and title like concat('%', #{title}, '%')</if><if test="type != null and type != ''"> and type = #{type}</if><if test="content != null and content != ''"> and content = #{content}</if><if test="urlAddress != null and urlAddress != ''"> and url_address = #{urlAddress}</if><if test="createUser != null and createUser != ''"> and create_user = #{createUser}</if><if test="isUse != null and isUse != ''"> and is_use = #{isUse}</if><if test="isDel != null and isDel != ''"> and is_del = #{isDel}</if><if test="remark1 != null and remark1 != ''"> and remark1 = #{remark1}</if><if test="remark2 != null and remark2 != ''"> and remark2 = #{remark2}</if><if test="remark3 != null and remark3 != ''"> and remark3 = #{remark3}</if><if test="remark4 != null and remark4 != ''"> and remark4 = #{remark4}</if><if test="remark5 != null and remark5 != ''"> and remark5 = #{remark5}</if></where></select><select id="selectSiteExampleById" parameterType="Long" resultMap="SiteExampleResult"><include refid="selectSiteExampleVo"/>where id = #{id}</select><insert id="insertSiteExample" parameterType="SiteExample" useGeneratedKeys="true" keyProperty="id">insert into site_example<trim prefix="(" suffix=")" suffixOverrides=","><if test="title != null">title,</if><if test="type != null">type,</if><if test="content != null">content,</if><if test="urlAddress != null">url_address,</if><if test="iconBase64 != null">icon_base64,</if><if test="iconPath != null">icon_path,</if><if test="createUser != null">create_user,</if><if test="createTime != null">create_time,</if><if test="isUse != null">is_use,</if><if test="isDel != null">is_del,</if><if test="remark1 != null">remark1,</if><if test="remark2 != null">remark2,</if><if test="remark3 != null">remark3,</if><if test="remark4 != null">remark4,</if><if test="remark5 != null">remark5,</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test="title != null">#{title},</if><if test="type != null">#{type},</if><if test="content != null">#{content},</if><if test="urlAddress != null">#{urlAddress},</if><if test="iconBase64 != null">#{iconBase64},</if><if test="iconPath != null">#{iconPath},</if><if test="createUser != null">#{createUser},</if><if test="createTime != null">#{createTime},</if><if test="isUse != null">#{isUse},</if><if test="isDel != null">#{isDel},</if><if test="remark1 != null">#{remark1},</if><if test="remark2 != null">#{remark2},</if><if test="remark3 != null">#{remark3},</if><if test="remark4 != null">#{remark4},</if><if test="remark5 != null">#{remark5},</if></trim></insert><update id="updateSiteExample" parameterType="SiteExample">update site_example<trim prefix="SET" suffixOverrides=","><if test="title != null">title = #{title},</if><if test="type != null">type = #{type},</if><if test="content != null">content = #{content},</if><if test="urlAddress != null">url_address = #{urlAddress},</if><if test="iconBase64 != null">icon_base64 = #{iconBase64},</if><if test="iconPath != null">icon_path = #{iconPath},</if><if test="createUser != null">create_user = #{createUser},</if><if test="createTime != null">create_time = #{createTime},</if><if test="isUse != null">is_use = #{isUse},</if><if test="isDel != null">is_del = #{isDel},</if><if test="remark1 != null">remark1 = #{remark1},</if><if test="remark2 != null">remark2 = #{remark2},</if><if test="remark3 != null">remark3 = #{remark3},</if><if test="remark4 != null">remark4 = #{remark4},</if><if test="remark5 != null">remark5 = #{remark5},</if></trim>where id = #{id}</update><delete id="deleteSiteExampleById" parameterType="Long">delete from site_example where id = #{id}</delete><delete id="deleteSiteExampleByIds" parameterType="String">delete from site_example where id in <foreach item="id" collection="array" open="(" separator="," close=")">#{id}</foreach></delete>">