android.database.sqlite.SQLiteDatabase#replace ( )源码实例Demo

下面列出了android.database.sqlite.SQLiteDatabase#replace ( ) 实例代码，或者点击链接到github查看源代码，也可以在右侧发表评论。

源代码1 项目： YiBo 文件： UserGroupDao.java

void save(SQLiteDatabase sqLiteDatabase, UserGroup userGroup) {
	if (isNull(userGroup)) {
		return;
	}
	if(Logger.isDebug()){
		Log.d("Save UserGroup:", userGroup.toString());
	}

	ContentValues values = new ContentValues();
	values.put("Service_Provider", userGroup.getServiceProvider().getSpNo());
	values.put("User_ID", userGroup.getUserId());
	values.put("Group_ID", userGroup.getGroupId());
	values.put("State", userGroup.getState());

	sqLiteDatabase.replace(TABLE, null, values);
}

源代码2 项目： school_shop 文件： UserDao.java

/**
 * 保存好友list
 * 
 * @param contactList
 */
public void saveContactList(List<User> contactList) {
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	if (db.isOpen()) {
		db.delete(TABLE_NAME, null, null);
		for (User user : contactList) {
			ContentValues values = new ContentValues();
			values.put(COLUMN_NAME_ID, user.getUsername());
			if(user.getNick() != null)
				values.put(COLUMN_NAME_NICK, user.getNick());
			if(user.getAvatar() != null)
			    values.put(COLUMN_NAME_AVATAR, user.getAvatar());
			db.replace(TABLE_NAME, null, values);
		}
	}
}

源代码3 项目： nono-android 文件： DemoDBManager.java

/**
 * 保存好友list
 * 
 * @param contactList
 */
synchronized public void saveContactList(List<EaseUser> contactList) {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    if (db.isOpen()) {
        db.delete(UserDao.TABLE_NAME, null, null);
        for (EaseUser user : contactList) {
            ContentValues values = new ContentValues();
            values.put(UserDao.COLUMN_NAME_ID, user.getUsername());
            if(user.getNick() != null)
                values.put(UserDao.COLUMN_NAME_NICK, user.getNick());
            if(user.getAvatar() != null)
                values.put(UserDao.COLUMN_NAME_AVATAR, user.getAvatar());
            db.replace(UserDao.TABLE_NAME, null, values);
        }
    }
}

源代码4 项目： recurrence 文件： DatabaseHelper.java

public void addNotification(Reminder reminder) {
    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COL_ID, reminder.getId());
    values.put(COL_TITLE, reminder.getTitle());
    values.put(COL_CONTENT, reminder.getContent());
    values.put(COL_DATE_AND_TIME, reminder.getDateAndTime());
    values.put(COL_REPEAT_TYPE, reminder.getRepeatType());
    values.put(COL_FOREVER, reminder.getForeverState());
    values.put(COL_NUMBER_TO_SHOW, reminder.getNumberToShow());
    values.put(COL_NUMBER_SHOWN, reminder.getNumberShown());
    values.put(COL_ICON, reminder.getIcon());
    values.put(COL_COLOUR, reminder.getColour());
    values.put(COL_INTERVAL, reminder.getInterval());
    database.replace(NOTIFICATION_TABLE, null, values);
}

源代码5 项目： PluginLoader 文件： PluginSQLiteHelper.java

/**
 * 改
 * 
 * @param db db
 * @param values values
 * @param selectionArgs args
 * @return result
 */
public static long update(SQLiteDatabase db, ContentValues values, String[] selectionArgs) {
       try {
           return db.replace(TABLE_NAME, null,values);
       } catch (Exception e) {
           e.printStackTrace();
       }
       return -1;
}

源代码6 项目： FanXin-based-HuanXin 文件： UserDao.java

/**
 * 保存一个联系人
 * @param user
 */
public void saveContact(User user){
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	ContentValues values = new ContentValues();
	values.put(COLUMN_NAME_ID, user.getUsername());
	if (user.getNick() != null) {
           values.put(COLUMN_NAME_NICK, user.getNick());
       }
       if (user.getBeizhu() != null) {
           values.put(COLUMN_NAME_BEIZHU, user.getBeizhu());
       }
       if (user.getTel() != null) {
           values.put(COLUMN_NAME_TEL, user.getTel());
       }
       if (user.getSex() != null) {
           values.put(COLUMN_NAME_SEX, user.getSex());
       }
       if (user.getAvatar() != null) {
           values.put(COLUMN_NAME_AVATAR, user.getAvatar());
       }
       if (user.getSign() != null) {
           values.put(COLUMN_NAME_SIGN, user.getSign());
       }
       if (user.getFxid() != null) {
           values.put(COLUMN_NAME_FXID, user.getFxid());
       }
       if (user.getRegion()!= null) {
           values.put(COLUMN_NAME_REGION, user.getRegion());
       }
	if(db.isOpen()){
		db.replace(TABLE_NAME, null, values);
	}
}

源代码7 项目： school_shop 文件： UserDao.java

/**
 * 保存一个联系人
 * @param user
 */
public void saveContact(User user){
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	ContentValues values = new ContentValues();
	values.put(COLUMN_NAME_ID, user.getUsername());
	if(user.getNick() != null)
		values.put(COLUMN_NAME_NICK, user.getNick());
	if(user.getAvatar() != null)
	    values.put(COLUMN_NAME_AVATAR, user.getAvatar());
	if(db.isOpen()){
		db.replace(TABLE_NAME, null, values);
	}
}

源代码8 项目： BaseProject 文件： BaseDao.java

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

源代码9 项目： DoraemonKit 文件： BaseDao.java

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

源代码10 项目： FanXin-based-HuanXin 文件： UserDao.java

/**
 * 保存好友list
 * 
 * @param contactList
 */
public void saveContactList(List<User> contactList) {
	SQLiteDatabase db = dbHelper.getWritableDatabase();
	if (db.isOpen()) {
		db.delete(TABLE_NAME, null, null);
		for (User user : contactList) {
			ContentValues values = new ContentValues();
			values.put(COLUMN_NAME_ID, user.getUsername());
			if (user.getNick() != null) {
                   values.put(COLUMN_NAME_NICK, user.getNick());
               }
               if (user.getBeizhu() != null) {
                   values.put(COLUMN_NAME_BEIZHU, user.getBeizhu());
               }
               if (user.getTel() != null) {
                   values.put(COLUMN_NAME_TEL, user.getTel());
               }
               if (user.getSex() != null) {
                   values.put(COLUMN_NAME_SEX, user.getSex());
               }
               if (user.getAvatar() != null) {
                   values.put(COLUMN_NAME_AVATAR, user.getAvatar());
               }
               if (user.getSign() != null) {
                   values.put(COLUMN_NAME_SIGN, user.getSign());
               }
               if (user.getFxid() != null) {
                   values.put(COLUMN_NAME_FXID, user.getFxid());
               }
               if (user.getRegion()!= null) {
                   values.put(COLUMN_NAME_REGION, user.getRegion());
               }
			db.replace(TABLE_NAME, null, values);
		}
	}
}

源代码11 项目： iBeebo 文件： AtUsersDBTask.java

public static void add(SQLiteDatabase db, AtUserBean atUserBean, String accountId) {
    Gson gson = new Gson();
    ContentValues cv = new ContentValues();
    cv.put(AtUsersTable.USERID, atUserBean.getUid());
    cv.put(AtUsersTable.ACCOUNTID, accountId);
    String json = gson.toJson(atUserBean);
    cv.put(AtUsersTable.JSONDATA, json);
    db.replace(AtUsersTable.TABLE_NAME, AtUsersTable.ID, cv);

    reduce(accountId);
}

源代码12 项目： okdownload 文件： BreakpointSQLiteHelper.java

public void updateFilename(@NonNull String url, @NonNull String filename) {
    final SQLiteDatabase db = getWritableDatabase();
    ContentValues values = new ContentValues(2);
    values.put(URL, url);
    values.put(FILENAME, filename);

    Cursor c = null;
    synchronized (url.intern()) {
        try {
            final String query = "SELECT " + FILENAME + " FROM " + RESPONSE_FILENAME_TABLE_NAME
                    + " WHERE " + URL + " = ?";
            c = db.rawQuery(query, new String[]{url});
            if (c.moveToFirst()) {
                // exist
                if (!filename.equals(c.getString(c.getColumnIndex(FILENAME)))) {
                    // replace if not equal
                    db.replace(RESPONSE_FILENAME_TABLE_NAME, null, values);
                }
            } else {
                // insert
                db.insert(RESPONSE_FILENAME_TABLE_NAME, null, values);
            }
        } finally {
            if (c != null) c.close();
        }
    }
}

源代码13 项目： three-things-today 文件： ThreeThingsDatabase.java

public synchronized boolean writeContentValues(ContentValues values) {
    if (values == null) {
        return false;
    }

    SQLiteDatabase db = mDbHelper.getWritableDatabase();

    Log.d("ThreeThingsDatabase", "writeContentValues: writing: " + values.toString());
    return db.replace(ThreeThingsEntry.TABLE_NAME, null, values) != -1;
}

源代码14 项目： recurrence 文件： DatabaseHelper.java

public void addColour(Colour colour) {
    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COL_PICKER_COLOUR, colour.getColour());
    values.put(COL_PICKER_DATE_AND_TIME, colour.getDateAndTime());
    database.replace(PICKER_COLOUR_TABLE, null, values);
}

源代码15 项目： YiBo 文件： SocialGraphDao.java

void save(SQLiteDatabase sqLiteDatabase, User userA, User userB, Relation relation, ServiceProvider sp) {
	ContentValues values = new ContentValues();
	values.put("User_A_ID", userA.getUserId());
	values.put("User_B_ID", userB.getUserId());
	values.put("Service_Provider", sp.getSpNo());
	values.put("Relationship", relation.getType());
	sqLiteDatabase.replace(TABLE, null, values);
}

源代码16 项目： okhttp-OkGo 文件： BaseDao.java

public boolean replace(SQLiteDatabase database, List<T> ts) {
    try {
        for (T t : ts) {
            database.replace(getTableName(), null, getContentValues(t));
        }
        return true;
    } catch (Exception e) {
        OkLogger.printStackTrace(e);
        return false;
    }
}

源代码17 项目： Memento 文件： Controller.java

/**
 * Reads data from json array
 * @param json an array of json objects
 * @throws Exception
 */
public void readBackup(JSONArray json) throws Exception {
	SQLiteDatabase db = helper.getReadableDatabase();

	try {
		int length = json.length();
		for (int i = 0; i < length; i++) {
			JSONObject item = json.getJSONObject(i);

			ContentValues values = new ContentValues();
			values.put(OpenHelper.COLUMN_ID, item.getLong(OpenHelper.COLUMN_ID));
			values.put(OpenHelper.COLUMN_TITLE, item.getString(OpenHelper.COLUMN_TITLE));
			values.put(OpenHelper.COLUMN_BODY, item.getString(OpenHelper.COLUMN_BODY));
			values.put(OpenHelper.COLUMN_TYPE, item.getInt(OpenHelper.COLUMN_TYPE));
			values.put(OpenHelper.COLUMN_DATE, item.getString(OpenHelper.COLUMN_DATE));
			values.put(OpenHelper.COLUMN_ARCHIVED, item.getInt(OpenHelper.COLUMN_ARCHIVED));
			values.put(OpenHelper.COLUMN_THEME, item.getInt(OpenHelper.COLUMN_THEME));
			values.put(OpenHelper.COLUMN_COUNTER, item.getInt(OpenHelper.COLUMN_COUNTER));
			values.put(OpenHelper.COLUMN_PARENT_ID, item.getLong(OpenHelper.COLUMN_PARENT_ID));
			values.put(OpenHelper.COLUMN_EXTRA, item.getString(OpenHelper.COLUMN_EXTRA));

			db.replace(
				OpenHelper.TABLE_NOTES,
				null,
				values
			);
		}
	} finally {
		db.close();
	}
}

源代码18 项目： DoraemonKit 文件： BaseDao.java

public long replace(SQLiteDatabase database, ContentValues contentValues) {
    return database.replace(getTableName(), null, contentValues);
}

源代码19 项目： DoraemonKit 文件： BaseDao.java

public long replace(SQLiteDatabase database, ContentValues contentValues) {
    return database.replace(getTableName(), null, contentValues);
}

源代码20 项目： YiBo 文件： TaskDao.java

public Task saveRecentContact(Task task) {
	if (task == null) {
		return null;
	}
	
	SQLiteDatabase sqLiteDatabase = dbHelper.getWritableDatabase();
	sqLiteDatabase.beginTransaction();
	try {
		ContentValues values = new ContentValues();
		//values.put("Task_ID", task.getTaskId());
		values.put("Type", task.getType());
		values.put("Content", task.getContent());
		values.put("Result_ID", task.getResultId());
		if (task.getCreatedAt() == null) {
			task.setCreatedAt(new Date());
		}
		values.put("Created_At", task.getCreatedAt().getTime());
		if (task.getFinishedAt() != null) {
		    values.put("Finished_At", task.getFinishedAt().getTime());
		}
		values.put("State", task.getState());
		values.put("Service_Provider", task.getServiceProvider().getSpNo());
		values.put("Account_ID", task.getAccountId());
		
		int rowsAffected = sqLiteDatabase.update(
			TABLE, values, 
			"Type = " + task.getType() + " and Account_ID = " + task.getAccountId() 
			+ " and Result_ID = '" + task.getResultId() + "'", 
			null);
		if (rowsAffected <= 0) {
			values.put("Task_ID", task.getTaskId());
			long rowId = sqLiteDatabase.replace(TABLE, null, values);
			task.setTaskId(rowId);
		}
		
		sqLiteDatabase.setTransactionSuccessful();
	} finally {
		sqLiteDatabase.endTransaction();
	}
	
	return task;
}