private void updateEmpInfo(){
        String empNum = empNo.getText();
        String fNam = fName.getText();
        String lNam = lName.getText();
        String mInt = mInit.getText();
        String dlNum = dlNo.getText();
        if(dlNum.equals("")){
            dlNum = null;
        }
        String dlExpryDate = ((JTextField)dlExpDate.getDateEditor().getUiComponent()).getText();
        String mStat = (String) mStatus.getSelectedItem();
        String sex = (String) gender.getSelectedItem();
        String bDay = ((JTextField)bDate.getDateEditor().getUiComponent()).getText();
        String spouseName = spouse.getText();
        String fatherName = father.getText();
        String motherName = mother.getText();
        String educ = (String) edAttainment.getSelectedItem();
        String yrsInCollege;
        if(!educ.equals("College Graduate")){
            yrsInCollege = "";
        }
        else{
            yrsInCollege = (String) yrInCollege.getSelectedItem();
        }
        String add = address.getText();
        String emailAdd = email.getText();
        String contact = contactNo.getText();
        String jbTitle = (String)jobTitle.getSelectedItem();
        String supervisor;
        if(supervisorField.isEnabled()){
            supervisor = (String)supervisorField.getSelectedItem();
        }
        else{
            supervisor = "";
        }
        String regionAss = region.getText();
        String areaAss = area.getText();
        String branchAss = (String)branch.getSelectedItem();
        String empStat = (String)empStatus.getSelectedItem();
        String hireDate = ((JTextField)dateHired.getDateEditor().getUiComponent()).getText();
        boolean onTraining = isOnTraining.isSelected();
        try{
            String set = "set empNo=?,fName=?,mInit=?,lName=?,dlNo=?,dlExpDate=?,mStatus=?,gender=?,bDate=?,spouse=?,father=?,mother=?,edAttainment=?,yrInCollege=?,"
                    + "address=?,email=?,contactNo=?,"
                    + "jobTitle=?,supervisor=?,region=?,area=?,branch=?,empStatus=?,dateHired=?,isOnTraining=?";
            String sql = "update Employee " + set + " where empNo=?";
            conn = DBConnect.connect();
            pst = conn.prepareStatement(sql);
            pst.setString(1,empNum);
            pst.setString(2,fNam);
            pst.setString(3,mInt);
            pst.setString(4,lNam);
            pst.setString(5,dlNum);
            pst.setString(6,dlExpryDate);
            pst.setString(7,mStat);
            pst.setString(8,sex);
            pst.setString(9,bDay);
            pst.setString(10,spouseName);
            pst.setString(11,fatherName);
            pst.setString(12,motherName);
            pst.setString(13, educ);
            pst.setString(14,yrsInCollege);
            pst.setString(15,add);
            pst.setString(16,emailAdd);
            pst.setString(17,contact);
            pst.setString(18,jbTitle);
            pst.setString(19, supervisor);
            pst.setString(20,regionAss);
            pst.setString(21,areaAss);
            pst.setString(22,branchAss);
            pst.setString(23,empStat);
            pst.setString(24, hireDate);
            pst.setBoolean(25, onTraining);
            pst.setString(26, empNm);
            pst.execute();
            JOptionPane.showMessageDialog(null, "Update successful!");
            close();
        }
        catch(Exception e){
            try{
                pst.close();
            }
            catch(SQLException ex){
                JOptionPane.showMessageDialog(null,ex);
            }
            JOptionPane.showMessageDialog(null,e);
        }
        finally{
            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);
                }
            }
        }
    }