在 Android 上的 SQLite 中创建多个表

public class MyDatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "my_database.db";
    public static final String TABLE1_NAME = "table1";
    public static final String TABLE2_NAME = "table2";

    public MyDatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTable1 = "CREATE TABLE " + TABLE1_NAME + " (" +
                "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "name TEXT NOT NULL, " +
                "age INTEGER NOT NULL)";
        db.execSQL(createTable1);

        String createTable2 = "CREATE TABLE " + TABLE2_NAME + " (" +
                "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "description TEXT NOT NULL, " +
                "price REAL NOT NULL)";
        db.execSQL(createTable2);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE1_NAME);
        db.execSQL("DROP TABLE IF EXISTS " + TABLE2_NAME);
        onCreate(db);
    }
}

MyDatabaseHelper dbHelper = new MyDatabaseHelper(getApplicationContext());
SQLiteDatabase db = dbHelper.getWritableDatabase();