Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. public Cursor getAllDataTableStaffDatabase(String table_name){
  2. this.open();
  3. Cursor result =this.mDb.rawQuery("SELECT * FROM " + table_name,null);
  4. return result;// fonctionne très bien
  5. }
  6.  
  7. public String findNameOfStaffBymail(String mail) {
  8. String sql = " SELECT * FROM " + DatabaseStaffHandler.STAFF_TABLE_NAME + " WHERE " + DatabaseStaffHandler.STAFF_MAIL + " = ? ";
  9. Cursor result = super.mDb.rawQuery(sql, new String[]{mail});
  10. Cursor data = super.getAllDataTableStaffDatabase(DatabaseStaffHandler.STAFF_TABLE_NAME);
  11.  
  12. String test = result.getString(1); //error
  13.  
  14. while (data.moveToNext()) {
  15. if (data.getString(3).equals(mail)) {
  16. viewAll();
  17. return data.getString(1);
  18. }
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement