public class MedsDBHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME
= "medsList.db";
private static final String TABLE_NAME
= "My_Medications";
private static final String COLUMN_TITLE
= "Medication_Name";
private static final String COLUMN_MG
= "Medication_MG";
private static final String COLUMN_SCHEDULE
= "Medication_Schedule";
super(context, DATABASE_NAME, null, 1 );
this.context = context;
}
@Override
public void onCreate(SQLiteDatabase myDB) {
String query
= "CREATE TABLE " + TABLE_NAME
+
" (" +
COLUMN_TITLE + " TEXT PRIMARY KEY , " +
COLUMN_MG + " TEXT, " +
COLUMN_SCHEDULE + " TEXT);";
myDB.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase myDB, int i, int i1) {
myDB.execSQL("drop Table if exists " + TABLE_NAME);
onCreate(myDB);
}
SQLiteDatabase myDB = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COLUMN_TITLE, title);
cv.put(COLUMN_MG, medsMG);
cv.put(COLUMN_SCHEDULE, sched);
long result = myDB.insert(TABLE_NAME, null, cv);
if(result == -1) {
Toast.makeText(context,"Failed", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(context, "Added Successfully!", Toast.LENGTH_SHORT).show();
}
}
String query
= "SELECT * FROM " + TABLE_NAME
;
SQLiteDatabase myDB = this.getReadableDatabase();
if(myDB != null) {
cursor = myDB.rawQuery(query, null);
}
return cursor;
}
public void deleteMedsData
(String id
) {
SQLiteDatabase db = this.getWritableDatabase();
db.
delete(TABLE_NAME,
" Medication_Name = ?",
new String[] {id
});
db.close();
}
SQLiteDatabase medsDB = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COLUMN_TITLE, title);
cv.put(COLUMN_MG, mg);
cv.put(COLUMN_SCHEDULE, schedule);
long result
= medsDB.
update(TABLE_NAME, cv,
" Medication_Name = ?",
new String[] {title
});
if (result == -1) {
Toast.makeText(context,"Failed to update", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(context,"Update Successful", Toast.LENGTH_SHORT).show();
}
}
}