最近写了一个抽签值日的程序需要用到数据库来存储数据,如果放到数据库中还要建表,还需要连网,本人感觉没有必要,所以就选择了本地存储sqlite的方式,来记录一下,方便以后查看
先创建一个工具类DateBaseHelper
public class StuDBHelper extends SQLiteOpenHelper{
public final static String NAME_CONTEXT_TAL = "name_context";//项目表
public final static String NAME_PERSON_TAL = "person_context";//人员与项目对应表
public final static int DB_VERSION = 6;
public StuDBHelper(Context context) {
super(context, NAME_CONTEXT_TAL, null, DB_VERSION);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "create table if not exists " + NAME_CONTEXT_TAL + "(_id integer primary key autoincrement,context_id varchar, context_name varchar)";
db.execSQL(sql);
String personsql = "create table if not exists " + NAME_PERSON_TAL + "(_id integer primary key autoincrement,person_id varchar, person_name varchar,context_name varchar)";
db.execSQL(personsql);
}
@Override