probleme de requete sql

import

}

}

{

}

}

}

HttpServletRequest request, HttpServletResponse response)

LotFactory lf =

List<Lot> lotList = lf.getLots();

((LotInfoForm) form).setLotList(lotList);

System.

System.

}

}

{

}


'lotinfoFactoryImpl' : action:

package com.st.mcc.wam.service;

import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.jpa.JpaTemplate;
import org.springframework.transaction.annotation.Transactional;

import com.st.mcc.wam.bean.Lot;

* This class is a Factory Method to creation of a list lot

*/

/** Pour ce design pattern il faudra indiquer :
*Préciser le nom de la classe.
*Préciser le type d'objet qui seront gérés par la Factory.
*Indiquer si vous désirez que cette factory deviennent aussi un manager,
* c.a.d qu'il est possible de lui confier des objets instanciés à l'extérieur
* de la classe.
*/

/* create a class LotFactoryImpl to implement interface LotFactory  */

public class LotFactoryImpl implements LotFactory
{
 
 /** Logger. */
 private static final Log LOG = LogFactory.getLog(LotFactoryImpl.class);

 private JpaTemplate jpaTemplate= null; /* object JpaTemplate(type) jpaTemplate(attribute) */
 private EntityManager entityManager = null;
 //private EntityManagerImpl = null;
 
 public LotFactoryImpl()
 {
  // default constructor
 }
 
 /* (non-Javadoc)
  * @see com.st.mcc.wam.service.CRUDLotfactory#createLot(com.st.mcc.wam.bean.Lot)
  */
 @Transactional /* an annotation  */
 public Lot createLot(Lot lot)  /*Create a Lot */
 {
  LOG.debug("create of lot (begin)");

  LOG.debug("id = " + lot.getLotId());
  
  /* try a LOG with jpaTemplate  */
 try {
   jpaTemplate.persist(lot);/*.persist(lot)= persistence Object(Lot) */
   jpaTemplate.flush(); /* .flush = empty a memory or up to date of memory */
   LOG.debug("create of lot (end)");

   return lot;
 }
  
  /* Failure so catch an exception to runtime */
  catch (RuntimeException e)
 {
  LOG.error("problem !");
   return null;
  }
 }

 /* (non-Javadoc)
  * @see com.st.mcc.wam.service.CRUDLotFactory#deleteLot(com.st.mcc.wam.bean.Lot)
  */
 @Transactional
 public void deleteLot(Lot lot) {
  // TODO Auto-generated method stub
  
 }

 /* (non-Javadoc)
  * @see com.st.mcc.wam.service.CRUDLotFactory#readLot(com.st.mcc.wam.bean.Lot)
  */
 @Transactional
 public Lot getLot(String lotId) {
  LOG.debug("search of lot (begin)");

  LOG.debug("id = " + lotId);
  try {
   Lot lot = jpaTemplate.find(Lot.class, lotId);/* .find serve to find a lot */
   LOG.debug("search of lot (end)");

   return lot;  /*find a lot so return a lot*/
  } catch (RuntimeException e) {
   LOG.error("problem !");
   return null;  /* not find a lot so return null and to start again a search */
  }
 }

 /* (non-Javadoc)
  * @see com.st.mcc.wam.service.CRUDLotFactory#updateLot(com.st.mcc.wam.bean.Lot)
  */
 @Transactional
 public void updateLot(Lot lot)
 {
  // TODO Auto-generated method stub
  
 }

 /*the connection at BDD = EntityManagerFactory */
 
 public void setEntityManagerFactory(EntityManagerFactory emf)
 {
  this.jpaTemplate = new JpaTemplate(emf); 
  this.entityManager = emf.createEntityManager();
 }

 @Transactional
 
 public List<Lot> getLots()
 {

  for(int i=0; i<10; i++)
  { 
   Lot l = new Lot();
   l.setLotId("GXXXXXX_"+ i);
   l.setLattice_code("ET_CONT_VIA");
   l.setQuantity(3);
   l.setJalon("J05");
   l.setTechnology("M10");
   l.setPriority("P12");
   l.setStatus_lot("Wait");
   l.setHold("N");
   l.setOverride("Y");
   int date_begin = 06/02/2008;
   l.setDate_debut(date_begin);
   l.setDate_debut(06/02/2008);
   int date_end = 17/04/2008;
   l.setDate_fin(date_end);
   this.createLot(l);
   LOG.debug("Lot = " + l.getLotId() );
  }
  
  List<Lot> lotList=jpaTemplate.find("SELECT LOTID FROM LOT ");
 
  
  
  jpaTemplate.findByNamedQuery("getAllLots",lotList);
   /** This is the list of object **/
   return lotList;
 }

}