Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package Interface; import projet.*; import Connexion.Connection; import buttonProg.DELETE; import buttonProg.SELECT; import java.awt.Desktop; import java.awt.Toolkit; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.sql.ResultSet; import java.sql.Statement; import java.util.Set; import java.util.TreeMap; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.ImageIcon; import javax.swing.JFileChooser; import javax.swing.JOptionPane; import javax.swing.ListSelectionModel; import javax.swing.RowFilter; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableRowSorter; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * * @author Y.T */ public class interProf extends javax.swing.JFrame { static String temtab[] = new String[21]; DefaultTableModel mod; public void filter(String s) { TableRowSorter<DefaultTableModel> tr = new TableRowSorter<DefaultTableModel>(mod); jTable1.setRowSorter(tr); tr.setRowFilter(RowFilter.regexFilter(s)); } private String getvlue(int x, int y) { return mod.getValueAt(x, y).toString(); } private void writetoxel() { XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet ws = wb.createSheet(); TreeMap<String, Object[]> data = new TreeMap<>(); data.put("0", new Object[] { mod.getColumnName(0), mod.getColumnName(1), mod.getColumnName(2), mod.getColumnName(3), mod.getColumnName(4), mod.getColumnName(5), mod.getColumnName(6), mod.getColumnName(7), mod.getColumnName(8), mod.getColumnName(9), mod.getColumnName(10), mod.getColumnName(11), mod.getColumnName(12), mod.getColumnName(13), mod.getColumnName(14), mod.getColumnName(15), mod.getColumnName(16), mod.getColumnName(17), mod.getColumnName(18), mod.getColumnName(19), mod.getColumnName(20) }); int nb = mod.getRowCount(); int s = 0; for (int i = 1; i <= nb; i++) { data.put(Integer.toString(i), new Object[] { getvlue(s, 0), getvlue(s, 1), getvlue(s, 2), getvlue(s, 3), getvlue(s, 4), getvlue(s, 5), getvlue(s, 6), getvlue(s, 7), getvlue(s, 8), getvlue(s, 9), getvlue(s, 10), getvlue(s, 11), getvlue(s, 12), getvlue(s, 13), getvlue(s, 14), getvlue(s, 15), getvlue(s, 16), getvlue(s, 17), getvlue(s, 18), getvlue(s, 19), getvlue(s, 20) }); s++; } Set<String> ids = data.keySet(); XSSFRow row; int rowID = 0; for (String key : ids) { row = ws.createRow(rowID++); Object[] values = data.get(key); int cellID = 0; for (Object o : values) { Cell cell = row.createCell(cellID++); cell.setCellValue(o.toString()); } } try { FileOutputStream fs; fs = new FileOutputStream(new File("bdd_prof.xlsx")); wb.write(fs); fs.close(); JOptionPane.showConfirmDialog(null, "Votre Base De Donnee Est Bien Expoter", "Valider", JOptionPane.CLOSED_OPTION); Desktop desktop = Desktop.getDesktop(); if (desktop.isSupported(Desktop.Action.OPEN)) { desktop.open(new File("bdd_prof.xlsx")); } else { System.out.println("Open is not supported"); } } catch (FileNotFoundException ex) { System.out.println("eruer fichier"); } catch (IOException ex) { System.out.println("eruer fichier"); } } public interProf() { initComponents(); try { String prof = "prof"; Infopersonnels s = new Infopersonnels(); InfoPersonnes l = new InfoPersonnes(); mod = (DefaultTableModel) jTable1.getModel(); for (int i = 0; i < s.sex.length; i++) { if (prof.equals(s.type[i])) mod.addRow(new Object[] { l.getNom()[i], l.getPrenom()[i], s.nomar[i], s.prenomar[i], l.getCin()[i], s.sex[i], s.lieudenaissance[i], s.datedenaissance[i], s.situationfamiliale[i], s.SEPCIALITE[i], s.daterecrutement[i], s.Date_affectation[i], l.getGrade()[i], l.getSom()[i], l.getcadre()[i], s.echelon[i], s.situationAdministrative[i], s.universsitee[i], s.departement[i], s.diplome[i], s.specialitee[i] }); } } catch (Exception ex) { System.out.print("verifier les donnees ..."); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); recherche = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jButton5 = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setBackground(new java.awt.Color(0, 0, 0)); setMinimumSize(new java.awt.Dimension(1100, 560)); setUndecorated(true); addWindowListener(new java.awt.event.WindowAdapter() { public void windowOpened(java.awt.event.WindowEvent evt) { formWindowOpened(evt); } }); getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); jButton1.setBackground(new java.awt.Color(51, 51, 51)); jButton1.setFont(new java.awt.Font("Microsoft JhengHei Light", 0, 14)); // NOI18N jButton1.setForeground(new java.awt.Color(255, 255, 255)); jButton1.setText("Ajouter"); jButton1.setMaximumSize(new java.awt.Dimension(87, 25)); jButton1.setMinimumSize(new java.awt.Dimension(87, 25)); jButton1.setPreferredSize(new java.awt.Dimension(87, 25)); jButton1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton1MouseClicked(evt); } }); getContentPane().add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 510, 90, 30)); jButton2.setBackground(new java.awt.Color(51, 51, 51)); jButton2.setFont(new java.awt.Font("Microsoft JhengHei Light", 0, 14)); // NOI18N jButton2.setForeground(new java.awt.Color(255, 255, 255)); jButton2.setText("Supprimer"); jButton2.setMaximumSize(new java.awt.Dimension(87, 25)); jButton2.setMinimumSize(new java.awt.Dimension(87, 25)); jButton2.setPreferredSize(new java.awt.Dimension(87, 25)); jButton2.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton2MouseClicked(evt); } }); getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(1060, 510, 110, 30)); jButton3.setBackground(new java.awt.Color(51, 51, 51)); jButton3.setFont(new java.awt.Font("Microsoft JhengHei Light", 0, 14)); // NOI18N jButton3.setForeground(new java.awt.Color(255, 255, 255)); jButton3.setText("Modifier"); jButton3.setMaximumSize(new java.awt.Dimension(87, 25)); jButton3.setMinimumSize(new java.awt.Dimension(87, 25)); jButton3.setPreferredSize(new java.awt.Dimension(87, 25)); jButton3.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton3MouseClicked(evt); } }); getContentPane().add(jButton3, new org.netbeans.lib.awtextra.AbsoluteConstraints(1180, 510, 110, 30)); jButton4.setBackground(new java.awt.Color(51, 51, 51)); jButton4.setFont(new java.awt.Font("Microsoft JhengHei Light", 0, 14)); // NOI18N jButton4.setForeground(new java.awt.Color(255, 255, 255)); jButton4.setText(" ATTESTATIONS"); jButton4.setMaximumSize(new java.awt.Dimension(87, 25)); jButton4.setMinimumSize(new java.awt.Dimension(87, 25)); jButton4.setPreferredSize(new java.awt.Dimension(87, 25)); jButton4.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton4MouseClicked(evt); } }); getContentPane().add(jButton4, new org.netbeans.lib.awtextra.AbsoluteConstraints(410, 130, 230, 50)); jTable1.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N jTable1.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "NOM", "PRENOM", " ", " ", "CIN", "SEX", "LIEU DE NAISSANCE", "DATE DE NAISSANCE", "SITUATION FAMILIALE", "SEPCIALITE", "DATE RECRUTEMENT", "DATE AFFECTATION", "GRADE", "SOM", "CADRE", "ECHELON", "situation administrative", "universit-tablissement-diplmant", "departement", "Diplome", "Specialite" })); jScrollPane1.setViewportView(jTable1); getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 190, 1300, 300)); recherche.setFont(new java.awt.Font("Microsoft JhengHei Light", 1, 14)); // NOI18N recherche.setForeground(new java.awt.Color(153, 153, 153)); recherche.setHorizontalAlignment(javax.swing.JTextField.LEFT); recherche.setText(" Recherche ..."); recherche.setBorder(null); recherche.addFocusListener(new java.awt.event.FocusAdapter() { public void focusGained(java.awt.event.FocusEvent evt) { rechercheFocusGained(evt); } public void focusLost(java.awt.event.FocusEvent evt) { rechercheFocusLost(evt); } }); recherche.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { rechercheActionPerformed(evt); } }); recherche.addKeyListener(new java.awt.event.KeyAdapter() { public void keyReleased(java.awt.event.KeyEvent evt) { rechercheKeyReleased(evt); } }); getContentPane().add(recherche, new org.netbeans.lib.awtextra.AbsoluteConstraints(70, 140, 260, 30)); jLabel4.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N jLabel4.setForeground(new java.awt.Color(204, 204, 204)); jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/exi1.png"))); // NOI18N jLabel4.setToolTipText("Close"); jLabel4.setVerticalAlignment(javax.swing.SwingConstants.BOTTOM); jLabel4.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR)); jLabel4.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel4MouseClicked(evt); } public void mouseEntered(java.awt.event.MouseEvent evt) { jLabel4MouseEntered(evt); } public void mousePressed(java.awt.event.MouseEvent evt) { jLabel4MousePressed(evt); } }); getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(1290, 10, 20, 20)); jLabel5.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N jLabel5.setForeground(new java.awt.Color(204, 204, 204)); jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.TRAILING); jLabel5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/min.png"))); // NOI18N jLabel5.setToolTipText("Minimize"); jLabel5.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR)); jLabel5.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel5MouseClicked(evt); } }); getContentPane().add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(1260, 12, 20, 20)); jLabel2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/FPO logo1_2.png"))); // NOI18N getContentPane().add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 10, 390, 90)); jLabel3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/search.png"))); // NOI18N getContentPane().add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 140, 30, 30)); jLabel6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/icon(2).png"))); // NOI18N jLabel6.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel6MouseClicked(evt); } public void mousePressed(java.awt.event.MouseEvent evt) { jLabel6MousePressed(evt); } public void mouseReleased(java.awt.event.MouseEvent evt) { jLabel6MouseReleased(evt); } }); getContentPane().add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 510, -1, -1)); jButton5.setBackground(new java.awt.Color(51, 51, 51)); jButton5.setFont(new java.awt.Font("Microsoft JhengHei Light", 0, 14)); // NOI18N jButton5.setForeground(new java.awt.Color(255, 255, 255)); jButton5.setText("Exporter la Base De donnee en Excel"); jButton5.setMaximumSize(new java.awt.Dimension(87, 25)); jButton5.setMinimumSize(new java.awt.Dimension(87, 25)); jButton5.setPreferredSize(new java.awt.Dimension(87, 25)); jButton5.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton5MouseClicked(evt); } }); getContentPane().add(jButton5, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 130, 280, 50)); jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Interface/Login_ajou.png"))); // NOI18N jLabel1.addMouseMotionListener(new java.awt.event.MouseMotionAdapter() { public void mouseDragged(java.awt.event.MouseEvent evt) { jLabel1MouseDragged(evt); } }); jLabel1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jLabel1MouseClicked(evt); } public void mousePressed(java.awt.event.MouseEvent evt) { jLabel1MousePressed(evt); } }); getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1320, 570)); pack(); }// </editor-fold>//GEN-END:initComponents private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened this.setLocation(Toolkit.getDefaultToolkit().getScreenSize().width / 2 - 660, Toolkit.getDefaultToolkit().getScreenSize().height / 2 - 300); }//GEN-LAST:event_formWindowOpened private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton1MouseClicked Ajouter_prof aj = new Ajouter_prof(); aj.setVisible(true); this.dispose(); }//GEN-LAST:event_jButton1MouseClicked private void jButton2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton2MouseClicked try { Connection connect; for (int i = 0; i < 21; i++) { temtab[i] = mod.getValueAt(jTable1.getSelectedRow(), i).toString(); } connect = new Connection(); Statement stmt = connect.con.createStatement(); String sql4 = "DELETE FROM `infopersonnes` WHERE NOM='" + temtab[0] + "'and PRENOM='" + temtab[1] + "'and GRADE='" + temtab[12] + "'and SOM='" + temtab[13] + "'and CADRE='" + temtab[14] + "'"; String sql3 = "DELETE FROM `infopersonnels` WHERE LIEU_DE_NAISSANCE='" + temtab[6] + "'and DATE_NAISSANCE='" + temtab[7] + "'and SITUATION_FAMILIALE='" + temtab[8] + "'and SEPCIALITE='" + temtab[9] + "'and DATE_RECRUTMENT='" + temtab[10] + "' and ECHELON='" + temtab[15] + "' and SITUATION_ADMINISTRATIVE='" + temtab[16] + "'"; stmt.executeUpdate(sql4); stmt.executeUpdate(sql3); System.out.println("c fais"); this.dispose(); interProf i = new interProf(); i.setVisible(true); } catch (Exception ex) { JOptionPane.showConfirmDialog(null, "veuillez selectionner un enseignant pour continuer", "Erreur", JOptionPane.CLOSED_OPTION); } }//GEN-LAST:event_jButton2MouseClicked private void jButton3MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton3MouseClicked try { for (int i = 0; i < 21; i++) { temtab[i] = mod.getValueAt(jTable1.getSelectedRow(), i).toString(); } //this.dispose(); Update_prof i = new Update_prof(); this.dispose(); i.setVisible(true); } catch (Exception ex) { JOptionPane.showConfirmDialog(null, "veuillez selectionner un enseignant pour continuer", "Erreur", JOptionPane.CLOSED_OPTION); } }//GEN-LAST:event_jButton3MouseClicked private void jButton4MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton4MouseClicked try { for (int i = 0; i < 21; i++) { temtab[i] = mod.getValueAt(jTable1.getSelectedRow(), i).toString(); } Les_attestations_prof att = new Les_attestations_prof(); att.setVisible(true); this.dispose(); } catch (Exception ex) { JOptionPane.showConfirmDialog(null, "veuillez selectionner un enseignant pour continuer", "Erreur", JOptionPane.CLOSED_OPTION); } }//GEN-LAST:event_jButton4MouseClicked private void jLabel4MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel4MouseClicked System.exit(0); }//GEN-LAST:event_jLabel4MouseClicked private void jLabel4MouseEntered(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel4MouseEntered }//GEN-LAST:event_jLabel4MouseEntered private void jLabel4MousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel4MousePressed // TODO add your handling code here: }//GEN-LAST:event_jLabel4MousePressed private void jLabel5MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel5MouseClicked this.setState(this.ICONIFIED); }//GEN-LAST:event_jLabel5MouseClicked int x, y; private void rechercheFocusGained(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_rechercheFocusGained if (recherche.getText().equalsIgnoreCase(" Recherche ...")) recherche.setText(null); }//GEN-LAST:event_rechercheFocusGained private void rechercheFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_rechercheFocusLost if (recherche.getText().isEmpty()) recherche.setText(" Recherche ..."); }//GEN-LAST:event_rechercheFocusLost private void rechercheActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_rechercheActionPerformed // TODO add your handling code here: }//GEN-LAST:event_rechercheActionPerformed private void rechercheKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_rechercheKeyReleased String query = recherche.getText().toLowerCase(); filter(query); }//GEN-LAST:event_rechercheKeyReleased private void jLabel6MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel6MouseClicked after_auth at = new after_auth(); at.setVisible(true); this.dispose(); }//GEN-LAST:event_jLabel6MouseClicked private void jLabel6MousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel6MousePressed jLabel6.setIcon(new ImageIcon(getClass().getResource("icon(3).png"))); }//GEN-LAST:event_jLabel6MousePressed private void jLabel6MouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel6MouseReleased jLabel6.setIcon(new ImageIcon(getClass().getResource("icon(2).png"))); }//GEN-LAST:event_jLabel6MouseReleased private void jButton5MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton5MouseClicked writetoxel(); }//GEN-LAST:event_jButton5MouseClicked private void jLabel1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel1MouseClicked // TODO add your handling code here: }//GEN-LAST:event_jLabel1MouseClicked private void jLabel1MousePressed(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel1MousePressed x = evt.getX(); y = evt.getY(); }//GEN-LAST:event_jLabel1MousePressed private void jLabel1MouseDragged(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jLabel1MouseDragged this.setLocation((int) evt.getXOnScreen() - x, (int) evt.getYOnScreen() - y); }//GEN-LAST:event_jLabel1MouseDragged /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(interProf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(interProf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(interProf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(interProf.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new interProf().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; private javax.swing.JTextField recherche; // End of variables declaration//GEN-END:variables }