Java EntityManager.createNamedQuery方法代码示例

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public String readRow(String name) {
    EntityManager em=emf.createEntityManager();
    Query q=em.createNamedQuery("Preferences.findByName");
    q.setParameter("name", name);
    List<Preferences> l=q.getResultList();
    if(l.size()==0) return null;
    Preferences p=l.get(0);
    em.close();
    return p.getValue();

}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
/** Creates new form PreferencesDialog */
public PreferencesDialog() {
    initComponents();
    emf = Persistence.createEntityManagerFactory("GeoImageViewerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Preferences.findAll");
    prefs = q.getResultList();
    em.close();

    setTitle("SUMO Preferences");
    initTable();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void loadAll() {

        List<DocumentDetail> ListDocumentDetail = new ArrayList<DocumentDetail>();

        Items it = new Items();
        EntityManager em = it.getEntityManager();
        TypedQuery<DocumentDetail> consultItems = em.createNamedQuery("DocumentDetail.findAll", DocumentDetail.class);
        ListDocumentDetail = consultItems.getResultList();

        ListProducts = new ArrayList<Products>();

        for (DocumentDetail selectedItem : ListDocumentDetail) {
            Products newProduct = new Products();
            newProduct.setArticulo(selectedItem.getItemId().getName());
            newProduct.setBodega(selectedItem.getWarehousesId().getName());
            if (selectedItem.getDocumentId().getTypedocId().getCode().equals("1")) {
                newProduct.setEntradas(selectedItem.getQuantity());
            } else {
                newProduct.setSallidas(selectedItem.getQuantity());

            }
            newProduct.setFecha(selectedItem.getDocumentId().getDocumentDate().toString());
            newProduct.setConsecutivo(selectedItem.getDocumentId().getConsecutive() + "");
            ListProducts.add(newProduct);
        }
    }
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void loadMore() {
    List<DocumentDetail> ListDocumentDetail = new ArrayList<DocumentDetail>();

    Items it = new Items();
    EntityManager em = it.getEntityManager();
    TypedQuery<DocumentDetail> consultItems = em.createNamedQuery("DocumentDetail.findAll", DocumentDetail.class);
    ListDocumentDetail = consultItems.getResultList();

    ListProducts = new ArrayList<Products>();
    ListMoreProducts = new ArrayList<Products>();

    for (DocumentDetail selectedItem : ListDocumentDetail) {
        Products newProduct = new Products();

        newProduct.setArticulo(selectedItem.getItemId().getName());

        Products alreadyItem = findInListMoreProducts(newProduct.getArticulo());
        if (alreadyItem == null) {
            if (selectedItem.getDocumentId().getTypedocId().getCode().equals("1")) {
                newProduct.setEntradas(selectedItem.getQuantity());
            } else {
                newProduct.setSallidas(selectedItem.getQuantity());

            }
            ListMoreProducts.add(newProduct);
        } else {
            if (selectedItem.getDocumentId().getTypedocId().getCode().equals("1")) {
                alreadyItem.setEntradas((alreadyItem.getEntradas() != null ? alreadyItem.getEntradas() : 0) + selectedItem.getQuantity());
            } else {
                alreadyItem.setSallidas((alreadyItem.getSallidas() != null ? alreadyItem.getSallidas() : 0) + selectedItem.getQuantity());
            }
        }
    }
    SumMoreProducts();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void searchProduct(){
    EntityManager em = i.getEntityManager();
    TypedQuery<Items> consultarProducto = em.createNamedQuery("Items.findByCode",Items.class);
    consultarProducto.setParameter("code",i.getCode());
    List<Items> productos = consultarProducto.getResultList();
    if(productos.size()>0){
        i = productos.get(0);
    }else{
        i = new Items();
    }
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void searchDocument(){
    EntityManager em = d.getEntityManager();
    TypedQuery<Document> consultDocument = em.createNamedQuery("Document.findByConsecutive",Document.class);
    consultDocument.setParameter("consecutive",d.getConsecutive());
    List<Document> document = consultDocument.getResultList();
    if(document.size()>0){
        d = document.get(0);
        alldd = new ArrayList<DocumentDetail2>();
        total = 0;
        em = dd.getEntityManager();
        TypedQuery<DocumentDetail> consultDocumentD = em.createNamedQuery("DocumentDetail.findByDocument",DocumentDetail.class);
        consultDocumentD.setParameter("documentId",d);
        List<DocumentDetail> documentD = consultDocumentD.getResultList();
        for(int i  = 0; i < documentD.size();i++){
            DocumentDetail2 dd2  = new DocumentDetail2();
            dd2.setDd(documentD.get(i));
            dd2.setDocumentDetailId(i);
            dd2.setTempi(documentD.get(i).getItemId().getItemId());
            dd2.setTempw(documentD.get(i).getWarehousesId().getWarehousesId());
            alldd.add(dd2);
            total +=  dd2.getDd().getPrice();
        }
        temptd = d.getTypedocId().getTypedocId();
        visualTotal = new BigDecimal(total)+"";
        disabled = true;
        consecutive = false;
        visibilityCreate = "none";
        visibilityUpdate = "none";
        visibilityEdit = "inline";
    }else{
        searchD();
    }
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void listTypeDoc(){
     EntityManager em = td.getEntityManager();
    //Query tipado con el tipo de objeto a extraer
    TypedQuery<TypeDoc> consulusert = em.createNamedQuery("TypeDoc.findAll",TypeDoc.class);
     //captura de listado de la consulta
    alltd = consulusert.getResultList();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void listWarehouse(){
     EntityManager em = w.getEntityManager();
    //Query tipado con el tipo de objeto a extraer
    TypedQuery<Warehouses> consulusert = em.createNamedQuery("Warehouses.findAll",Warehouses.class);
     //captura de listado de la consulta
    allw = consulusert.getResultList();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void listItems(){
     EntityManager em = i.getEntityManager();
    //Query tipado con el tipo de objeto a extraer
    TypedQuery<Items> consuli= em.createNamedQuery("Items.findByIsActived",Items.class);
     //captura de listado de la consulta 
    consuli.setParameter("isActived", true);
    alli = consuli.getResultList();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void listUserType(){
     EntityManager em = ut.getEntityManager();
    //Query tipado con el tipo de objeto a extraer
    TypedQuery<UsersType> consulusert = em.createNamedQuery("UsersType.findAll",UsersType.class);
     //captura de listado de la consulta
    allut = consulusert.getResultList();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void listUsers(){
     EntityManager em = u.getEntityManager();
    //Query tipado con el tipo de objeto a extraer
    TypedQuery<Users> consuluser = em.createNamedQuery("Users.findAll",Users.class);
     //captura de listado de la consulta
    allu = consuluser.getResultList();
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void searchWarehouse(){
    EntityManager em = w.getEntityManager();
    TypedQuery<Warehouses> consultwarehouse = em.createNamedQuery("Warehouses.findByCode",Warehouses.class);
    consultwarehouse.setParameter("code",w.getCode());
    List<Warehouses> warehouse = consultwarehouse.getResultList();
    if(warehouse.size()>0){
        w = warehouse.get(0);
    }else{
        w = new Warehouses();
    }
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public SalesSimulator(EntityManager em){
        this.em = em;
//        regionByZipCode = em.createNamedQuery("Region.findByZipCodePrefix", Region.class);
        
        thisRandom = new Random();
        
        Query q = em.createNamedQuery("ZipCityInfo.findAll", ZipCityInfo.class);
        listOfZips = q.getResultList();
        
        usRegions= new ArrayList<Region>();
        intlRegions= new ArrayList<Region>();
        
        generateRegionLists();
        
        
        
    }
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public static void readFullProductListing(EntityManager entityManager){
    Query namedQuery = entityManager.createNamedQuery("FullProductListing.findAll");
    List products = namedQuery.getResultList();
    System.out.println(products.size());
}
 

import javax.persistence.EntityManager; //导入方法依赖的package包/类
public void ConsecutiveDocument(){
    EntityManager em = d.getEntityManager();
    TypedQuery<Document> consultDocument = em.createNamedQuery("Document.findAll",Document.class);
    alld = consultDocument.getResultList();
    d.setConsecutive(alld.size()+1);
}