rendered paste bodypackage 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(); } } }