Android SQLite数据库

1.新建MyDatabaseHelper extends SQLiteOpenHelper

public class MyDatabaseHelper extends SQLiteOpenHelper {
    public static final String CREATE_INFO = "create table Info(" +
            "id integer primary key autoincrement," +
            "name text," +
            "age integer" +
            ")";
    public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_INFO);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {

    }
}

2.增删改查

public class MyDatabase {
	Context context;
	SQLiteDatabase db;
    public MyDatabase(Context context) {
        this.context = context;
        db = new MyDatabaseHelper(context,"My.db",null,1).getWritableDatabase();
    }
    
    void add(){
        ContentValues values = new ContentValues();
        values.put("name","david");
        values.put("age",18);
        db.insert("Info",null,values);
    }

    void update(){
        ContentValues values = new ContentValues();
        values.put("age",20);
        db.update("Info",values,"name=?",new String[]{"david"});
    }
    
    void query(){
        Cursor cursor = db.query("Info",null,null,null,null,null,null);
        if(cursor.moveToFirst()){
            do{
                Log.d("", "name"+cursor.getString(cursor.getColumnIndex("name")));
            }while (cursor.moveToNext());
        }
    }
    
    void delete(){
        db.delete("Info","name=?",new String[]{"david"});
    }


}

3.升级数据库
3.1修改onUpgrade

	public void onUpgrade(SQLiteDatabase db, int i, int i1) {
        db.execSQL(("drop table if exists Info"));
        onCreate(db);
    }

3.2重新调用database并增加版本号

	db = new MyDatabaseHelper(context,"My.db",null,2).getWritableDatabase();