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>
<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>