private void deleteEmpHistActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteEmpHistActionPerformed
       String sql = "delete from EmploymentHistory where empNo=? and jobTitle=? and employer=? and start=? and end=?";            
            try{
                conn = DBConnect.connect();
                pst = conn.prepareStatement(sql);
                pst.setString(1, empNm);
                pst.setString(2, job);
                pst.setString(3, emplyr);
                pst.setString(4, st);
                pst.setString(5, en);
                pst.execute();
                
                JOptionPane.showMessageDialog(null, "Command successful!");
            }
            catch(Exception e){
                JOptionPane.showMessageDialog(null, e);
            }
            finally{
                if(pst != null){
                     try{
                         pst.close();
                    }
                    catch(SQLException e){

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

                    }
                }
            }
            initEmpHistTable();
    }