sql错误

sql错误

查询错误

 <where>
            a.conference_id = #{dto.conferenceId}
            <if test=" dto.realName!= null and dto.realName != ''">
                and b.real_name LIKE concat('%',#{dto.realName},'%')
            </if>
            <if test=" dto.mobile!= null and dto.mobile != ''">
                and b.mobile LIKE concat ('%',#{dto.mobile},'%')
            </if>
            <if test=" dto.workplace!= null and dto.workplace != ''">
                and b.workplace LIKE concat ('%',#{dto.workplace},'%')
            </if>
            <if test=" dto.conferenceType!= null">
                and b.conference_type = #{dto.conferenceType}
            </if>
            <if test=" dto.isStay!= null">
                and b.is_stay = #{dto.isStay}
            </if>
        </where>
        ORDER BY
        a.gmt_create DESC

这里注意参数isStay为Integer类型写法与String不太一样，Integer只需要判断null即可，String需要判断null与空两个