public synchronized void save(SQLiteDatabase database) { ContentValues values = Gen_getValues(); values.remove(GEN_FIELD__ID); // Never save the SSH password and passphrase. values.put(GEN_FIELD_SSHPASSWORD, ""); values.put(GEN_FIELD_SSHPASSPHRASE, ""); if (!getKeepPassword()) { values.put(GEN_FIELD_PASSWORD, ""); } if (isNew()) { set_Id(database.insert(GEN_TABLE_NAME, null, values)); } else { database.update( GEN_TABLE_NAME, values, GEN_FIELD__ID + " = ?", new String[] {Long.toString(get_Id())}); } }
@OnClick({R.id.add_data, R.id.query_data}) public void onClick(View view) { switch (view.getId()) { case R.id.add_data: ContentValues values = new ContentValues(); values.put("name", "GOT"); values.put("pages", 566); database.insert("Book", null, values); break; case R.id.query_data: Cursor cursor = database.query("Book", null, null, null, null, null, null); if (cursor != null) { while (cursor.moveToNext()) { String name = cursor.getString(cursor.getColumnIndex("name")); int pages = cursor.getInt(cursor.getColumnIndex("pages")); Log.d("TAG", "book names is " + name); Log.d("TAG", "book pages is " + pages); } } cursor.close(); break; } }
public void add(TimelineEvent timelineEvent) { Log.e("Timeline", " Created " + timelineEvent.caseId() + "--" + timelineEvent.title()); SQLiteDatabase database = masterRepository.getWritableDatabase(); database.insert(TIMELINEEVENT_TABLE_NAME, null, createValuesFor(timelineEvent)); }