import java.sql.*;
import java.io.*;
public class Q41{
  public static void main(String [] args) throws Exception{
    String url = "jdbc:oracle:thin:@charlemagne:1521:infodb";
    Connection cnt = DriverManager.getConnection(url, "gerard296u", "motdepasse");
    PreparedStatement req = cnt.prepareStatement("select villeagence, nomagence, telagence, codecateg, libellecateg, prixjour, numvehic from agence natural join categorie natural join vehicule");
    ResultSet rs = req.executeQuery();

    String ville = "";
    String nom = "";
    String categ = "";
    int line = 0;

    while(rs.next()){
      String villeag = rs.getString(1);
      if (!villeag.equals(ville)){
        ville = villeag;
        System.out.println("\n" + ville);
      }
      String nomag = rs.getString(2);
      if (!nomag.equals(nom)){
        nom = nomag;
        Long teltel = rs.getLong(3);
        System.out.println("\n  " + " " + nom +" "+ teltel);
      }
      String categag = rs.getString(4);
      if (!nomag.equals(categ)){
        categ = categag;
        System.out.println("\n      " + "" +categ +" "+ rs.getString(5) +" "+ rs.getDouble(6));
      }
      System.out.println("\n          " + rs.getString(7));
    }
  }
}

-------------------------------------------------------------------------------------------------------

import java.sql.*;
import java.io.*;
import java.util.*;
public class Q42{
  public static void main(String[] args) throws Exception{
    Scanner sc = new Scanner(System.in);
    Scanner sc2 = new Scanner(System.in);
    Scanner sc3 = new Scanner(System.in);
    Scanner sc4 = new Scanner(System.in);
    Scanner sc5 = new Scanner(System.in);
    Scanner sc6 = new Scanner(System.in);
    Scanner sc7 = new Scanner(System.in);
    Scanner sc8 = new Scanner(System.in);
    Scanner sc9 = new Scanner(System.in);
    Scanner sc10 = new Scanner(System.in);
    Scanner sc11 = new Scanner(System.in);
    Scanner sc12 = new Scanner(System.in);
    Scanner sc13 = new Scanner(System.in);
    Scanner sc14 = new Scanner(System.in);
    Scanner sc15 = new Scanner(System.in);

    String url = "jdbc:oracle:thin:@charlemagne:1521:infodb";
    Connection cnt = DriverManager.getConnection(url, "gerard296u", "S481Q117L450");
    boolean fin = false;



    while(!fin){
      CallableStatement req = null;
      PreparedStatement req2 = null;
      ResultSet rs = null;
      System.out.println("Agence EasyCar\n");
      System.out.println("1 - Etablir un devis\n");
      System.out.println("2 - Disponibilité d'un véhicule\n");
      System.out.println("3 - Ajouter une réservation\n");
      System.out.println("4 - Supprimer une réservation\n");
      System.out.println("5 - Afficher une réseravation\n");
      System.out.println("6 - Quitter\n");
      System.out.println("  Choix : ");
      int choix = sc.nextInt();
      switch (choix){
        case 1 :
          System.out.println("\nRentrez la catégorie du véhicule : ");
          String categ = sc2.nextLine();
          System.out.println("\nRentrez la date de début : ");
          String dateDeb = sc3.nextLine();
          System.out.println("\nRentrez la date de fin : ");
          String dateFin = sc4.nextLine();
          req = cnt.prepareCall("{call creer_devis('"+categ+"',to_date('"+dateDeb+"'),('"+dateFin+"'))}");
          req.execute();
          System.out.println(req.getInt(1));
          break;
        case 2 :
          System.out.println("\nRentrez la catégorie du véhicule : ");
          String categ2 = sc5.nextLine();
          System.out.println("\nRentrez la date de début : ");
          String dateDeb2 = sc6.nextLine();
          System.out.println("\nRentrez la date de fin : ");
          String dateFin2 = sc7.nextLine();
          req = cnt.prepareCall("{call vehicule_dispo('" + categ2 + "',to_date('" + dateDeb2 + "'),to_date('" + dateFin2 +"'))}");
          req.execute();
          System.out.println(req.getString(1));
          break;
        case 3 :
          System.out.println("\nRentrez la date de la réservation : ");
          String dateRes = sc8.nextLine();
          System.out.println("\nRentrez la date de début : ");
          String dateDeb3 = sc9.nextLine();
          System.out.println("\nRentrez la date de fin : ");
          String dateFin3 = sc10.nextLine();
          System.out.println("\nRentrez le numéro du client : ");
          String numCli = sc11.nextLine();
          System.out.println("\nRentrez le numéro de l'agence : ");
          String numAg = sc12.nextLine();
          System.out.println("\nRentrez le numéro du véhicule : ");
          String numVehi = sc13.nextLine();
          req = cnt.prepareCall("{call ajout_reservation(to_date('"+dateRes+"'),to_date('"+dateDeb3+"'),('"+dateFin3+"'),'"+numCli+"','"+numAg+"','"+numVehi+"',?)}");
          req.registerOutParameter(1,Types.NVARCHAR);
          req.execute();
          System.out.println(req.getString(1));
          break;
        case 4 :
          System.out.println("\nRentrez le numéro de la réservation à supprimer : ");
          String numRes = sc14.nextLine();
          req = cnt.prepareCall("{call remove_reserv('"+numRes+"',?)}");
          req.registerOutParameter(1,Types.NVARCHAR);
          req.execute();
          System.out.println(req.getString(1));
          break;
        case 5 :
          System.out.println("\nRentrez le numéro de la réservation à afficher : ");
          String numres = sc15.nextLine();
          req2 = cnt.prepareStatement("select reservation.numClient, nom, prenom, dateDep, dateRetour,creer_devis(libelleCateg, dateDep, dateRetour) libelleCateg, regle from reservation inner join client on reservation.numClient = client.numClient inner join vehicule on reservation.numvehic = vehicule.numvehic inner join categorie on vehicule.codeCateg = categorie.codeCateg inner join facture on reservation.numReserv = facture.numReserv where reservation.numreserv = '" + numres+"'");
          rs=req2.executeQuery();
          while (rs.next()){
            System.out.println("\nNuméro : "+rs.getString(1) +"\nNom : "+ rs.getString(2) +"\nPrénom : "+ rs.getString(3) + "\nDate départ"+ rs.getDate(4) +"\nDate retour"+ rs.getDate(5) +"\nLibelle : " + rs.getString(6) + "\nRéglé : " + rs.getString(7));
          }
          break;
        case 6 :
          fin = true;
          break;
        default :
          System.out.println("Veuillez faire un choix correct.");
          break;
      }
    }
  }
}