1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| public List<String> search(String query, String rechPrenom) {
List<String> result = new ArrayList<String>();
SQLiteDatabase db = getReadableDatabase();
if (rechPrenom.equals(null)){
final Cursor cursor = db.query(TABLE_NAME, new String[]
{ COLUMN_NOM, COLUMN_NOMM , COLUMN_PRENOM , COLUMN_DATE, COLUMN_NUMERO, COLUMN_ADRESSE,COLUMN_CODEEL, COLUMN_BUREAU},
COLUMN_NOM + " LIKE ?", new String[] { query }, null, null, null);
if (cursor.moveToFirst()) {
do {
String text = cursor.getString(COLUMN_NOM_ID) +" "+ cursor.getString(COLUMN_PRENOM_ID)
+"\n Nom de naissance: "+ cursor.getString(COLUMN_NOMM_ID)
+"\n Date de naissance: "+ cursor.getString(COLUMN_DATE_ID)
+"\n Adresse: "+ cursor.getString(COLUMN_NUMERO_ID) +" "+ cursor.getString(COLUMN_ADRESSE_ID)
+"\n N° Electeur: "+ cursor.getString(COLUMN_CODEEL_ID)
+"\n Bureau: "+ cursor.getString(COLUMN_BUREAU_ID);
result.add(text);
} while (cursor.moveToNext());
}
cursor.close();
}
else {
final Cursor cursor = db.query(TABLE_NAME, new String[]
{ COLUMN_NOM, COLUMN_NOMM , COLUMN_PRENOM , COLUMN_DATE, COLUMN_NUMERO, COLUMN_ADRESSE,COLUMN_CODEEL, COLUMN_BUREAU},
(COLUMN_NOM +" LIKE ? AND" + COLUMN_PRENOM + " LIKE ? "), new String[] { query, rechPrenom}, null, null, null);
if (cursor.moveToFirst()) {
do {
String text = cursor.getString(COLUMN_NOM_ID) +" "+ cursor.getString(COLUMN_PRENOM_ID)
+"\n Nom de naissance: "+ cursor.getString(COLUMN_NOMM_ID)
+"\n Date de naissance: "+ cursor.getString(COLUMN_DATE_ID)
+"\n Adresse: "+ cursor.getString(COLUMN_NUMERO_ID) +" "+ cursor.getString(COLUMN_ADRESSE_ID)
+"\n N° Electeur: "+ cursor.getString(COLUMN_CODEEL_ID)
+"\n Bureau: "+ cursor.getString(COLUMN_BUREAU_ID);
result.add(text);
} while (cursor.moveToNext());
}
cursor.close();
} |
Partager