private void initEmpProfile(){
        Date date = null;
        String fn = null;
        String mi = null;
        String ln = null;
        String empN = null;
        String dln = null;
        String dled = null;
        String ms = null;
        String g = null;
        String bd = null;
        String s = null;
        String f = null;
        String m = null;
        String ea = null;
        String yic = null;
        String a = null;
        String e = null;
        String cn = null;
        String jt = null;
        String sv = null;
        String b = null;
        String r = null;
        String ar = null;
        String es = null;
        String dh = null;
        boolean iot = false;
        boolean ckr = false;
        
        try{
            String sql = "select * from Employee where empNo = ?";
            conn = DBConnect.connect();
            pst = conn.prepareStatement(sql);
            pst.setString(1, empNm);
            rs = pst.executeQuery();
            
            if(rs.next()){
                ckr = true;
                fn = rs.getString("fName");
                mi = rs.getString("mInit");
                ln = rs.getString("lName");
                empN = rs.getString("empNo");
                dln = rs.getString("dlNo");
                dled =  rs.getString("dlExpDate");
                ms = rs.getString("mStatus");
                g = rs.getString("gender");
                bd =  rs.getString("bDate");
                s = rs.getString("spouse");
                f = rs.getString("father");
                m = rs.getString("mother");
                ea = rs.getString("edAttainment");
                yic = rs.getString("yrInCollege");
                a = rs.getString("address");
                e = rs.getString("email");
                cn = rs.getString("contactNo");
                jt = rs.getString("jobTitle");
                sv = rs.getString("supervisor");
                b = rs.getString("branch");
                r = rs.getString("region");
                ar = rs.getString("area");
                es = rs.getString("empStatus");
                dh =  rs.getString("dateHired");
                iot = rs.getBoolean("isOnTraining");
            }
        }
        catch(Exception ex){
            JOptionPane.showMessageDialog(null, ex);
        }
        finally{
            if(pst != null){
                try{
                    pst.close();
                }
                catch(SQLException ex){

                }
            }
            if(rs != null){
                try{
                    rs.close();
                }
                catch(SQLException ex){

                }
            }
            if(conn != null){
                try{
                    conn.close();
                }
                catch(SQLException ex){

                }
            }
        }
        if(ckr){
            fName.setText(fn);
            mInit.setText(mi);
            lName.setText(ln);
            empNo.setText(empN);
            dlNo.setText(dln);
            
            if(dled != null && !"".equals(dled)){
                try{
                    date = new SimpleDateFormat("yyyy-MM-dd").parse(dled);
                }
                catch(ParseException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
                dlExpDate.setDate(date);
            }
            mStatus.getModel().setSelectedItem(ms);
            gender.getModel().setSelectedItem(g);
                
            if(bd != null && !"".equals(bd)){
                try{
                    date = new SimpleDateFormat("yyyy-MM-dd").parse(bd);
                }
                catch(ParseException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
                bDate.setDate(date);
            }
            spouse.setText(s);
            father.setText(f);
            mother.setText(m);
            edAttainment.getModel().setSelectedItem(ea);
            yrInCollege.getModel().setSelectedItem(yic);
            address.setText(a);
            email.setText(e);
            contactNo.setText(cn);
            
            
            jobTitle.getModel().setSelectedItem(jt);
            if(jt!=null && (jt.equals("AO/Individual Lending Staff") || jt.equals("PO/Group Lending Staff") || jt.equals("APO/TMP Lending Staff"))){
                initSupervisorField(jt);
                supervisorField.setEnabled(true);
                region.setEnabled(true);
                area.setEnabled(true);
                branch.setEnabled(true);
                jLabel1.setEnabled(true);
                jLabel6.setEnabled(true);
                jLabel12.setEnabled(true);
                jLabel26.setEnabled(true);
            }
            else if(jt.equals("ASAP Supervisor") || jt.equals("MFU Supervisor") || jt.equals("TMP Supervisor")){
                region.setEnabled(true);
                area.setEnabled(true);
                branch.setEnabled(true);
                jLabel6.setEnabled(true);
                jLabel12.setEnabled(true);
                jLabel26.setEnabled(true);
            }
            else if(jt.equals("MF Manager")){
                region.setEnabled(true);
                area.setEnabled(true);
                jLabel6.setEnabled(true);
                jLabel12.setEnabled(true);
            }
            else if(jt.equals("MF Regional Head")){
                region.setEnabled(true);
                jLabel6.setEnabled(true);
            }
            
            
            supervisorField.getModel().setSelectedItem(sv);
            if(sv!=null && !sv.equals("")){
                
                branch.removeAllItems();
                branch.addItem(b);
                branch.getModel().setSelectedItem(b);
            }
            else{
                initBranchAssField();
                branch.getModel().setSelectedItem(b);
            }
            
            
            region.setText(r);
                            
            area.setText(ar);
                
            empStatus.getModel().setSelectedItem(es);
            
            if(dh != null && !"".equals(dh)){
                try{
                    date = new SimpleDateFormat("yyyy-MM-dd").parse(dh);
                }
                catch(ParseException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
                dateHired.setDate(date);
            }
            
            isOnTraining.setSelected(iot);
        }
    }