数据库操作

一、数据库操作语言

       create table userinfo(id text primary key,name text);

       insert into userinfo(id,name) values (1,"小泽");

      insert into userinfo(id,name) values (2,"小CANG");

      insert into userinfo(id,name) values (3,"小龙");

     delete from userinfo where id = 3;

     update userinfo set name = "老师" where id = 2;

public class CarConfigDataBase extends SQLiteAssetHelper {
    public static final int VERSION = 1;

    public static final String DB_NAME = "CarConfig.db3";

    private static String dbDirctory;

    private static CarConfigDataBase mInstance;

    private CarConfigDataBase(Context context, String directory) {
        super(context, DB_NAME, directory, null, VERSION);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    public static void setDbDirctory(String dirctory){
        dbDirctory = dirctory;

        if (mInstance != null) {
            mInstance.close();
        }
        mInstance = null;
    }

    public static synchronized CarConfigDataBase getInstance(Context context) {
        if (mInstance == null) {
            mInstance = new CarConfigDataBase(context, dbDirctory);
        }
        return mInstance;
    }
}