SQLite

1、创建数据库MyOpenHelper 继承SQLiteOpenHelper

public class MyOpenHelper extends SQLiteOpenHelper {
    public static final String sql = "create table User("
            +"id integer primary key autoincrement,"
            +"userName text,"
            +"passWord text)";
    private Context mContext;
    public MyOpenHelper(Context context, String name, CursorFactory factory, int version) {
        super(context, name, factory, version);
        this.mContext = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(sql);
        Toast.makeText(mContext, "创建成功", Toast.LENGTH_SHORT).show();
    }

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

    }

}

在Activity里面：

public class MainActivity extends Activity {
protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        button = (Button) findViewById(R.id.savebut);
        helper = new MyOpenHelper(this, "test.db", null, 1);
        button.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                helper.getWritableDatabase();
            }
        });
    }
}

2、在数据库中创建多张表，先将之前的表删除

db.execSQL("drop table if exists User");
db.execSQL("drop table if exists xxoo");

public static final String sql2 = "create table xxoo("
            +"id integer primary key autoincrement,"
            +"userName text,"
            +"passWord text)";
@Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(sql);
        db.execSQL(sql2);
        Toast.makeText(mContext, "创建成功", Toast.LENGTH_SHORT).show();
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists User");
        db.execSQL("drop table if exists xxoo");
        onCreate(db);
    }

在activity里面：
版本号改为：2

helper = new MyOpenHelper(this, "test.db", null, 2);