MyBatis错误之 Parameter 'xxx' not found. Available parameters are [xxx]

蔚落 2022-01-16 00:41 292阅读 0赞

MyBatis中操作数据时显示错误  **Parameter 'xxx' not found. Available parameters are \[xxx\]**

即SQL语句中 **参数传递错误**

有两种解决方法参考：

**1. 加注解（测试过成功debug）**

在该方法定义时加注解 **@Param**

public interface LogDAO {
        void insertLog( @Param("username") String username, @Param("logInfo") String logInfo);
    }

**2. 写下标（当时试没效果，可供参考，如果上一个方法不行，可以试试）**

SQL语句需要参数的地方改为 \#\{1\} \#\{2\} \#\{3\}……  参数写入方法定义的顺序

<insert id="insertLog" parameterType="String">
         insert into log (logUserId, logInfo) VALUES (#{0}, #{1})
    </insert>

参考文章：【1】[mybatis出现Parameter 'xxx' not found. Available parameters are \[...\]错误][mybatis_Parameter _xxx_ not found. Available parameters are _...]

【2】[Parameter '\*\*' not found. Available parameters are \[0, 1, param1, param2\]解决办法][Parameter _ not found. Available parameters are _0_ 1_ param1_ param2]

【3】[Parameter '\*\*' not found. Available parameters are \[0, 1, param1, param2\]解决办法][Parameter _ not found. Available parameters are _0_ 1_ param1_ param2 1]

[mybatis_Parameter _xxx_ not found. Available parameters are _...]: https://blog.csdn.net/weixin_44261856/article/details/88368182
[Parameter _ not found. Available parameters are _0_ 1_ param1_ param2]: https://blog.csdn.net/baidu_35975930/article/details/80014087
[Parameter _ not found. Available parameters are _0_ 1_ param1_ param2 1]: https://blog.csdn.net/qq_38726370/article/details/90056649