也谈下sqlite的rawQuery方法获取的Cursor流查询数据方法

最新推荐文章于 2024-09-01 20:44:53 发布

原创最新推荐文章于 2024-09-01 20:44:53 发布 · 5.9k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一种使用Cursor从SQLite数据库中查询特定属性的方法，并通过示例代码详细展示了如何实现这一过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

因为对于cursor流不太熟悉，特别是在数据中查询一部分属性，而在网上也没找到相应的资料，因此我花时间研究了一下。以下是研究成果:

	public void getChatMsg(String friendName){
		Msg msg;
		String sql = "select a.msg,a.username,a.sendTime,a.inOrOut from(select * from chatRecord" +
				" where whosRecord = ? and friend = ? order by _id desc LIMIT " +SHOW_MSG_COUNT+")a order by a._id";
		Cursor cursor = db.rawQuery(sql, new String[]{XmppApplication.user,friendName});
		while(cursor.moveToNext()){
			msg = new Msg(cursor.getString(0),cursor.getString(1),cursor.getString(2),cursor.getString(3));
			Log.i(TAG,"cursor.getString(0)="+cursor.getString(0));
			//设置是和谁的聊天记录
			OneFridenMessages oneFridenMessages = XmppApplication.AllFriendsMessageMapData
					.get(friendName);
			if (oneFridenMessages == null) {
				oneFridenMessages = new OneFridenMessages();
				XmppApplication.AllFriendsMessageMapData.put(friendName,
						oneFridenMessages);
			}
			oneFridenMessages.MessageList.add(msg);
			msg = null;
		}
		cursor.close();
	}

cursor.getString(0)获取的是sql查询的第一个属性，当第一个属性为a.msg时，打印结果如下：

public void getChatMsg(String friendName){
		Msg msg;
		String sql = "select a.username,a.msg,a.sendTime,a.inOrOut from(select * from chatRecord" +
				" where whosRecord = ? and friend = ? order by _id desc LIMIT " +SHOW_MSG_COUNT+")a order by a._id";
		Cursor cursor = db.rawQuery(sql, new String[]{XmppApplication.user,friendName});
		while(cursor.moveToNext()){
			msg = new Msg(cursor.getString(0),cursor.getString(1),cursor.getString(2),cursor.getString(3));
			Log.i(TAG,"cursor.getString(0)="+cursor.getString(0));
			//设置是和谁的聊天记录
			OneFridenMessages oneFridenMessages = XmppApplication.AllFriendsMessageMapData
					.get(friendName);
			if (oneFridenMessages == null) {
				oneFridenMessages = new OneFridenMessages();
				XmppApplication.AllFriendsMessageMapData.put(friendName,
						oneFridenMessages);
			}
			oneFridenMessages.MessageList.add(msg);
			msg = null;
		}
		cursor.close();
	}

cursor.getString(0)获取的是sql查询的第一个属性，当第一个属性为a.username时，打印结果如下：