1. DB insert
SQLiteDatabases db = DBHelper.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(JSON_COLUMN.URL, http://localhost/main);
db.insert(TABLE_NAME, null, cv);
2. DB query
Cursor cursor = db.query(false, TABLE_NAME, null, JSON_COLUMN.URL+"=?", selections, null, null, null, null);
if(null == cursor){
return false;
}
if(cursor.getCount() == 0){
cursor.close();
return false;
}
whild(cursor.moveToNext()){
int id = cursor.getInt(0);
String url = cursor.getString(1);
String json = cursor.getString(2);
}
cursor.close();