public static ArrayList<Velo> getAllVelo() {

        Statement stat;
        ArrayList<Velo> velos = new ArrayList<>();
        try {
            stat = ConnexionDB.getConnection().createStatement();
            stat.executeUpdate("use nemovelo");
            ResultSet res = stat.executeQuery("select * from velo");
            Velo velo;
            int id_velo, fk_id_borne;
            double kmParcourus;
            String serialNumber, dateMiseEnService, etat;
            while (res.next()) {
                id_velo = res.getInt("id_velo");
                serialNumber = res.getString("serialNumber");
                dateMiseEnService = res.getString("dateMiseEnService");
                kmParcourus = res.getDouble("kmParcourus");
                etat = res.getString("etat");
                fk_id_borne = res.getInt("fk_id_borne");
                velo = new Velo(id_velo, serialNumber, dateMiseEnService, kmParcourus, etat, fk_id_borne);
                velos.add(velo);
            }
        } catch (SQLException e) {
            while (e != null) {
                System.out.println(e.getErrorCode());
                System.out.println(e.getMessage());
                System.out.println(e.getSQLState());
                e.printStackTrace();
                e = e.getNextException();
            }
        }
        return velos;

    }