public class Country { private String code; private String name; public Country(final String code, final String name) { this.code = code; this.name = name; } public String getCode() { return code; } public void setCode(final String code) { this.code = code; } public String getName() { return name; } public void setName(final String name) { this.name = name; } @Override public String toString() { return name; } }
import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.DefaultComboBoxModel; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JOptionPane; public class Test extends JFrame { public Test() { setSize(300, 300); setLocationRelativeTo(null); setDefaultCloseOperation(EXIT_ON_CLOSE); getContentPane().setLayout(new FlowLayout()); /* ajout de quelques pays au model du combo */ DefaultComboBoxModel<Country> model = new DefaultComboBoxModel<Country>(); model.addElement(new Country("FR", "France")); model.addElement(new Country("US", "USA")); /* création du combo avec son model */ final JComboBox<Country> countries = new JComboBox<Country>(model); /* action sur sélection d'un item */ countries.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { Country c = (Country)countries.getSelectedItem(); String str ="<html>Country name: " + c.getName() + "<br>Country code: " + c.getCode() + "</html>"; JOptionPane.showMessageDialog(Test.this, str); } }); add(countries); } public static void main(String[] args) { new Test().setVisible(true); } }
Rs2 =St3.executeQuery("SELECT Code_Type, Libelle_Type FROM Type " );
Cbx_Typ.addItem("");
while(Rs2.next()){
Cbx_Typ.addItem(Rs2.getString(1).trim());
Cbx_Typ.addItem(Rs2.getString(2).trim());
}
St2.executeUpdate("INSERT INTO Bande(Num_Bande ,Date_Enreg ,Nbre_sujet ,Type )VALUES ('"+NumBd.getText().trim()+"',GETDATE(),'"+TxtSujet.getText().trim()+"','"+Cbx_Typ.getSelectedItem()+"' ) ");