public ArrayList<Contact> getAllContacts() { ArrayList<Contact> contactList = new ArrayList<Contact>(); String selectQuery = "SELECT * FROM " + TABLE_DETAILS; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); if (cursor.moveToFirst()) { // if (cursor != null) do { Contact contact = new Contact(); contact.setName(cursor.getString(1)); contact.setAddress(cursor.getString(4)); contact.setPhone(cursor.getString(5)); String interest = getInterest(cursor.getInt(0)); contact.setInterest(interest); contactList.add(contact); } while (cursor.moveToNext()); } return contactList; }
public ArrayList<Contact> getCustomizedContacts(String interest, String city, String area) { ArrayList<Contact> contactList = new ArrayList<Contact>(); boolean flag = true; String selectQuery = "select * from " + TABLE_DETAILS + " as a" + " natural join " + TABLE_INTEREST + " as b "; if (interest.compareTo("ALL") != 0) { if (flag) { selectQuery += " where "; flag = false; } else selectQuery += " and "; selectQuery += " a.Sr = b.sr and b.Interest = '" + interest + "'"; } if (city.compareTo("ALL") != 0) { if (flag) { selectQuery += " where "; flag = false; } else selectQuery += " and "; selectQuery += " a.City = '" + city + "'"; } if (area.compareTo("ALL") != 0) { if (flag) { selectQuery += " where "; flag = false; } else selectQuery += " and "; selectQuery += " a.Area = '" + area + "'"; } SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); if (cursor.moveToFirst()) { // if (cursor != null) do { Contact contact = new Contact(); contact.setName(cursor.getString(1)); contact.setAddress(cursor.getString(4)); contact.setPhone(cursor.getString(5)); contact.setInterest(cursor.getString(6)); contactList.add(contact); } while (cursor.moveToNext()); } return contactList; }