public void updateURL(BVBURL bvbURL) { SQLiteDatabase db = getWritableDatabase(); ContentValues contentValues = new ContentValues(); if (bvbURL.getLastModified() != null && !"".equals(bvbURL.getLastModified())) { contentValues.put(HTTP_LASTMODIFIED, bvbURL.getLastModified()); } if (bvbURL.getETag() != null && !"".equals(bvbURL.getETag())) { contentValues.put(HTTP_ETAG, bvbURL.getETag()); } contentValues.put(HTTP_LOCALDATA, bvbURL.getLocalData()); try { int num = db.update(TB_NAME, contentValues, HTTP_URL + "=?", new String[] {bvbURL.getUrl()}); if (num == 0) { insert(contentValues); } } catch (Exception e) { Log.i(TAG, e.getMessage()); } }
public synchronized boolean insertURL(BVBURL bvbRUL) { try { ContentValues values = new ContentValues(); values.put(HTTP_URL, bvbRUL.getUrl()); values.put(HTTP_LASTMODIFIED, bvbRUL.getLastModified()); values.put(HTTP_ETAG, bvbRUL.getETag()); values.put(HTTP_LOCALDATA, bvbRUL.getLocalData()); long err = insert(values); if (err == -1) { Log.i(TAG, "Error from insertURL:" + err); return false; } else { Log.i(TAG, "insertURL successful! "); return true; } } catch (Exception e) { Log.i(TAG, e.getMessage()); return false; } }