mardi 24 mars 2015

Retreive a date from sqlite database in android studio


I've used the following code to create a database




db.execSQL("CREATE TABLE IF NOT EXISTS " +
TABLE_NAME +
" (date Number, time Number, comments Varchar,image blob);");





* Saving of data is done.The current system date is saved in the "date" column.
The requirement is to retrive the "date" from the database check if it is equal to system date and if yes display the corresponding "comments" in a Textview.
Please help on how to retrive "date" from the database.


*


Aucun commentaire:

Enregistrer un commentaire