一:处理模糊查询
①创建mapper接口:
public interface SpecialSQLMapper {
List<User> getUserByLike(@Param("mohu") String mohu);
}
②创建对应接口的映射文件(这里有三种处理方式)
<!-- List<User> getUserByLike(@Param("mohu") String mohu);-->
<select id="getUserByLike" resultType="User">
<!-- select * from t_user where username like '%${mohu}%'-->
<!-- select * from t_user where username like concat('%',#{mohu},'%')-->
select * from t_user where username like "%"#{mohu}"%"
</select>
③测试类:
public class SpecialSQLMapperTest {
@Test
public void testGetUserByLike() {
SqlSession sqlSession = SqlSessionUtil.getSqlSession();
SpecialSQLMapper mapper = sqlSess