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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111
|
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Panel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import nombre_app.Connection_bdd;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
public class nbr_interface extends javax.swing.JFrame {
private Panel p=new Panel();
private final JComboBox combo=new JComboBox();
private final JComboBox comboitem=new JComboBox();
private JLabel lb=new JLabel("Nombre : ");
private JLabel lbitem=new JLabel("Nombre selectionner : ");
Connection con=null;
Statement st;
ResultSet rs;
int id;
public nbr_interface() throws ClassNotFoundException, SQLException {
initComponents();
this.setTitle("Nombre");
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setSize(500,300);
p.setBackground(Color.white);
p.setPreferredSize(new Dimension(400,200));
p.setLayout(new BorderLayout());
Panel contenu=new Panel();
p.add(contenu , BorderLayout.NORTH);
combo.setPreferredSize(new Dimension(200,30));
lb.setPreferredSize(new Dimension(200,30));
lbitem.setPreferredSize(new Dimension(200,30));
contenu.add(lbitem);
contenu.add(comboitem , BorderLayout.SOUTH);
comboitem.setPreferredSize(new Dimension(200,30));
contenu.add(lb);
contenu.add(combo);
this.setVisible(true);
this.setContentPane(p);
Connection_bdd conn=new Connection_bdd();
con=conn.getCon();
st=con.createStatement();
String sql="select name_n from nombre1";
rs=st.executeQuery(sql);
while(rs.next()){
combo.addItem(rs.getString(1));
}
combo.addItemListener(new Itemlistener());
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 400, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 300, Short.MAX_VALUE)
);
pack();
}// </editor-fold>
class Itemlistener implements ItemListener {
@Override
public void itemStateChanged(ItemEvent ie) {
comboitem.addItem(combo.getSelectedIndex());
System.out.println(ie.getItem());
}
} |
Partager