1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
   |     public void AllDataBilan(){
        vData.clear();
        String QuerySql=RequeteSelectionCB;
        ResultSet rs;
        PreparedStatement ps;
        try{
            ps=mConnexion.prepareStatement(QuerySql);
            rs=ps.executeQuery();
            ResultSetMetaData metaData = rs.getMetaData();
            int count = metaData.getColumnCount();
            Hashtable ligne=new Hashtable(count);
            while(rs.next()){
            ligne.put("ID",mDBaccess.TransferStringNull(rs.getString("id_structure_bilan")));
            ligne.put("LIBELLE",mDBaccess.TransferStringNull(rs.getString("lib_structure_bilan_fr")));
            ligne.put("ID_PERE",mDBaccess.TransferStringNull(rs.getString("pere_id_structure_bilan"))); 
           // int index=Integer.parseInt(ligne.get("ID").toString().trim());
            mComboBoxRubrique.addItem(ligne.get("ID"));
            }
            mComboBoxRubrique.addItem(" ");
          }
        catch (NullPointerException e) {
            System.out.println(e.toString() + "  " + e.getMessage());
            e.printStackTrace();
        } catch (SQLException e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    } |