Example usage for javax.persistence Persistence createEntityManagerFactory

List of usage examples for javax.persistence Persistence createEntityManagerFactory

  1. HOME
  2. Java
  3. javax
  4. javax.persistence.*
  5. Persistence
  6. createEntityManagerFactory

Introduction

In this page you can find the example usage for javax.persistence Persistence createEntityManagerFactory.

Prototype

public static EntityManagerFactory createEntityManagerFactory(String persistenceUnitName)

Source Link

Document

Create and return an EntityManagerFactory for the named persistence unit.

Usage

From source file:Logica.Usuario.java

/**
 *
 * @param numOrden/*from  w ww  .  j a  v a  2  s . co  m*/
 * @param idRec
 * @param articulos
 * @return
 * @throws RemoteException
 */
@Override
public boolean devolverPedido(BigDecimal numOrden, String idRec, ArrayList<itemRecep> articulos)
        throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Itmxorden.findByNumorden");
    q.setParameter("numorden", new Double(numOrden.toString()));
    q.setParameter("recibido", "SI");
    List<Itmxorden> resultList = q.getResultList();
    ItmxordenJpaController itm = new ItmxordenJpaController(emf);
    for (Itmxorden i : resultList) {
        for (itemRecep rec : articulos) {
            if (i.getItemCinterno().getCinterno().equalsIgnoreCase(rec.getCinterno())) {
                try {
                    this.updateCantidad(rec.getCinterno(), -rec.getcAprobada());
                    i.setRecibido("NO");
                    itm.edit(i);
                } catch (Exception ex) {
                    Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
    }
    q = em.createNamedQuery("Recepcion.findByNumorden");
    q.setParameter("numorden", new Ordencompra(new Double(numOrden.toString())));
    List<Recepcion> recepcion = q.getResultList();
    RecepcionJpaController contrRec = new RecepcionJpaController(emf);
    for (Recepcion r : recepcion) {
        for (itemRecep rec : articulos) {
            if (rec.getCinterno().equalsIgnoreCase(rec.getCinterno())) {
                try {
                    contrRec.destroy(r.getFechallegada());
                } catch (NonexistentEntityException ex) {
                    Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
    }
    return true;

}

From source file:Logica.Usuario.java

/**
 *
 * @param e/*from w w  w . j a va 2 s.com*/
 * @throws RemoteException
 */
@Override
public void evaluarProv(evProv e) throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    Evaluacionprov ev = new Evaluacionprov(e.getNit(), e.getNumorden(), e.getEv1(), e.getEv2(), e.getEv3(),
            e.getEv4(), e.getEv5(), e.getEv6(), e.getEv7(), e.getEv8());
    EvaluacionprovJpaController contr = new EvaluacionprovJpaController(emf);
    contr.create(ev);
    emf.close();
}

From source file:Logica.Usuario.java

/**
 *
 * @param e//from w w w.  j  a va  2s . co  m
 * @throws RemoteException
 */
@Override
public void borrarEvaluacion(evProv e) throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Evaluacionprov.findByNumorden");
    q.setParameter("numorden", e.getNumorden());
    List<Evaluacionprov> ev = q.getResultList();
    EvaluacionprovJpaController contr = new EvaluacionprovJpaController(emf);
    for (Evaluacionprov ee : ev) {
        try {
            contr.destroy(ee.getId());
        } catch (NonexistentEntityException ex) {
            Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    emf.close();
}

From source file:Logica.Usuario.java

/**
 *
 * @param nit/*w  w  w . ja v  a  2s  .  c  om*/
 * @return ArayList
 * @throws RemoteException
 *
 * Genera un listado con los tems asociados a un proveedor en particular
 */
@Override
public ArrayList<ItemInventario> itemxProv(String nit) throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    Connection con = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    String statement = "select  item.cinterno, item.descripcion, item.presentacion, item.cantidad, item.precio, item.ccalidad, item.cesp"
            + " from ixp, proveedor, item"
            + " where ixp.cinterno =item.cinterno and ixp.nit = proveedor.nit and proveedor.nit= ?;";
    ItemInventario item = null;
    ArrayList<ItemInventario> lista = new ArrayList<>();

    try {
        con = Conexion.conexion.getConnection();
        ps = con.prepareStatement(statement);
        ps.setString(1, nit);
        rs = ps.executeQuery();
        while (rs.next()) {
            item = new ItemInventario(rs.getString(1), rs.getString(2), rs.getString(3), rs.getFloat(4),
                    rs.getFloat(5), rs.getString(6), "", "", rs.getString(7));
            lista.add(item);
        }

    } catch (SQLException ex) {
        System.out.println("Error funcion \"Item por Proveedor \"");
        Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex);
    } finally {

        try {
            if (ps != null) {
                ps.close();
            }
            if (rs != null) {
                rs.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.out.println("Error cerrando conexion");
        }

    }
    return lista;
}

From source file:Logica.Usuario.java

/**
 *
 * @param numorden/* ww  w. ja  v a2 s.  c  o  m*/
 * @param id
 * @return
 * @throws RemoteException
 *
 * Retorna los datos completos de una orden de compra.
 */
@Override
public recepcionProd getDatosRec(BigDecimal numorden, String id) throws RemoteException {
    recepcionProd rec = null;
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Itmxorden.findByNumorden");
    q.setParameter("numorden", new Double(numorden.toString()));
    q.setParameter("recibido", "NO");
    List<Itmxorden> resultList = q.getResultList();
    ArrayList<itemRecep> items = new ArrayList<>();
    proveedor p = new proveedor();
    for (Itmxorden i : resultList) {
        Proveedor prov = i.getProveedorNit();
        p = new proveedor(prov.getNit(), prov.getNombre(), prov.getDir(), prov.getTel(), prov.getFax(),
                prov.getCiudad(), prov.getCelular(), prov.getCorreo(), p.getContacto());
        Item itm = i.getItemCinterno();
        items.add(new itemRecep(itm.getCinterno(), "", new Float(i.getCaprobada()), new Float(i.getPrecioU())));
    }
    Query qq = em.createNamedQuery("Ordencompra.findByNumOrden");
    qq.setParameter("numOrden", new Double(numorden.toString()));
    if (qq.getResultList().isEmpty()) {
        return null;
    } else {
        Ordencompra o = (Ordencompra) qq.getResultList().get(0);
        emf.close();
        rec = new recepcionProd(numorden, p, id, items, o.getObservaciones());
        return rec;
    }
}

From source file:Logica.Usuario.java

@Override
public recepcionProd getDatosRec2(BigDecimal numorden, String id) throws RemoteException {
    recepcionProd rec = null;/* ww  w .j av a2  s  .  co  m*/
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Itmxorden.findByNumorden2");
    q.setParameter("numorden", new Double(numorden.toString()));
    List<Itmxorden> resultList = q.getResultList();
    ArrayList<itemRecep> items = new ArrayList<>();
    proveedor p = new proveedor();
    for (Itmxorden i : resultList) {
        Proveedor prov = i.getProveedorNit();
        p = new proveedor(prov.getNit(), prov.getNombre(), prov.getDir(), prov.getTel(), prov.getFax(),
                prov.getCiudad(), prov.getCelular(), prov.getCorreo(), p.getContacto());
        Item itm = i.getItemCinterno();
        items.add(new itemRecep(itm.getCinterno(), "", new Float(i.getCaprobada()), new Float(i.getPrecioU())));
    }
    Query qq = em.createNamedQuery("Ordencompra.findByNumOrden");
    qq.setParameter("numOrden", new Double(numorden.toString()));
    if (qq.getResultList().isEmpty()) {
        return null;
    } else {
        Ordencompra o = (Ordencompra) qq.getResultList().get(0);
        emf.close();
        rec = new recepcionProd(numorden, p, id, items, o.getObservaciones());
        return rec;
    }
}

From source file:Logica.Usuario.java

/**
 *
 * @param numorden//from  ww w . j a  va2 s.  c o m
 * @param id
 * @return
 * @throws RemoteException
 *
 * Retorna los datos completos de una orden de compra.
 */
@Override
public recepcionProd getDatosPedidoRecibido(BigDecimal numorden, String id) throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Itmxorden.findByNumorden");
    q.setParameter("numorden", new Double(numorden.toString()));
    q.setParameter("recibido", "SI");
    ArrayList<itemRecep> items = new ArrayList<>();
    List<Itmxorden> resultList = q.getResultList();
    if (!resultList.isEmpty() || resultList != null) {
        Itmxorden get = resultList.get(0);
        proveedor p = new proveedor(get.getProveedorNit().getNit(), get.getProveedorNit().getNombre(),
                get.getProveedorNit().getDir(), get.getProveedorNit().getTel(), get.getProveedorNit().getFax(),
                get.getProveedorNit().getCiudad(), get.getProveedorNit().getCelular(),
                get.getProveedorNit().getCorreo(), get.getProveedorNit().getContacto());
        for (Itmxorden itmxorden : resultList) {
            Item itemCinterno = itmxorden.getItemCinterno();
            Query qq = em.createNamedQuery("Recepcion.findByNumorden");
            qq.setParameter("numorden", new Ordencompra(new Double(numorden.toString())));
            List<Recepcion> recepcion = qq.getResultList();
            for (Recepcion r : recepcion) {
                if (r.getCinterno().getCinterno().equalsIgnoreCase(itemCinterno.getCinterno())) {
                    itemRecep itmRecibido = new itemRecep(itemCinterno.getCinterno(), r.getFechallegada(),
                            r.getFechavencimiento(), r.getCcalidad(), r.getCesp(), r.getMverificacion(),
                            r.getObservaciones(), new Float(itmxorden.getCaprobada()),
                            new Float(r.getPrecioanterior()));
                    items.add(itmRecibido);
                }
            }
        }
        recepcionProd recepcionProd = new recepcionProd(numorden, p, "", items, id);
        return recepcionProd;
    } else {
        return null;
    }
}

From source file:Logica.Usuario.java

/**
 *
 * @param numorden/*from   w w w .ja v a 2 s . c om*/
 * @return
 * @throws RemoteException
 */
@Override
public evProv getEvaluacionProv(double numorden) throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Evaluacionprov.findByNumorden");
    q.setParameter("numorden", numorden);
    List<Evaluacionprov> resultList = q.getResultList();
    evProv ev = null;
    for (Evaluacionprov e : resultList) {
        ev = new evProv(e.getNitProv(), e.getNumorden(), e.getEv1(), e.getEv2(), e.getEv3(), e.getEv4(),
                e.getEv5(), e.getEv6(), e.getEv7(), e.getEv8());
    }
    emf.close();
    return ev;
}

From source file:Logica.Usuario.java

/**
 *
 * @return @throws RemoteException//from  w ww .  ja  v a2  s. c  om
 */
@Override
public ArrayList<Integer> numerosDeOrden() throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    OrdencompraJpaController contr = new OrdencompraJpaController(emf);
    List<Ordencompra> resultList = contr.findOrdencompraEntities();
    ArrayList<Integer> ordenes = new ArrayList<>();
    for (Ordencompra r : resultList) {
        ordenes.add(r.getNumOrden().intValue());
    }
    emf.close();
    return ordenes;
}

From source file:Logica.Usuario.java

@Override
public ArrayList<Integer> numerosDeOrdenRecibidas() throws RemoteException {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Biot_ServerPU");
    EntityManager em = emf.createEntityManager();
    Query q = em.createNamedQuery("Recepcion.findAllOrdenes");
    List<Ordencompra> resultList = q.getResultList();
    ArrayList<Integer> numorden = new ArrayList<>();
    for (Ordencompra r : resultList) {
        numorden.add(r.getNumOrden().intValue());
    }/*www. ja v  a  2 s  . co m*/
    return numorden;
}