android Mms数据库2

最新推荐文章于 2024-05-24 03:04:23 发布
原创 最新推荐文章于 2024-05-24 03:04:23 发布 · 1k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库 #android #sms #integer #string #thread

本文详细解析了MMS数据库的位置及其内部结构，包括短信表的字段定义和意义，提供了创建相关表的代码示例，并解释了各字段的具体含义。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >


Mms数据库的位置/data/data/com.android.providers.telephony/databases/mmssms.db

先看sms，从这里可以找到uri的分类

        sURLMatcher.addURI("sms", null, SMS_ALL);
        sURLMatcher.addURI("sms", "#", SMS_ALL_ID);
        sURLMatcher.addURI("sms", "inbox", SMS_INBOX);
        sURLMatcher.addURI("sms", "inbox/#", SMS_INBOX_ID);
        sURLMatcher.addURI("sms", "sent", SMS_SENT);
        sURLMatcher.addURI("sms", "sent/#", SMS_SENT_ID);
        sURLMatcher.addURI("sms", "draft", SMS_DRAFT);
        sURLMatcher.addURI("sms", "draft/#", SMS_DRAFT_ID);
        sURLMatcher.addURI("sms", "outbox", SMS_OUTBOX);
        sURLMatcher.addURI("sms", "outbox/#", SMS_OUTBOX_ID);
        sURLMatcher.addURI("sms", "undelivered", SMS_UNDELIVERED);
        sURLMatcher.addURI("sms", "failed", SMS_FAILED);
        sURLMatcher.addURI("sms", "failed/#", SMS_FAILED_ID);
        sURLMatcher.addURI("sms", "queued", SMS_QUEUED);
        sURLMatcher.addURI("sms", "conversations", SMS_CONVERSATIONS);
        sURLMatcher.addURI("sms", "conversations/*", SMS_CONVERSATIONS_ID);
        sURLMatcher.addURI("sms", "raw", SMS_RAW_MESSAGE);
        sURLMatcher.addURI("sms", "attachments", SMS_ATTACHMENT);
        sURLMatcher.addURI("sms", "attachments/#", SMS_ATTACHMENT_ID);
        sURLMatcher.addURI("sms", "threadID", SMS_NEW_THREAD_ID);
        sURLMatcher.addURI("sms", "threadID/*", SMS_QUERY_THREAD_ID);
        sURLMatcher.addURI("sms", "status/#", SMS_STATUS_ID);
        sURLMatcher.addURI("sms", "sr_pending", SMS_STATUS_PENDING);
        sURLMatcher.addURI("sms", "icc", SMS_ALL_ICC);
        sURLMatcher.addURI("sms", "icc/#", SMS_ICC);
        //we keep these for not breaking old applications
        sURLMatcher.addURI("sms", "sim", SMS_ALL_ICC);
        sURLMatcher.addURI("sms", "sim/#", SMS_ICC);


开始创建sms的相关表格：

    private void createSmsTables(SQLiteDatabase db) {
        // N.B.: Whenever the columns here are changed, the columns in
        // {@ref MmsSmsProvider} must be changed to match.
        db.execSQL("CREATE TABLE sms (" +
                   "_id INTEGER PRIMARY KEY," +
                   "thread_id INTEGER," +
                   "address TEXT," +
                   "person INTEGER," +
                   "date INTEGER," +
                   "date_sent INTEGER DEFAULT 0," +
                   "protocol INTEGER," +
                   "read INTEGER DEFAULT 0," +
                   "status INTEGER DEFAULT -1," + // a TP-Status value
                                                  // or -1 if it
                                                  // status hasn't
                                                  // been received
                   "type INTEGER," +
                   "reply_path_present INTEGER," +
                   "subject TEXT," +
                   "body TEXT," +
                   "service_center TEXT," +
                   "locked INTEGER DEFAULT 0," +
                   "error_code INTEGER DEFAULT 0," +
                   "seen INTEGER DEFAULT 0" +
                   ");");

        /**
         * This table is used by the SMS dispatcher to hold
         * incomplete partial messages until all the parts arrive.
         */
        db.execSQL("CREATE TABLE raw (" +
                   "_id INTEGER PRIMARY KEY," +
                   "date INTEGER," +
                   "reference_number INTEGER," + // one per full message
                   "count INTEGER," + // the number of parts
                   "sequence INTEGER," + // the part number of this message
                   "destination_port INTEGER," +
                   "address TEXT," +
                   "pdu TEXT);"); // the raw PDU for this part

        db.execSQL("CREATE TABLE attachments (" +
                   "sms_id INTEGER," +
                   "content_url TEXT," +
                   "offset INTEGER);");

        /**
         * This table is used by the SMS dispatcher to hold pending
         * delivery status report intents.
         */
        db.execSQL("CREATE TABLE sr_pending (" +
                   "reference_number INTEGER," +
                   "action TEXT," +
                   "data TEXT);");
    }
至于Table sms的数据项意义，可以参考android.provider.Telephony
    /**
     * Base columns for tables that contain text based SMSs.
     */
    public interface TextBasedSmsColumns {
        /**
         * The type of the message
         * <P>Type: INTEGER</P>
         */
        public static final String TYPE = "type";

        public static final int MESSAGE_TYPE_ALL    = 0;
        public static final int MESSAGE_TYPE_INBOX  = 1;
        public static final int MESSAGE_TYPE_SENT   = 2;
        public static final int MESSAGE_TYPE_DRAFT  = 3;
        public static final int MESSAGE_TYPE_OUTBOX = 4;
        public static final int MESSAGE_TYPE_FAILED = 5; // for failed outgoing messages
        public static final int MESSAGE_TYPE_QUEUED = 6; // for messages to send later


        /**
         * The thread ID of the message
         * <P>Type: INTEGER</P>
         */
        public static final String THREAD_ID = "thread_id";

        /**
         * The address of the other party
         * <P>Type: TEXT</P>
         */
        public static final String ADDRESS = "address";

        /**
         * The person ID of the sender
         * <P>Type: INTEGER (long)</P>
         */
        public static final String PERSON_ID = "person";

        /**
         * The date the message was received
         * <P>Type: INTEGER (long)</P>
         */
        public static final String DATE = "date";

        /**
         * The date the message was sent
         * <P>Type: INTEGER (long)</P>
         */
        public static final String DATE_SENT = "date_sent";

        /**
         * Has the message been read
         * <P>Type: INTEGER (boolean)</P>
         */
        public static final String READ = "read";

        /**
         * Indicates whether this message has been seen by the user. The "seen" flag will be
         * used to figure out whether we need to throw up a statusbar notification or not.
         */
        public static final String SEEN = "seen";

        /**
         * The TP-Status value for the message, or -1 if no status has
         * been received
         */
        public static final String STATUS = "status";

        public static final int STATUS_NONE = -1;
        public static final int STATUS_COMPLETE = 0;
        public static final int STATUS_PENDING = 32;
        public static final int STATUS_FAILED = 64;

        /**
         * The subject of the message, if present
         * <P>Type: TEXT</P>
         */
        public static final String SUBJECT = "subject";

        /**
         * The body of the message
         * <P>Type: TEXT</P>
         */
        public static final String BODY = "body";

        /**
         * The id of the sender of the conversation, if present
         * <P>Type: INTEGER (reference to item in content://contacts/people)</P>
         */
        public static final String PERSON = "person";

        /**
         * The protocol identifier code
         * <P>Type: INTEGER</P>
         */
        public static final String PROTOCOL = "protocol";

        /**
         * Whether the <code>TP-Reply-Path</code> bit was set on this message
         * <P>Type: BOOLEAN</P>
         */
        public static final String REPLY_PATH_PRESENT = "reply_path_present";

        /**
         * The service center (SC) through which to send the message, if present
         * <P>Type: TEXT</P>
         */
        public static final String SERVICE_CENTER = "service_center";

        /**
         * Has the message been locked?
         * <P>Type: INTEGER (boolean)</P>
         */
        public static final String LOCKED = "locked";

        /**
         * Error code associated with sending or receiving this message
         * <P>Type: INTEGER</P>
         */
        public static final String ERROR_CODE = "error_code";

        /**
         * Meta data used externally.
         * <P>Type: TEXT</P>
         */
        public static final String META_DATA = "meta_data";
}

部分内容解释如下：

thread_id

>conversation序号，是以收件人地址来进行组织的，同一收件人的信息thread_id相同

address

>发件人手机号码

person

>person id, 陌生人为null

protocol

>0 SMS_RPOTO, 1 MMS_PROTO 

read            

status

>TP-status -1接收，0 complete, 64 pending, 128 failed

type

>box状态

    ALL    = 0;
    INBOX  = 1;
    SENT   = 2;
    DRAFT  = 3;
    OUTBOX = 4;
    FAILED = 5;
    QUEUED = 6;
body                    

service_center     

subject                  

reply_path_present

>TP-Reply-Path

locked

>代表sms是否被锁住，不能删除



android sms 接收短信,Android SMS 短信操作
weixin_36267615的博客
05-26 1715
android的短信保存在短信库里，但并提供类似Contacts的公开的Content Provider方便操作。这里简单的介绍下：android中的短信信息保存在/data/data/com.android.providers.telephony/databases目录下的sqlite库中。常用的表有：canonical_addresses, sms, threads。对短信的操作基本也就是对这...
android短信数据库类型,安卓短信收发 mmssms.db数据库和查询简介
weixin_35962107的博客
05-26 1820
Android 手机信息存放在mmssms.db数据库，位于data/data/com.android.providers.telephony/databases下。短讯息主要用到sms表和threads表。 sms表 threads表sms表和threads表用thread_id互连；sms表中重要的列位：_id sms表自增列，查询时必须加上thread_id 列 对应着threads表dat...
Android系统源码数据库（mmssms.db）
thorzdf的博客
10-14 1111
论Android系统源码数据库（mmssms.db）中几个表之前的关系. 首先明了未接信息的数据库的位置在系统 /data/data/com.android.providers.telephony/databases/mmssms.db 包下。 希望大家能够结合源码中的 1. Telephony.java （主要讲这些表里有哪些字段） 2. ...
Android SMS（一） —— 读取短信
轻轻草原
03-07 989
Android SMS Read package com.homer.sms; import java.sql.Date; import java.text.SimpleDateFormat; import android.app.Activity; import android.database.Cursor; import android.database.sqlite.SQLiteE...
Android Mms 数据库
dirk_it的专栏
05-08 1367
在mmssms.db中与彩信相关的表有 数据表 MMS模块总共包含17张表：addr、android_metadata、attachments、canonical_addresses、drm、part、pdu、pending_msgs、rate、raw、sms、sr_pending、threads、words、words_content、words_segdir、words_segment
android 短信 彩信 数据库
winnerfm的专栏
09-14 1361
android 短信 彩信 数据库<br />转自：http://gnibre.javaeye.com/blog/558031<br /> <br />短信 sms <br /> 文件 /data/data/com.android.providers.telephony/databases/mmssms.db <br /> 这个数据库有13张表，sms表存了短信信息。 <br /><br /> sms表的uri是Java代码 public static final Uri CONTENT_URI
Android MMS数据库存储说明
weixin_34208185的博客
07-05 1204
数据表 MMS模块总共包含17张表：addr、android_metadata、attachments、canonical_addresses、drm、part、pdu、pending_msgs、rate、raw、sms、sr_pending、threads、words、words_content、words_segdir、words_segments。 其中，pending_msgs表用于存...
android Mms 数据库1
thinkinwm的专栏
10-13 1484
简介 Mms 数据库代码的位置在/packages/providers/TelephonyProvider，这里还包括APN的部分。从AndroidManifest中可以看到，其注明sharedUserId为android.uid.phone，运行在com.android.phone进程中。TelephonyProvider是APN的数据库，SmsProvider、MmsProvider、Mms
android常用数据库字段描述
最新发布
2401_85239863的博客
05-24 399
strColumnName=type strColumnValue=1 //类型 1是接收到的，2是发出的。content://contacts/people //本地联系人列表信息。content://contacts/phones //本地联系人列表信息。content://call_log/calls/ //本地通话记录。content://mms 彩信。
Android Mms之:PDU的使用详解
09-05
2. `PduParser`类：用于解析PDU字节流为Android系统可以识别的`GenericPdu`对象。通过`PduParser(byte[])`构造函数创建解析器，然后调用`parse()`方法将PDU字节流解析为Android的PDU。 3. `PduComposer`类：反向...
Android Mms之:深入MMS支持
09-05
在Android系统中，MMS（Multimedia Messaging Service）是一种用于发送和接收包含多媒体内容的短信服务。本文将深入探讨Android MMS支持的实现机制，帮助开发者理解和操作这一关键功能。 首先，Android MMS的实现...
Android实现将已发送的短信写入短信数据库的方法
09-04
短信数据库主要由系统维护，通常位于`/data/data/com.android.providers.telephony/databases/mmssms.db`路径下，这是一个SQLite数据库。数据库中有多个表，包括`sms`表，用于存储接收到和发送出去的短信。短信根据...
Android短信数据库相关
VVel1996的博客
10-13 974
Android短信数据库相关
android Mms 数据库3
thinkinwm的专栏
10-13 2233
先来看看Mms相关表格 pdu ：存储彩信的基本信息，一条mms在pdu表中由一条数据项表示 addr：关于收件人的表，群发彩信时收件人地址就存在这里 part：彩信的每个媒体文件（比如彩信有多少个音频，图片或视频） drm： 彩信中媒体文件权限信息 rate：传送速度相关的信息 MMS/SMS相关表格关系 threads   _id主键；recipient_ids关联can
android Mms 数据库4
thinkinwm的专栏
10-13 1389
thread的产生 当和一个联系人进行交流时，会将产生的message进行归类到conversation，其判断依据是recipient: android.provider.Telephony.java /** * This is a single-recipient version of * getOrCreateThread
sql 查询MMS_REPORT_STATUS
thinkinwm的专栏
10-14 1223
查询 MMS_REPORT_STATUS语句 case MMS_REPORT_STATUS: /* SELECT DISTINCT address, T.delivery_status AS delivery_status,
android Mms 数据库5
thinkinwm的专栏
10-14 1172
Mms数据库的triggers 1. threads表将SMS、MMS的信息组织成一个conversation，所以当MMS、SMS信息发生改变时也需要更新threads表 2. 维护pending_msgs表格，其中包含pending_msgs表用于存储待发送或下载的SMS/MMS 3. 维护错误标志位 /** * the name of the table
Mms 数据库的一个bug
thinkinwm的专栏
10-13 820
之前遇到的一个Mms 数据库的bug，看到4.1版本已经解掉了； 老版本的代码： public static void updateThread(SQLiteDatabase db, long thread_id) { if (thread_id < 0) { updateAllThreads(db, null, null);
Android MMS 数据存取详解
**threads表**是MMS数据库中的一个重要部分，它包含了以下字段： - `_id`：唯一的整数ID，自增长，从1开始。 - `date`：会话的最新更新时间，以整数形式表示的时间戳。 - `message_count`：会话中包含的消息总数。 -...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值