|
9-Amaliy mashgʻulot: Matni maydon komponenetalari bilan ishlash
|
| bet | 1/5 | | Sana | 27.12.2022 | | Hajmi | 68.95 Kb. | | #37217 |
Bog'liq 9-Amaliy mashgʻulot Axborot xati konf. ADU, Mayers- Briggs qo\'shimcha, 36-qo\'shma qaror, 27.04.2022, Oila tushunchasi, uning turlari va shakillari, fHy1I56Pj1m1Sqci4f9q3e28B9S0AiBM, dars ishlanma, 11-21-ALGORITMIK TILLAR VA DASTURLASH, Мустақил ишни ташкиллаштириш, Иқтибослик учун, Документ Microsoft Word, Calendar plan-RAQAMLI VA AXBOROT TEXNOLOGIYALARI (2), статья, Исмаилова Н С , Шагазатов У У Жахон иқтисодиёти ва халқаро (1), A5 9-Amaliy mashgʻulot: Matni maydon komponenetalari bilan ishlash.
ContentValues values = new ContentValues();
values.put(PostDatabase.COL_TITLE, "Second title changed");
// Which row to update, based on the ID
String whereClause = PostDatabase.ID + " LIKE ?"; String[] whereArgs = { "2" }; int affectedRows = sqlDB.update( PostDatabase.TABLE_POSTS, values, whereClause, whereArgs );
// Dumps 1
Log.d(TAG, String.valueOf(affectedRows));
Ma`lumotlarni o`chirish (DELETE)
| Qaysi joyini o`zgartirmoqchi bo`lsak o`sh yerni tanlab olishimiz kerak:
String whereClause = PostDatabase.ID + " = ?"; // Specify arguments in placeholder order.
String[] whereArgs = { "1" }; // Issue SQL statement.
sqlDB.delete(PostDatabase.TABLE_POSTS, whereClause, whereArgs);
|
Qaysi joyini o`chirmoqchi bo`lsak o`sh yerni tanlab olishimiz kerak:
SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder(); queryBuilder.setTables(PostDatabase.TABLE_POSTS); queryBuilder.appendWhere("id = 1");
// Dumps "SELECT * FROM posts WHERE (id = 1)"
Log.d(TAG, queryBuilder.buildQuery(null, null, null, null, null, null));
// queryBuilder.query(DB.getReadableDatabase(), projection, selection, selectionArgs, null, null, sortOrder)
Here’s how you could build a JOIN (between posts and comments table): queryBuilder.setTables(
PostDatabase.TABLE_POSTS
+ " INNER JOIN "
+ PostDatabase.TABLE_COMMENTS
+ " ON "
+ PostDatabase.ID
+ " = "
+ (PostDatabase.TABLE_COMMENTS + "." + PostDatabase.COMMENT_POST_ID)
);
// queryBuilder.query(...)
|
SQLiteQueryBuilder
|
| |
