android短彩信查询以及MMS表结构

android短信的数据库的Uri是不公开的, 读取起来时灰常不方便的, 这里做了下总结.
用adb指令将mmssms.db从/data/data/com.android.providers.telephony/databases中pull出来
经常使用到的表有
canonical_addresses, sms, threads三个表格
sms是存储着所有的短信, 主要的列有_id, thread_id, address, person, date, read, type, body
关于的sms的Uri有
发件箱 content://sms/outbox
收件箱 content://sms/inbox
草稿箱 content://sms/draft
conversations content://sms/conversations
threads表存储着每一个短信对话的线程. 主要列有_id, date, message_count, recipient_ids, snippet, read
recipient_ids 存放的是参与此次对话的person的id, 然而这个id不是通讯录里面的id, 而是canonical_addresses 的id. 这就是canonical_addresses 表格的作用
threads 表 uri: content://mms-sms/conversations?simple=true
canonical_addresses 表 uri content://mms-sms/canonical-addresses

一、需要实现一个同系统信息一样的功能

1）会话列表；

2）会话对话详情；

3）系统会话增加新信息或者删除信息等变化时做到同步；

二、实现思路

通过查询会话表显示会话界面，监听会话数据库实现与系统信息同步。通过会话id查询会话对应的具体聊天内容，比如短信或者彩信；

看下mmssms.db中的uri有好多个，可以根据自己的需求选择合适的uri，可以避免不必要的操作，提高效率。经过多次测试，实现以上功能需要用的信息表有：

1）会话表：content://mms-sms/conversations/

2）短信表：content://sms

3）彩信表：content://mms、content://mms/part

4）信息对应手机号码表：content://mms-sms/canonical-addresses

需要权限：<uses-permission android:name="android.permission.READ_SMS" />


首先：显示会话列表

public static final Uri THREADS_URI = Uri.parse("content://mms-sms/conversations?simple=true");


threads字段：

_id
date
ct_t：区分彩信还是短信：application/vnd.wap.multipart.related是彩信，否则是短信
snippet：最新的一条会话信息。彩信为彩信的主题，短信时短信的body
recipient_ids：信息对应手机号码表（content://mms-sms/canonical-addresses）中的id，查询对应的手机号码


message_count：详细对话条数


read


snippet_cs：snippet的编码方式，彩信：106（utf-8），短信：0

……

根据threads表中的date，snippet，messagecount基本可以显示会话列表了。


另外：

1：通过4）信息对应手机号码表：content://mms-sms/canonical-addresses获取了手机号之后获取联系人姓名以及头像使用：ContactsContract.CommonDataKinds.Phone.CONTENT_URI

2：当会话为彩信时，snippet显示的是彩信的主题，编码方式为utf-8。显示为乱码。

解决：snippet_mms = new String(snippet.getBytes("ISO8859_1"), "utf-8");


其次，获取会话具体对话内容

具体对话的格式有ssm或者mms，通过content://mms-sms/conversations/threadid，可以查询与某联系人的所有聊天记录的id，这个id对应短信或者彩信表中的id。如果具体会话是短信，则去sms表中查询具体内容，如果是彩信则去mms表中查询。通过字段ct_t 区分信息类别。

具体实现：

1）获取sms


[java] view plaincopyprint?String selection = "_id = "+id;
Uri uri = Uri.parse("content://sms");
Cursor cursor = contentResolver.query(uri, null, selection, null, null);
String phone = cursor.getString(cursor.getColumnIndex("address"));
int type = cursor.getInt(cursor.getColumnIndex("type"));// 2 = sent, etc.
String date = cursor.getString(cursor.getColumnIndex("date"));
String body = cursor.getString(cursor.getColumnIndex("body"));

String selection = "_id = "+id;
Uri uri = Uri.parse("content://sms");
Cursor cursor = contentResolver.query(uri, null, selection, null, null);
String phone = cursor.getString(cursor.getColumnIndex("address"));
int type = cursor.getInt(cursor.getColumnIndex("type"));// 2 = sent, etc.
String date = cursor.getString(cursor.getColumnIndex("date"));
String body = cursor.getString(cursor.getColumnIndex("body"));
2）获取mms

彩信表:content://mms

彩信附件：content://mms/part/


get text content from MMS：
[java] view plaincopyprint?String selectionPart = "mid=" + mmsId;
Uri uri = Uri.parse("content://mms/part");
Cursor cursor = getContentResolver().query(uri, null,
selectionPart, null, null);
if (cursor.moveToFirst()) {
do {
String partId = cursor.getString(cursor.getColumnIndex("_id"));
String type = cursor.getString(cursor.getColumnIndex("ct"));
if ("text/plain".equals(type)) {
String data = cursor.getString(cPart.getColumnIndex("_data"));
String body;
if (data != null) {
// implementation of this method below
body = getMmsText(partId);
} else {
body = cursor.getString(cursor.getColumnIndex("text"));
}
}
} while (cursor.moveToNext());
}

String selectionPart = "mid=" + mmsId;
Uri uri = Uri.parse("content://mms/part");
Cursor cursor = getContentResolver().query(uri, null,
selectionPart, null, null);
if (cursor.moveToFirst()) {
do {
String partId = cursor.getString(cursor.getColumnIndex("_id"));
String type = cursor.getString(cursor.getColumnIndex("ct"));
if ("text/plain".equals(type)) {
String data = cursor.getString(cPart.getColumnIndex("_data"));
String body;
if (data != null) {
// implementation of this method below
body = getMmsText(partId);
} else {
body = cursor.getString(cursor.getColumnIndex("text"));
}
}
} while (cursor.moveToNext());
}


[java] view plaincopyprint?private String getMmsText(String id) {
Uri partURI = Uri.parse("content://mms/part/" + id);
InputStream is = null;
StringBuilder sb = new StringBuilder();
try {
is = getContentResolver().openInputStream(partURI);
if (is != null) {
InputStreamReader isr = new InputStreamReader(is, "UTF-8");
BufferedReader reader = new BufferedReader(isr);
String temp = reader.readLine();
while (temp != null) {
sb.append(temp);
temp = reader.readLine();
}
}
} catch (IOException e) {}
finally {
if (is != null) {
try {
is.close();
} catch (IOException e) {}
}
}
return sb.toString();
}

private String getMmsText(String id) {
Uri partURI = Uri.parse("content://mms/part/" + id);
InputStream is = null;
StringBuilder sb = new StringBuilder();
try {
is = getContentResolver().openInputStream(partURI);
if (is != null) {
InputStreamReader isr = new InputStreamReader(is, "UTF-8");
BufferedReader reader = new BufferedReader(isr);
String temp = reader.readLine();
while (temp != null) {
sb.append(temp);
temp = reader.readLine();
}
}
} catch (IOException e) {}
finally {
if (is != null) {
try {
is.close();
} catch (IOException e) {}
}
}
return sb.toString();
}

获取彩信中图片：


[java] view plaincopyprint?String selectionPart = "mid=" + mmsId;
Uri uri = Uri.parse("content://mms/part");
Cursor cPart = getContentResolver().query(uri, null,
selectionPart, null, null);
if (cPart.moveToFirst()) {
do {
String partId = cPart.getString(cPart.getColumnIndex("_id"));
String type = cPart.getString(cPart.getColumnIndex("ct"));
if ("image/jpeg".equals(type) || "image/bmp".equals(type) ||
"image/gif".equals(type) || "image/jpg".equals(type) ||
"image/png".equals(type)) {
Bitmap bitmap = getMmsImage(partId);
}
} while (cPart.moveToNext());
}

String selectionPart = "mid=" + mmsId;
Uri uri = Uri.parse("content://mms/part");
Cursor cPart = getContentResolver().query(uri, null,
selectionPart, null, null);
if (cPart.moveToFirst()) {
do {
String partId = cPart.getString(cPart.getColumnIndex("_id"));
String type = cPart.getString(cPart.getColumnIndex("ct"));
if ("image/jpeg".equals(type) || "image/bmp".equals(type) ||
"image/gif".equals(type) || "image/jpg".equals(type) ||
"image/png".equals(type)) {
Bitmap bitmap = getMmsImage(partId);
}
} while (cPart.moveToNext());
}
[java] view plaincopyprint?private Bitmap getMmsImage(String _id) {
Uri partURI = Uri.parse("content://mms/part/" + _id);
InputStream is = null;
Bitmap bitmap = null;
try {
is = getContentResolver().openInputStream(partURI);
bitmap = BitmapFactory.decodeStream(is);
} catch (IOException e) {}
finally {
if (is != null) {
try {
is.close();
} catch (IOException e) {}
}
}
return bitmap;
}

private Bitmap getMmsImage(String _id) {
Uri partURI = Uri.parse("content://mms/part/" + _id);
InputStream is = null;
Bitmap bitmap = null;
try {
is = getContentResolver().openInputStream(partURI);
bitmap = BitmapFactory.decodeStream(is);
} catch (IOException e) {}
finally {
if (is != null) {
try {
is.close();
} catch (IOException e) {}
}
}
return bitmap;
}
测试结果：


最后，我的会话界面与系统的实时同步

监听系统的会话数据表即可：

public static final Uri THREADS_URI = Uri
.parse("content://mms-sms/conversations?simple=true");


getContentResolver().registerContentObserver(THREADS_URI ,true, sysCallLogObserver);


另外：

我只写了自己用的表字段，如果想字段别的可以自己打印下：

cursor.getColumnNames();
========================================
数据库中sms相关的字段如下：



_id primary key integer 与words表内的source_id关联

thread_id 会话id，一个联系人的会话一个id，与threads表内的_id关联 integer

address 对方号码 text

person 联系人id integer

date 发件日期 integer

protocol 通信协议，判断是短信还是彩信 integer 0：SMS_RPOTO, 1：MMS_PROTO

read 是否阅读 integer default 0 0：未读， 1：已读

status 状态 integer default-1 -1：接收，

0：complete,

64： pending,

128： failed

type 短信类型 integer 1：inbox

2：sent

3：draft56

4：outbox

5：failed

6：queued

body 内容

service_center 服务中心号码

subject 主题

reply_path_present

locked

error_code

seen