package com.acxiom.RapidusIG; import javax.persistence.*; import com.acxiom.Entities.*; import java.util.Date; import java.util.*; //import java.net.URL; import org.apache.log4j.Logger; public class CampaignManager extends FlowComponentManager { private int m_campID; private String m_description; private String m_code; private Date m_expireDate; private Date m_createDate; private String m_updateUser; private Date m_updateDate; private FlowComponentManager [] m_flowComponents; private String m_lastRunUser; private Date m_lastRunDate; private long m_runTime; @PersistenceUnit private EntityManagerFactory emf = Persistence.createEntityManagerFactory("p1"); @PersistenceContext private EntityManager em = emf.createEntityManager(); public CampaignManager() { Logger logger = Logger.getLogger("com.acxiom.RapidusIG.CampaignManager"); Campaign campaign = new Campaign(); EntityTransaction et = em.getTransaction(); et.begin(); // logger.warn("about to create query"); javax.persistence.Query q = em.createQuery("select c from Campaign c"); //javax.persistence.Query q = em.createNativeQuery("select * from CAMP_CAMPAIGN"); logger.warn("created query"); //Campaign campaign = (Campaign)q.getSingleResult(); List results = q.getResultList(); System.out.println(results); //System.out.println(campaign); // em.close(); } public int getCampID() { return m_campID; } public void setCampID(int campID) { m_campID = campID; } public String getCode() { return m_code; } public void setCode(String code) { m_code = code; } public Date getCreateDate() { return m_createDate; } public void setCreateDate(Date date) { m_createDate = date; } public String getDescription() { return m_description; } public void setDescription(String description) { m_description = description; } public Date getExpireDate() { return m_expireDate; } public void setExpireDate(Date date) { m_expireDate = date; } public FlowComponentManager[] getFlowComponents() { return m_flowComponents; } public void setFlowComponents(FlowComponentManager[] components) { m_flowComponents = components; } public Date getLastRunDate() { return m_lastRunDate; } public void setLastRunDate(Date runDate) { m_lastRunDate = runDate; } public String getLastRunUser() { return m_lastRunUser; } public void setLastRunUser(String runUser) { m_lastRunUser = runUser; } public long getRunTime() { return m_runTime; } public void setRunTime(long time) { m_runTime = time; } public Date getUpdateDate() { return m_updateDate; } public void setUpdateDate(Date date) { m_updateDate = date; } public String getUpdateUser() { return m_updateUser; } public void setUpdateUser(String user) { m_updateUser = user; } }