2023-08-16 19:28:47.599 INFO 7260 --- [nio-8080-exec-5] c.s.i.JwtTokenAdminInterceptor : jwt校验:eyJhbGciOiJIUzI1NiJ9.eyJlbXBJZCI6MSwiZXhwIjoxNjkyMTkxMjk0fQ.acKQU1IOoqCKYFhW4p9RnBaZpjPeFTnjW5OAjqCKYWg
2023-08-16 19:28:47.599 INFO 7260 --- [nio-8080-exec-5] c.s.i.JwtTokenAdminInterceptor : 当前员工id:
2023-08-16 19:28:47.600 WARN 7260 --- [nio-8080-exec-5] c.s.controller.admin.EmployeeController : EmployeeDTO(id=null, username=wersf, name=awd, phone=13432344889, sex=1, idNumber=123456789123456789)
2023-08-16 19:28:47.600 DEBUG 7260 --- [nio-8080-exec-5] c.s.mapper.EmployeeMapper.getByUsername : ==> Preparing: select * from employee where username = ?
2023-08-16 19:28:47.600 DEBUG 7260 --- [nio-8080-exec-5] c.s.mapper.EmployeeMapper.getByUsername : ==> Parameters: wersf(String)
2023-08-16 19:28:47.601 DEBUG 7260 --- [nio-8080-exec-5] c.s.mapper.EmployeeMapper.getByUsername : <== Total: 0
2023-08-16 19:28:47.601 DEBUG 7260 --- [nio-8080-exec-5] com.sky.mapper.EmployeeMapper.save : ==> Preparing: INSERT INTO employee ( name, username, password, phone , sex, id_number, status, create_time , update_time, create_user, update_user) VALUES ( ?, ?, ?, ? , ?, ?, ?, ? , ?, ?, ?)
2023-08-16 19:28:47.602 ERROR 7260 --- [nio-8080-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [emp, param1]] with root cause
org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [emp, param1]
异常原因:在mapper层里
void save(@parem(“emp”)Employee emp);、
在sql语句看半天,各种检查发现多加了一个@parem(“emp”),如果加了这个那么sql语句里
就要加上例如#{emp.name}。