Parameter ‘name‘ not found. Available parameters are [0, 1, param1, param2]] with root cause

最新推荐文章于 2025-06-07 10:46:52 发布
最新推荐文章于 2025-06-07 10:46:52 发布
阅读量1.3w 收藏
点赞数 2
CC 4.0 BY-SA版权
分类专栏： 个人BUG集
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_40310480/article/details/82744111
本文介绍了一个SpringBoot环境中DAO层查询时遇到的问题：使用注解查询时加入参数会报错，提示找不到传入的参数。文章详细解释了如何定位问题并给出了正确的接口方法实现。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

SpringBoot环境,测试查询数据库,第一次直接通过dao层的注解查询,全局查询没问题,加入参数就报这里写图片描述错了.提示说传的参数找不到,打印出来都有值,最后查了一下
这是错误的接口方法
这里写图片描述
查询注解里的参数有问题,修改为:
这里写图片描述

解决错误 “Parameter ‘username‘ not found. Available parameters are [arg1, arg0, param1]“ 的方法详解
pleaseprintf的博客
07-12 7402
在开发应用程序时，有时可能会遇到错误信息 “Parameter ‘username’ not found. Available parameters are [arg1, arg0, param1]”，该错误表明在参数列表中找不到 ‘username’ 参数。本文将介绍如何解决这个错误，帮助你正确传递参数并避免出现问题。
Parameter 'name' not found. Available parameters are [arg1, arg0, param1, param2]
a8153285的博客
02-10 1079
解决方法： <select id="selectIf" resultType="student"> SELECT id,name,age,score FROM t_student WHERE 1=1 <if test="arg0 != null and arg0 !=''"> AND ...
Parameter 'name' not found. Available parameters are [0, 1, param1, param2]
热门推荐
Wendz的博客
09-19 1万+
org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [0, 1, param1, param2] at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:165)
Parameter ‘XXX‘ not found. Available parameters are [list, param1]
weixin_37301300的博客
06-07 435
1、在批量插入的中直接使用了字段名（如userArticlesId）而非列表项对象属性。3、VALUES部分的拼接语法错误（逗号位置不正确）2、动态SQL的判断未正确关联到列表项对象。
报错：Parameter 'name' not found. Available parameters are [0, 1, param1, param2]
fulong0406的博客
05-30 2086
修改前，我的映射文件是这样写的： <insert id="insertUser"> insert into users(name,age) values(#{name}, #{age}) </insert> 按照提示，将name和age用param1和param2代替， 修改后是： <insert id="insertUser"&g...
Parameter 'name' not found. Available parameters are [role,param1]
分外蓝
11-15 1440
原因：入参找不到， 解决方案： 需要 role.name,且需要在接口中设置别名，否则会报错 mapper里写name，接口中直接Role role
重大: 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 'insertUserId' not found. Available parameters are [params, param1]] with root cause org.apache.ibatis.binding.BindingException: Parameter 'insertUserId' not found. Available parameters are [params, param1]
最新发布
07-25
Available parameters are [params, param1] 根据引用[1][2][3][4][5]的信息，这类异常通常是因为MyBatis在映射接口方法参数时，无法找到与SQL语句中引用的参数名相匹配的参数。 具体原因和解决方案如下： 原因...
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 'flavor' not found. Available parameters are [flavors, collection, list]] with root cause
03-09
Available parameters are [arg0, arg1, param1, param2]` 这样的错误提示时，通常意味着 SQL 映射文件中的参数名称与实际传递给映射器方法的参数不匹配。这种情况下，MyBatis 无法找到名为 `flavor` 的参数。 ###...
2025-03-16T21:40:19.136+08:00 WARN 25332 --- [demo1] [nio-8080-exec-3] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.HttpRequestMethodNotSupportedException: Request method 'POST' is not supported] 2025-03-16T21:40:33.536+08:00 INFO 25332 --- [demo1] [nio-8080-exec-4] c.e.demo.controller.DeptController : 要修改的id：4 Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@613d0eef] was not registered for synchronization because synchronization is not active 2025-03-16T21:40:33.551+08:00 INFO 25332 --- [demo1] [nio-8080-exec-4] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2025-03-16T21:40:33.869+08:00 INFO 25332 --- [demo1] [nio-8080-exec-4] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@527baea9 2025-03-16T21:40:33.871+08:00 INFO 25332 --- [demo1] [nio-8080-exec-4] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. JDBC Connection [HikariProxyConnection@1064111603 wrapping com.mysql.cj.jdbc.ConnectionImpl@527baea9] will not be managed by Spring ==> Preparing: update dept set name = ?, create_time = ?,update_time=? where id = ? Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@613d0eef] 2025-03-16T21:40:33.912+08:00 ERROR 25332 --- [demo1] [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.mybatis.spring.MyBatisSystemException: ### Error updating database. Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2] ### The error may exist in com/example/demo/mapper/DeptMapper.java (best guess) ### The error may involve com.example.demo.mapper.DeptMapper.update-Inline ### The error occurred while setting parameters ### SQL: update dept set name = ?, create_time = ?,update_time=? where id = ? ### Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2]] with root cause
03-17
Available parameters are [id, dept, param1, param2] ``` 表明MyBatis在执行SQL时找不到名为 `name` 的参数。 --- ### **2. 问题场景还原** - **触发操作**：通过POST请求修改部门信息（`DeptController.update...
2025-03-16T22:17:33.366+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2025-03-16T22:17:33.366+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2025-03-16T22:17:33.367+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms 2025-03-16T22:17:33.449+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] c.e.demo.controller.DeptController : 要修改的dept：Dept(id=4, name=xue员部, createTime=null, updateTime=null) Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7bee5916] was not registered for synchronization because synchronization is not active 2025-03-16T22:17:33.463+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2025-03-16T22:17:33.762+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@a735783 2025-03-16T22:17:33.764+08:00 INFO 20444 --- [demo1] [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. JDBC Connection [HikariProxyConnection@1078374248 wrapping com.mysql.cj.jdbc.ConnectionImpl@a735783] will not be managed by Spring ==> Preparing: update dept set name = ?, create_time = ?,update_time=? where id = ? Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7bee5916] 2025-03-16T22:17:33.803+08:00 ERROR 20444 --- [demo1] [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.mybatis.spring.MyBatisSystemException: ### Error updating database. Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2] ### The error may exist in com/example/demo/mapper/DeptMapper.java (best guess) ### The error may involve com.example.demo.mapper.DeptMapper.update-Inline ### The error occurred while setting parameters ### SQL: update dept set name = ?, create_time = ?,update_time=? where id = ? ### Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2]] with root cause
03-18
Available parameters are [id, dept, param1, param2] ``` 这说明在MyBatis执行更新操作时，找不到参数'name'。可能是在Mapper接口的方法中，参数绑定出了问题。根据错误提示，可用的参数是[id, dept, param1, ...
2025-03-16T21:43:57.345+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2025-03-16T21:43:57.346+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2025-03-16T21:43:57.346+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Completed initialization in 0 ms 2025-03-16T21:43:57.434+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] c.e.demo.controller.DeptController : 要修改的id：4 Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b2ae945] was not registered for synchronization because synchronization is not active 2025-03-16T21:43:57.450+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2025-03-16T21:43:57.770+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@200a3e22 2025-03-16T21:43:57.772+08:00 INFO 28196 --- [demo1] [nio-8080-exec-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. JDBC Connection [HikariProxyConnection@580968360 wrapping com.mysql.cj.jdbc.ConnectionImpl@200a3e22] will not be managed by Spring ==> Preparing: update dept set name = ?, create_time = ?,update_time=? where id = ? Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b2ae945] 2025-03-16T21:43:57.809+08:00 ERROR 28196 --- [demo1] [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.mybatis.spring.MyBatisSystemException: ### Error updating database. Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2] ### The error may exist in com/example/demo/mapper/DeptMapper.java (best guess) ### The error may involve com.example.demo.mapper.DeptMapper.update-Inline ### The error occurred while setting parameters ### SQL: update dept set name = ?, create_time = ?,update_time=? where id = ? ### Cause: org.apache.ibatis.binding.BindingException: Parameter 'name' not found. Available parameters are [id, dept, param1, param2]] with root cause
03-17
Available parameters are [id, dept, param1, param2] ``` 表明SQL语句中尝试使用`#{name}`，但MyBatis未找到名为`name`的参数。 #### **2. 关键问题** - **Mapper方法参数未正确绑定**：MyBatis在调用Mapper方法...
Parameter 'name' not found. Available parameters are [password, arg0, param1, param2]
qq_46242165的博客
03-24 520
标题org.apache.ibatis.binding.BindingException: Parameter ‘name’ not found. Available parameters are [password, arg0, param1, param2] 今天在springboot整合mybatis时遇到的一个小坑 报错信息 根据用户名和密码查用户 这是我的UserMapper.xml...
Parameter ‘name‘ not found. Available parameters are [arg3, arg2, arg1, arg0, param3, param4, param1
2301_77739370的博客
01-03 1277
这个时候是因为我们用的spring官方支持的maven使用的最低jdk版本为17，为了使用11使用的阿里云的框架，这里有两种解决方案。2、如上图在pom文件中加入这行代码。1、@param指定参数名称。
idea运行报错Parameter ‘name‘ not found. Available parameters are [arg1, arg0, param1, param2]
每一次跌倒都是为了华丽的站起来。
08-07 5012
Parameter 'name' not found. Available parameters are [arg1, arg0, param1, param2] 出现问题： 在mapper或者dao中，两个参数未指定！ 问题显示： 解决方法： 在mapper（dao）中,使用@param指定传参 之后就可以运行啦！ 但是每个人出现的问题，很多很类似，其实解决办法并非全部可以行得通，希望对你们有帮助！ ...
解决Parameter ‘name‘ not found. Available parameters are [arg3, arg2]问题
m0_73818084的博客
12-27 1181
将name，gender，begin，end，用arg0，arg1，arg2，arg3替代。查看java代码发现name定义了，并没有问题。
解决报错 Parameter ‘name‘not found.Available parameters are [arg1,arg0,param1,param2]
weixin_54394527的博客
12-09 1056
解决报错 Parameter 'name'not found.Available parameters are [arg1,arg0,param1,param2]
[mybatis] 异常Available parameters are [0, 1, param1, param2]] with root cause解决
朱同学的博客
07-04 2750
问题描述: 使用mybatis框架做增删改查操作时报错,详细错误信息为: Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBati...
解决BindingException: Parameter ‘name‘ not found. Available parameters are [xxxx, param1, param2]
haroroc的博客
06-18 1万+
在做分页查询的时候，后台报出BindingException: Parameter ‘name‘ not found. Available parameters are [xxxx, param1, param2]错误。
Parameter ‘name’ not found. Available parameters are [teacherUser, maxAge, param1, param2]....
2301_78513202的博客
04-16 410
Parameter 'name’ not found. Available parameters are .......mybatis多参数传递
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值