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

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

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

    
        
        
            del_flag = '0'
            and development_history_txt  like '%${developmentHistoryTxt}%'
            and roof_placement = #{roofPlacement}
            and status = #{status}
            and remarks = #{remarks}