DBHelper.java

    //not included in model but to prepare for exam,
    public List<String> viewSearchedUser(String id) {
        SQLiteDatabase db = getReadableDatabase();

        //retrieve the user using primary key
        String[] selectionArgs = {id+"%"};
        String query = "SELECT * FROM " + TABLE_NAME + " WHERE "+ _ID + " = ? ";

        Cursor cursor = db.rawQuery(query, selectionArgs);

        List<String> users = new ArrayList();
        if (cursor.moveToFirst()) {
            String value = cursor.getLong(0) + "\n" +
                    cursor.getString(1) + "\n" +
                    cursor.getString(2) +  "\n" +
                    cursor.getString(3) + "\n" +
                    cursor.getString(4);
            users.add(value);
        }
        cursor.close();
        return users;
    }

gistfile1.txt

    //not included in model but to prepare for exam,
    public List<String> viewAllInfor() {
        SQLiteDatabase db = getReadableDatabase();

        String[] projection = {
                _ID,
                COLUMN_USERNAME,
                COLUMN_PASSWORD,
                COLUMN_DOB,
                COLUMN_GENDER
        };

        Cursor cursor = db.query(
                TABLE_NAME,
                projection,
                null,
                null,
                null,
                null,
                null);

        //just to make things easy I change User type to String
        List<String> users = new ArrayList();
        while (cursor.moveToNext()) {
            String value = cursor.getLong(0) + "\n" +
                    cursor.getString(1) + "\n" +
                    cursor.getString(2) +  "\n" +
                    cursor.getString(3) + "\n" +
                    cursor.getString(4);
            users.add(value);
        }
        cursor.close();
        return users;
    }