package cocoland;
import Connection.DB;
import Connection.MessageBox;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
/**
*
* @author Amila
*/
public class personalInfo extends javax.swing.JFrame {
/** Creates new form personalInfo */
public personalInfo() {
initComponents();
jCheckBox1.setEnabled(false);
jCheckBox2.setEnabled(false);
jCheckBox3.setEnabled(false);
jCheckBox4.setEnabled(false);
jCheckBox5.setEnabled(false);
jCheckBox6.setEnabled(false);
jCheckBox7.setEnabled(false);
jCheckBox8.setEnabled(false);
jCheckBox9.setEnabled(false);
jCheckBox10.setEnabled(false);
jCheckBox11.setEnabled(false);
jCheckBox12.setEnabled(false);
jCheckBox13.setEnabled(false);
}
@SuppressWarnings("unchecked")
private void initComponents() {
buttonGroup1 = new javax.swing.ButtonGroup();
jPanel1 = new javax.swing.JPanel();
jPanel2 = new javax.swing.JPanel();
jCheckBox1 = new javax.swing.JCheckBox();
jCheckBox2 = new javax.swing.JCheckBox();
jCheckBox3 = new javax.swing.JCheckBox();
jCheckBox4 = new javax.swing.JCheckBox();
jPanel3 = new javax.swing.JPanel();
jCheckBox5 = new javax.swing.JCheckBox();
jCheckBox6 = new javax.swing.JCheckBox();
jCheckBox7 = new javax.swing.JCheckBox();
jCheckBox8 = new javax.swing.JCheckBox();
jCheckBox9 = new javax.swing.JCheckBox();
jPanel4 = new javax.swing.JPanel();
jCheckBox10 = new javax.swing.JCheckBox();
jCheckBox11 = new javax.swing.JCheckBox();
jCheckBox12 = new javax.swing.JCheckBox();
jCheckBox13 = new javax.swing.JCheckBox();
jButton1 = new javax.swing.JButton();
jRadioButton1 = new javax.swing.JRadioButton();
jRadioButton2 = new javax.swing.JRadioButton();
jRadioButton3 = new javax.swing.JRadioButton();
jButton2 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jPanel1.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED));
jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createTitledBorder(""), "Type of Worker"));
jCheckBox1.setText("Permanent");
jCheckBox2.setText("Casual");
jCheckBox3.setText("Hamilton");
jCheckBox4.setText("Tasma");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jCheckBox1)
.addComponent(jCheckBox2)
.addComponent(jCheckBox3)
.addComponent(jCheckBox4))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jCheckBox1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jCheckBox2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jCheckBox3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jCheckBox4)
.addContainerGap(40, Short.MAX_VALUE))
);
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createTitledBorder(""), "Job Category"));
jCheckBox5.setText("Helper");
jCheckBox6.setText("Operator");
jCheckBox7.setText("Staff");
jCheckBox8.setText("Executive");
jCheckBox9.setText("Manager");
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jCheckBox5)
.addComponent(jCheckBox6)
.addComponent(jCheckBox7)
.addComponent(jCheckBox8)
.addComponent(jCheckBox9))
.addContainerGap(26, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(jCheckBox5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox6)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox7)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox8)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox9)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder("Department"));
jCheckBox10.setText("Stores");
jCheckBox11.setText("Production");
jCheckBox12.setText("Quality");
jCheckBox13.setText("Administrator");
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jCheckBox11)
.addComponent(jCheckBox10)
.addComponent(jCheckBox12)
.addComponent(jCheckBox13))
.addContainerGap(19, Short.MAX_VALUE))
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jCheckBox11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox10)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox12)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jCheckBox13)
.addContainerGap(32, Short.MAX_VALUE))
);
jButton1.setText("View Details...");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
buttonGroup1.add(jRadioButton1);
jRadioButton1.setText("Type of Worker");
jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton1ActionPerformed(evt);
}
});
buttonGroup1.add(jRadioButton2);
jRadioButton2.setText("Job Category");
jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton2ActionPerformed(evt);
}
});
buttonGroup1.add(jRadioButton3);
jRadioButton3.setText("Department");
jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton3ActionPerformed(evt);
}
});
jButton2.setText("Close");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
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)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jRadioButton1)
.addGap(26, 26, 26)
.addComponent(jRadioButton2)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jRadioButton3)
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(71, 71, 71))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addGap(46, 46, 46)
.addComponent(jButton1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton2))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jRadioButton2)
.addComponent(jRadioButton1)
.addComponent(jRadioButton3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, 166, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addContainerGap(33, Short.MAX_VALUE))
);
getContentPane().add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 40, 580, 240));
jLabel1.setFont(new java.awt.Font("High Tower Text", 0, 24)); // NOI18N
jLabel1.setText("View Employee Information");
getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(150, 10, 310, -1));
pack();
}// </editor-fold>
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
new viewDetails().setVisible(true);
if (jCheckBox1.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where Type= 'Permanent'order by EMPNo";
setTableValue(sql);
}
if (jCheckBox2.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where Type= 'Casual' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox3.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where Type= 'Hamilton' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox4.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where Type= 'Tasma' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox5.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where job= 'Helper' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox6.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where job= 'Operator' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox7.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where job= 'Staff' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox8.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where job= 'Executive' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox9.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where job= 'Manager' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox10.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where depart= 'Stores' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox11.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where depart= 'Production' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox12.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where depart= 'Quality' order by EMPNo";
setTableValue(sql);
}
if (jCheckBox11.isSelected()) {
String sql = "select EMPNo, Name, Address, NIC from empinfo Where depart= 'Administrator' order by EMPNo";
setTableValue(sql);
}
JOptionPane.showMessageDialog(null,"If you want to print this data click get Report !","Information", JOptionPane.INFORMATION_MESSAGE);
}
private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
clear();
jCheckBox1.setEnabled(true);
jCheckBox2.setEnabled(true);
jCheckBox3.setEnabled(true);
jCheckBox4.setEnabled(true);
jCheckBox5.setEnabled(false);
jCheckBox6.setEnabled(false);
jCheckBox7.setEnabled(false);
jCheckBox8.setEnabled(false);
jCheckBox9.setEnabled(false);
jCheckBox10.setEnabled(false);
jCheckBox11.setEnabled(false);
jCheckBox12.setEnabled(false);
jCheckBox13.setEnabled(false);
}
private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
clear();
jCheckBox5.setEnabled(true);
jCheckBox6.setEnabled(true);
jCheckBox7.setEnabled(true);
jCheckBox8.setEnabled(true);
jCheckBox9.setEnabled(true);
jCheckBox10.setEnabled(false);
jCheckBox11.setEnabled(false);
jCheckBox12.setEnabled(false);
jCheckBox13.setEnabled(false);
jCheckBox1.setEnabled(false);
jCheckBox2.setEnabled(false);
jCheckBox3.setEnabled(false);
jCheckBox4.setEnabled(false);
}
private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {
jCheckBox1.setEnabled(false);
jCheckBox2.setEnabled(false);
jCheckBox3.setEnabled(false);
jCheckBox4.setEnabled(false);
jCheckBox5.setEnabled(false);
jCheckBox6.setEnabled(false);
jCheckBox7.setEnabled(false);
jCheckBox8.setEnabled(false);
jCheckBox9.setEnabled(false);
jCheckBox10.setEnabled(true);
jCheckBox11.setEnabled(true);
jCheckBox12.setEnabled(true);
jCheckBox13.setEnabled(true);
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose(); // TODO add your handling code here:
}
public void clear() {
jCheckBox1.setSelected(false);
jCheckBox2.setSelected(false);
jCheckBox3.setSelected(false);
jCheckBox4.setSelected(false);
jCheckBox5.setSelected(false);
jCheckBox6.setSelected(false);
jCheckBox7.setSelected(false);
jCheckBox8.setSelected(false);
jCheckBox9.setSelected(false);
jCheckBox10.setSelected(false);
jCheckBox11.setSelected(false);
jCheckBox12.setSelected(false);
jCheckBox13.setSelected(false);
}
public void setTableValue(String sql) {
DefaultTableModel df = (DefaultTableModel) viewDetails.jTable1.getModel();
try {
Connection c = DB.myCon();
Statement s = c.createStatement();
ResultSet r = s.executeQuery(sql);
while (r.next()) {
Vector v = new Vector();
v.add(r.getString("EMPNo"));
v.add(r.getString("Name"));
v.add(r.getString("NIC"));
v.add(r.getString("Address"));
df.addRow(v);
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new personalInfo().setVisible(true);
}
});
}
// Variables declaration
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
public static javax.swing.JCheckBox jCheckBox1;
public static javax.swing.JCheckBox jCheckBox10;
public static javax.swing.JCheckBox jCheckBox11;
public static javax.swing.JCheckBox jCheckBox12;
public static javax.swing.JCheckBox jCheckBox13;
public static javax.swing.JCheckBox jCheckBox2;
public static javax.swing.JCheckBox jCheckBox3;
public static javax.swing.JCheckBox jCheckBox4;
public static javax.swing.JCheckBox jCheckBox5;
public static javax.swing.JCheckBox jCheckBox6;
public static javax.swing.JCheckBox jCheckBox7;
public static javax.swing.JCheckBox jCheckBox8;
public static javax.swing.JCheckBox jCheckBox9;
private javax.swing.JLabel jLabel1;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JRadioButton jRadioButton1;
private javax.swing.JRadioButton jRadioButton2;
private javax.swing.JRadioButton jRadioButton3;
// End of variables declaration
}
