/** * @param name * @param mode * @param factory * @return * @see android.content.ContextWrapper#openOrCreateDatabase(java.lang.String, * int, android.database.sqlite.SQLiteDatabase.CursorFactory) */ public SQLiteDatabase openOrCreateDatabase(String name, int mode, CursorFactory factory) { return mActivity.openOrCreateDatabase(name, mode, factory); }
/** * @param name * @param mode * @param factory * @param errorHandler * @return * @see android.content.ContextWrapper#openOrCreateDatabase(java.lang.String, * int, android.database.sqlite.SQLiteDatabase.CursorFactory, * android.database.DatabaseErrorHandler) */ public SQLiteDatabase openOrCreateDatabase(String name, int mode, CursorFactory factory, DatabaseErrorHandler errorHandler) { return mActivity.openOrCreateDatabase(name, mode, factory, errorHandler); }
static String selectedItem(Activity activity, String[] who, int where, ArrayList<String> column) { //create the notes db SQLiteDatabase notesDB = activity.openOrCreateDatabase("notesDB", MODE_PRIVATE, null); Cursor notesCursor = notesDB.rawQuery("SELECT * FROM " + who[0], null); String selected = ""; if (notesCursor != null && notesCursor.moveToFirst()) { while (!notesCursor.isAfterLast()) { //get items at selected position selected = column.get(where); notesCursor.moveToNext(); } notesCursor.close(); } notesDB.close(); return selected; } }
static ArrayList<String> initNoteElement(Activity activity, String[] who) { //create the notes db SQLiteDatabase notesDB = activity.openOrCreateDatabase("notesDB", MODE_PRIVATE, null); //create a table called ? with a column called ? where notes titles will be stored notesDB.execSQL("CREATE TABLE IF NOT EXISTS " + who[0] + "(id INTEGER PRIMARY KEY AUTOINCREMENT," + who[1] + " varchar);"); ArrayList<String> selected = new ArrayList<>(); Cursor notesDBcursor; notesDBcursor = notesDB.rawQuery("SELECT * FROM " + who[0], null); if (notesDBcursor != null && notesDBcursor.moveToFirst()) { while (!notesDBcursor.isAfterLast()) { //add items to selected field selected.add(notesDBcursor.getString(notesDBcursor.getColumnIndex(who[1]))); notesDBcursor.moveToNext(); } notesDBcursor.close(); } notesDB.close(); return selected; }
public int verifytoken(String orgstr) { try { String str = Token.lastToken(orgstr).getVal().toString(); SQLiteDatabase db = MainActivity.activity.openOrCreateDatabase("data", MODE_PRIVATE, null); db.execSQL("create table if not exists key (key varchar,ans varchar)");
@Override public void onClick(DialogInterface dialog, int which) { SQLiteDatabase notesDB = getActivity().openOrCreateDatabase("notesDB", MODE_PRIVATE, null);
private static void deleteNote(Activity activity, int pos) { SQLiteDatabase notesDB = activity.openOrCreateDatabase("notesDB", MODE_PRIVATE, null);