public void addUser(User user) { SQLiteDatabase db = this.getWritableDatabase(); db.delete(TABLE_USER, null, null); ContentValues values = new ContentValues(); values.put(KEY_ID, user.getId()); values.put(KEY_FIRSTNAME, user.getFirstname()); values.put(KEY_LASTNAME, user.getLastname()); values.put(KEY_USERNAME, user.getUsername()); values.put(KEY_TOKEN, user.getToken()); db.insert(TABLE_USER, null, values); db.close(); // Closing database connection }
public User getUser() { // Select All Query User user = new User(); String selectQuery = "SELECT * FROM " + TABLE_USER; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { user.setId(cursor.getInt(cursor.getColumnIndex(KEY_ID))); user.setFirstname(cursor.getString(cursor.getColumnIndex(KEY_FIRSTNAME))); user.setLastname(cursor.getString(cursor.getColumnIndex(KEY_LASTNAME))); user.setUsername(cursor.getString(cursor.getColumnIndex(KEY_USERNAME))); user.setToken(cursor.getString(cursor.getColumnIndex(KEY_TOKEN))); } cursor.close(); db.close(); // return contact list return user; }