public List<Road> DisplayAllRoad (){


        List<Road> RoadList = new ArrayList<>();

        String requete = "select * from road";
        try {
           Statement statement = MyConnection.getInstance().createStatement();
            ResultSet resultat = statement.executeQuery(requete);

            while(resultat.next()){
                Road road =new Road();
                
                road.setId(resultat.getInt(1));
                road.setDriver(resultat.getString(2));
                road.setPrice(resultat.getFloat(3));
                road.setSeat(resultat.getInt(4));
                road.setCityD(resultat.getString(5));
                road.setCityR(resultat.getString(6));
                road.setRound(resultat.getString(7));
                road.setDateD(resultat.getDate(8));
                road.setDateR(resultat.getDate(9));
                road.setHourD(resultat.getString(10));
                road.setHourR(resultat.getString(11));
                road.setCar(resultat.getString(12));
                RoadList.add(road);
            }
            return RoadList;
        } catch (SQLException ex) {
           //Logger.getLogger(PersonneDao.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("Error : "+ex.getMessage());
            return null;
        }
    }