Skip to content

Instantly share code, notes, and snippets.

@lucasuyezu
Created October 28, 2010 14:39
Show Gist options
  • Save lucasuyezu/651466 to your computer and use it in GitHub Desktop.
Save lucasuyezu/651466 to your computer and use it in GitHub Desktop.
DictionaryOpenHelper storage = new DictionaryOpenHelper(getApplicationContext());
// write
SQLiteDatabase writableDatabase = storage.getWritableDatabase();
ContentValues map2 = new ContentValues();
map2.put("QUERY_STRING", queryString.toString());
map2.put("QUERY_DATE", new Date().toLocaleString());
writableDatabase.insert("dictionary", "", map2);
HashMap<String, String> map = new HashMap<String, String>();
map.put(QUERY_TEXT, queryString.toString());
map.put(QUERY_DATE, new Date().toLocaleString());
queryList.add(map);
// read
SQLiteDatabase readableDatabase = storage.getReadableDatabase();
Cursor rawQuery = readableDatabase.rawQuery("SELECT * FROM dictionary", null );
while (rawQuery.moveToNext()) {
map = new HashMap<String, String>();
map.put(QUERY_TEXT, rawQuery.getString(0));
map.put(QUERY_DATE, rawQuery.getString(1));
queryList.add(map);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment