import java.util.ArrayList;
import android.app.Activity;
import android.content.Context;
import android.database.DatabaseUtils;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.os.Bundle;
import android.widget.TextView;
public class GetSqliteconfigurationtoolActivity extends Activity {
TextView txt;
DB db;
private String TABLE = "t1";
ArrayList<String> dbSetting;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
db = new DB(this);
txt = (TextView) findViewById(R.id.txt);
StringBuilder s = new StringBuilder();
dbSetting = db.showDBSetting();
for (int i = 0; i < dbSetting.size(); i++) {
s.append(dbSetting.get(i) + "\n");
}
txt.setText("" + s.toString());
}
class DB extends SQLiteOpenHelper {
private static final String DB_NAME = "rlbencmark.db";
private static final int DB_VERSION = 1;
SQLiteStatement sq;
private SQLiteDatabase mDB;
public DB(Context c){
super(c, DB_NAME, null, DB_VERSION);
mDB = this.getWritableDatabase();
showDBSetting();
createTable();
}
ArrayList<String> initDBSetting(){
ArrayList<String> rtn = new ArrayList<String>();
rtn.add("journal_mode");
rtn.add("synchronous");
rtn.add("wal_checkpoint");
rtn.add("wal_autocheckpoint");
rtn.add("auto_vacuum");
rtn.add("automatic_index");
rtn.add("cache_size");
rtn.add("checkpoint_fullfsync ");
rtn.add("compile_options");
rtn.add("count_changes");
rtn.add("default_cache_size");
rtn.add("encoding");
rtn.add("foreign_keys");
rtn.add("freelist_count");
rtn.add("fullfsync");
rtn.add("ignore_check_constraints ");
rtn.add("integrity_check ");
rtn.add("journal_size_limit ");
rtn.add("legacy_file_format ");
rtn.add("locking_mode ");
rtn.add("max_page_count ");
rtn.add("page_count ");
rtn.add("page_size ");
rtn.add("quick_check ");
rtn.add("read_uncommitted ");
rtn.add("recursive_triggers ");
rtn.add("reverse_unordered_selects ");
rtn.add("schema_version ");
rtn.add("secure_delete ");
rtn.add("shrink_memory ");
rtn.add("temp_store ");
rtn.add("temp_store_directory ");
return rtn;
}
ArrayList<String> showDBSetting() {
ArrayList<String> DBSettings = initDBSetting();
ArrayList<String> rtn = new ArrayList<String>();
for (int i = 0; i < DBSettings.size(); i++) {
try {
String s = DatabaseUtils.stringForQuery(mDB, "PRAGMA " + DBSettings.get(i),null);
rtn.add("--DBSetting--\t\t" + DBSettings.get(i) + " :\t\t" + s);
} catch (Exception e) {}
}
return rtn;
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
}
void dropTable() {
mDB.execSQL("DROP TABLE IF EXISTS " + TABLE);
}
void createTable() {
mDB.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE + " (a INTEGER, b INTEGER, c TEXT);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
}
拿到Android 手機 Sqlite 設置
最新推荐文章于 2022-10-15 17:15:21 发布
本文介绍如何在Android活动中获取SQLite数据库的配置信息。通过继承SQLiteOpenHelper创建DB类,利用PRAGMA语句查询数据库设置,如journal_mode、synchronous等,并展示在TextView上。
摘要由CSDN通过智能技术生成