Changeset 70 for ether_eccad/trunk/ECCAD_INTERFACE/WEB-INF/src/org/medias/eccad/persistance/jdbc/CodeDAOjdbc.java

Timestamp:

04/26/10 19:12:49 (14 years ago)

Author:

cbipsl

Message:

maj eccad V3.2

File:

• ether_eccad/trunk/ECCAD_INTERFACE/WEB-INF/src/org/medias/eccad/persistance/jdbc/CodeDAOjdbc.java (modified) (1 diff)

ether_eccad/trunk/ECCAD_INTERFACE/WEB-INF/src/org/medias/eccad/persistance/jdbc/CodeDAOjdbc.java

@@ -21 +21 @@
                 try {
                         requete = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
-                        sql = " select legend_code" 
-                                + " from grille join codification using (id_codification)"
-                                + " join code using (id_codification) where id_grille = " + id_grille + " order by id_code;";
-                        
+//                      sql = " select num_code,legend_code" 
+//                              + " from grille join codification using (id_codification)"
+//                              + " join code using (id_codification) where id_grille = " + id_grille + " order by num_code;";
+                        sql = " select number_code,legend_code" 
+                        + " from grille left join code on id_grille = num_code"
+                        + " where id_grille = " + id_grille + " order by number_code;";
+
                         ResultSet resultat = requete.executeQuery(sql);
-                        
+                        String legend = "";
                         while (resultat.next()) {
-                                code.add(resultat.getString("legend_code").toLowerCase());
+                                legend = resultat.getString("legend_code");
+                                code.add(resultat.getString("number_code")+"-"+legend);
+                        }
+                        if (code.size() == 1) {
+                                code.set(0, "1-"+legend);
                         }
                 }