java - 尝试更新 SQLite 时出现 "SQL error or missing data type near WHERE syntax"

Question

我遇到问题，但找不到错误。它不允许我更新索引，并且总是提示 SQL 错误或 WHERE 语法附近缺少数据类型。其他一切都有效。所以我想你们可以看看这个:

创建表:execute("CREATE TABLE Players (player TEXT, Money DOUBLE, job TEXT, level INTEGER, exp DOUBLE)"); 有效

插入:DATABASE.execute("插入玩家值('"+ 玩家 + "', "+ 金钱 + ", '"+ job.getJob() + "', "+ job.getLevel( ) + ", "+ job.getEXP() + ")"); 有效

更新:DATABASE.execute("更新玩家，其中player = '"+ player.toLowerCase() + "' SET Money = "+ Money + ", job = '"+ job.getJob() + "', level = "+ job.getLevel() + ", exp = "+ job.getEXP()); 不起作用

我使用以下值进行更新:

player = gemaken
money = 100.0
job.getJob() = miner
level = 0
exp = 0.0

提前致谢!

真诚的，格玛肯

Answer 1

在 SQL UPDATE 中，SET 部分先出现，WHERE 部分稍后出现:

DATABASE.execute("UPDATE Players SET money = " + money + ", job = '" + job.getJob() + "', level = " + job.getLevel() + ", exp = " + job.getEXP()) + " WHERE player = '" + player.toLowerCase() + "';

此外，请考虑使用参数和准备好的语句。