这篇博文是笔记,主要介绍SQLite数据库的使用方法,这里以一个建立黑名单数据库为例子
第一步,建立数据库
建立数据库需要先建立一张表,然后再根据这张表建立起数据库
package com.example.administrator.telphone_cut.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;
/**
* Created by A君 on 2016/3/27.
*/
public class BlackNumberDBHelper extends SQLiteOpenHelper {
private static BlackNumberDBHelper mInstance;
private final static String name = "blacknumber.db";
private static Context mContext;
public static final String CREAT_BLACKNUMBER = "create table blacknumber ("
+ "id integer primary key autoincrement, "
+ "number text)";
public static SQLiteOpenHelper getmInst