一、MyBatis模糊查询
1. 接口方法
List<Car> getUserByLike(@Param("mohu") String mohu);
2. 映射文件
2.1、方法一
<select id="getUserByLike" resultType="Car">
select * from t_car where car_name like '%${mohu}%';
</select>
2.2、方法二
<select id="getUserByLike" resultType="Car">
select * from t_car where car_name like concat('%',#{mohu},'%');
</select>
2.3、方法三(常用)
<select id="getUserByLike" resultType="Car">
select * from t_car where car_name like "%"#{mohu}"%";
</select>
3. 测试类
@Test
public void test() throws IOException {
SqlSession sqlSession= SqlSessionUtil.getSqlSession();
CarMapper mapper = sqlSession.getMapper(CarMapper.class);
List<Car> userByLike = mapper.getUserByLike("兰");
userByLike.forEach(System.out::println);
}