How to Delete and Modify Datas using Struts2 and Hibernate

Question

I created a jsp page that shows me the list of doctors (medecin in french) contained in my mysql database via the hibernate framework and struts2 .

I have a delete button supprimer (in french), to remove a doctor, and a button , modifier , to edit the doctor's data .

The edit button , modifier , will take all the datas (id , nom , prenom etc..) of the selectionned doctor and put it in a form so i can update it .

ListMed action give me this .

ListedesMedecins.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<%@ taglib prefix="sb" uri="/struts-bootstrap-tags"%>



    
    Listes des Medecins


    
    Listes des Medecins
         

    

    id
    Nom
    Prenom
            contact
    specialite



        
        
        
                    
        
                    "> Modifier   
                    "> Supprimer

my class MedecinDAO with the required method (select , update , delete , list)

public Medecin getMedecin(Integer idMedecin) {
    log.info("********** Debut getMedecin MedecinDAO **********");
    Medecin Medecin = null;
    Session session = SessionFactoryUtil.getInstance().openSession();
    try {
        Medecin = (Medecin) session.get(Medecin.class, idMedecin);

        return Medecin;
    } catch (Exception e) {
        e.printStackTrace();
        log.fatal(e.getMessage());
        return null;
    } finally {
        session.close();
        log.info("********** Fin getMedecin MedecinDAO **********");
    }
}

public boolean saveMedecin(Medecin Medecin) {
    log.info("********** Debut saveMedecin MedecinDAO **********");
    Session session = SessionFactoryUtil.getInstance().openSession();
    Transaction trans = session.beginTransaction();
    try {


        session.save(Medecin);
        trans.commit();
        return true;
    } catch (Exception e) {
        e.printStackTrace();
        log.fatal(e.getMessage());
        trans.rollback();
        return false;
    } finally {
        session.close();
        log.info("********** Fin saveMedecin MedecinDAO **********");

    }
}

public boolean updateMedecin(Medecin Medecin) {
    log.info("********** Debut updateMedecin MedecinDAO **********");
    Session session = SessionFactoryUtil.getInstance().openSession();
    Transaction trans = session.beginTransaction();
    try {
        session.update(Medecin);
        trans.commit();
        return true;
    } catch (Exception e) {
        e.printStackTrace();
        log.fatal(e.getMessage());
        return false;
    } finally {
        session.close();
        log.info("********** Fin updateMedecin MedecinDAO **********");

    }
}


public boolean deleteMedecin(Medecin Medecin) {
    log.info("********** Debut deleteMedecin MedecinDAO **********");
    Session session = SessionFactoryUtil.getInstance().openSession();
    try {
        Transaction trans = session.beginTransaction();
        session.delete(Medecin);
        trans.commit();
        return true;
    } catch (Exception e) {
        e.printStackTrace();
        log.fatal(e.getMessage());
        return false;
    } finally {
        session.close();
        log.info("********** Fin deleteMedecin MedecinDAO **********");
    }
}

   public List allmedecin(){

    List medecin = null;

    Session session = SessionFactoryUtil.getInstance().openSession();
    String registr = "from Medecin";

    Query query = session.createQuery(registr);
    medecin=query.list();

    return medecin;
}

And finally my action class , formMedAction.java

   //getters,setters...
   //this method is for adding Medecin/doctors 
   public String Ajoutmed() {


     MedecinDAO medDAO= MedecinDAO.getInstance();
     Medecin M = new Medecin();

     M.setIdmed(idmed);
     M.setNom(nom);
     M.setPrenom(prenom);
     M.setContact(contact);
     M.setSpecialite(specialite);
     medDAO.saveMedecin(M);

    return SUCCESS;

  }
  // return list of all medecin in the table
  public String Listmed() throws Exception {

    MedecinDAO medDAO = MedecinDAO.getInstance();
    Medecin = medDAO.allmedecin();

    return SUCCESS;
  }

  // Method I created to delete the data, but I'm not sure if it correct
  public String Supmed() {
      MedecinDAO medDAO = MedecinDAO.getInstance();
      Medecin M = new Medecin();
      M.getIdmed();
      M.getNom();
      M.getPrenom();
      M.getContact();
      M.getSpecialite();
      medDAO.deleteMedecin(M);

      return SUCCESS;


  }

  public string Modmed () {
  //dont know what to do for the modifier/edit action , need your help
  return SUCCESS;
  }

Need your help Thanks

EDIT !

Find a way to delete a doctor with this code in MedecinDAO :

public Medecin deleteMedecin(Integer idmed) {
    log.info("********** Debut deleteMedecin MedecinDAO **********");
    Session session = SessionFactoryUtil.getInstance().openSession();
        Transaction trans = session.beginTransaction();
       Medecin m = (Medecin) session.load(Medecin.class, idmed);
        session.delete(m);
        trans.commit();
        return m;
    }

And adding this in the action class

 public String Supmed() {
      MedecinDAO medDAO = MedecinDAO.getInstance();
      Medecin m = new Medecin();
      m = medDAO.deleteMedecin(getIdmed());
      return SUCCESS;

  }

And in JSP button action

"> Supprimer

now i need to know how to edit

Kane Samba · Accepted Answer

Ok i have found the solution .

If you want to get the selected object param (id , name or something) you just need to add this code . (in my case for example , i needed : idmed , nom prenom ,contact , specialite )

 "> Modifier

You create an Edit action

 public String editmed()
{

    return SUCCESS;
}

And then you create a new page , edit.jsp for example and you set the value of the param , in struts textfields (select etc..)

And it should work !

How to Delete and Modify Datas using Struts2 and Hibernate

Answers (2)

Related Questions