Android SQLite数据库中的表详解

import java.util.Arrays;
import android.app.Activity;
import android.database.@R_616_10930@or;
import android.database.sqlite.sqliteDatabase;
import android.os.bundle;
import android.util.Log;
import android.view.View;
import android.view.View.onClickListener;
import android.widget.button;

public class SecondActivity extends Activity {

  public static final String TAG = "Debug Info";

  @Override
  protected void onCreate(Bundle savedInstanceStatE) {
    super.onCreate(savedInstanceStatE);

    ((Button)findViewById(R.id.btnQuE)).setOnClickListener(new OnClickListener() {

      @Override
      public void onClick(View v) {
        MyDatabaseHelper dbHelper = new MyDatabaseHelper(SecondActivity.this,"BookStore.db",null,1);
        sqliteDatabase db = dbHelper.getWritableDatabase();

        //核心区
        //读取系统表 sqlite_master
        String sql = "SELEct * from sqlite_master";
        @R_616_10930@or @R_616_10930@or = db.rawQuery(sql,null);

        //打印表的所有列名
        Log.i(tag,Arrays.toString(@R_616_10930@or.getcolumnNames()));

        //打印当前数据库中的所有表
        if (@R_616_10930@or.moveToFirst()) {
          do {
            String str = "";

            for (String item : @R_616_10930@or.getcolumnNames()) {
              str += item + ": " + @R_616_10930@or.getString(@R_616_10930@or.getcolumnIndex(item)) + "\n";
            }

            Log.i(tag,str);

          } while (@R_616_10930@or.moveToNext());
        }
      }
    });
  }

}

public Boolean tableIsExist(sqliteDatabase db,String tableName){
  Boolean result = false;
  @R_616_10930@or @R_616_10930@or = null;

  if(tablename == null){
    return result;
  }

  String sql = "SELEct count(*) from sqlite_master where type ='table' and name ='"+tablename.trim()+"'";
  @R_616_10930@or = db.rawQuery(sql,null);

  if(@R_616_10930@or.moveToNext()){
    if(@R_616_10930@or.geTint(0) > 0){
      result = true;
    }
  }

  return result;
}  

public ArrayList<String> tablesInDB(sqliteDatabase db){
  ArrayList<String> list = new ArrayList<String>();
  String sql = "SELEct name from sqlite_master where type='table'";
  @R_616_10930@or @R_616_10930@or = db.rawQuery(sql,null);

  if (@R_616_10930@or.moveToFirst()) {
      do {
        list.add(@R_616_10930@or.getString(0));
      } while (@R_616_10930@or.moveToNext());
    }

  return list;

}