android database 常用欄位描述
1.簡訊資料庫
String strUriInbox = "content://sms";
Uri uriSms = Uri.parse(strUriInbox);
Cursor c_groups = managedQuery( uriSms , new String[] { "date","person" }, select, null, "date DESC");
strColumnName=_id strColumnValue=48 //短訊息序號
strColumnName=thread_id strColumnValue=16 //對話的序號(conversation)
strColumnName=address strColumnValue=+8613411884805 //發件人地址,手機號
strColumnName=person strColumnValue=null //發件人,返回一個數字就是聯絡人列表裡的序號,陌生人為null
strColumnName=date strColumnValue=1256539465022 //日期 long型,想得到具體日期自己轉換吧!
strColumnName=protocol strColumnValue=0 //協議
strColumnName=read strColumnValue=1 //是否閱讀
strColumnName=status strColumnValue=-1 //狀態
strColumnName=type strColumnValue=1 //型別 1是接收到的,2是發出的
strColumnName=reply_path_present strColumnValue=0 //
strColumnName=subject strColumnValue=null //主題
strColumnName=body strColumnValue=您好 //短訊息內容
strColumnName=service_center strColumnValue=+8613800755500 //簡訊服務中心號碼編號,可以得知該簡訊是從哪裡發過來的
2.聯絡人資料庫
strColumnName = _sync_id strColumnValue=null
strColumnName = primary_organization strColumnValue=null
strColumnName = notes strColumnValue=null
strColumnName = primary_phone strColumnValue=1
strColumnName = status strColumnValue=null
strColumnName = im_handle strColumnValue=null
strColumnName = _sync_local_id strColumnValue=null
strColumnName = im_account strColumnValue=null
strColumnName = _sync_time strColumnValue=null
strColumnName = im_protocol strColumnValue=null
strColumnName = mode strColumnValue=null
strColumnName = label strColumnValue=null
strColumnName = times_contacted strColumnValue=0
strColumnName = name strColumnValue=é??è?3
strColumnName = send_to_voicemail strColumnValue=null
strColumnName = primary_email strColumnValue=null
strColumnName = custom_ringtone strColumnValue=null
strColumnName = sort_string strColumnValue=í?¤í2?í??ío3à?
strColumnName = _sync_version strColumnValue=null
strColumnName = last_time_contacted strColumnValue=null
strColumnName = _sync_account strColumnValue=null
strColumnName = display_name strColumnValue=é??è?3
strColumnName = number_key strColumnValue=77681111831
strColumnName = number strColumnValue=13811118677
strColumnName = phonetic_name strColumnValue=null
strColumnName = _id strColumnValue=1
strColumnName = type strColumnValue=2
strColumnName = _sync_dirty strColumnValue=1
strColumnName = starred strColumnValue=0
4.其他資料庫
//Available Uri string
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
String strUriInbox = "content://sms/inbox"; //SMS_INBOX:1
String strUriFailed = "content://sms/failed"; //SMS_FAILED:2
String strUriQueued = "content://sms/queued"; //SMS_QUEUED:3
String strUriSent = "content://sms/sent"; //SMS_SENT:4
String strUriDraft = "content://sms/draft"; //SMS_DRAFT:5
String strUriOutbox = "content://sms/outbox"; //SMS_OUTBOX:6
String strUriUndelivered = "content://sms/undelivered"; //SMS_UNDELIVERED
String strUriAll = "content://sms/all"; //SMS_ALL
String strUriConversations= "content://sms/conversations";//you can delete one conversation by thread_id
String strUriAll = "content://sms" //you can delete one message by _id
String strUriInbox = "content://sms";
Uri uriSms = Uri.parse(strUriInbox);
Cursor c_groups = managedQuery( uriSms , new String[] { "date","person" }, select, null, "date DESC");
strColumnName=_id strColumnValue=48 //短訊息序號
strColumnName=thread_id strColumnValue=16 //對話的序號(conversation)
strColumnName=address strColumnValue=+8613411884805 //發件人地址,手機號
strColumnName=person strColumnValue=null //發件人,返回一個數字就是聯絡人列表裡的序號,陌生人為null
strColumnName=date strColumnValue=1256539465022 //日期 long型,想得到具體日期自己轉換吧!
strColumnName=protocol strColumnValue=0 //協議
strColumnName=read strColumnValue=1 //是否閱讀
strColumnName=status strColumnValue=-1 //狀態
strColumnName=type strColumnValue=1 //型別 1是接收到的,2是發出的
strColumnName=reply_path_present strColumnValue=0 //
strColumnName=subject strColumnValue=null //主題
strColumnName=body strColumnValue=您好 //短訊息內容
strColumnName=service_center strColumnValue=+8613800755500 //簡訊服務中心號碼編號,可以得知該簡訊是從哪裡發過來的
2.聯絡人資料庫
strColumnName = _sync_id strColumnValue=null
strColumnName = primary_organization strColumnValue=null
strColumnName = notes strColumnValue=null
strColumnName = primary_phone strColumnValue=1
strColumnName = status strColumnValue=null
strColumnName = im_handle strColumnValue=null
strColumnName = _sync_local_id strColumnValue=null
strColumnName = im_account strColumnValue=null
strColumnName = _sync_time strColumnValue=null
strColumnName = im_protocol strColumnValue=null
strColumnName = mode strColumnValue=null
strColumnName = label strColumnValue=null
strColumnName = times_contacted strColumnValue=0
strColumnName = name strColumnValue=é??è?3
strColumnName = send_to_voicemail strColumnValue=null
strColumnName = primary_email strColumnValue=null
strColumnName = custom_ringtone strColumnValue=null
strColumnName = sort_string strColumnValue=í?¤í2?í??ío3à?
strColumnName = _sync_version strColumnValue=null
strColumnName = last_time_contacted strColumnValue=null
strColumnName = _sync_account strColumnValue=null
strColumnName = display_name strColumnValue=é??è?3
strColumnName = number_key strColumnValue=77681111831
strColumnName = number strColumnValue=13811118677
strColumnName = phonetic_name strColumnValue=null
strColumnName = _id strColumnValue=1
strColumnName = type strColumnValue=2
strColumnName = _sync_dirty strColumnValue=1
strColumnName = starred strColumnValue=0
4.其他資料庫
//Available Uri string
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
String strUriInbox = "content://sms/inbox"; //SMS_INBOX:1
String strUriFailed = "content://sms/failed"; //SMS_FAILED:2
String strUriQueued = "content://sms/queued"; //SMS_QUEUED:3
String strUriSent = "content://sms/sent"; //SMS_SENT:4
String strUriDraft = "content://sms/draft"; //SMS_DRAFT:5
String strUriOutbox = "content://sms/outbox"; //SMS_OUTBOX:6
String strUriUndelivered = "content://sms/undelivered"; //SMS_UNDELIVERED
String strUriAll = "content://sms/all"; //SMS_ALL
String strUriConversations= "content://sms/conversations";//you can delete one conversation by thread_id
String strUriAll = "content://sms" //you can delete one message by _id
相關文章
- 獲取表的結構、欄位描述等
- Django 常用欄位和引數Django
- drf中常用的欄位及用法
- SQL2005查詢表中欄位的描述SQL
- Django之ORM常用欄位和引數DjangoORM
- pydantic 欄位欄位校驗
- (轉)Sql Server 快速檢視錶結構(表描述及欄位說明)SQLServer
- MySQL show status命令常用輸出欄位詳解MySql
- odoo ORM研究3 - odoo fields常用的欄位屬性OdooORM
- golang常用庫:欄位引數驗證庫-validatorGolang
- 轉載:Oracle常用的資料庫欄位型別Oracle資料庫型別
- 機器人位姿描述機器人
- EF Core3.1 CodeFirst動態自動新增表和欄位的描述資訊
- 如何獲得C4C裡某個code欄位對應的描述資訊
- fastadmin 新增欄位記圖片欄位AST
- X$KCCDI部分欄位解析和DUMP資訊和V$DATABASE進行對應Database
- 可以處理LOB欄位的常用字元函式字元函式
- 欄位排序排序
- [BUG反饋]模型管理 > 欄位管理看不見任何欄位。這表明顯有欄位、!模型
- GCC常用命令描述(轉)GC
- 星輝Odoo模型開發教程4-常用欄位屬性Odoo模型
- 【Mongo】mongo更新欄位為另一欄位的值Go
- sql語句修改欄位型別和增加欄位SQL型別
- oracle刪除表欄位和oracle表增加欄位Oracle
- [原創]如何獲得SBO的資料表中文描述和資料表的中文欄位
- 模型追加欄位模型
- elasticsearch 特殊欄位Elasticsearch
- 巧用欄位對映實現指定欄位的搜尋
- 快速將下劃線欄位改為駝峰欄位
- arcgis欄位值計算(擷取A欄位前8位+按照順序計算8位)
- SQL字元型欄位按數字型欄位排序實現方法SQL字元排序
- 通用首部欄位詳解-四大首部欄位之一
- MySQL欄位新增註釋,但不改變欄位的型別MySql型別
- 利用fnd_flex_keyval包輕鬆獲取關鍵性彈性域組合描述欄位Flex
- MySQL 欄位約束MySql
- mysql中文欄位排序MySql排序
- SQL新增表欄位SQL
- clob 欄位查詢