spring boot项目mapper.xml文件中遇到模糊查询问题解决

springboot项目中的mapper.xml文件编辑查询Sql语句中将等号换成上图like后加**%${参数}%**形式即可

    <select id="selectCmsDevelopmentHistoryList" parameterType="com.hbck.website.domain.CmsDevelopmentHistory" resultMap="CmsDevelopmentHistoryResult">
        <include refid="selectCmsDevelopmentHistoryVo"/>
        <where>
            del_flag = '0'
            <if test="developmentHistoryTxt != null  and developmentHistoryTxt != ''">and development_history_txt  like '%${developmentHistoryTxt}%'</if>
            <if test="roofPlacement != null  and roofPlacement != ''">and roof_placement = #{roofPlacement}</if>
            <if test="status != null  and status != ''">and status = #{status}</if>
            <if test="remarks != null  and remarks != ''">and remarks = #{remarks}</if>
        </where>
    </select>