petcontrol.java

Java Swing Application。涉及到 JPA, appframework, beansbinding.

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package personalpetvet.model;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.Vector;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityManager;
import javax.persistence.Id;
import javax.persistence.Query;
import personalpetvet.DBHelper;

/**
 *
 * @author james
 */
public class PetControl {

    static public void main(String[] args) {

        System.out.println(getAllPetsFolders());
    }
    private static EntityManager em = DBHelper.getEntityManager();

    public static Vector<String> getAllPetsFolders() {
//        Query q = em.createNativeQuery("select foldername from pets", FolderName.class);
//        return (Vector<String>) q.getResultList();

        Query q = em.createNativeQuery("select FILEFOLDER from pets");
        Vector<String> v = new Vector();
        for (Vector<String> r : (List<Vector<String>>) q.getResultList()) {
            v.add(r.firstElement());
        }
        return v;
    }

    public static EntityManager getEntityManager() {

        return em;
    }

    public static int getPetCount() {
        return (Integer) em.createNativeQuery("select count(*) from pets").getSingleResult();
    }

    public static Pet getFirstPet() {
        Query query = em.createQuery("select p from Pet p");
        query.setMaxResults(1);
        return (Pet) query.getSingleResult();
    }

    public static Vector<Pet> getAllPets() {
        Query query = em.createQuery("select p from Pet p");
        return (Vector<Pet>) query.getResultList();
    }


}