1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
package com.struts.controleur;
import java.util.Iterator;
import org.hibernate.*;
import com.gestion.Personne;
import com.util.HibernateUtil;
/*import java.text.SimpleDateFormat;
import java.util.Date;*/
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.struts.data.PersonneForm;
public final class RecherchePersonnAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest req,
HttpServletResponse res) throws Exception {
String resultat = null;
int id = ((PersonneForm) form).getId();
String nomPersonne = ((PersonneForm) form).getNom();
String prenomPersonne = ((PersonneForm) form).getPrenom();
try{
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
String query = "select p.Id, p.Nom , p.Prenom from gestion.personne p where p.Id ="+id;
Iterator results = session.createSQLQuery(query).list().iterator();
while(results.hasNext())
{
Object[] row = (Object[]) results.next();
Integer id1 = (Integer) row[0];
String nom1 = (String) row[1];
String prenom1 = (String) row[2];
}
session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();
resultat = "succes";
}catch(Exception ex){
HibernateUtil.getSessionFactory().close();
resultat = "echec";
}
return mapping.findForward(resultat);
}
} |
Partager