ibatis 模糊查询和多条件查询

    <select        id="getList"        parameterType="remotecollaborationDO"        resultType="remotecollaborationDO" >        SELECT  t1.id,t1.send_user_id,t1.status,t1.content,t1.profile,        t1.contact_person,t1.contact_tel,t1.institute,t1.email,t1.comment,t2.real_name        FROM remote_collaboration t1        LEFT JOIN user_info t2         ON t1.send_user_id=t2.user_id        where 1=1        <if test="(status!=3 )" >        and status=#{status}        </if>        <if test="real_name!=null and real_name!=''  " >        and real_name  like CONCAT('%', trim(#{real_name}),'%')        </if>        <if test="(itemPerPage!=null and itemPerPage!=0 and startRow>=0)" >            limit #{startRow}, #{itemPerPage}         </if>    </select>