All pastes #741520 Raw Edit

Someone

public java v1 · immutable
·published 2007-10-18 19:31 UTC
rendered paste body
package com.dvd.model;import java.util.ArrayList;import java.util.List;import javax.persistence.EntityManager;import javax.persistence.EntityManagerFactory;import javax.persistence.Persistence;import javax.persistence.Query;public class DVDLibraryDAO {    private EntityManager em;        public DVDLibraryDAO() {        EntityManagerFactory emf = Persistence.createEntityManagerFactory("DVDLibraryPU");        em = emf.createEntityManager();    }        public List getGenres(String username) {        System.out.println("getGenres called");        List genres = new ArrayList();        try {            em.getTransaction().begin();            Query query = em.createQuery("select d.genre from DVDItem d where d.username=?1");            query.setParameter(1, username);            genres = query.getResultList();            em.getTransaction().commit();        } catch (Exception e) {            e.printStackTrace();        }        return genres;    }        public List getDVDLibrary(String username) {        System.out.println("getDVDLibrary called");        List dvdLibrary = new ArrayList();        try {            em.getTransaction().begin();            Query query = em.createQuery("select d from DVDItem d where d.username=?1");            query.setParameter(1, username);            dvdLibrary = query.getResultList();            em.getTransaction().commit();        } catch (Exception e) {            e.printStackTrace();        }        System.out.println("found " + dvdLibrary.size() + " dvds for " + username);        return dvdLibrary;    }        public void addDVD(String username, DVDItem item) {        System.out.println("addDVD called");        try {            em.getTransaction().begin();            em.persist(item);            em.getTransaction().commit();        } catch (Exception e) {            e.printStackTrace();        }    }    }