Syntax

1. /**
    * 
    */
   package com.sap.nwce.ra.sedm.ejb.service;
   
   import java.util.List;
   
   import javax.ejb.Stateless;
   import javax.persistence.EntityManager;
   import javax.persistence.NamedQuery;
   import javax.persistence.PersistenceContext;
   import javax.persistence.Query;
   
   import com.sap.nwce.ra.sedm.ejb.entity.Employee;
   import com.sap.nwce.ra.sedm.ejb.entity.Project;
   
   
   /**
    * @author I030736
    *
    */
   @Stateless
   public class ProjectFacadeBean implements ProjectFacadeLocal {
   
   	@PersistenceContext(unitName = "ems/EJB3_simpl_EDM_DEMO_PU")
       protected EntityManager em;
   
   	public List<Project> findProjects(String nameDescrPtrn){
   		Query q = ("".equals(nameDescrPtrn)) ? 
   			em.createNamedQuery( "Project.getAll" ) : 
   			em.createNamedQuery( "Project.findByNameOrDescPart" ) ;
   
   		if  ( ! "".equals(nameDescrPtrn)){
   			q.setParameter("namepart", "%" + nameDescrPtrn + "%");
   			q.setParameter("namepart1", "%" + nameDescrPtrn + "%");
   		}
   
   		return q.getResultList();
   	}
   
   	public List<Employee> findEmployees(String nameDescrPtrn){
   		Query q = ("".equals(nameDescrPtrn)) ? 
   			em.createNamedQuery( "Employee.getAll" ) : 
   			em.createNamedQuery( "Employee.findByNamePart" ) ;
   
   		if  ( ! "".equals(nameDescrPtrn)){
   			q.setParameter("namepart", "%" + nameDescrPtrn + "%");
   			q.setParameter("namepart1", "%" + nameDescrPtrn + "%");
   		}
   
   		return q.getResultList();
   	}
   
   	public void saveProject(Project proj){
   		em.merge(proj);
   	}
   
   	public void saveEmployee(Employee empl){
   		em.merge(empl);
   	}
   
   	public Project getProjectById(int id){
   		Query q = em.createNamedQuery( "Project.getByProjectID" ); 
   		q.setParameter("prjId", id);
   		return (Project) q.getSingleResult();
   
   	}
   
   	public Employee getEmployeeById(int id){
   		Query q = em.createNamedQuery( "Employee.getById" ); 
   		q.setParameter("id", id);
   		return (Employee) q.getSingleResult();
   
   	}
   
   }