1、前端上送拼接条件没问题
2、条件拼接完之后name字段出现乱码
Time:2 ms - ID:com.atguigu.eduService.mapper.EduTeacherMapper.selectPage
Execute SQL:
SELECT
id,
name,
intro,
career,
level,
avatar,
sort,
is_deleted,
gmt_create,
gmt_modified
FROM
edu_teacher
WHERE
is_deleted=0
AND name LIKE '%??%'
3、其实不只是模糊查询,只要涉及到中文都会出现乱码,此时查看配置
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8
4.解决方法,在后面加上useUnicode=true&characterEncoding=UTF-8即可
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8即可
Time:2 ms - ID:com.atguigu.eduService.mapper.EduTeacherMapper.selectPage
Execute SQL:
SELECT
id,
name,
intro,
career,
level,
avatar,
sort,
is_deleted,
gmt_create,
gmt_modified
FROM
edu_teacher
WHERE
is_deleted=0
AND name LIKE '%张三%' LIMIT 0,10