java异常信息之手欠多加@parem(“emp”)

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}。

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值