Android获取短信session

在smsmms.db中有个sms表，里面含有_id、thread_id、address、person、date、protocol、read、status、type、reply_path_present、subject、body、service_center、locked这些属性。这个表存有收发信息和草稿信息，但是草稿信息的发送地址即address属性在这个表中却为空(事实是草稿信息的address没有保存在sms这个表中，其他属性值正常)，只能在canonical_addresses这个表中找到草稿信息的address，但是canonical_addresses这个表中只有两个属性值即_id和address，要找到草稿信息的address，先得知道_id，这个canonical_addresses表中的_id对应了threads表中的recipient_ids属性，而threads表中的_id对应了sms表中的thread_id，现在问题出来了，没有查找threads表的接口，另外两个表都有相应的接口，可以根据sms表中的thread_id找到threads表中的_id，但是不能根据threads表中的_id找到这个表中的recipient_ids，从而也不能再根据已经得到的recipient_ids值去canonical_addresses表中找到相应的address。

Cursor cursor = getContentResolver().query(Uri.parse("content://sms/"),
new String[] { "* from threads--" }, null, null, null);
String mString = "";
if(cursor != null) {
int count = cursor.getColumnCount();
for(int i = 0; i < count; i++) {
mString += cursor.getColumnName(i) + "\n";
}

Log.i("123", mString);
}

if (cursor.moveToFirst()) {

do {
String msg = "";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("_id"))) + " ";
msg += String.valueOf(cursor.getLong(cursor.getColumnIndex("date"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("message_count"))) + " ";
msg += String.valueOf(cursor.getString(cursor.getColumnIndex("recipient_ids"))) + " ";
msg += String.valueOf(cursor.getString(cursor.getColumnIndex("snippet"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("snippet_cs"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("read"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("type"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("error"))) + " ";
msg += String.valueOf(cursor.getInt(cursor.getColumnIndex("has_attachment"))) + "\n";
Log.i("123", msg);
} while (cursor.moveToNext());
}

更多相关文章

随机推荐