Android查询短信数据库
16lz
2021-12-04
android常用数据库字段描述
1.短信数据库
StringstrUriInbox="content://sms";
UriuriSms=Uri.parse(strUriInbox);
Cursorc_groups=managedQuery(uriSms,newString[]{"date","person"},select,null,"dateDESC");
strColumnName=_idstrColumnValue=48//短消息序号
strColumnName=thread_idstrColumnValue=16//对话的序号(conversation)
strColumnName=addressstrColumnValue=+8613411884805//发件人地址,手机号
strColumnName=personstrColumnValue=null//发件人,返回一个数字就是联系人列表里的序号,陌生人为null
strColumnName=datestrColumnValue=1256539465022//日期long型,想得到具体日期自己转换吧!
strColumnName=protocolstrColumnValue=0//协议
strColumnName=readstrColumnValue=1//是否阅读
strColumnName=statusstrColumnValue=-1//状态
strColumnName=typestrColumnValue=1//类型1是接收到的,2是发出的
strColumnName=reply_path_presentstrColumnValue=0//
strColumnName=subjectstrColumnValue=null//主题
strColumnName=bodystrColumnValue=您好//短消息内容
strColumnName=service_centerstrColumnValue=+8613800755500//短信服务中心号码编号,可以得知该短信是从哪里发过来的见下表
2.联系人数据库
strColumnName=_sync_idstrColumnValue=null
strColumnName=primary_organizationstrColumnValue=null
strColumnName=notesstrColumnValue=null
strColumnName=primary_phonestrColumnValue=1
strColumnName=statusstrColumnValue=null
strColumnName=im_handlestrColumnValue=null
strColumnName=_sync_local_idstrColumnValue=null
strColumnName=im_accountstrColumnValue=null
strColumnName=_sync_timestrColumnValue=null
strColumnName=im_protocolstrColumnValue=null
strColumnName=modestrColumnValue=null
strColumnName=labelstrColumnValue=null
strColumnName=times_contactedstrColumnValue=0
strColumnName=namestrColumnValue=é??è?3
strColumnName=send_to_voicemailstrColumnValue=null
strColumnName=primary_emailstrColumnValue=null
strColumnName=custom_ringtonestrColumnValue=null
strColumnName=sort_stringstrColumnValue=í?¤í2?í??ío3à?
strColumnName=_sync_versionstrColumnValue=null
strColumnName=last_time_contactedstrColumnValue=null
strColumnName=_sync_accountstrColumnValue=null
strColumnName=display_namestrColumnValue=é??è?3
strColumnName=number_keystrColumnValue=77681111831
strColumnName=numberstrColumnValue=13811118677
strColumnName=phonetic_namestrColumnValue=null
strColumnName=_idstrColumnValue=1
strColumnName=typestrColumnValue=2
strColumnName=_sync_dirtystrColumnValue=1
strColumnName=starredstrColumnValue=0
4.其他数据库
//AvailableUristring
content://contacts/people//本地联系人列表信息
content://contacts/phones//本地联系人列表信息
content://call_log/calls///本地通话记录
content://mms彩信
content://mms-sms/threadID
content://mms-sms/conversations
content://mms-sms/messages/byphone
content://mms-sms/undelivered
content://mms-sms/draft
StringstrUriInbox="content://sms/inbox";//SMS_INBOX:1
StringstrUriFailed="content://sms/failed";//SMS_FAILED:2
StringstrUriQueued="content://sms/queued";//SMS_QUEUED:3
StringstrUriSent="content://sms/sent";//SMS_SENT:4
StringstrUriDraft="content://sms/draft";//SMS_DRAFT:5
StringstrUriOutbox="content://sms/outbox";//SMS_OUTBOX:6
StringstrUriUndelivered="content://sms/undelivered";//SMS_UNDELIVERED
StringstrUriAll="content://sms/all";//SMS_ALL
StringstrUriConversations="content://sms/conversations";//youcandeleteoneconversationbythread_id
StringstrUriAll="content://sms"//youcandeleteonemessageby_id
1.短信数据库
StringstrUriInbox="content://sms";
UriuriSms=Uri.parse(strUriInbox);
Cursorc_groups=managedQuery(uriSms,newString[]{"date","person"},select,null,"dateDESC");
strColumnName=_idstrColumnValue=48//短消息序号
strColumnName=thread_idstrColumnValue=16//对话的序号(conversation)
strColumnName=addressstrColumnValue=+8613411884805//发件人地址,手机号
strColumnName=personstrColumnValue=null//发件人,返回一个数字就是联系人列表里的序号,陌生人为null
strColumnName=datestrColumnValue=1256539465022//日期long型,想得到具体日期自己转换吧!
strColumnName=protocolstrColumnValue=0//协议
strColumnName=readstrColumnValue=1//是否阅读
strColumnName=statusstrColumnValue=-1//状态
strColumnName=typestrColumnValue=1//类型1是接收到的,2是发出的
strColumnName=reply_path_presentstrColumnValue=0//
strColumnName=subjectstrColumnValue=null//主题
strColumnName=bodystrColumnValue=您好//短消息内容
strColumnName=service_centerstrColumnValue=+8613800755500//短信服务中心号码编号,可以得知该短信是从哪里发过来的见下表
2.联系人数据库
strColumnName=_sync_idstrColumnValue=null
strColumnName=primary_organizationstrColumnValue=null
strColumnName=notesstrColumnValue=null
strColumnName=primary_phonestrColumnValue=1
strColumnName=statusstrColumnValue=null
strColumnName=im_handlestrColumnValue=null
strColumnName=_sync_local_idstrColumnValue=null
strColumnName=im_accountstrColumnValue=null
strColumnName=_sync_timestrColumnValue=null
strColumnName=im_protocolstrColumnValue=null
strColumnName=modestrColumnValue=null
strColumnName=labelstrColumnValue=null
strColumnName=times_contactedstrColumnValue=0
strColumnName=namestrColumnValue=é??è?3
strColumnName=send_to_voicemailstrColumnValue=null
strColumnName=primary_emailstrColumnValue=null
strColumnName=custom_ringtonestrColumnValue=null
strColumnName=sort_stringstrColumnValue=í?¤í2?í??ío3à?
strColumnName=_sync_versionstrColumnValue=null
strColumnName=last_time_contactedstrColumnValue=null
strColumnName=_sync_accountstrColumnValue=null
strColumnName=display_namestrColumnValue=é??è?3
strColumnName=number_keystrColumnValue=77681111831
strColumnName=numberstrColumnValue=13811118677
strColumnName=phonetic_namestrColumnValue=null
strColumnName=_idstrColumnValue=1
strColumnName=typestrColumnValue=2
strColumnName=_sync_dirtystrColumnValue=1
strColumnName=starredstrColumnValue=0
4.其他数据库
//AvailableUristring
content://contacts/people//本地联系人列表信息
content://contacts/phones//本地联系人列表信息
content://call_log/calls///本地通话记录
content://mms彩信
content://mms-sms/threadID
content://mms-sms/conversations
content://mms-sms/messages/byphone
content://mms-sms/undelivered
content://mms-sms/draft
StringstrUriInbox="content://sms/inbox";//SMS_INBOX:1
StringstrUriFailed="content://sms/failed";//SMS_FAILED:2
StringstrUriQueued="content://sms/queued";//SMS_QUEUED:3
StringstrUriSent="content://sms/sent";//SMS_SENT:4
StringstrUriDraft="content://sms/draft";//SMS_DRAFT:5
StringstrUriOutbox="content://sms/outbox";//SMS_OUTBOX:6
StringstrUriUndelivered="content://sms/undelivered";//SMS_UNDELIVERED
StringstrUriAll="content://sms/all";//SMS_ALL
StringstrUriConversations="content://sms/conversations";//youcandeleteoneconversationbythread_id
StringstrUriAll="content://sms"//youcandeleteonemessageby_id
更多相关文章
- Android中读取电话本Contacts联系人的所有电话号信息
- android 单元测试, 以sqlite测试为例
- Android学习之sqlit
- Android根据联系人姓名首字符顺序读取通讯录
- 图解IntelliJ IDEA 13版本对Android(安卓)SQLite数据库的支持
- 人人网官方Android客户端源码分析(1)
- 使用adb工具访问sqlite数据库
- android 的短信数据库的读取
- Android中读取电话本Contacts联系人的所有电话号信息