android如何查询数据库版本,查询Android数据库是否存在！

当初始化以下类：

mOpenHelper = new DatabaseHelper(getContext());

，如果它不存在，它会自动创建数据库。 它还允许通过将DB_VER更改为更高的数字来升级数据库。

然后让你能够查询数据库的使用：

SQLiteDatabase db = mOpenHelper.getWritableDatabase();

上面让你db.query() & db.insert()等方法。

private static class DatabaseHelper extends SQLiteOpenHelper {

private static final String DB_NAME = "db_name.db";

private static final int DB_VER = 1;

public DatabaseHelper(Context context) {

super(context, DB_NAME, null, DB_VER);

}

@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL("CREATE TABLE table_name (" + "_id INTEGER PRIMARY KEY, "

+ " column_name_2 TEXT);");

.execSQL("INSERT INTO table_name "

+ "(column_name_2) "

+ "VALUES " + "('hello world');");

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

Log.w(TAG + "Upgrading database from version " + oldVersion + " to "

+ newVersion + ", which will destroy all old data");

try {

db.execSQL("DROP TABLE IF EXISTS table_name");

onCreate(db);

} catch (SQLException e) {

Log.e(TAG + "getting exception "

+ e.getLocalizedMessage().toString());

}

}

}