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 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
| import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Date;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
public class NewJFrame1 extends javax.swing.JFrame {
private Connection cnx;
private Statement St;
private ResultSet Rs;
private DefaultTableModel dt;
private String Référence;
private String Adresse;
private String Service;
private int exercice;
private Date Date_depot;
private String Déposant;
private String état;
private Date date_mouvement;
private String Intervenant;
private String Mouvement;
private JTextField jtf ;
public NewJFrame1() {
initComponents();
}
private void formWindowOpened(java.awt.event.WindowEvent evt) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cnx = DriverManager.getConnection("jdbc:odbc:Data_archives","sa","sa");
St = cnx.createStatement();
Rs=St.executeQuery("select lib_service from service ");
servi.removeAllItems();
while(Rs.next()){
servi.addItem(Rs.getString("lib_service"));
}
Rs = St.executeQuery("select code_salle from salle");
salle.removeAllItems();
while(Rs.next()){
salle.addItem(Rs.getString("code_salle"));
}
dt = new DefaultTableModel();
dt.addColumn("Référence");
dt.addColumn("Adresse");
dt.addColumn("Service");
dt.addColumn("exercice");
dt.addColumn("Date dépot ");
dt.addColumn("Déposant");
dt.addColumn("état");
dt.addColumn("Date mouvement");
dt.addColumn("Intervenant");
dt.addColumn("Mouvement");
tInv.setModel(dt);
afficher();
}catch(Exception e){
JOptionPane.showMessageDialog(null,"erreur requete ");
}
}
private void afficher(){
try {
NewJFrame2 n = new NewJFrame2();
jtf.setText(n.getJtf());
Rs = St.executeQuery("Select * from Inventaire,service,autorisation_user where Inventaire.Service=service.lib_service and autorisation_user.code_utilisateur=service.code_utilsateur and service.code_utilsateur ="+jtf+" and autorisation_user.code_salle = "+ salle.getSelectedItem()+" and autorisation_user.autorisation= 1 " );
while(Rs.next()){
Référence = Rs.getString("Reference");
Adresse = Rs.getString("Adresse");
Service = Rs.getString("Service");
exercice = Rs.getInt("exercice");
Date_depot = Rs.getDate("Date depot");
Déposant=Rs.getString("Deposant");
état=Rs.getString("etat");
date_mouvement= Rs.getDate("date Mvt");
Intervenant=Rs.getString("Intervenant");
Mouvement =Rs.getString("Mouvement");
Object ar [] = new Object[] {Adresse,Service,exercice,Date_depot,Déposant,état,date_mouvement,Intervenant,Mouvement };
dt.addRow(ar);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"erreur affichage" );
}
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
new NewJFrame1().setVisible(true);
}
});
}
private javax.swing.JButton jButton1;
private javax.swing.JInternalFrame jInternalFrame1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField reference;
private javax.swing.JComboBox salle;
private javax.swing.JComboBox servi;
private javax.swing.JTable tInv; |
Partager