Mybatis如何进行模糊查询

这里我使用注解的方式来演示

首先是mapper层：

@select("select * from user where username = #{username}")
User getUserByName(String userName);

在调用此方法的时候，注意要在参数前后加上%

@autowired
private UserMapper userMapper;

User getUserByName(String userName){
	userMapper. getUserByName("%" + userName + "%")
}

最终测试：

==>  Preparing: select * from student_info where realname like ?
==> Parameters: %张%(String)
<==    Columns: id, account, realname, sex, phone, birth_date, regist_date
<==        Row: 1, student, 张三, , , null, 2022-03-07
<==      Total: 1