branchmanagerbean.java

THIS IS A FINANCIAL BANK APPLICATION

package Pcrd.Subscription.Beans;

import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import Pcrd.Subscription.Entities.Branch;
import Pcrd.Subscription.Entities.BranchPK;
import Pcrd.Subscription.Entities.SubscriptionPending;
import Pcrd.Subscription.Sessions.BranchManager;
@Stateless
public class BranchManagerBean implements BranchManager {
	@PersistenceContext
	EntityManager em;
	public Branch affichrLabelBranch(String branchCode, String bankCode) {
		try{
			System.out.println("SELECT br FROM Branch br WHERE ( br.pk.branchCode='"
					+ branchCode + "' AND br.pk.bankCode='" + bankCode
					+ "' )");
			Object obj = em.createQuery(
					"SELECT br FROM Branch br WHERE ( br.pk.branchCode='"
						+ branchCode + "' AND br.pk.bankCode='" + bankCode
						+ "' )").getSingleResult();
			if(obj != null) return (Branch) obj; else return null;
		}catch(Exception e){
			System.out.println("PCRD:"+e.getMessage());
			return null;
		}
		
	}
	public String LabelAgence(String branchCode,String bankCode){
		BranchPK pk=new BranchPK();
		pk.setBankCode(bankCode);
		pk.setBranchCode(branchCode);
		Branch sp=em.find(Branch.class,pk);
		String Label=sp.getBranchName();
		return(Label);
    	
	}
	public List<Branch> listerTous(String bankCode) {
	      return em.createQuery("SELECT p FROM Branch p where p.pk.bankCode='"+bankCode+"'").getResultList();
	}

}