android - android项目中SQLite向表中插入一条记录的错误

Question

我创建了一个这样的表:

DB_CREATE = "create table " + DB_TABLE + " (" + 
"id" + " integer, " + 
 "title" + " text, " + "author" + " text, " + 
 "image" + " text, " +   "time" + " text, " +
 "detail" + " text);";

 _db.execSQL(DB_CREATE);

哪个 _db 是对 SQLiteDatabase 的引用。我按如下方式调用方法 insert():

ContentValues newValues = new ContentValues();
    if(object instanceof NewsBean) {
        newValues.put("id", ((NewsBean) object).getId());
        newValues.put("title", ((NewsBean) object).getTitle());
        newValues.put("author", ((NewsBean) object).getAuthor());
        newValues.put("image", ((NewsBean) object).getImage());
        newValues.put("time", ((NewsBean) object).getTime());
        newValues.put("detail", ((NewsBean) object).getDetail());

        return db.insert(DB_TABLE, null, newValues);

问题是 newValues 中的元素没有列为表格列。如何解决？我不想换 table 。

Answer 1

“id”列被定义为自动递增。因此，您不得将“id”列的值放入 ContentValues。