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
|
public class Rapport_electricien extends javax.swing.JFrame {
Statement stmt;
Statement stmtListeRapportelec;
BaseDD maConnexion2 ;
ResultSet rs;
public Rapport_electricien() {
initComponents();
maConnexion2 = new BaseDD(new Parameter().HOST_DB, new Parameter().USERNAME_DB, new Parameter().PASSWORD_DB, new Parameter().IPHOST, new Parameter().PORT);
table();
}
public void table() {
String t[] = {"id","date","nom","poste","rapport"};
rs = maConnexion2.querySelect(t, "rapport_elec");
tbl_rapport_elec.setModel(new ResultSetTableModel(rs));
}
void actualiser() {
txt_date.setText("");
txt_nom.setText("");
txt_poste.setText("");
txt_rapport.setText("");
}
tbl_rapport_elec.addPropertyChangeListener("model",new PropertyChangeListener() {
@Override
public void propertyChange(PropertyChangeEvent evt) {
TableColumnModel columnmodel = tbl_rapport_elec.getColumnModel();
for(Enumeration<TableColumn> columns = columnmodel.getColumns(); columns.hasMoreElements(); ) {
TableColumn column = columns.nextElement();
column.setMinWidth(50);
column.setMaxWidth(50);
}
}
} ) ;
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tbl_rapport_elec = new javax.swing.JTable();
jPanel1 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
txt_date = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
txt_nom = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
txt_poste = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
bt_ajouter = new javax.swing.JButton();
modifjButton3 = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
txt_rapport = new javax.swing.JTextArea();
jPanel2 = new javax.swing.JPanel();
jLabel9 = new javax.swing.JLabel();
comrech = new javax.swing.JComboBox<>();
txtrech = new javax.swing.JTextField();
recherchejButton4 = new javax.swing.JButton();
actualiserjButton4 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
jLabel1.setFont(new java.awt.Font("Tahoma", 3, 36)); // NOI18N
jLabel1.setForeground(new java.awt.Color(51, 153, 255));
jLabel1.setText("Rapport electricien");
tbl_rapport_elec.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null},
{null, null, null, null, null},
{null, null, null, null, null},
{null, null, null, null, null},
{null, null, null, null, null}
},
new String [] {
"id", "Date", "Nom", "Poste", "Rapport"
}
) {
Class[] types = new Class [] {
java.lang.Object.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
tbl_rapport_elec.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF);
tbl_rapport_elec.setColumnSelectionAllowed(true);
tbl_rapport_elec.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
jScrollPane1.setViewportView(tbl_rapport_elec);
tbl_rapport_elec.getColumnModel().getSelectionModel().setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);
if (tbl_rapport_elec.getColumnModel().getColumnCount() > 0) {
tbl_rapport_elec.getColumnModel().getColumn(0).setPreferredWidth(50);
tbl_rapport_elec.getColumnModel().getColumn(1).setPreferredWidth(100);
tbl_rapport_elec.getColumnModel().getColumn(2).setPreferredWidth(100);
tbl_rapport_elec.getColumnModel().getColumn(3).setPreferredWidth(100);
tbl_rapport_elec.getColumnModel().getColumn(4).setPreferredWidth(500);
}
tbl_rapport_elec.repaint(); |