- /**
- * 添加数据
- */
- public static boolean insert(ContentResolver resolver, Message msg) {
- ContentValues values = new ContentValues();
- values.put("content", msg.getContent());
- values.put("date", DateUtils.showDate());
- resolver.insert(MyMessageProvider.URI.CODE_MESSAGE_INSERT, values);
- return true;
- }
- /**
- * 删除数据
- */
- public static void delete(ContentResolver resolver, int id) {
- resolver.delete(MyMessageProvider.URI.CODE_MESSAGE_DELETE, "id = " + id, null);
- }
- /**
- * 删除全部数据
- */
- public static void deleteAll(ContentResolver resolver) {
- resolver.delete(MyMessageProvider.URI.CODE_MESSAGE_DELETE, null, null);
- }
- /**
- * 查询数据
- *
- * @param resolver
- * @return
- */
- public static List<Message> query(ContentResolver resolver) {
- List<Message> list = new ArrayList<>();
- Cursor cursor = resolver.query(MyMessageProvider.URI.CODE_MESSAGE_QUERY, null, null, null, null);
- while (cursor.moveToNext()) {
- Message msg = new Message();
- msg.setDate(cursor.getString(cursor.getColumnIndex("date")));
- msg.setContent(cursor.getString(cursor.getColumnIndex("content")));
- msg.setId(cursor.getInt(cursor.getColumnIndex("id")));
- list.add(0, msg);
- }
- return list;
- }
数据库查询示例