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

来源:互联网 发布:电脑屏幕调节软件 编辑:程序博客网 时间:2024/05/22 14:35
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);  } }}


 

原创粉丝点击