コード例 #1
0
 public NotesData getNotes(String id) {
   Cursor cursor =
       baseDataSource
           .getDatabase()
           .query("notes_data", null, "id = ?", new String[] {id}, null, null, null);
   cursor.moveToFirst();
   NotesData notesData = new NotesData();
   notesData.setId(cursor.getString(cursor.getColumnIndex("id")));
   notesData.setTitle(cursor.getString(cursor.getColumnIndex("title")));
   notesData.setNote(cursor.getString(cursor.getColumnIndex("note")));
   cursor.close();
   return notesData;
 }
コード例 #2
0
 public List<NotesData> getNotesData() {
   List<NotesData> meta_data = new ArrayList<>();
   NotesData data;
   Cursor curData =
       baseDataSource
           .getDatabase()
           .query("notes_data", null, "soft_delete = ?", new String[] {"1"}, null, null, null);
   if (curData.moveToFirst()) {
     do {
       data = new NotesData();
       data.setId(curData.getString(curData.getColumnIndex("id")));
       data.setTitle(curData.getString(curData.getColumnIndex("title")));
       data.setLabel(curData.getString(curData.getColumnIndex("label")));
       data.setNote(curData.getString(curData.getColumnIndex("note")));
       data.setDate(curData.getString(curData.getColumnIndex("date")));
       meta_data.add(data);
     } while (curData.moveToNext());
   }
   curData.close();
   return meta_data;
 }
コード例 #3
0
 public void insertUpdateNote(NotesData data) {
   Cursor cursor =
       baseDataSource
           .getDatabase()
           .query("notes_data", null, "id = ?", new String[] {data.getId()}, null, null, null);
   if (!cursor.moveToFirst()) {
     ContentValues row = new ContentValues();
     row.put("title", data.getTitle());
     row.put("label", data.getLabel());
     row.put("note", data.getNote());
     row.put("date", data.getDate());
     row.put("soft_delete", "1");
     baseDataSource.getDatabase().insert("notes_data", null, row);
   } else {
     ContentValues row = new ContentValues();
     row.put("id", data.getId());
     row.put("title", data.getTitle());
     row.put("label", data.getLabel());
     row.put("note", data.getNote());
     row.put("date", data.getDate());
     row.put("soft_delete", "1");
     baseDataSource.getDatabase().update("notes_data", row, "id=?", new String[] {data.getId()});
   }
   cursor.close();
 }