使用Sqlite保存数据

1. 定义bean类:

public class XGMessage {

    public int msgType; //消息类型. 0--链接(有url--打开网页, 没有url--打开app); 1-报警
    public String content; //消息内容
    public String url; //消息url
    public String receiveTime; //接收消息的时间
    public int isRead;  //是否已读。0-未读，1-已读
    public String mac; //设备的mac地址
    public String username;
    public String entryId;
}

2. 定义契约类:

/**
 * 契约类是用于定义 URI、表格和列名称的常数的容器
 * 通过实现 BaseColumns 接口，您的内部类可继承调用的主键字段_ID ，某些 Android 类（比如光标适配器）
 * 将需要内部类拥有该字段。 这并非必需项，但可帮助您的数据库与 Android 框架协调工作。
 */

public final class XGMessageContract {
   
    // To prevent someone from accidentally instantiating the contract class,
    // give it an empty constructor.
    private XGMessageContract() {
    }

    /**
     * BaseColumns接口包换_id,_count两个字段
     */
    public static abstract class XGMessageEntry implements BaseColumns {
   
        public static final String TABLE_NAME="xg_message_list";
        public static final String COLUMN_NAME_MSG_USERNAME="username";
        public static final String COLUMN_NAME_MSG_ENTRY_ID ="entryId";
        public static final String COLUMN_NAME_MSG_TYPE="msgType";
        public static final String COLUMN_NAME_CONTENT="content";
        public static final String COLUMN_NAME_URL="url";
        public static final String COLUMN_NAME_RECEIVE_TIME="receiveTime";
        public static final String COLUMN_NAME_MAC="mac";
        public static final String COLUMN_NAME_IS_READ="isRead";
        public static final String COLUMN_NAME_MSG_IS_DELETE="isDelete";
        public static final String COLUMN_NAME_MSG_INTENT="intent";
    }
}

3. 编写常量类: