Java tutorial
//package com.java2s; //License from project: Open Source License import android.content.Context; import android.content.SharedPreferences; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.preference.PreferenceManager; import android.text.TextUtils; public class Main { private static final String DEPRECATED_DATABASE_NAME = "wordpress"; private static final String DEPRECATED_ACCOUNT_TABLE = "tbl_accounts"; private static final String DEPRECATED_ACCESS_TOKEN_COLUMN = "access_token"; private static final String DEPRECATED_ACCESS_TOKEN_PREFERENCE = "wp_pref_wpcom_access_token"; public static String getLatestDeprecatedAccessToken(Context context) { String latestToken = getAccessTokenFromTable(context, DEPRECATED_ACCOUNT_TABLE); if (TextUtils.isEmpty(latestToken)) { latestToken = getDeprecatedPreferencesAccessToken(context); } return latestToken; } static String getAccessTokenFromTable(Context context, String tableName) { String token = null; try { SQLiteDatabase db = context.openOrCreateDatabase(DEPRECATED_DATABASE_NAME, 0, null); Cursor c = db.rawQuery( "SELECT " + DEPRECATED_ACCESS_TOKEN_COLUMN + " FROM " + tableName + " WHERE local_id=0", null); if (c.moveToFirst() && c.getColumnIndex(DEPRECATED_ACCESS_TOKEN_COLUMN) != -1) { token = c.getString(c.getColumnIndex(DEPRECATED_ACCESS_TOKEN_COLUMN)); } c.close(); db.close(); } catch (SQLException e) { // DB doesn't exist } return token; } private static String getDeprecatedPreferencesAccessToken(Context context) { SharedPreferences prefs = PreferenceManager.getDefaultSharedPreferences(context); String token = prefs.getString(DEPRECATED_ACCESS_TOKEN_PREFERENCE, null); return token; } }