Discussion :

[chahrazedd]

Bonjour,

Je souhaite afficher les données existantes de ma base, dans la console.

J'utilse Hibernate + Spring pour ça mais sur le console n'affiche pas les données que je veux.

Voilà comment ça s'affiche

.........
Hibernate: select affectatio0_.Id_engin as Id8_1_9_, affectatio0_.Id_affectation as Id1_9_, affectatio0_.Id_affectation as Id1_3_8_, affectatio0_.Id_chf as Id7_3_8_, affectatio0_.consommation_suplement as consomma2_3_8_, affectatio0_.Date_debut as Date3_3_8_, affectatio0_.Date_fin as Date4_3_8_, affectatio0_.Id_engin as Id8_3_8_, affectatio0_.id_miss_deb as id9_3_8_, affectatio0_.id_miss_fin as id10_3_8_, affectatio0_.kilometrage as kilometr5_3_8_, affectatio0_.qte_carb_rest as qte6_3_8_, affectatio0_.Id_soc as Id11_3_8_, chauffeur1_.Id_chf as Id1_0_0_, chauffeur1_.Adresse_chf as Adresse2_0_0_, chauffeur1_.Cin_chf as Cin3_0_0_, chauffeur1_.Date_embauche_chf as Date4_0_0_, chauffeur1_.Date_licensement_chf as Date5_0_0_, chauffeur1_.Date_nais_chf as Date6_0_0_, chauffeur1_.Etat_chf as Etat7_0_0_, chauffeur1_.Nom_chf as Nom8_0_0_, chauffeur1_.Photo_chf as Photo9_0_0_, chauffeur1_.Prenom_chf as Prenom10_0_0_, chauffeur1_.Id_soc as Id12_0_0_, chauffeur1_.Tel_chf as Tel11_0_0_, societe2_.Id_soc as Id1_2_1_, societe2_.Adr_soc as Adr2_2_1_, societe2_.Date_inscrit_soc as Date3_2_1_, societe2_.Date_res_soc as Date4_2_1_, societe2_.Etat_soc as Etat5_2_1_, societe2_.Fax_soc as Fax6_2_1_, societe2_.Mail_soc as Mail7_2_1_, societe2_.Raison_social as Raison8_2_1_, societe2_.Tel_soc as Tel9_2_1_, mission3_.id_miss as id1_4_2_, mission3_.id_affectation as id7_4_2_, mission3_.date_miss as date2_4_2_, mission3_.description_miss as descript3_4_2_, mission3_.etat as etat4_2_, mission3_.heurs_debut_miss as heurs5_4_2_, mission3_.heurs_fin_miss as heurs6_4_2_, mission3_.id_poi as id8_4_2_, mission3_.id_soc as id9_4_2_, affectatio4_.Id_affectation as Id1_3_3_, affectatio4_.Id_chf as Id7_3_3_, affectatio4_.consommation_suplement as consomma2_3_3_, affectatio4_.Date_debut as Date3_3_3_, affectatio4_.Date_fin as Date4_3_3_, affectatio4_.Id_engin as Id8_3_3_, affectatio4_.id_miss_deb as id9_3_3_, affectatio4_.id_miss_fin as id10_3_3_, affectatio4_.kilometrage as kilometr5_3_3_, affectatio4_.qte_carb_rest as qte6_3_3_, affectatio4_.Id_soc as Id11_3_3_, poi5_.id_poi as id1_5_4_, poi5_.adress_poi as adress2_5_4_, poi5_.date_entre_poi as date3_5_4_, poi5_.laltitude_poi as laltitude4_5_4_, poi5_.longitude_poi as longitude5_5_4_, poi5_.id_soc as id8_5_4_, poi5_.type_poi as type6_5_4_, poi5_.ville_poi as ville7_5_4_, societe6_.Id_soc as Id1_2_5_, societe6_.Adr_soc as Adr2_2_5_, societe6_.Date_inscrit_soc as Date3_2_5_, societe6_.Date_res_soc as Date4_2_5_, societe6_.Etat_soc as Etat5_2_5_, societe6_.Fax_soc as Fax6_2_5_, societe6_.Mail_soc as Mail7_2_5_, societe6_.Raison_social as Raison8_2_5_, societe6_.Tel_soc as Tel9_2_5_, mission7_.id_miss as id1_4_6_, mission7_.id_affectation as id7_4_6_, mission7_.date_miss as date2_4_6_, mission7_.description_miss as descript3_4_6_, mission7_.etat as etat4_6_, mission7_.heurs_debut_miss as heurs5_4_6_, mission7_.heurs_fin_miss as heurs6_4_6_, mission7_.id_poi as id8_4_6_, mission7_.id_soc as id9_4_6_, societe8_.Id_soc as Id1_2_7_, societe8_.Adr_soc as Adr2_2_7_, societe8_.Date_inscrit_soc as Date3_2_7_, societe8_.Date_res_soc as Date4_2_7_, societe8_.Etat_soc as Etat5_2_7_, societe8_.Fax_soc as Fax6_2_7_, societe8_.Mail_soc as Mail7_2_7_, societe8_.Raison_social as Raison8_2_7_, societe8_.Tel_soc as Tel9_2_7_ from base_local.affectation affectatio0_ left outer join base_local.chauffeur chauffeur1_ on affectatio0_.Id_chf=chauffeur1_.Id_chf left outer join base_local.societe societe2_ on chauffeur1_.Id_soc=societe2_.Id_soc left outer join base_local.mission mission3_ on affectatio0_.id_miss_deb=mission3_.id_miss left outer join base_local.affectation affectatio4_ on mission3_.id_affectation=affectatio4_.Id_affectation left outer join base_local.poi poi5_ on mission3_.id_poi=poi5_.id_poi left outer join base_local.societe societe6_ on mission3_.id_soc=societe6_.Id_soc left outer join base_local.mission mission7_ on affectatio0_.id_miss_fin=mission7_.id_miss left outer join base_local.societe societe8_ on affectatio0_.Id_soc=societe8_.Id_soc where affectatio0_.Id_engin=?
6
**********liste des chauffeurs**************
[org.wisetech.geoloc.model.Chauffeur@142c778, org.wisetech.geoloc.model.Chauffeur@95215b, org.wisetech.geoloc.model.Chauffeur@c10de0, org.wisetech.geoloc.model.Chauffeur@75f5b7, org.wisetech.geoloc.model.Chauffeur@56fc16, org.wisetech.geoloc.model.Chauffeur@c017e9]
23755 [main] INFO org.hibernate.impl.SessionFactoryImpl - closing

Je ne sais pas pourquoi mais il m'affiche ceci

org.wisetech.geoloc.model.Chauffeur@142c778

mais ce ne sont pas les données que je veux.

Quelqu'un saurait-il m'expliquer comment faire ?

Merci d'avance pour votre aide.

[Laurent.B]

Bonjour,

C'est normal, il t'affiche les adresses mémoire des objets. En Java c'est comme ça.

Intéresse-toi à la classe ToStringBuilder de la lib commons-lang de la fondation Apache, ou redéfinis toi-même les méthodes toString de tes classes.