android mysql同时_android 同时打开两个sqlite database db

packagecom.example.testdb;importandroid.content.Context;importandroid.database.SQLException;importandroid.database.sqlite.SQLiteDatabase;importandroid.database.sqlite.SQLiteException;importandroid.database.sqlite.SQLiteOpenHelper;importandroid.util.Log;public classDBAdapter {//DB info

public static String MAIN_DATABASE_NAME = "Bowers.db";public static final String OFFSET_DATABASE_NAME = "BowersOffset.db";public static final int MAIN_DATABASE_VERSION = 1;public static final int OFFSET_DATABASE_VERSION = 1;//database control

privateDatabaseHelper mDbHelper;privateSQLiteDatabase mDb;privateContext mCtx;publicString currentDBName;public intcurrentDBVer;private class DatabaseHelper extendsSQLiteOpenHelper {

DatabaseHelper(Context context, String dbname,intdbversion) {super(context, dbname, null, dbversion);

}

@Overridepublic voidonCreate(SQLiteDatabase db) {

Log.e("xxxx","onCreate");

db.execSQL("CREATE TABLE `room` (`roomName` VARCHAR , `clazzId` INTEGER DEFAULT 0 , `createTime` BIGINT , `roomId` BIGINT , `check_code` BIGINT , `roomType` INTEGER , PRIMARY KEY (`roomId`) );");

}

@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, intnewVersion) {

Log.e("xxxx","onCreate");

}

}publicDBAdapter(Context ctx) {

mCtx=ctx;

}public DBAdapter open(String dbname, int dbversion) throwsSQLException {

mDbHelper= newDatabaseHelper(mCtx, dbname, dbversion);

mDb=mDbHelper.getWritableDatabase();

currentDBName=dbname;

currentDBVer=dbversion;return this;

}public voidinsert() {

mDb.execSQL("Replace into room(roomName, roomType ) values( '"+currentDBName+"',"+currentDBVer+");");

}public voidclose() {

mDbHelper.close();

}//指定数据库文件路径方法打开数据库。

static String MAIN_DB_PATH="/data/data/com.example.testdb/databases/";private static booleancheckDataBase(String dbname) {

SQLiteDatabase checkDB= null;boolean exist = false;try{

String db= MAIN_DB_PATH +dbname;

checkDB= SQLiteDatabase.openDatabase(db, null, SQLiteDatabase.OPEN_READONLY);

}catch(SQLiteException e) {

Log.v("db log", "database does't exist");

}if (checkDB != null) {

exist= true;

checkDB.close();

}returnexist;

}public void openDataBase(String dbname) throwsSQLException {

String dbPath= MAIN_DB_PATH +dbname;

mDb= SQLiteDatabase.openDatabase(dbPath, null, SQLiteDatabase.OPEN_READWRITE);

}

}