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();
}
} |