要在Android Studio中列出同名的SQLite表,您可以使用以下代码示例:
// 创建一个SQLiteOpenHelper
public class MyDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "mydb";
private static final int DATABASE_VERSION = 1;
public MyDatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// 创建表
db.execSQL("CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY, name TEXT)");
// 插入数据
db.execSQL("INSERT INTO mytable (name) VALUES ('John')");
db.execSQL("INSERT INTO mytable (name) VALUES ('Jane')");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// 升级数据库时的操作,略
}
}
// 获取所有表的名称
public List getTableNames(Context context) {
List tableNames = new ArrayList<>();
SQLiteDatabase db = new MyDatabaseHelper(context).getReadableDatabase();
Cursor cursor = db.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null);
if (cursor != null) {
while (cursor.moveToNext()) {
String tableName = cursor.getString(0);
tableNames.add(tableName);
}
cursor.close();
}
return tableNames;
}
// 在Activity或Fragment中调用方法,并显示结果
List tableNames = getTableNames(getApplicationContext());
for (String tableName : tableNames) {
Log.d("Table Name", tableName);
}
这样,您就可以在Android Studio中列出同名的SQLite表了。