void createTable() { SQLiteDatabase db = Obtainer.AcquireDB(); db.beginTransaction(); boolean createComplete = false; try { Obtainer.getDB().execSQL(CREATE); createComplete = true; } catch (SQLException ex) { String msg = null; if (ex != null) { msg = ex.getMessage(); } if (msg != null && msg.contains("already exists")) { createComplete = true; } else { createComplete = false; } } if (createComplete) { db.setTransactionSuccessful(); } db.endTransaction(); Obtainer.ReleaseDB(); }
Cursor getCursor(String statement) { Cursor ret; try { ret = Obtainer.AcquireDB() .query( TableName, new String[] {IDXKEY, USER_ID, NICK_NAME, NICK_NAME_MINE}, statement, null, null, null, null); } finally { Obtainer.ReleaseDB(); } return ret; }