在java中的dao或service层或者controller层传值的时候写上%%号
public void getUserByName(String name) {
userDao.getUserByName("%" + name + "%");
}
mapper文件:
<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
SELECT * FROM user WHERE name LIKE #{name}
</select>
<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
</select>
<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
SELECT * FROM user WHERE name like "%"#{name}"%"
</select>