【原创】SQLiteOpenHelper 示例

最新推荐文章于 2022-08-01 16:09:51 发布

firewings_r

最新推荐文章于 2022-08-01 16:09:51 发布

阅读量104

点赞数

分类专栏： Android 文章标签： Android SQLite

Android 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

本文介绍了一个用于管理短信数据的SQLite数据库助手类DbHelper。该工具为Android应用提供了一个简便的方法来创建和升级短信数据库，包括sms表及其字段如_id、address、person等。

摘要由CSDN通过智能技术生成

package com.firewings.smstools;  
  
import android.content.Context;  
import android.database.sqlite.SQLiteDatabase;  
import android.database.sqlite.SQLiteOpenHelper;  
  
public class DbHelper extends SQLiteOpenHelper {  
      
    private static DbHelper sSingleton = null;  
  
    public static final String DATABASE_NAME = "sms.db";  
    public static final int DATABASE_VERSION = 1;  
  
    public interface Tables {  
        public static final String SMS = "sms";  
    }  
  
    public interface SmsColumns {  
        public static final String _ID = "_id";  
        public static final String ADDRESS = "address";  
        public static final String PERSON = "person";  
        public static final String DATE = "date";  
        public static final String TYPE = "type";  
        public static final String BODY = "body";  
        public static final String SEND = "send";  
    }  
      
    public static synchronized DbHelper getInstance(Context context) {  
        if (sSingleton == null) {  
            sSingleton = new DbHelper(context);  
        }  
        return sSingleton;  
    }  
  
    public DbHelper(Context context) {  
        super(context, DATABASE_NAME, null, DATABASE_VERSION);  
    }  
  
    @Override  
    public void onCreate(SQLiteDatabase db) {  
        db.execSQL("CREATE TABLE " + Tables.SMS + " (" +  
                SmsColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +  
                SmsColumns.ADDRESS + " TEXT NOT NULL," +  
                SmsColumns.PERSON + " TEXT," +  
                SmsColumns.DATE + " TEXT NOT NULL," +  
                SmsColumns.TYPE + " TEXT NOT NULL," +  
                SmsColumns.BODY + " TEXT NOT NULL," +  
                SmsColumns.SEND + " INTEGER NOT NULL DEFAULT 0" +  
        ");");  
    }  
  
    @Override  
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {  
    }  
}