myybatis 自由模糊查询

    <select id="getlike" parameterType="ConditionUser" resultType="User">
    
        select * from d_user where  
        
        <if test="name != null">
        <!-- 如下格式  -->
        name like '%' #{name} '%' and 
        
        </if>
        
        
        age between #{minAge} and #{maxAge}
        
    </select>

 

转载于:https://www.cnblogs.com/moonmars/p/6629337.html