1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| Statement requete = con.createStatement();
ResultSet resultat = requete.executeQuery("select distinct t.sDisplayName from DeviceType t, Device d where t.nDeviceTypeID=d.nDeviceTypeID and (d.nBestStateID=6 or d.nBestStateID=5 or d.nBestStateID=10);");
ResultSet affichage= requete.executeQuery("select * from Device where sDisplayName =???????")
principal.outstr("<center><h1>Liste des equipements actifs :</h1></center>",false);
principal.outstr("<center>Veuillez choisir une categorie d'equipement : <FORM><SELECT name=\"nom\" size=\"1\">",false);
while(resultat.next()) {
principal.outstr("<OPTION>"+resultat.getString(1),false);
}
principal.outstr("</SELECT> </FORM>",true);
principal.outstr("</center>",true); |
Partager