我正在開發一個關于 java（android studio 專案）的 SQL 資料庫，但我有一個奇怪的錯誤。基本上，每次我有
near "Hello": syntax error in "INSERT INTO GAMES(_id, PRICE, NAME, DEV, PLATFORM) VALUES (0, 70, Hello, Henri, Terrain)"
我試過這樣
public void addGame(String Price, String Name, String Dev, String Platform) {
database = getWritableDatabase();
database.execSQL("INSERT INTO " SchemeDB.TAB_GAMES "("
DBS.COL_GAMES_ID ", "
DBS.COL_GAMES_PRICE ", "
DBS.COL_GAMES_NAME ", "
DBS.COL_GAMES_DEV ", "
DBS.COL_GAMES_PLATFORM ") VALUES (" i ", "
Price ", "
Name ", "
Dev ", "
Platform ")");
database.close();
}
我的星展銀行是
public interface SchemeDB {
int VERSION = 1;
String DB_NAME = "????";
String TAB_GAMES = "???";
String COL_GAMES_ID = "_id";
String COL_GAMES_PRICE = "PRICE";
String COL_GAMES_NAME = "NAME";
String COL_GAMES_DEV = "DEV";
String COL_GAMES_PLATFORM = "PLATFORM";
}
而且我真的不明白錯誤在哪里。因為他們說“語法錯誤”，但對我來說，它看起來還不錯。有人有線索嗎？我只是想在我的資料庫中插入一些東西。
uj5u.com熱心網友回復：
像這樣的東西...
"'" Name "', "
"'" Dev "', "
"'" Platform "')");
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/480469.html
上一篇：子查詢實作