/** * 保存message * * @param message * @return 返回这条messaged在db中的id */ public synchronized Integer saveMessage(InviteMessage message) { SQLiteDatabase db = dbHelper.getWritableDatabase(); int id = -1; if (db.isOpen()) { ContentValues values = new ContentValues(); values.put(COLUMN_NAME_FROM, message.getFrom()); values.put(COLUMN_NAME_GROUP_ID, message.getGroupId()); values.put(COLUMN_NAME_GROUP_Name, message.getGroupName()); values.put(COLUMN_NAME_REASON, message.getReason()); values.put(COLUMN_NAME_TIME, message.getTime()); values.put(COLUMN_NAME_STATUS, message.getStatus().ordinal()); db.insert(TABLE_NAME, null, values); Cursor cursor = db.rawQuery("select last_insert_rowid() from " + TABLE_NAME, null); if (cursor.moveToFirst()) { id = cursor.getInt(0); } } return id; }