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 112 113 114 115 116 117
| package resto;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
public class JPStat extends JPanel {
private Fenetre fenetre;
private JButton jbRetour;
private JPanel jpanBoutonBas, jpanStat;
private String Nom, Plat;
private JTable jtStat;
private Connection connec;
private String requete1="SELECT * FROM employe WHERE nom";
private String requete2="SELECT * FROM plat WHERE nom";
private JComboBox jcbStat;
public JPStat(Fenetre fensave) {
this.setLayout(new BorderLayout());
fenetre=fensave;
String[] contenu={"Sélectionner ici","Voir utilisateur","Voir repas"};
MonGestionnaireAction ga = new MonGestionnaireAction();
MonGestionnaire2 g= new MonGestionnaire2();
jcbStat= new JComboBox(contenu);
jpanStat = new JPanel();
jpanBoutonBas = new JPanel();
jcbStat.addItemListener(ga);
jcbStat.addItemListener(ga);
jpanStat.add(jcbStat);
jbRetour = new JButton ("Retour");
jbRetour.addActionListener(g);
jpanBoutonBas.add(jbRetour);
this.add(jpanStat,BorderLayout.NORTH);
this.add(jpanBoutonBas,BorderLayout.SOUTH);
}
private class MonGestionnaire2 implements ActionListener
{
public void actionPerformed(ActionEvent f){
if (f.getSource()==jbRetour){
fenetre.getContain().removeAll() ;
PanelAdmin pA= new PanelAdmin(fenetre);
fenetre.getContain().add(pA,BorderLayout.CENTER);
fenetre.getContain().repaint();
fenetre.setVisible(true);
fenetre.setFalseJMIStatistic();
}
}
}
private class MonGestionnaireAction implements ItemListener
{
public void itemStateChanged(ItemEvent s){
fenetre.getConnec();
switch(jcbStat.getSelectedIndex())
{ case 0:if(s.getStateChange()==ItemEvent.SELECTED)
JOptionPane.showMessageDialog(null,"A vous de choisir");
break;
case 1: if(s.getStateChange()==ItemEvent.SELECTED){
try{
jtStat= new JTable(AccesGen.creerTableModel(connec, requete1));
}
catch(SQLException sq){
JOptionPane.showMessageDialog(null,"Erreur","Erreur",JOptionPane.ERROR_MESSAGE);
}
removeAll();
jtStat.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
JScrollPane defilant = new JScrollPane(jtStat);
jpanStat.add(jtStat);
jpanStat.add(defilant);
repaint();
}
break;
case 2 : if(s.getStateChange()==ItemEvent.SELECTED){
try{
jtStat= new JTable(AccesGen.creerTableModel(connec, requete2));
}
catch(SQLException sq){
JOptionPane.showMessageDialog(null,"Erreur","Erreur",JOptionPane.ERROR_MESSAGE);
}
removeAll();
jtStat.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
JScrollPane defilant = new JScrollPane(jtStat);
jpanStat.add(defilant);
jpanStat.add(jtStat);
repaint();
}
break;
}
}
}} |
Partager