绑定参数太多.提供了 5 个参数，但语句需要 4 个参数
执行下面的函数时，我得到了上面的 IllegalArgumentException.我没有得到的是，当我运行调试器时，values 变量显然只包含 4 个参数，因为它应该.
I get the IllegalArgumentException above when executing the function below. What I don't get is that when I run the debugger, the values variable clearly only contains 4 arguments, as it should.
所以……
(1) 这个神秘的第五个论点从何而来?
(1) Where does this mysterious fifth argument come from?
(2) 我应该如何找到这个错误?
(2) How should I approach finding this error?
db.update(
UppdragEntry.TABLE_NAME,
values,
selection,
selectionArgs);
推荐答案
Selection 包含以下内容: String selection = "_id";String[] selectionArgs = {" =" + personId};
Selection contains the following: String selection = "_id"; String[] selectionArgs = {" =" + personId};
您在 selectionArgs 中有一个值，但在 selection 中没有 ? 占位符.
You have a value in selectionArgs but no ? placeholder for it in selection.
改成
String selection = "_id = ?";
String[] selectionArgs = { "" + personId };
该方法构建一个 SQL 字符串.提供的 ContentValues 构建为 ? 占位符和绑定参数.额外的选择参数也作为绑定参数提供，它们必须与相同数量的 ? 占位符匹配.
The method builds an SQL string. Supplied ContentValues are built as ? placeholder and bind arguments. Additional selection args are also provided as bind arguments and they must be matched with equal number of ? placeholders.
相关文章