53
* @return hamma satrlar kursorlarini qaytaradi
*/
public Cursor getAllTodos() {
SQLiteDatabase db = this.getWritableDatabase();
Cursor
mCursor
=
db.query(DATABASE_TABLE,
new
String[]
{
COLUMN_ID,
COLUMN_CATEGORY,
COLUMN_SUMMARY,
COLUMN_DESCRIPTION }, COLUMN_CATEGORY + "='Dushanba'",
null, null, null, null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
/**
* Ko‘rsatilgan satrdagi kursor qiymatini qaytaradi
*/
public Cursor getTodo(long rowId) throws SQLException {
SQLiteDatabase db = this.getReadableDatabase();
Cursor mCursor = db.query(true, DATABASE_TABLE,
new
String[]
{
COLUMN_ID,
COLUMN_CATEGORY,
COLUMN_SUMMARY,
COLUMN_DESCRIPTION }, COLUMN_ID + "="
+ rowId, null,
null, null, null, null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
/*
* Qiymatlarni bazaga yozib qo‘yish
*/
private ContentValues createContentValues(String category, String summary,
String description) {
ContentValues values = new ContentValues();
values.put(COLUMN_CATEGORY, category);
values.put(COLUMN_SUMMARY, summary);
values.put(COLUMN_DESCRIPTION, description);
return values;
}
}