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 MFPIM; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; import javax.swing.JOptionPane; import javax.swing.JTable; import net.proteanit.sql.DbUtils; import org.apache.commons.lang3.time.DateUtils; /** * * @author Melvin */ public class NotificationFrame extends javax.swing.JFrame { Connection conn = null; ResultSet rs = null; PreparedStatement pst = null; /** * Creates new form NotificationFrame */ public NotificationFrame() { initComponents(); initEmpNotifTable(); initDlExpNotifTable(); } public int rowCount() { return probEmpNotifTable.getRowCount() + dlExpNotifTable.getRowCount(); } //source code from http://www.roseindia.net/java/example/java/swing/ChangeColumnName.shtml public void ChangeName(JTable table, int col_index, String col_name) { table.getColumnModel().getColumn(col_index).setHeaderValue(col_name); } private void initEmpNotifTable() { try { DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); Date date = DateUtils.addMonths(new Date(), -5); String newDate = dateFormat.format(date); String sql = "select empNo,fName,lName from Employee where dateHired <= '" + newDate + "' and empStatus='Probationary'"; conn = DBConnect.connect(); pst = conn.prepareStatement(sql); rs = pst.executeQuery(); probEmpNotifTable.setModel(DbUtils.resultSetToTableModel(rs)); ChangeName(probEmpNotifTable, 0, "Employee ID No."); ChangeName(probEmpNotifTable, 1, "First Name"); ChangeName(probEmpNotifTable, 2, "Surname"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "initEmpNotifTable:" + e); } finally { if (rs != null) { try { rs.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } if (pst != null) { try { pst.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } if (conn != null) { try { conn.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } } } private void initDlExpNotifTable() { try { DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); String currentDate = dateFormat.format(new Date()); String sql = "select empNo,fName,lName, dlExpDate from Employee where dlExpDate <= '" + currentDate + "' and empStatus!='Terminated'"; conn = DBConnect.connect(); pst = conn.prepareStatement(sql); rs = pst.executeQuery(); dlExpNotifTable.setModel(DbUtils.resultSetToTableModel(rs)); ChangeName(dlExpNotifTable, 0, "Employee ID No."); ChangeName(dlExpNotifTable, 1, "First Name"); ChangeName(dlExpNotifTable, 2, "Surname"); ChangeName(dlExpNotifTable, 3, "Expiration Date"); } catch (Exception e) { JOptionPane.showMessageDialog(null, "initEmpNotifTable:" + e); } finally { if (rs != null) { try { rs.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } if (pst != null) { try { pst.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } if (conn != null) { try { conn.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } } } /** * 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() { jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jTabbedPane1 = new javax.swing.JTabbedPane(); jPanel2 = new javax.swing.JPanel(); jScrollPane3 = new javax.swing.JScrollPane(); probEmpNotifTable = new javax.swing.JTable() { public boolean isCellEditable(int rowIndex, int colIndex) { return false; //Disallow the editing of any cell } }; jPanel3 = new javax.swing.JPanel(); jScrollPane4 = new javax.swing.JScrollPane(); dlExpNotifTable = new javax.swing.JTable() { public boolean isCellEditable(int rowIndex, int colIndex) { return false; //Disallow the editing of any cell } }; setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setResizable(false); jLabel1.setBackground(new java.awt.Color(255, 255, 255)); jLabel1.setFont(new java.awt.Font("Andalus", 1, 12)); // NOI18N jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel1.setText("NOTIFICATIONS"); jLabel1.setIconTextGap(1); probEmpNotifTable.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "Employee ID No.", "First Name", "Surname" }) { boolean[] canEdit = new boolean[] { false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); jScrollPane3.setViewportView(probEmpNotifTable); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout .setHorizontalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 475, Short.MAX_VALUE)); jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 508, Short.MAX_VALUE)); jTabbedPane1.addTab("Probationary Employment Issues", jPanel2); dlExpNotifTable.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "Employee ID No.", "First Name", "Surname", "License Expiry Date" }) { boolean[] canEdit = new boolean[] { false, false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); jScrollPane4.setViewportView(dlExpNotifTable); javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3); jPanel3.setLayout(jPanel3Layout); jPanel3Layout .setHorizontalGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane4, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 475, Short.MAX_VALUE)); jPanel3Layout.setVerticalGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane4, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 508, Short.MAX_VALUE)); jTabbedPane1.addTab("Driver's License Issues", jPanel3); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap() .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTabbedPane1)) .addContainerGap())); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup().addContainerGap() .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 36, Short.MAX_VALUE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 536, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap())); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent( jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)); pack(); setLocationRelativeTo(null); }// </editor-fold>//GEN-END:initComponents /** * @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(NotificationFrame.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(NotificationFrame.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(NotificationFrame.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(NotificationFrame.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 NotificationFrame().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JTable dlExpNotifTable; private javax.swing.JLabel jLabel1; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JScrollPane jScrollPane3; private javax.swing.JScrollPane jScrollPane4; private javax.swing.JTabbedPane jTabbedPane1; private javax.swing.JTable probEmpNotifTable; // End of variables declaration//GEN-END:variables }