android常用数据库字段描述
16lz
2021-01-23
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 SQLite数据库使用实例
- android中操纵sqlite数据库
- android访问远程数据库
- Android 开发中使用 SQLite 数据库
- Android Sqlite 数据库—基础篇
- Android:SNS客户端开发三:数据库操作(一)
- Android联系人数据库全解析(2)
- Android数据库事务浅析
- Android 的 SQLLite数据库