/**
* 测试模糊查询
* @param mohu
* @return
*/
//模糊查询
List<User> getUserByName(@Param("mohuName") String mohuName);
映射文件mapper.xml:
<!-- List<User> getUserByName(@Param("mohuName") String mohuName);-->
<select id="testMohu" resultType="User">
<!--如下三种写法都ok-->
<!--select * from t_user where username like '%${mohuName}%'-->
<!--select * from t_user where username like concat('%',#{mohuName},'%')
这个cancat()是数据库中的字符串拼接函数-->
<!--必须是双引号-->
select * from t_user where username like "%"#{mohuName}"%"
</select>
@Test
public void testGetUserByName(){
SqlSession sqlSession = sqlSessionUtils.getSqlSession();
SelectMapper mapper = sqlSession.getMapper(SelectMapper.class);
List<User> a = mapper.getUserByName("a");
System.out.println(a);
}