首頁猿問在 SQLite 中使用 long...

在 SQLite 中使用 long 始終返回 -1 時(shí)出現(xiàn)問題

Java

回首憶惘然 2022-09-07 21:45:02

我無法找到代碼中缺少的內(nèi)容。我正在嘗試插入數(shù)據(jù)，但數(shù)據(jù)庫助手類中的“l(fā)ong result == db.insert”始終返回-1”。我無法指出我做錯(cuò)了什么。請幫忙。任何想法將不勝感激。我的數(shù)據(jù)庫助手類：public class DatabaseHelper extends SQLiteOpenHelper {public static final String DATABASE_NAME = "drivefinal.db";public static final String TABLE_NAME = "drive_table";public static final String ID = "ID";public static final String NUMBER = "Number";public static final String FNAME = "First Name";public static final String LNAME = "Last Name";public static final String COORDINATE = "Coordinate";public static final String ADDRESS = "Address";public static final String NOTES = "Notes";public DatabaseHelper(Context context) { super(context, DATABASE_NAME, null, 1);}@Overridepublic void onCreate(SQLiteDatabase db) { db.execSQL("create table if not exists " + TABLE_NAME +"(ID INTEGER PRIMARY KEY AUTOINCREMENT ,NUMBER TEXT,FNAME TEXT,LNAME TEXT,COORDINATE TEXT,ADDRESS TEXT,NOTES TEXT)");}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME); onCreate(db);}public boolean insertData(String number, String fName, String lName, String coordinate, String address, String notes){ SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(NUMBER, number); contentValues.put(FNAME, fName); contentValues.put(LNAME, lName); contentValues.put(COORDINATE, coordinate); contentValues.put(ADDRESS, address); contentValues.put(NOTES, notes); long result = db.insert(TABLE_NAME,null ,contentValues); if(result == -1 ) return false; else return true;}

查看完整描述

1 回答

慕森王

TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超3個(gè)贊

表定義創(chuàng)建的列名與您在插入時(shí)嘗試使用的列名不同。

例如，您的表將具有列名 FNAME 而不是名字（等）。

其次，嘗試使用名為“名字”的列時(shí)會(huì)遇到問題，因?yàn)樗粋€(gè)空格，并且必須括起來，例如[名字]。

我建議使用：-

public static final String NUMBER = "Number";

public static final String FNAME = "FirstName"; //<<<<<<<<<< space removed

public static final String LNAME = "LastName"; //<<<<<<<<<< space removed

public static final String COORDINATE = "Coordinate";

public static final String ADDRESS = "Address";

public static final String NOTES = "Notes";

隨著：-

db.execSQL("create table if not exists " + TABLE_NAME +"(" + ID + " INTEGER PRIMARY KEY AUTOINCREMENT ," + NUMBER + " TEXT," + FNAME + " TEXT," + LNAME + " TEXT," + COORDINATE + " TEXT," + ADDRESS + " TEXT," + NOTES + " TEXT)");

要引入更改（即運(yùn)行onCreate方法，因?yàn)樗鼉H在創(chuàng)建數(shù)據(jù)庫時(shí)自動(dòng)運(yùn)行），您必須執(zhí)行以下操作之一：-