Package modele.chauffeur

Examples of modele.chauffeur.Localite

69
70
71
72
73
74
75
76
77
78
79
          try {
            smt = connection.prepareStatement(GET_LOCALITE_BY_ID);
            smt.setInt(1, id);
            res = smt.executeQuery();
            if (res.next()) {
              result[0] = new Localite(res.getInt(1));
              //result[0].setCp(Integer.parseInt(res.getString(1)));
              result[0].setCommune(res.getString(2));

              Ville ville = new Ville(res.getInt(3));
              ville.setNomVille(res.getString(4));
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
          ResultSet res = null;
          try {
            smt = connection.prepareStatement(GET_ALL_LOCALITE);
            res = smt.executeQuery();
            while (res.next()) {
              Localite localite = new Localite(res.getInt(1));
              //localite.setCp(Integer.parseInt(res.getString(2)));
              localite.setCommune(res.getString(2));

              Ville ville = new Ville(res.getInt(3));
              ville.setNomVille(res.getString(4));/////////////////////
              localite.setVille(ville);

              listeLocalite.add(localite);
            }
          } finally {
            try {
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
          try {
            smt = connection.createStatement();
            res = smt.executeQuery("select cp, commune, tville.idVille,tville.nomVille from tlocalite, tville where tlocalite.idVille = tville.idVille ");//and idLoca = LAST_INSERT_ID()");

            if (res.next()) {
              result[0] = new Localite(res.getInt(1));
              result[0].setCommune(res.getString(2));

              Ville ville = new Ville(res.getInt(3));
              ville.setNomVille(res.getString(4));
              result[0].setVille(ville);
View Full Code Here
187
188
189
190
191
192
193
194
195
196
        dlgDialog = new LocaliteEditionFenetre();
        dlgDialog.affiche();

        if (dlgDialog.OK_Button()) {
          Localite localite = dlgDialog.renvoiLocalite();
          getLocaliteDao().insert(localite);
        }
     
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
      public int getRowCount() {
        return localite.size();
      }

      public Object getValueAt(int rowIndex, int columnIndex) {
        Localite localiteAtRow = localite.get(rowIndex);
        switch (columnIndex) {
        case 0:         
          return localiteAtRow.getCp();
        case 1:
          return localiteAtRow.getCommune();
        case 2:
          return localiteAtRow.getVille().getNomVille();

        default:
          throw new IllegalStateException("Le nombre de colonne ne peut pas d�passer " + NOMBRE_COLONNE + ". index demand� " + columnIndex);
        }
      }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
              result[0].setNom(res.getString(2));
              result[0].setPrenom(res.getString(3));
              result[0].setRue(res.getString(4));
              result[0].setNumRue(res.getString(5));
             
              Localite localite = new Localite(res.getInt(6));
              localite.setCp(res.getInt(8));
              result[0].setLocalite(localite);
             
             
              localite.setCommune(res.getString(9));
              result[0].setLocalite(localite);

              Ville ville = new Ville(res.getInt(10));
              ville.setNomVille(res.getString(11));
              result[0].setVille(ville);
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
              chauffeur.setNom(res.getString(2));
              chauffeur.setPrenom(res.getString(3));
              chauffeur.setRue(res.getString(4));
              chauffeur.setNumRue(res.getString(5));
             
              Localite localite = new Localite(res.getInt(6));
              //localite.setCp(res.getInt(7));
              chauffeur.setLocalite(localite);
             
              localite.setCommune(res.getString(7));
              chauffeur.setLocalite(localite);
             
              Ville ville = new Ville(res.getInt(8));
              ville.setNomVille(res.getString(9));
              chauffeur.setVille(ville);
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
              result[0].setNom(res.getString(2));
              result[0].setPrenom(res.getString(3));
              result[0].setRue(res.getString(4));
              result[0].setNumRue(res.getString(5));
             
              Localite localite = new Localite(res.getInt(6));
              //localite.setCp(res.getInt(7));
              chauffeur.setLocalite(localite);
             
              localite.setCommune(res.getString(7));
             
              Ville ville = new Ville(res.getInt(8));
              ville.setNomVille(res.getString(9));
              chauffeur.setVille(ville);
             
View Full Code Here
TOP

Related Classes of modele.chauffeur.Localite

  • dao.implementation.mysql.chauffeur.MySqlChauffeurDao
  • dao.implementation.mysql.chauffeur.MySqlLocaliteDao
  • gui.commun.localite.LocaliteListeFenetre
  • gui.commun.localite.LocaliteListeFenetre$LocaliteTableModel
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.