addcontent.java里如下代码缺少table其他的项目赋值:
修正前:
public void addDB(){
ContentValues cv = new ContentValues();
cv.put(NotesDB.CONTENT, ettext.getText().toString());
cv.put(NotesDB.TIME, getTime());
dbWriter.insert(NotesDB.TABLE_NAME, null, cv);
}
修正后:
public void addDB(){
ContentValues cv = new ContentValues();
cv.put(NotesDB.CONTENT, ettext.getText().toString());
cv.put(NotesDB.TIME, getTime());
cv.put(NotesDB.PATH, phoneFile + "");
cv.put(NotesDB.VIDEO, videoFile + "");
dbWriter.insert(NotesDB.TABLE_NAME, null, cv);
}
其中table 定义部分为:
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + ID
+ " INTEGER PRIMARY KEY AUTOINCREMENT," + CONTENT
+ " TEXT NOT NULL," + PATH + " TEXT NOT NULL," + VIDEO
+ " TEXT NOT NULL," + TIME + " TEXT NOT NULL)");
}
SQLITE Error inserting 或者 android.database.sqlite.SQLiteConstraintException: error code 19
最新推荐文章于 2023-06-15 16:47:37 发布