public static Station getStationById(int id_station) {

        Station station = null;
        Statement stat;
        try {
            stat = ConnexionDB.getConnection().createStatement();
            stat.executeUpdate("use nemovelo");
            ResultSet res = stat.executeQuery("select * from station where id_station="+ id_station);
            String serialNumber, etat, latitude, longitude;
            if (res.next()) {
                id_station = res.getInt("id_station");
                serialNumber = res.getString("serialNumber");
                etat = res.getString("etat");
                latitude = res.getString("latitude");
                longitude = res.getString("longitude");
                station = new Station(id_station, serialNumber, etat, latitude, longitude);
            }
        } 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 station;
                
    }