<select id="selectSysAnnouncementList" parameterType="SysAnnouncement" resultMap="SysAnnouncementResult">
        <include refid="selectSysAnnouncementVo"/>
        <where>
            <if test="title != null  and title != ''">and title like '%'||#{title}||'%'</if>
            <if test="nickname != null  and nickname != ''"> and nickname like concat('%', #{nickname}, '%')</if>
        </where>
    </select>

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code