Android Open Source - Go2-Rennes Bus Dao






From Project

Back to project page Go2-Rennes.

License

The source code is released under:

GNU General Public License

If you think the Android project Go2-Rennes listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

/*******************************************************************************
 * Copyright (c) 2011 Michel DAVID mimah35-at-gmail.com
 * //from w  w w  .j  av  a  2  s  . c  o  m
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package fr.gotorennes.persistence;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import android.app.ProgressDialog;
import android.content.Context;
import android.database.Cursor;
import fr.gotorennes.domain.Arret;
import fr.gotorennes.domain.Circuit;
import fr.gotorennes.domain.Ligne;
import fr.gotorennes.domain.SensCirculation;
import fr.gotorennes.domain.Station;
import fr.gotorennes.domain.StationGroup;
import fr.gotorennes.util.JoursUtils;

public class BusDao {

  private static BusDao instance;

  private BusDatabase database;

  private BusDao(Context context, ProgressDialog progress) {
    database = new BusDatabase(context);
    database.init(progress);
  }

  public static synchronized BusDao getInstance(Context context, ProgressDialog progress) {
    if (instance == null) {
      instance = new BusDao(context, progress);
    }
    return instance;
  }

  public List<String> getTypesLigne() {

    Cursor cursor = database.query("SELECT distinct type FROM LIGNE", new String[] {});
    List<String> types = new ArrayList<String>();
    if (cursor != null) {
      do {
        types.add(cursor.getString(0));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return types;
  }

  public List<Ligne> getLignes(String type) {
    Cursor cursor = database.query("SELECT * FROM LIGNE WHERE type = ?", new String[] { type });
    List<Ligne> lines = new ArrayList<Ligne>();
    if (cursor != null) {
      do {
        lines.add(new Ligne(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return lines;
  }

  public List<Ligne> getLignes() {
    Cursor cursor = database.query("SELECT * FROM LIGNE", new String[] {});
    List<Ligne> lines = new ArrayList<Ligne>();
    if (cursor != null) {
      do {
        lines.add(new Ligne(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return lines;
  }

  public List<SensCirculation> getCircuits(Ligne ligne) {

    Cursor cursor = database.query("select group_concat(nom, ', ') nom, idLigne, sens from CIRCUIT where idLigne = ? group by idLigne, sens order by sens", new String[] { String.valueOf(ligne.id) });

    List<SensCirculation> sens = new ArrayList<SensCirculation>();
    if (cursor != null) {
      do {
        sens.add(new SensCirculation(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return sens;
  }
  
  public List<StationGroup> getStations() {
    Cursor cursor = database.query(
        "SELECT nom, commune, avg(latitude) latitude, avg(longitude) longitude, min(accessible) accessible, min(banc) banc, min(eclairage) eclairage, min(couvert) couvert FROM STATION GROUP BY nom, commune ORDER BY nom",
        new String[] { });
    List<StationGroup> stations = new ArrayList<StationGroup>();
    if (cursor != null) {
      do {
        stations.add(new StationGroup(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }

  public List<Station> getStations(Ligne ligne, SensCirculation sens) {
    Cursor cursor = database.query(
        "SELECT distinct STATION.* FROM STATION_CIRCUIT, STATION, CIRCUIT WHERE STATION_CIRCUIT.idStation = STATION._id AND STATION_CIRCUIT.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = ? AND CIRCUIT.sens = ? ORDER BY sequence",
        new String[] { String.valueOf(ligne.id), String.valueOf(sens.sens) });
    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }
  
  public List<Station> getStations(Ligne ligne) {
    Cursor cursor = database.query(
        "SELECT STATION.* FROM CIRCUIT, STATION_CIRCUIT, STATION WHERE STATION_CIRCUIT.idStation = STATION._id AND STATION_CIRCUIT.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = ?",
        new String[] { String.valueOf(ligne.id) });
    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }

  public Station getStation(long idStation) {

    Cursor cursor = database.query("select * from STATION where _id = ? LIMIT 1", new String[] { String.valueOf(idStation) });

    Station station = null;
    if (cursor != null) {
      station = new Station(cursor);
      cursor.close();
    }
    return station;
  }
  
  public Station getStation(String codeStation) {

    Cursor cursor = database.query("select * from STATION where code = ? LIMIT 1", new String[] { codeStation });

    Station station = null;
    if (cursor != null) {
      station = new Station(cursor);
      cursor.close();
    }
    return station;
  }
  
  public Station getStation(long idCircuit, String nom) {

    String request = "select STATION.* from STATION_CIRCUIT, STATION where STATION_CIRCUIT.idCircuit = ? AND STATION_CIRCUIT.idStation = station._id AND station.nom = ? limit 1";
    Cursor cursor = database.query(request, new String[] { String.valueOf(idCircuit), nom });

    Station station = null;
    if (cursor != null) {
      station = new Station(cursor);
      cursor.close();
    }
    return station;
  }
  
  public StationGroup getStationGroup(Station station) {
    String request = "select nom, commune, avg(latitude) latitude, avg(longitude) longitude, min(accessible) accessible, min(banc) banc, min(eclairage) eclairage, min(couvert) couvert from STATION where station.nom = ? and station.commune = ? group by nom, commune";
    Cursor cursor = database.query(request, new String[] { station.nom, station.commune });
    
    StationGroup stationGroup = null;
    if (cursor != null) {
      stationGroup = new StationGroup(cursor);
      cursor.close();
    }
    return stationGroup;
  }

  public List<StationGroup> getStationsProches(double latitude, double longitude) {
    
    String request = "select nom, commune, avg(latitude) latitude, avg(longitude) longitude, min(accessible) accessible, min(banc) banc, min(eclairage) eclairage, min(couvert) couvert from STATION group by nom, commune order by (latitude - ?) * (latitude - ?)+ (longitude - ?) * (longitude - ?) limit 4";
    Cursor cursor = database.query(request, new String[] { String.valueOf(latitude), String.valueOf(latitude), String.valueOf(longitude), String.valueOf(longitude) });

    List<StationGroup> stations = new ArrayList<StationGroup>();
    if (cursor != null) {
      do {
        stations.add(new StationGroup(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }

  public List<Station> getStations(double latitudeMin, double latitudeMax, double longitudeMax, double longitudeMin) {
    
    String request = "select * from STATION where latitude >= ? and latitude <= ? and longitude >= ? and longitude <= ? LIMIT 50";
    Cursor cursor = database.query(request,
        new String[] { String.valueOf(latitudeMin), String.valueOf(latitudeMax), String.valueOf(longitudeMin), String.valueOf(longitudeMax) });

    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }
  
  public List<Ligne> getLignes(Station station) {
    String request = "select distinct LIGNE.* from STATION_CIRCUIT, CIRCUIT, LIGNE where STATION_CIRCUIT.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = LIGNE._id AND STATION_CIRCUIT.idStation = ? order by LIGNE.code";
    Cursor cursor = database.query(request, new String[] { String.valueOf(station.id) });

    List<Ligne> lignes = new ArrayList<Ligne>();
    if (cursor != null) {
      do {
        lignes.add(new Ligne(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return lignes;
  }
  
  public List<Station> getStations(StationGroup station) {
    String request = "select * from STATION where nom = ? AND commune = ?";
    Cursor cursor = database.query(request, new String[] { station.nom, station.commune });

    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }
  
  public List<Circuit> getCircuits(Station station) {
    
    String request = "select CIRCUIT.* from STATION_CIRCUIT, CIRCUIT where STATION_CIRCUIT.idCircuit = CIRCUIT._id AND STATION_CIRCUIT.idStation = ? order by idLigne, nom";
    Cursor cursor = database.query(request, new String[] { String.valueOf(station.id) });

    List<Circuit> circuits = new ArrayList<Circuit>();
    if (cursor != null) {
      do {
        circuits.add(new Circuit(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return circuits;
  }

  public Circuit getCircuit(long id) {
    
    String request = "select * from CIRCUIT where _id = ? LIMIT 1";
    Cursor cursor = database.query(request, new String[] { String.valueOf(id) });

    Circuit circuit = null;
    if (cursor != null) {
      circuit = new Circuit(cursor);
      cursor.close();
    }
    return circuit;
  }

  public Arret getProchainPassage(long idStation, long idLigne, boolean nuit) {
    return getPassage(idStation, idLigne, Calendar.getInstance(), nuit);
  }
  
  public Arret getPassage(long idStation, long idLigne, Calendar calendrier, boolean nuit) {
    String requete = "SELECT ARRET.* FROM ARRET, TRAJET, CIRCUIT WHERE " +
        "ARRET.idStation = ? " +
        "AND ARRET.idTrajet = TRAJET._id " +
        "AND TRAJET.idCircuit = CIRCUIT._id " +
        "AND CIRCUIT.idLigne = ? " +
        "AND TRAJET.calendrier & ? > 0 " +
        "AND ARRET.depart > ? " +
        "AND ARRET.sequence < TRAJET.nbArrets " +
        "ORDER BY depart LIMIT 1";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(calendrier, nuit), Arret.getTimeInMinutes(calendrier, nuit) });
    Arret arret = null;
    if (cursor != null) {
      arret = new Arret(cursor);
      cursor.close();      
    }
    return arret;
  }
  
  public Arret getPassagePrecedent(long idStation, long idLigne, boolean nuit, int sens) {
    
    String requete = "SELECT ARRET.* FROM ARRET, TRAJET, CIRCUIT WHERE " +
        "ARRET.idStation = ? " +
        "AND ARRET.idTrajet = TRAJET._id " +
        "AND TRAJET.idCircuit = CIRCUIT._id " +
        "AND CIRCUIT.idLigne = ? " +
        "AND TRAJET.calendrier & ? > 0 " +
        "AND ARRET.depart <= ? " +
        "AND CIRCUIT.sens = ? " +
        "AND ARRET.sequence < TRAJET.nbArrets " +
        "ORDER BY depart desc LIMIT 1";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(nuit), Arret.getTimeInMinutes(nuit), String.valueOf(sens) });
    Arret arret = null;
    if (cursor != null) {
      arret = new Arret(cursor);
      cursor.close();
    }
    return arret;
  }
  
  public List<Arret> getProchainsPassages(long idStation, long idLigne, boolean nuit, int sens) {

    String requete = "SELECT ARRET.* FROM ARRET, TRAJET, CIRCUIT WHERE " +
        "ARRET.idStation = ? " +
        "AND ARRET.idTrajet = TRAJET._id " +
        "AND TRAJET.idCircuit = CIRCUIT._id " +
        "AND CIRCUIT.idLigne = ? " +
        "AND TRAJET.calendrier & ? > 0 " +
        "AND ARRET.depart > ? " +
        "AND CIRCUIT.sens = ? " +
        "AND ARRET.sequence < TRAJET.nbArrets " +
        "ORDER BY depart LIMIT 2";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(nuit), Arret.getTimeInMinutes(nuit), String.valueOf(sens) });
    List<Arret> stopTimes = new ArrayList<Arret>();
    if (cursor != null) {
      do {
        stopTimes.add(new Arret(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stopTimes;
  }

  public List<Arret> getPassagesDuJour(long idStation, long idLigne, Calendar calendrier, boolean nuit, boolean filtrePasse) {

    String time = filtrePasse ? Arret.getTimeInMinutes(calendrier, nuit) : "0";

    String requete = "SELECT ARRET.* FROM ARRET, TRAJET, CIRCUIT WHERE ARRET.idStation = ? AND ARRET.idTrajet = TRAJET._id AND TRAJET.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = ? AND "
        + "TRAJET.calendrier & ? > 0 and depart >= ? ORDER BY depart";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(calendrier, nuit), time });
    List<Arret> stopTimes = new ArrayList<Arret>();
    if (cursor != null) {
      do {
        stopTimes.add(new Arret(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stopTimes;
  }

  public List<Arret> getArrets(long idTrajet, long idStation) {
    // AND sequence >= (select sequence from arret where idTrajet = ? and idStation = ?) 
    // String.valueOf(idTrajet), String.valueOf(idStation)
    Cursor cursor = database.query("SELECT * FROM ARRET WHERE idTrajet = ? ORDER BY sequence",
        new String[] { String.valueOf(idTrajet) });
    List<Arret> stopTimes = new ArrayList<Arret>();
    if (cursor != null) {
      do {
        stopTimes.add(new Arret(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stopTimes;
  }
  
  public Arret getArret(long idStation, long idCircuit, Calendar calendrier, boolean nuit) {
    String requete = "SELECT ARRET.* FROM ARRET, TRAJET WHERE ARRET.idStation = ? AND ARRET.idTrajet = TRAJET._id AND TRAJET.idCircuit = ? AND "
        + "TRAJET.calendrier & ? > 0 AND ARRET.depart > ? ORDER BY depart LIMIT 1";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idStation), String.valueOf(idCircuit), JoursUtils.getCalendrier(calendrier, nuit), Arret.getTimeInMinutes(calendrier, nuit) });
    Arret arret = null;
    if (cursor != null) {
      arret = new Arret(cursor);
      cursor.close();      
    }
    return arret;
  }
  
  public Arret getArret(long idTrajet, long idStation) {
    Cursor cursor = database.query("SELECT ARRET.* FROM ARRET, TRAJET WHERE ARRET.idStation = ? AND ARRET.idTrajet = ? LIMIT 1",
        new String[] { String.valueOf(idStation), String.valueOf(idTrajet) });
    
    Arret arret = null;
    if (cursor != null) {
      arret = new Arret(cursor);
      cursor.close();
    }
    return arret;
  }

  public Ligne getLigne(long idLigne) {
    Cursor cursor = database.query("select * from LIGNE where _id = ? LIMIT 1", new String[] { String.valueOf(idLigne) });

    Ligne line = null;
    if (cursor != null) {
      line = new Ligne(cursor);
      cursor.close();
    }
    return line;
  }
  
  public Ligne getLigne(String codeLigne) {
    Cursor cursor = database.query("select * from LIGNE where code = ? LIMIT 1", new String[] { codeLigne });

    Ligne line = null;
    if (cursor != null) {
      line = new Ligne(cursor);
      cursor.close();
    }
    return line;
  }

  public long getTrajetSuivant(long idLigne, long idStation, Calendar calendrier, boolean nuit) {
    String requete = "SELECT ARRET.idTrajet FROM ARRET, TRAJET, CIRCUIT WHERE ARRET.idStation = ? AND ARRET.idTrajet = TRAJET._id AND TRAJET.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = ? AND TRAJET.calendrier & ? > 0 AND depart > ? order by depart LIMIT 1";

    Cursor cursor = database.query(requete,
        new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(calendrier, nuit), Arret.getTimeInMinutes(calendrier, nuit) });
    
    long idTrajet = 0;
    if (cursor != null) {
      idTrajet = cursor.getLong(0);
      cursor.close();
    }
    return idTrajet;
  }

  public long getTrajetPrecedent(long idLigne, long idStation, Calendar calendrier, boolean nuit) {
    String requete = "SELECT ARRET.idTrajet FROM ARRET, TRAJET, CIRCUIT WHERE ARRET.idStation = ? AND ARRET.idTrajet = TRAJET._id AND TRAJET.idCircuit = CIRCUIT._id AND CIRCUIT.idLigne = ? AND TRAJET.calendrier & ? > 0 AND depart < ? order by depart DESC LIMIT 1";

    Cursor cursor = database.query(requete,
        new String[] { String.valueOf(idStation), String.valueOf(idLigne), JoursUtils.getCalendrier(calendrier, nuit), Arret.getTimeInMinutes(calendrier, nuit) });
    
    long idTrajet = 0;
    if (cursor != null) {
      idTrajet = cursor.getLong(0);
      cursor.close();
    }
    return idTrajet;
  }
  
  public String getIdStationLaPlusProche(double latitude, double longitude) {
    String request = "select _id from STATION order by (latitude - ?) * (latitude - ?)+ (longitude - ?)* (longitude - ?) limit 1";
    
    Cursor cursor = database.query(request, new String[] { String.valueOf(latitude), String.valueOf(latitude), String.valueOf(longitude), String.valueOf(longitude) });
    
    String idStation = null;
    if(cursor != null) {
      idStation = cursor.getString(0);
      cursor.close();
    }
    return idStation;
  }
  
  public List<Station> getStationsLesPlusProches(double latitude, double longitude) {
    String request = "select s.* from station s where " +
      "   abs(s.latitude - ?) < 0.005 and " +
      "   abs(s.longitude - ?) < 0.005";
    Cursor cursor = database.query(request, new String[] {String.valueOf(latitude), String.valueOf(longitude) });

    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }
  
  public List<Station> getStationsProches(StationGroup stationGroup) {
    String request = "select s2.* from station s1, station s2 where " +
      "   s1.nom = ? and " +
      "   s1.commune = ? and " +
      "   abs(s1.latitude - s2.latitude) < 0.003 and " +
      "   abs(s1.longitude - s2.longitude) < 0.003";
    Cursor cursor = database.query(request, new String[] {stationGroup.nom, stationGroup.commune });

    List<Station> stations = new ArrayList<Station>();
    if (cursor != null) {
      do {
        stations.add(new Station(cursor));
      } while (cursor.moveToNext());
      cursor.close();
    }
    return stations;
  }
  
  public boolean isCircuitValid(Circuit circuit, Station stationDepart, Station stationArrivee) {
    String requete = "select * from station s1, station s2, station_circuit sc1, station_circuit sc2 where sc1.idCircuit = ? and sc2.idCircuit = sc1.idCircuit and sc1.idStation = s1._id and sc2.idStation = s2._id and s1._id = ? and s2._id = ? and sc1.sequence < sc2.sequence limit 1"; 
    Cursor cursor = database.query(requete, new String[] { String.valueOf(circuit.id), String.valueOf(stationDepart.id), String.valueOf(stationArrivee.id) });
    if(cursor != null) {
      cursor.close();
      return true;
    }
    return false;
  }
  
  public long[] getCorrespondance(Circuit circuit1, Station station1, Circuit circuit2, Station station2) {
    String requeteCircuits = "select " +
    "station1._id station1, " +
    "station2._id station2 " +
    "from " +
    "(select s.*, (sc2.sequence - sc1.sequence) nbArrets from station s, station_circuit sc1, station_circuit sc2 where " +
    "   sc1.idCircuit = ? and sc1.idCircuit = sc2.idCircuit and " +
    "   sc1.idStation = ? and " +
    "   sc1.sequence < sc2.sequence and " +
    "  s._id = sc2.idStation " +
    ") station1, " +
    "(select s.*, (sc1.sequence - sc2.sequence) nbArrets from station s, station_circuit sc1, station_circuit sc2 where " +
    "   sc1.idCircuit = ? and sc1.idCircuit = sc2.idCircuit and " +
    "   sc1.idStation = ? and " +
    "   sc1.sequence > sc2.sequence and " +
    "  s._id = sc2.idStation " +
    ") station2 " +
    "where " +
    "abs(station1.latitude - station2.latitude) < 0.0015 and " +
    "abs(station1.longitude - station2.longitude) < 0.0015 " +
    "order by station1.nbArrets + station2.nbArrets " +
    "limit 1";
    
    Cursor cursor = database.query(requeteCircuits, new String[] { String.valueOf(circuit1.id), String.valueOf(station1.id), String.valueOf(circuit2.id), String.valueOf(station2.id) });
    
    if(cursor != null) {
      long[] correspondance = new long[2];
      correspondance[0] = cursor.getLong(0);
      correspondance[1] = cursor.getLong(1);
      cursor.close();

      return correspondance;
    }
    return null;
  }
  
  public Long getCorrespondance(Circuit circuit, Station station, double latitude, double longitude, boolean retour) {
    String requeteCircuits = "select " +
    "station1._id " +
    "from " +
    "(select s.*, (sc2.sequence - sc1.sequence) nbArrets from station s, station_circuit sc1, station_circuit sc2 where " +
    "   sc1.idCircuit = ? and sc1.idCircuit = sc2.idCircuit and " +
    "   sc1.idStation = ? and " +
    (retour ? "   sc1.sequence > sc2.sequence and " : "   sc1.sequence < sc2.sequence and ") +
    "  s._id = sc2.idStation " +
    ") station1 " +
    "where " +
    "abs(station1.latitude - ?) < 0.0015 and " +
    "abs(station1.longitude - ?) < 0.0015 " +
    "order by station1.nbArrets " +
    "limit 1";
    
    Cursor cursor = database.query(requeteCircuits, new String[] { String.valueOf(circuit.id), String.valueOf(station.id), String.valueOf(latitude), String.valueOf(longitude) });
    
    if(cursor != null) {
      long idStation = cursor.getLong(0);
      cursor.close();

      return idStation;
    }
    return null;
  }
  
  public Circuit getCircuit(Ligne ligne, Station station) {
    String request = "select CIRCUIT.* from STATION_CIRCUIT, CIRCUIT where STATION_CIRCUIT.idCircuit = CIRCUIT._id AND STATION_CIRCUIT.idStation = ? AND CIRCUIT.idLigne = ?";
    Cursor cursor = database.query(request, new String[] { String.valueOf(station.id), String.valueOf(ligne.id) });

    Circuit circuit = null;
    if (cursor != null) {
      circuit = new Circuit(cursor);
      cursor.close();
    }
    return circuit;
  }

  public Circuit getCircuitByIdTrajet(long idTrajet) {
    String requete = "SELECT CIRCUIT.* FROM TRAJET, CIRCUIT WHERE TRAJET._id = ? AND TRAJET.idCircuit = CIRCUIT._id LIMIT 1";

    Cursor cursor = database.query(requete, new String[] { String.valueOf(idTrajet) });
    Circuit circuit = null;
    if (cursor != null) {
      circuit = new Circuit(cursor);
      cursor.close();
    }
    return circuit;
  }
}




Java Source Code List

fr.gotorennes.AbstractActivity.java
fr.gotorennes.AbstractConfigurationActivity.java
fr.gotorennes.AbstractMapActivity.java
fr.gotorennes.AbstractWidgetProvider.java
fr.gotorennes.BikeStationActivity.java
fr.gotorennes.BikeStationWidgetConfigurationActivity.java
fr.gotorennes.BikeStationWidgetProvider.java
fr.gotorennes.BikeStationsActivity.java
fr.gotorennes.BikeWidgetProvider.java
fr.gotorennes.BusArretActivity.java
fr.gotorennes.BusCircuitsActivity.java
fr.gotorennes.BusCircuitsWidgetConfigurationActivity.java
fr.gotorennes.BusLignesActivity.java
fr.gotorennes.BusLignesWidgetConfigurationActivity.java
fr.gotorennes.BusStationActivity.java
fr.gotorennes.BusStationGroupsActivity.java
fr.gotorennes.BusStationsActivity.java
fr.gotorennes.BusStationsMapActivity.java
fr.gotorennes.BusStopWidgetConfigurationActivity.java
fr.gotorennes.BusStopWidgetProvider.java
fr.gotorennes.BusTripActivity.java
fr.gotorennes.CadenasActivity.java
fr.gotorennes.ClockActivity.java
fr.gotorennes.CreditsActivity.java
fr.gotorennes.FavorisActivity.java
fr.gotorennes.GoToRennesActivity.java
fr.gotorennes.GoToRennes.java
fr.gotorennes.ItineraireActivity.java
fr.gotorennes.ItineraireBusDetailActivity.java
fr.gotorennes.ItineraireBusResultActivity.java
fr.gotorennes.ItineraireMapActivity.java
fr.gotorennes.ItineraireVeloResultActivity.java
fr.gotorennes.MetroStationActivity.java
fr.gotorennes.MetroStationsActivity.java
fr.gotorennes.PointDeVenteActivity.java
fr.gotorennes.PointDeVentesActivity.java
fr.gotorennes.ProximiteActivity.java
fr.gotorennes.ProximiteResultActivity.java
fr.gotorennes.ProximityMapActivity.java
fr.gotorennes.RelayParkActivity.java
fr.gotorennes.RelayParkWidgetConfigurationActivity.java
fr.gotorennes.RelayParkWidgetProvider.java
fr.gotorennes.RelayParksActivity.java
fr.gotorennes.domain.Arret.java
fr.gotorennes.domain.BikeStation.java
fr.gotorennes.domain.Circuit.java
fr.gotorennes.domain.EquipementStatus.java
fr.gotorennes.domain.Equipement.java
fr.gotorennes.domain.Ligne.java
fr.gotorennes.domain.LineAlert.java
fr.gotorennes.domain.Localisable.java
fr.gotorennes.domain.MetroStation.java
fr.gotorennes.domain.NextDeparture.java
fr.gotorennes.domain.NextMetroDeparture.java
fr.gotorennes.domain.PointDeVenteCommune.java
fr.gotorennes.domain.PointDeVenteQuartier.java
fr.gotorennes.domain.PointDeVente.java
fr.gotorennes.domain.RelayPark.java
fr.gotorennes.domain.SensCirculation.java
fr.gotorennes.domain.StationGroup.java
fr.gotorennes.domain.Station.java
fr.gotorennes.persistence.BusDao.java
fr.gotorennes.persistence.BusDatabase.java
fr.gotorennes.remote.BikeStationService.java
fr.gotorennes.remote.BusStationService.java
fr.gotorennes.remote.CommuneService.java
fr.gotorennes.remote.EquipementService.java
fr.gotorennes.remote.EquipementStatusService.java
fr.gotorennes.remote.LineAlertService.java
fr.gotorennes.remote.MetroStationService.java
fr.gotorennes.remote.MetroStationStatusService.java
fr.gotorennes.remote.NextDepartureService.java
fr.gotorennes.remote.NextMetroDepartureService.java
fr.gotorennes.remote.PointDeVenteService.java
fr.gotorennes.remote.QuartierService.java
fr.gotorennes.remote.RelayParkService.java
fr.gotorennes.remote.RemoteService.java
fr.gotorennes.util.AsciiUtils.java
fr.gotorennes.util.BackgroundTask.java
fr.gotorennes.util.JoursUtils.java
fr.gotorennes.util.LocationUtils.java
fr.gotorennes.util.UpdateUtils.java
fr.gotorennes.view.ExpandableView.java
fr.gotorennes.view.FilterBar.java
fr.gotorennes.view.FilterSortBar.java
fr.gotorennes.view.LockPopupWindow.java
fr.gotorennes.view.MapDrawable.java
fr.gotorennes.view.TitleBar.java