【原创】SQLiteOpenHelper 示例

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) {  
    }  
}