package cocoland;
import Connection.DB;
import com.mysql.jdbc.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
/**
*
* @author Amila
*/
public class PersanalInfo extends javax.swing.JFrame {
/** Creates new form PersanalInfo */
public PersanalInfo() {
initComponents();
delete.setEnabled(false);
update.setEnabled(false);
}
@SuppressWarnings("unchecked")
private void initComponents() {
buttonGroup1 = new javax.swing.ButtonGroup();
jTabbedPane1 = new javax.swing.JTabbedPane();
jPanel2 = new javax.swing.JPanel();
jPanel4 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
empNo = new javax.swing.JTextField();
jScrollPane1 = new javax.swing.JScrollPane();
address = new javax.swing.JTextArea();
name = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jPanel5 = new javax.swing.JPanel();
Hamilton = new javax.swing.JRadioButton();
permanent = new javax.swing.JRadioButton();
casual = new javax.swing.JRadioButton();
Tasma = new javax.swing.JRadioButton();
Search = new javax.swing.JButton();
jPanel8 = new javax.swing.JPanel();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
djoin = new javax.swing.JFormattedTextField();
db = new javax.swing.JFormattedTextField();
shitgeneral = new javax.swing.JComboBox();
nic = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jPanel9 = new javax.swing.JPanel();
jLabel15 = new javax.swing.JLabel();
depart = new javax.swing.JComboBox();
jLabel13 = new javax.swing.JLabel();
jLabel14 = new javax.swing.JLabel();
job = new javax.swing.JComboBox();
jLabel5 = new javax.swing.JLabel();
tel = new javax.swing.JTextField();
accBranch = new javax.swing.JTextField();
accNo = new javax.swing.JTextField();
jLabel12 = new javax.swing.JLabel();
jLabel16 = new javax.swing.JLabel();
gender = new javax.swing.JComboBox();
jLabel18 = new javax.swing.JLabel();
jPanel3 = new javax.swing.JPanel();
jPanel6 = new javax.swing.JPanel();
jLabel10 = new javax.swing.JLabel();
jScrollPane2 = new javax.swing.JScrollPane();
qulification = new javax.swing.JTextArea();
jLabel11 = new javax.swing.JLabel();
jScrollPane3 = new javax.swing.JScrollPane();
comments = new javax.swing.JTextArea();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jPanel7 = new javax.swing.JPanel();
cancel = new javax.swing.JButton();
delete = new javax.swing.JButton();
save = new javax.swing.JButton();
update = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Persenal Details");
setResizable(false);
jPanel4.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED));
jLabel2.setText("Employee Number");
empNo.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
empNoMouseClicked(evt);
}
});
empNo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
empNoActionPerformed(evt);
}
});
empNo.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyTyped(java.awt.event.KeyEvent evt) {
empNoKeyTyped(evt);
}
});
address.setColumns(20);
address.setRows(5);
jScrollPane1.setViewportView(address);
name.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nameActionPerformed(evt);
}
});
jLabel4.setText("Address");
jLabel3.setText("Name");
jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Type of worker", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(51, 102, 255))); // NOI18N
buttonGroup1.add(Hamilton);
Hamilton.setText("Hamilton");
buttonGroup1.add(permanent);
permanent.setText("Permanent");
buttonGroup1.add(casual);
casual.setSelected(true);
casual.setText("Casual");
buttonGroup1.add(Tasma);
Tasma.setText("Tasma");
javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
jPanel5.setLayout(jPanel5Layout);
jPanel5Layout.setHorizontalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(casual)
.addComponent(Hamilton)
.addComponent(Tasma))
.addContainerGap(16, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(permanent)
.addContainerGap())
);
jPanel5Layout.setVerticalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(casual)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(permanent)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Hamilton)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Tasma))
);
Search.setText("Search");
Search.setToolTipText("Click to search for get information");
Search.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SearchActionPerformed(evt);
}
});
jLabel6.setText("NIC No");
jLabel7.setText("Date of Birth");
try {
djoin.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("####-##-##")));
} catch (java.text.ParseException ex) {
ex.printStackTrace();
}
djoin.setHorizontalAlignment(javax.swing.JTextField.CENTER);
djoin.setToolTipText("yyyy-MM-dd");
try {
db.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("####-##-##")));
} catch (java.text.ParseException ex) {
ex.printStackTrace();
}
db.setHorizontalAlignment(javax.swing.JTextField.CENTER);
db.setToolTipText("yyyy-MM-dd");
shitgeneral.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Shift", "General" }));
shitgeneral.setToolTipText("");
shitgeneral.setAutoscrolls(true);
nic.setAutoscrolls(false);
jLabel8.setText("Date Of Registration");
jLabel9.setText("Shift or General");
javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
jPanel8.setLayout(jPanel8Layout);
jPanel8Layout.setHorizontalGroup(
jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel8Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel6)
.addComponent(jLabel7)
.addComponent(jLabel8)
.addComponent(jLabel9))
.addGap(4, 4, 4)
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(nic, javax.swing.GroupLayout.DEFAULT_SIZE, 84, Short.MAX_VALUE)
.addComponent(db, javax.swing.GroupLayout.DEFAULT_SIZE, 84, Short.MAX_VALUE)
.addComponent(djoin, javax.swing.GroupLayout.DEFAULT_SIZE, 84, Short.MAX_VALUE)
.addComponent(shitgeneral, 0, 84, Short.MAX_VALUE))
.addContainerGap())
);
jPanel8Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {db, djoin, nic, shitgeneral});
jPanel8Layout.setVerticalGroup(
jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel8Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(nic, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(db, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(djoin, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8))
.addGap(9, 9, 9)
.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(shitgeneral, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9))
.addContainerGap())
);
jLabel15.setText("Branch");
depart.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Production", "Stores", "Administrator", "Quality", "Maintain" }));
depart.setToolTipText("select Department");
jLabel13.setText("Job Category");
jLabel14.setText("Account No");
job.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Helper", "Operator", "Staff", "Executive", "Manager" }));
jLabel5.setText("Gender");
jLabel12.setText("Tel No");
jLabel16.setText("Department");
gender.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Male", "Female" }));
javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
jPanel9.setLayout(jPanel9Layout);
jPanel9Layout.setHorizontalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel13)
.addComponent(jLabel16))
.addGap(6, 6, 6)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(depart, 0, 0, Short.MAX_VALUE)
.addComponent(job, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(gender, 0, 84, Short.MAX_VALUE))
.addGap(20, 20, 20)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel12)
.addComponent(jLabel14)
.addComponent(jLabel15))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(accBranch)
.addComponent(accNo)
.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(61, Short.MAX_VALUE))
);
jPanel9Layout.setVerticalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel9Layout.createSequentialGroup()
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(gender, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(job, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel13))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(depart, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel16)))
.addGroup(jPanel9Layout.createSequentialGroup()
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel12)
.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel14)
.addComponent(accNo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel15)
.addComponent(accBranch, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
);
jLabel18.setText("Basic Salary");
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, false)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel3)
.addComponent(jLabel4))
.addGap(6, 6, 6)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(empNo, javax.swing.GroupLayout.PREFERRED_SIZE, 77, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(Search))
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(name, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 320, Short.MAX_VALUE))))
.addComponent(jPanel9, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(37, 37, 37)
.addComponent(jLabel18)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(18, 18, 18)
.addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, 197, Short.MAX_VALUE)
.addContainerGap())))
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel18)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(19, Short.MAX_VALUE))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(17, 17, 17)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(empNo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(Search))
.addGap(37, 37, 37)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
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()
.addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(50, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Personal Information", jPanel2);
jPanel6.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED));
jLabel10.setText("Qulifications");
qulification.setColumns(20);
qulification.setRows(5);
jScrollPane2.setViewportView(qulification);
jLabel11.setText("Comments");
comments.setColumns(20);
comments.setRows(5);
jScrollPane3.setViewportView(comments);
javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
jPanel6.setLayout(jPanel6Layout);
jPanel6Layout.setHorizontalGroup(
jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel6Layout.createSequentialGroup()
.addGap(69, 69, 69)
.addComponent(jLabel10)
.addGap(30, 30, 30)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 287, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 129, Short.MAX_VALUE)
.addContainerGap())
);
jPanel6Layout.setVerticalGroup(
jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel6Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jScrollPane3, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel11, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 278, Short.MAX_VALUE)
.addComponent(jLabel10, javax.swing.GroupLayout.Alignment.LEADING))
.addContainerGap(72, Short.MAX_VALUE))
);
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()
.addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
jTabbedPane1.addTab("Other Information", jPanel3);
jPanel1.setBackground(new java.awt.Color(173, 195, 219));
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jPanel1.setForeground(new java.awt.Color(124, 161, 219));
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24));
jLabel1.setText("Personal Details");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(272, Short.MAX_VALUE)
.addComponent(jLabel1)
.addGap(255, 255, 255))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(24, Short.MAX_VALUE)
.addComponent(jLabel1)
.addContainerGap())
);
cancel.setText("Cancel");
cancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cancelActionPerformed(evt);
}
});
delete.setText("Delete");
delete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
deleteActionPerformed(evt);
}
});
save.setText("Save");
save.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
saveActionPerformed(evt);
}
});
update.setText("Update");
update.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
updateActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
jPanel7.setLayout(jPanel7Layout);
jPanel7Layout.setHorizontalGroup(
jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel7Layout.createSequentialGroup()
.addContainerGap()
.addComponent(delete)
.addGap(71, 71, 71)
.addComponent(update, javax.swing.GroupLayout.PREFERRED_SIZE, 143, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(save, javax.swing.GroupLayout.PREFERRED_SIZE, 173, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 56, Short.MAX_VALUE)
.addComponent(cancel, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(24, 24, 24))
);
jPanel7Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {save, update});
jPanel7Layout.setVerticalGroup(
jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE, false)
.addComponent(update, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(delete, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(save)
.addComponent(cancel))
);
jPanel7Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {cancel, delete, save, update});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 676, Short.MAX_VALUE)
.addContainerGap())
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addGap(21, 21, 21)
.addComponent(jPanel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 412, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-704)/2, (screenSize.height-559)/2, 704, 559);
}// </editor-fold>
private void saveActionPerformed(java.awt.event.ActionEvent evt) {
try {
Connection c = DB.myCon();
Statement s = c.createStatement();
if(casual.isSelected()){
String sql = "insert into empinfo values ('"+empNo.getText()+"','"+name.getText()+"','"+address.getText()+"','"+gender.getSelectedItem().toString()+"','"+tel.getText()+"','"+nic.getText()+"','"+db.getText()+"','"+djoin.getText()+"','"+shitgeneral.getSelectedItem().toString()+"','"+qulification.getText()+"','"+comments.getText()+"','"+casual.getText()+"','"+job.getSelectedItem().toString()+"','"+depart.getSelectedItem().toString()+"','"+accNo.getText()+"','"+accBranch.getText()+"')";
s.executeUpdate(sql);
}
if(permanent.isSelected()){
String sql = "insert into empinfo values ('"+empNo.getText()+"','"+name.getText()+"','"+address.getText()+"','"+gender.getSelectedItem().toString()+"','"+tel.getText()+"','"+nic.getText()+"','"+db.getText()+"','"+djoin.getText()+"','"+shitgeneral.getSelectedItem().toString()+"','"+qulification.getText()+"','"+comments.getText()+"','"+permanent.getText()+"','"+job.getSelectedItem().toString()+"','"+depart.getSelectedItem().toString()+"','"+accNo.getText()+"','"+accBranch.getText()+"')";
s.executeUpdate(sql);
}
if(Hamilton.isSelected()){
String sql = "insert into empinfo values ('"+empNo.getText()+"','"+name.getText()+"','"+address.getText()+"','"+gender.getSelectedItem().toString()+"','"+tel.getText()+"','"+nic.getText()+"','"+db.getText()+"','"+djoin.getText()+"','"+shitgeneral.getSelectedItem().toString()+"','"+qulification.getText()+"','"+comments.getText()+"','"+Hamilton.getText()+"','"+job.getSelectedItem().toString()+"','"+depart.getSelectedItem().toString()+"','"+accNo.getText()+"','"+accBranch.getText()+"')";
s.executeUpdate(sql);
}
if(Tasma.isSelected()){
String sql = "insert into empinfo values ('"+empNo.getText()+"','"+name.getText()+"','"+address.getText()+"','"+gender.getSelectedItem().toString()+"','"+tel.getText()+"','"+nic.getText()+"','"+db.getText()+"','"+djoin.getText()+"','"+shitgeneral.getSelectedItem().toString()+"','"+qulification.getText()+"','"+comments.getText()+"','"+Tasma.getText()+"','"+job.getSelectedItem().toString()+"','"+depart.getSelectedItem().toString()+"','"+accNo.getText()+"','"+accBranch.getText()+"')";
s.executeUpdate(sql);
}
clear();
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null, "Invalid EPF No or , There is an error in the details of you entered. Please check & correct it.", "Error", JOptionPane.ERROR_MESSAGE);
}
}
public void clear(){
empNo.setText("");
address.setText("");
name.setText("");
tel.setText("");
nic.setText("");
db.setText("");
djoin.setText("");
comments.setText("");
qulification.setText("");
accNo.setText("");
accBranch.setText("");
}
private void updateActionPerformed(java.awt.event.ActionEvent evt) {
try {
Connection c = DB.myCon();
Statement s = c.createStatement();
if (casual.isSelected()){
s.executeUpdate("update empinfo set Name = '"+name.getText()+"', Address = '"+address.getText()+"', gender = '"+gender.getSelectedItem().toString()+"', Tel = '"+tel.getText()+"', NIC = '"+nic.getText()+"', DB = '"+db.getText()+"', Djoin = '"+djoin.getText()+"', ShiftGeneral = '"+shitgeneral.getSelectedItem().toString()+"', Type = '"+casual.getText()+"', Quli = '"+qulification.getText()+"', Comm = '"+comments.getText()+"',job='"+job.getSelectedItem().toString()+"',depart='"+depart.getSelectedItem().toString()+"', accNo='"+accNo.getText()+"', branch='"+accBranch.getText()+"' Where EMPNo = '"+empNo.getText()+"' ");
}
if (permanent.isSelected()){
s.executeUpdate("update empinfo set Name = '"+name.getText()+"', Address = '"+address.getText()+"', gender = '"+gender.getSelectedItem().toString()+"', Tel = '"+tel.getText()+"', NIC = '"+nic.getText()+"', DB = '"+db.getText()+"', Djoin = '"+djoin.getText()+"', ShiftGeneral = '"+shitgeneral.getSelectedItem().toString()+"', Type = '"+permanent.getText()+"', Quli = '"+qulification.getText()+"', Comm = '"+comments.getText()+"',job='"+job.getSelectedItem().toString()+"',depart='"+depart.getSelectedItem().toString()+"', accNo='"+accNo.getText()+"', branch='"+accBranch.getText()+"' Where EMPNo = '"+empNo.getText()+"' ");
}
if (Hamilton.isSelected()){
s.executeUpdate("update empinfo set Name = '"+name.getText()+"', Address = '"+address.getText()+"', gender = '"+gender.getSelectedItem().toString()+"', Tel = '"+tel.getText()+"', NIC = '"+nic.getText()+"', DB = '"+db.getText()+"', Djoin = '"+djoin.getText()+"', ShiftGeneral = '"+shitgeneral.getSelectedItem().toString()+"', Type = '"+Hamilton.getText()+"', Quli = '"+qulification.getText()+"', Comm = '"+comments.getText()+"',job='"+job.getSelectedItem().toString()+"',depart='"+depart.getSelectedItem().toString()+"', accNo='"+accNo.getText()+"', branch='"+accBranch.getText()+"' Where EMPNo = '"+empNo.getText()+"' ");
}
if (Tasma.isSelected()){
s.executeUpdate("update empinfo set Name = '"+name.getText()+"', Address = '"+address.getText()+"', gender = '"+gender.getSelectedItem().toString()+"', Tel = '"+tel.getText()+"', NIC = '"+nic.getText()+"', DB = '"+db.getText()+"', Djoin = '"+djoin.getText()+"', ShiftGeneral = '"+shitgeneral.getSelectedItem().toString()+"', Type = '"+Tasma.getText()+"', Quli = '"+qulification.getText()+"', Comm = '"+comments.getText()+"',job='"+job.getSelectedItem().toString()+"',depart='"+depart.getSelectedItem().toString()+"', accNo='"+accNo.getText()+"', branch='"+accBranch.getText()+"' Where EMPNo = '"+empNo.getText()+"' ");
}
JOptionPane.showMessageDialog(null,"Successfully update.","Done",JOptionPane.INFORMATION_MESSAGE);
} catch (Exception e) {
e.printStackTrace();
}
}
private void deleteActionPerformed(java.awt.event.ActionEvent evt) {
try {
Connection c = DB.myCon();
Statement s = c.createStatement();
s.executeUpdate("delete from empinfo where EMPNo = '"+empNo.getText()+"'");
clear();
} catch (Exception e) {
e.printStackTrace();
}
}
private void cancelActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
}
private void SearchActionPerformed(java.awt.event.ActionEvent evt) {
try {
Connection c = DB.myCon();
Statement s = c.createStatement();
ResultSet rs = s.executeQuery("select * from empinfo where EMPNo = '"+empNo.getText()+"'");
while (rs.next()){
name.setText(rs.getString("Name"));
address.setText(rs.getString("Address"));
gender.setSelectedItem(rs.getString("gender"));
tel.setText(rs.getString("Tel"));
nic.setText(rs.getString("NIC"));
db.setText(rs.getString("DB"));
job.setSelectedItem(rs.getString("job"));
depart.setSelectedItem(rs.getString("depart"));
djoin.setText(rs.getString("Djoin"));
shitgeneral.setSelectedItem(rs.getString("ShiftGeneral"));
accNo.setText(rs.getString("accNo"));
accBranch.setText(rs.getString("branch"));
comments.setText(rs.getString("Comm"));
qulification.setText(rs.getString("Quli"));
String a = rs.getString("Type");
if ("Casual".equals(a) ){
casual.doClick();
}
if ("Permanent".equals(a) ){
permanent.doClick();
}
if ("Hamilton".equals(a) ){
Hamilton.doClick();
}
if ("Tasma".equals(a) ){
Tasma.doClick();
}
}
delete.setEnabled(true);
update.setEnabled(true);
save.setEnabled(false);
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null, "Invalid EPF No or there is an error u entered values", "Search",JOptionPane.ERROR_MESSAGE);
}
delete.setEnabled(true);
update.setEnabled(true);
}
private void empNoKeyTyped(java.awt.event.KeyEvent evt) {
delete.setEnabled(false);
update.setEnabled(false);
save.setEnabled(true);
address.setText("");
name.setText("");
tel.setText("");
nic.setText("");
db.setText("");
djoin.setText("");
comments.setText("");
qulification.setText("");
accNo.setText("");
accBranch.setText("");
}
private void empNoActionPerformed(java.awt.event.ActionEvent evt) {
}
private void empNoMouseClicked(java.awt.event.MouseEvent evt) {
delete.setEnabled(false);
update.setEnabled(false);
save.setEnabled(true);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new PersanalInfo().setVisible(true);
}
});
}
// Variables declaration
private javax.swing.JRadioButton Hamilton;
private javax.swing.JButton Search;
private javax.swing.JRadioButton Tasma;
private javax.swing.JTextField accBranch;
private javax.swing.JTextField accNo;
private javax.swing.JTextArea address;
private javax.swing.ButtonGroup buttonGroup1;
private javax.swing.JButton cancel;
private javax.swing.JRadioButton casual;
public static javax.swing.JTextArea comments;
private javax.swing.JFormattedTextField db;
private javax.swing.JButton delete;
private javax.swing.JComboBox depart;
private javax.swing.JFormattedTextField djoin;
private javax.swing.JTextField empNo;
private javax.swing.JComboBox gender;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel14;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel18;
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.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JPanel jPanel6;
private javax.swing.JPanel jPanel7;
private javax.swing.JPanel jPanel8;
private javax.swing.JPanel jPanel9;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTextField jTextField1;
private javax.swing.JComboBox job;
private javax.swing.JTextField name;
private javax.swing.JTextField nic;
private javax.swing.JRadioButton permanent;
public static javax.swing.JTextArea qulification;
private javax.swing.JButton save;
private javax.swing.JComboBox shitgeneral;
private javax.swing.JTextField tel;
private javax.swing.JButton update;
// End of variables declaration
}
