public List<Players> getAllPlayers() { if (_local) { SQLiteDatabase db = this.getReadableDatabase(); List<Players> players = new ArrayList<Players>(); String selectPlayerQuery = "SELECT * FROM " + TABLE_PLAYERS; Log.i(LOG, selectPlayerQuery); Cursor c = db.rawQuery(selectPlayerQuery, null); if (c != null && c.moveToFirst()) { do { // create the instance of Players using cursor information Players player = new Players(); player.setpid(c.getLong(c.getColumnIndex(KEY_P_ID))); player.settid(c.getLong(c.getColumnIndex(KEY_T_ID))); player.setpname((c.getString(c.getColumnIndex(KEY_P_NAME)))); player.setpnum((c.getInt(c.getColumnIndex(KEY_P_NUM)))); // adding to players list players.add(player); } while (c.moveToNext()); } return players; } else { return _net.getAllPlayers(); } }