@Override
    public ObservableList<Driver> getListOfDrivers() {
        ObservableList list = FXCollections.observableArrayList();
        String query = "SELECT u.id, u.phone, u.password, u.firstName, u.lastName, u.gender_id, u.created, u.lastLogin, u.userType_id, "
                + "d.birthDate, d.address, d.dateofEmployment, d.dateofDismissal "
                + "FROM user u INNER JOIN driver d on u.id=d.User_id";
        try {
            rs = connection.createStatement().executeQuery(query);

            while (rs.next()) {
                long id = rs.getLong(1);
                String phone = rs.getString(2);
                String password = rs.getString(3);
                String firstname = rs.getString(4);
                String lastname = rs.getString(5);
                int gender = rs.getInt(6);
                Timestamp created = rs.getTimestamp(7);
                Timestamp lastlogin = rs.getTimestamp(8);
                int usertype = rs.getInt(9);
                LocalDate birthDate = rs.getDate(10).toLocalDate();
                String address = rs.getString(11);
                LocalDate dateOfEmployment = rs.getDate(12).toLocalDate();
                Date date2 = rs.getDate(13);
                LocalDate dateOfDismissal = null;
                if(date2 != null){
                    date2.toLocalDate();
                }
                Driver user = new Driver(birthDate, address, dateOfEmployment, dateOfDismissal, id, phone, password, firstname, lastname, gender, created, lastlogin, usertype);
                list.add(user);
            }
        } catch (SQLException ex) {
            System.out.println(ex.getMessage());
            Logger.getLogger(MySQLUserDAO.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
        return list;
    }