Android--遍历SQLite数据库下的所有表名

时间:2022-11-05 23:00:36
package cn.mrzhu.foreignkey;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;

public class ForeignKeyActivity extends Activity {
String[] arr = {"table1", "table2", "table3"};
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
//创建数据库
SQLiteDatabase db = openOrCreateDatabase("test.db", Context.MODE_PRIVATE, null);
for(int i = 0; i < 3; ++i){
//循环创建三张表
db.execSQL("create table'" + arr[i] + "'(id varchar(20), name varchar(20))");
}
Cursor cursor = db.rawQuery("select name from sqlite_master where type='table' order by name", null);
while(cursor.moveToNext()){
//遍历出表名
String name = cursor.getString(0);
Log.i("System.out", name);
}
}
}