org.apache.ibatis.binding.BindingException: Parameter ‘username‘ not found. postman报错500

梦里梦外; 2024-03-24 09:25 24阅读 0赞

查询中，postman报错500，且idea报错：

2023-03-27 18:43:08.297 ERROR 33084 --- [nio-8080-exec-2] 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 'username' not found. 
    Available parameters are [page, user, param1, param2]] with root cause
    
    org.apache.ibatis.binding.BindingException: 
    Parameter 'username' not found.
     Available parameters are [page, user, param1, param2]

![b6c5ab0d83d34775a2569326266f65bd.png][]

![8c2663756e3c490e960c867857ade6e6.png][]

**报错信息说，username没找到**

错误解决：mapper中我给user对象起了别名用来区分page对象，但是**xml文件没对应着改**，第一个是username的if语句，没找到，直接报错

![86dbb60896b24fcc91df4cd20f685ae9.png][]

![52e17515da1f4585a8a8817a1bf4a22a.png][]

**把红框内的username改为user.username就能找到了**

[b6c5ab0d83d34775a2569326266f65bd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/a7b150e92b66438c8e13d55d861f83e6.png
[8c2663756e3c490e960c867857ade6e6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/5edc7b1c991340dd832e3962d2307c61.png
[86dbb60896b24fcc91df4cd20f685ae9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/3d257e995aa948adbf33b26c2f1c198c.png
[52e17515da1f4585a8a8817a1bf4a22a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/c533c3aaec594eda891963be69680aa7.png