private void deleteTrAttendedActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteTrAttendedActionPerformed
        String sql = "delete from EmpTrainingAttended where empNo=? and trainingTitle=? and trainingDate=? and trainingPersonnel=?";
            try{
                conn = DBConnect.connect();
                pst = conn.prepareStatement(sql);
                pst.setString(1, empNm);
                pst.setString(2, trTitle);
                pst.setString(3, trDate);
                pst.setString(4, trPersonnel);
                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){

                    }
                }
            }
            initTrainingAttendedTable();
    }