模糊查询
1、使用concat进行字符串拼接
<select id="searUserInfo" parameterType="String" resultType="com.zhongruan.bean.UserInfo" >
select * from tb_user where username like concat('%',#{username},'%')
</select>
2、直接添加%
<select id="searUserInfo" parameterType="String" resultType="com.zhongruan.bean.UserInfo" >
select * from tb_user where username like "%"#{username}"%"
</select>