public class DBOperator {
private static DBOperator dbInstance = new DBOperator();
private SQLiteDatabase db;
private DaoMaster daoMaster;
private DaoSession daoSession;
public static DBOperator getInstance() {
return dbInstance;
}
/**
* sqlite connection
*
* @param
* @return
*/
public DaoSession getDaoSession() {
try {
db = SQLiteDatabase.openDatabase(数据库路径 + 数据库名称, null,
SQLiteDatabase.OPEN_READWRITE);
daoMaster = new DaoMaster(db);
daoSession = daoMaster.newSession();
} catch (Exception e) {
daoSession = null;
}
return daoSession;
}
/**
* sqlite 连接
*
* @param db
* @return
*/
public SQLiteDatabase connection(SQLiteDatabase db) {
try {
db = SQLiteDatabase.openDatabase(数据库路径 + 数据库名称, null,
SQLiteDatabase.OPEN_READWRITE);
} catch (Exception e) {
lodg("[SQLiteDatabase]......e===>" + e.toString());
}
return db;
}
/**
* 关闭 sqlite db
*
* @param mCursor
* @param db
*/
public void closeConnection(Cursor mCursor, SQLiteDatabase db) {
try {
if (mCursor != null) {
mCursor.close();
}
if (db != null) {
db.close();
}
} catch (Exception e) {
lodg("[closeConnection]....e====>" + e.toString());
}
}
}