Example #1
0
  private static void pecas() {
    Session session = HibernateUtil.getSession();
    session.beginTransaction();

    for (String linha : getPecasFromCSV()) {
      String[] item = linha.split(";");

      String hqlMarca = "from Marca m where m.nome = :nome ";
      Query queryMarca = session.createQuery(hqlMarca).setString("nome", item[2]);
      Marca marca = (Marca) queryMarca.uniqueResult();

      if (marca == null || marca.getId() == 0) {
        marca = new Marca();
        marca.setNome(item[2]);
        session.saveOrUpdate(marca);
      }

      Peca peca = new Peca();
      peca.setNome(item[0]);
      peca.setDescricao(item[1] + " - " + item[3]);
      peca.setQuantidade(50);
      peca.setMarca(marca);
      session.saveOrUpdate(peca);

      TarifarioPeca tarifarioPeca = new TarifarioPeca();
      tarifarioPeca.setData(new Date());
      tarifarioPeca.setValor(Double.parseDouble(item[4]));
      tarifarioPeca.setMarkup(25);
      tarifarioPeca.setValorVenda(
          (tarifarioPeca.getValor() * (25 / 100)) + tarifarioPeca.getValor());
      tarifarioPeca.setPeca(peca);
      session.saveOrUpdate(tarifarioPeca);

      String hqlTipoServico = "from TipoServico m where m.nome = :nome ";
      Query queryTipoServico =
          session.createQuery(hqlTipoServico).setString("nome", "Troca de peça");
      TipoServico tipoServico = (TipoServico) queryTipoServico.uniqueResult();

      if (tipoServico == null || tipoServico.getId() == 0) {
        tipoServico = new TipoServico();
        tipoServico.setNome("Troca de peça");
        session.saveOrUpdate(tipoServico);
      }

      Servico servico = new Servico();
      servico.setNome(item[5]);
      servico.setDescricao(item[5]);
      servico.setTipoServico(tipoServico);
      session.saveOrUpdate(servico);

      TarifarioServico tarifarioServico = new TarifarioServico();
      tarifarioServico.setData(new Date());
      tarifarioServico.setServico(servico);
      tarifarioServico.setValor(Double.parseDouble(item[6]));
      session.saveOrUpdate(tarifarioServico);
    }

    session.getTransaction().commit();
    System.out.println("Peças importadas!");
  }
  private static boolean atualizarCarencia(Segurado segurado, Long idTitular) throws Exception {
    String sqlConsignacao =
        "select min(c.dataDoCredito) from ConsignacaoSegurado c  where c.titular.idSegurado = :idTitular "
            + "and c.statusConsignacao  = 'P' and c.dataDoCredito >= :dataAdesao";

    String sqlCobranca =
        "select min(c.dataPagamento) from Cobranca c where c.titular.idSegurado = :idTitular  "
            + "and descricao = 'Pago(a)' and c.dataPagamento >= :dataAdesao";

    Query queryConsignacao = HibernateUtil.currentSession().createQuery(sqlConsignacao);
    Query queryCobranca = HibernateUtil.currentSession().createQuery(sqlCobranca);

    queryConsignacao.setLong("idTitular", idTitular);
    queryConsignacao.setDate("dataAdesao", segurado.getDataAdesao());

    Date inicioCarencia = (Date) queryConsignacao.uniqueResult();

    if (inicioCarencia == null) {
      queryCobranca.setLong("idTitular", idTitular);
      queryCobranca.setDate("dataAdesao", segurado.getDataAdesao());
      inicioCarencia = (Date) queryCobranca.uniqueResult();
    }

    if (inicioCarencia != null) {
      System.out.println(segurado.getNumeroDoCartao() + " - " + inicioCarencia);
      segurado.setInicioDaCarencia(inicioCarencia);
      ImplDAO.save(segurado);
      return true;
    }
    return false;
  }
  @Test
  public void basicCRUD() {
    try {
      Actor actor = new Actor();
      actor.setFirstName("Arnold");
      actor.setLastName("Schwarzenegger");
      actor.setNickName("Arnie");
      Date date1 = new SimpleDateFormat("MM/dd/yy").parse("06/30/47");
      actor.setBirthDate(date1);

      getSession().save(actor);

      Query query = getSession().createQuery("from Actor where nickname=:nickname");
      query.setParameter("nickname", "Arnie");

      Actor arnie = (Actor) query.uniqueResult();
      assertEquals(2, arnie.getId());
      arnie.setNickName("Big Guy");
      getSession().save(arnie);

      query.setParameter("nickname", "Big Guy");
      Actor arnie2 = (Actor) query.uniqueResult();
      assertEquals("Version should match", 1, arnie2.getVersion());

      getSession().delete(actor);
      Actor arnie3 = (Actor) query.uniqueResult();
      assertEquals("Arnie should no longer exist!", null, arnie3);

    } catch (Exception ex) {
      logger.error("Excption thrown: ", ex.getMessage());
      assertTrue(ex.getMessage(), false);
      ex.printStackTrace();
    }
  }
Example #4
0
  @Test
  public void test() {
    String username = "******";
    String password = "******";

    String hqlSame = " from User u where u.username = '******' ";
    Query query = session.createQuery(hqlSame);
    User user = (User) query.uniqueResult();

    if (user == null) {

      String hqlId = " select u.userId from User u where u.userId >=ALL(select u.userId from u)";
      Query queryId = session.createQuery(hqlId);
      int id = (int) queryId.uniqueResult();

      id++;
      Transaction transaction = (Transaction) session.beginTransaction();
      session.save(new User(id, username, password, username + "_" + password, 0));
      Userditals ud = new Userditals();
      ud.setUser(user);
      ud.setUserId(id);
      ud.setRegdate(new Timestamp(System.currentTimeMillis()));
      session.save(ud);
      transaction.commit();
    } else {
      System.out.println("Óû§ÃûÖظ´£¡");
    }
  }
Example #5
0
  public FacturaAlmacen cierra(FacturaAlmacen factura, Usuario usuario)
      throws NoSePuedeCerrarException, NoSePuedeCerrarEnCeroException, NoEstaAbiertaException {
    if (factura != null) {
      if (factura.getEstatus().getNombre().equals(Constantes.ABIERTA)) {
        if (usuario != null) {
          factura.setAlmacen(usuario.getAlmacen());
        }

        Date fecha = new Date();
        factura.setIva(BigDecimal.ZERO);
        factura.setTotal(BigDecimal.ZERO);
        Query query =
            currentSession().createQuery("select e from Estatus e where e.nombre = :nombre");
        query.setString("nombre", Constantes.FACTURADA);
        Estatus facturada = (Estatus) query.uniqueResult();
        for (Salida salida : factura.getSalidas()) {
          salida.setEstatus(facturada);
          salida.setFechaModificacion(fecha);
          currentSession().update(salida);
          audita(salida, usuario, Constantes.FACTURADA, fecha);
          factura.setIva(factura.getIva().add(salida.getIva()));
          factura.setTotal(factura.getTotal().add(salida.getTotal()));
        }

        for (Entrada entrada : factura.getEntradas()) {
          entrada.setEstatus(facturada);
          entrada.setFechaModificacion(fecha);
          currentSession().update(entrada);
          audita(entrada, usuario, Constantes.FACTURADA, fecha);
          factura.setIva(factura.getIva().subtract(entrada.getIva()));
          factura.setTotal(factura.getTotal().subtract(entrada.getTotal()));
        }

        query.setString("nombre", Constantes.CERRADA);
        Estatus estatus = (Estatus) query.uniqueResult();
        factura.setEstatus(estatus);
        factura.setFolio(getFolio(factura.getAlmacen()));
        factura.setFechaModificacion(fecha);

        currentSession().update(factura);

        audita(factura, usuario, Constantes.ACTUALIZAR, fecha);

        currentSession().flush();
        return factura;
      } else {
        throw new NoEstaAbiertaException("No se puede actualizar una factura que no este abierta");
      }
    } else {
      throw new NoSePuedeCerrarException("No se puede cerrar la factura pues no existe");
    }
  }
Example #6
0
  /** 返回满足条件的文件数量(方法思路同UserDao中的userCount) (注意:File数据库中的name字段有".",不要忘了查询时的单引号) */
  public Long fileCount(
      String name, String s_screateDate, String s_ecreateDate, HttpSession httpSession)
      throws Exception {

    User u = (User) httpSession.getAttribute("u");

    Long total;
    if (StringUtil.isNotEmpty(name)
        || StringUtil.isNotEmpty(s_screateDate)
        || StringUtil.isNotEmpty(s_ecreateDate)) {
      // 需要查询的个数
      StringBuffer sqlBuffer =
          new StringBuffer("select count(*) from File file where file.user.id=" + u.getId() + " ");

      if (StringUtil.isNotEmpty(name)) {
        sqlBuffer.append("and file.name = '" + name + "' ");
      }

      if (StringUtil.isEmpty(s_screateDate)) {
        s_screateDate = "2010-01-01";
      }

      if (StringUtil.isEmpty(s_ecreateDate)) {
        // 如果s_ejoindate为空,设s_ejoindate为当前系统时间
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        s_ecreateDate = df.format(new Date());
      }

      SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // 小写的mm表示的是分钟
      Date begin = sdf.parse(s_screateDate);
      Date end = sdf.parse(s_ecreateDate);

      sqlBuffer.append("and file.createDate > :beginTime and file.createDate <= :endTime");
      Query q =
          sessionFactory
              .getCurrentSession()
              .createQuery(sqlBuffer.toString())
              .setTimestamp("beginTime", begin)
              .setTimestamp("endTime", end);
      total = (Long) q.uniqueResult();
    } else {
      // 总个数
      Query q =
          sessionFactory
              .getCurrentSession()
              .createQuery("select count(*) from File file where file.user.id=" + u.getId());
      total = (Long) q.uniqueResult();
    }
    System.out.println(total);
    return total;
  }
  @Override
  public String getAmountByShipmentTotalPriceAdj(String orderId) {
    Session session = getSession();
    StringBuilder sb = new StringBuilder();
    sb.append("select cd.amount from acoapp_oms.SHIPMENT_TOTALPRICE_ADJ cd");
    sb.append(" where cd.order_id = :orderId");
    Query q = session.createSQLQuery(sb.toString());
    q.setString("orderId", orderId);

    if (q.uniqueResult() == null) {
      return "0.00";
    } else {
      return q.uniqueResult().toString();
    }
  }
Example #8
0
  @Override
  public List<Forum> getForumsOfaUser(int userId) {
    // TODO Auto-generated method stub
    List<Forum> forums = new ArrayList<Forum>();
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Query query = session.createQuery("from Subscription where userId = :userId");
      query.setString("userId", String.valueOf(userId));
      List<Subscription> userSubscribedGroups = query.list();
      for (Subscription subsc : userSubscribedGroups) {
        query = session.createQuery("from Forum where forumId = :forumId");
        query.setParameter("forumId", subsc.getForumId());
        // add this to a list variable query.uniqueResult();
        forums.add((Forum) query.uniqueResult());
      }

    } catch (HibernateException e) {
      if (tx != null) {
        tx.rollback();
        e.printStackTrace();
      }
    } finally {
      session.close();
    }
    return forums;
  }
Example #9
0
 public User getUser(String username, String psd) {
   Session session = sessionFactory.getCurrentSession();
   Query q = session.createQuery(" from User u where username= :username and psd = :psd");
   q.setParameter("username", username);
   q.setParameter("psd", psd);
   return (User) q.uniqueResult();
 }
 @Override
 public Salary findSalaryById(Integer id) {
   Query query = getSession().createQuery("from Salary as s where s.id = ?");
   query.setString(0, id.toString());
   Salary s = (Salary) query.uniqueResult();
   return s;
 }
Example #11
0
 @SuppressWarnings("unchecked")
 public OrdemServico buscarPorId(final Long id) {
   Query q =
       sessionFactory
           .getCurrentSession()
           .createQuery(
               "SELECT h FROM "
                   + entityClass.getName()
                   + " h "
                   + "LEFT JOIN FETCH h.unidade u "
                   + "LEFT JOIN FETCH h.itemNotaFiscal inf "
                   + "LEFT JOIN FETCH u.equipamento e "
                   + "LEFT JOIN FETCH u.fabricante f "
                   + "LEFT JOIN FETCH u.laboratorio l "
                   + "LEFT JOIN FETCH h.placasFilhas pf "
                   + "LEFT JOIN FETCH pf.orcamento pfOrc "
                   + "LEFT JOIN FETCH pf.reparo pfRep "
                   + "LEFT JOIN FETCH pfOrc.listaDefeito "
                   + "LEFT JOIN FETCH pfRep.listaDefeito "
                   + "LEFT JOIN FETCH h.orcamento orc "
                   + "LEFT JOIN FETCH h.reparo rep "
                   + "LEFT JOIN FETCH orc.listaDefeito "
                   + "LEFT JOIN FETCH rep.listaDefeito WHERE h.id=:id");
   q.setParameter("id", id);
   OrdemServico r = (OrdemServico) q.uniqueResult();
   sessionFactory.getCurrentSession().flush();
   sessionFactory.getCurrentSession().clear();
   return r;
 }
 public Profile findProfileForEmployer(long id) {
   String queryString = "from EmployerProfile e where e.employer.id= :id ";
   Query query = getSession().createQuery(queryString);
   query.setLong("id", id);
   Profile profile = (Profile) query.uniqueResult();
   return profile;
 }
Example #13
0
 public static Friend findByUser(User user, User friend) {
   Session session = getSession();
   Query query = session.getNamedQuery("Friend.getByUser");
   query.setEntity("inviter", user);
   query.setEntity("invitee", friend);
   return (Friend) query.uniqueResult();
 }
Example #14
0
 public static Friend findByInviter(long id, User user) {
   Session session = getSession();
   Query query = session.getNamedQuery("Friend.getByInviter");
   query.setLong("id", id);
   query.setEntity("user", user);
   return (Friend) query.uniqueResult();
 }
Example #15
0
 public static Friend findByEmail(User user, String email) {
   Session session = getSession();
   Query query = session.getNamedQuery("Friend.getByEmail");
   query.setString("email", email);
   query.setEntity("user", user);
   return (Friend) query.uniqueResult();
 }
Example #16
0
  @SuppressWarnings("unchecked")
  public OrdemServico montarConjunto(final Long id) {
    Query q =
        sessionFactory
            .getCurrentSession()
            .createQuery(
                "SELECT h FROM "
                    + entityClass.getName()
                    + " h "
                    + "LEFT JOIN FETCH h.unidadePai u "
                    + "LEFT JOIN FETCH h.reparo rep "
                    + "LEFT JOIN FETCH h.orcamento orc "
                    + "WHERE h.id=:id");
    q.setParameter("id", id);
    OrdemServico r = (OrdemServico) q.uniqueResult();

    Query q2 =
        sessionFactory
            .getCurrentSession()
            .createQuery(
                "SELECT h FROM "
                    + entityClass.getName()
                    + " h "
                    + "LEFT JOIN FETCH h.unidadePai u "
                    + "LEFT JOIN FETCH h.reparo rep "
                    + "LEFT JOIN FETCH h.orcamento orc "
                    + "WHERE h.unidadePai.id=:id");
    q2.setParameter("id", id);
    List<OrdemServico> pFilhas = q2.list();

    r.setPlacasFilhas(new HashSet<OrdemServico>());
    r.getPlacasFilhas().addAll(pFilhas);
    return r;
  }
Example #17
0
  @SuppressWarnings("unchecked")
  public OrdemServico buscarConsultaId(final Long id) {
    System.out.println("QUERY DA CONSULTA - INICIO");

    Query q =
        sessionFactory
            .getCurrentSession()
            .createQuery(
                "SELECT h FROM "
                    + entityClass.getName()
                    + " h "
                    + "LEFT JOIN FETCH h.unidade u "
                    + "LEFT JOIN FETCH u.fabricante f "
                    + "LEFT JOIN FETCH u.equipamento e "
                    + "LEFT JOIN FETCH u.laboratorio l "
                    + "LEFT JOIN FETCH h.notaFiscal nf "
                    + "LEFT JOIN FETCH nf.cliente c "
                    + "LEFT JOIN FETCH h.orcamento orc "
                    + "LEFT JOIN FETCH h.reparo rep "
                    + "LEFT JOIN FETCH h.proposta p "
                    + "LEFT JOIN FETCH p.contato cont "
                    + "LEFT JOIN FETCH h.notaFiscalSaida nfs "
                    + "LEFT JOIN FETCH nfs.cliente nfsc "
                    + "LEFT JOIN FETCH nfs.transportador nfst "
                    + "WHERE h.id=:id");
    q.setParameter("id", id);
    OrdemServico r = (OrdemServico) q.uniqueResult();
    System.out.println("QUERY DA CONSULTA - FIM");
    SessionStatistics sessionStats = sessionFactory.getCurrentSession().getStatistics();
    Statistics stats = this.sessionFactory.getStatistics();
    System.out.println(stats);
    return r;
  }
Example #18
0
 @Override
 public User findByNameAndPassword(String name, String password) {
   Query query = session.createQuery(BY_NAME_AND_PASSWORD_QUERY);
   query.setString("name", name);
   query.setString("password", password);
   return (User) query.uniqueResult();
 }
  @Override
  public CommentModel findByIdWithHQLQuery(int commentId) {
    // Query all properties from model.
    Session session = sessionFactory.getCurrentSession();
    Query query = session.createQuery("FROM CommentModel WHERE commentId=:commentId");
    query.setParameter("commentId", commentId);
    CommentModel result = (CommentModel) query.uniqueResult();

    // Query partial properties from model.
    query =
        session.createQuery(
            "SELECT new CommentModel(commentContent,commentAuthor) FROM CommentModel WHERE commentId=:commentId");
    query.setParameter("commentId", commentId);
    result = (CommentModel) query.uniqueResult();
    return result;
  }
 // User defined finders/Buscadores definidos por el usuario
 public static FilterBySubfamily findBy() throws javax.ejb.ObjectNotFoundException {
   if (XavaPreferences.getInstance().isJPAPersistence()) {
     javax.persistence.Query query =
         org.openxava.jpa.XPersistence.getManager().createQuery("from FilterBySubfamily as o");
     try {
       return (FilterBySubfamily) query.getSingleResult();
     } catch (Exception ex) {
       // In this way in order to work with Java pre 5
       if (ex.getClass().getName().equals("javax.persistence.NoResultException")) {
         throw new javax.ejb.ObjectNotFoundException(
             XavaResources.getString("object_not_found", "FilterBySubfamily"));
       } else {
         ex.printStackTrace();
         throw new RuntimeException(ex.getMessage());
       }
     }
   } else {
     org.hibernate.Query query =
         org.openxava.hibernate.XHibernate.getSession().createQuery("from FilterBySubfamily as o");
     FilterBySubfamily r = (FilterBySubfamily) query.uniqueResult();
     if (r == null) {
       throw new javax.ejb.ObjectNotFoundException(
           XavaResources.getString("object_not_found", "FilterBySubfamily"));
     }
     return r;
   }
 }
Example #21
0
 @Override
 public Member memberLogin(String login, String password) throws Exception {
   Session session = HibernateUtil.getSession();
   Transaction tx = null;
   Member member = null;
   try {
     String hql = "SELECT a FROM Member AS a WHERE a.login=:login AND a.password=:password";
     Query query = session.createQuery(hql);
     query.setString("login", login.trim());
     query.setString("password", password.trim());
     query.setMaxResults(1);
     tx = session.beginTransaction();
     member = (Member) query.uniqueResult();
     if (member != null && ("y").equals(member.getActivated().toLowerCase())) {
       member.setLoginTimes(Integer.valueOf(member.getLoginTimes() + 1));
       member.setLastLogin(new Date());
       session.update(member);
     }
     tx.commit();
   } catch (Exception ex) {
     if (tx != null) tx.rollback();
     logger.info("In class MemberServiceImpl:memberLogin()\n");
     ex.printStackTrace();
   } finally {
     HibernateUtil.closeSession();
   }
   return member;
 }
Example #22
0
 public Content getSide(
     Integer id, Integer siteId, Integer channelId, boolean next, boolean cacheable) {
   Finder f = Finder.create("from Content bean where 1=1");
   if (channelId != null) {
     f.append(" and bean.channel.id=:channelId");
     f.setParam("channelId", channelId);
   } else if (siteId != null) {
     f.append(" and bean.site.id=:siteId");
     f.setParam("siteId", siteId);
   }
   if (next) {
     f.append(" and bean.id>:id");
     f.setParam("id", id);
     f.append(" and bean.status=" + ContentCheck.CHECKED);
     f.append(" order by bean.id asc");
   } else {
     f.append(" and bean.id<:id");
     f.setParam("id", id);
     f.append(" and bean.status=" + ContentCheck.CHECKED);
     f.append(" order by bean.id desc");
   }
   Query query = f.createQuery(getSession());
   query.setCacheable(cacheable).setMaxResults(1);
   return (Content) query.uniqueResult();
 }
Example #23
0
 private String getFolio(Almacen almacen) {
   Query query =
       currentSession()
           .createQuery(
               "select f from Folio f where f.nombre = :nombre and f.almacen.id = :almacenId");
   query.setString("nombre", "FACTURA");
   query.setLong("almacenId", almacen.getId());
   query.setLockOptions(LockOptions.UPGRADE);
   Folio folio = (Folio) query.uniqueResult();
   if (folio == null) {
     folio = new Folio("FACTURA");
     folio.setAlmacen(almacen);
     currentSession().save(folio);
     return getFolio(almacen);
   }
   folio.setValor(folio.getValor() + 1);
   java.text.NumberFormat nf = java.text.DecimalFormat.getInstance();
   nf.setGroupingUsed(false);
   nf.setMinimumIntegerDigits(9);
   nf.setMaximumIntegerDigits(9);
   nf.setMaximumFractionDigits(0);
   StringBuilder sb = new StringBuilder();
   sb.append("FA-");
   sb.append(almacen.getEmpresa().getOrganizacion().getCodigo());
   sb.append(almacen.getEmpresa().getCodigo());
   sb.append(almacen.getCodigo());
   sb.append(nf.format(folio.getValor()));
   return sb.toString();
 }
  public PersonalPointScore getPersonalPointScoreByDate(String email, Date date) {
    Query query = getQuery("from PersonalPointScore p where p.member.email=? and p.createDate=?");
    query.setString(0, email);
    query.setParameter(1, date);

    return (PersonalPointScore) query.uniqueResult();
  }
Example #25
0
  public int getCountOfSubscribers(int forumId, int userId) {
    // TODO Auto-generated method stub
    Session session = this.sessionFactory.openSession();
    Transaction tx = null;
    int countOfSubscribers = 0;
    try {
      tx = session.beginTransaction();
      Query query = null;
      if (userId == 0) {
        query = session.createQuery("select count(*) from Subscription where forumId = :forumId");
        query.setParameter("forumId", forumId);
      } else {
        query =
            session.createQuery(
                "select count(*) from Subscription where forumId = :forumId and userId = :userId");
        query.setParameter("forumId", forumId);
        query.setParameter("userId", userId);
      }

      Long count = (Long) query.uniqueResult();
      countOfSubscribers = count.intValue();
      // System.out.println("No of subscribers.."+countOfSubscribers);
    } catch (HibernateException e) {
      if (tx != null) {
        tx.rollback();
        e.printStackTrace();
      }
    } finally {
      session.close();
    }
    return countOfSubscribers;
  }
Example #26
0
  public Hyjbxx getUserById(Integer id) {
    String sql = "from Hyjbxx h where h.hyjbxxid=?";
    Query query = this.getQuery(sql);
    query.setParameter(0, id);

    return (Hyjbxx) query.uniqueResult();
  }
Example #27
0
 // User defined finders/Buscadores definidos por el usuario
 public static Size findById(int id) throws javax.ejb.ObjectNotFoundException {
   if (XavaPreferences.getInstance().isJPAPersistence()) {
     javax.persistence.Query query =
         org.openxava.jpa.XPersistence.getManager()
             .createQuery("from Size as o where o.id = :arg0");
     query.setParameter("arg0", new Integer(id));
     try {
       return (Size) query.getSingleResult();
     } catch (Exception ex) {
       // In this way in order to work with Java pre 5
       if (ex.getClass().getName().equals("javax.persistence.NoResultException")) {
         throw new javax.ejb.ObjectNotFoundException(
             XavaResources.getString("object_not_found", "Size"));
       } else {
         ex.printStackTrace();
         throw new RuntimeException(ex.getMessage());
       }
     }
   } else {
     org.hibernate.Query query =
         org.openxava.hibernate.XHibernate.getSession()
             .createQuery("from Size as o where o.id = :arg0");
     query.setParameter("arg0", new Integer(id));
     Size r = (Size) query.uniqueResult();
     if (r == null) {
       throw new javax.ejb.ObjectNotFoundException(
           XavaResources.getString("object_not_found", "Size"));
     }
     return r;
   }
 }
Example #28
0
 public int getMessageSizeByToId(int toId) {
   String sql = "select count(*) from Message m where m.toid=?";
   Query query = this.getQuery(sql);
   query.setParameter(0, toId);
   Object count = query.uniqueResult();
   return ((Long) count).intValue();
 }
  public Pager findAllUnconfirmedByProbationUnitId(
      String referenceId, Integer start, Integer size) {
    Pager pager = new Pager();

    start = (start == null) ? 0 : start;
    pager.setStart(start);

    size = (size == null) ? Pager.DEFAULT_PAGE_SIZE : size;
    pager.setSize(size);

    Query queryCount =
        getSession()
            .createQuery(
                "select count(ct) from ChildTransfer ct,LamaNivasa tl,ProbationUnit p where ct.toLamaNivasaId.id = tl.id and tl.probationUnit.id=p.id and p.id= :pid and ct.status=0");
    queryCount.setParameter("pid", referenceId);
    int listCount = ((Long) queryCount.uniqueResult()).intValue();
    pager.setTotal(listCount);

    Query query =
        getSession()
            .createQuery(
                "select ct from ChildTransfer ct,LamaNivasa tl,ProbationUnit p where ct.toLamaNivasaId.id = tl.id and tl.probationUnit.id=p.id and p.id= :pid and ct.status=0");

    query.setParameter("pid", referenceId);
    query.setFirstResult(start);
    query.setMaxResults(size);
    @SuppressWarnings("unchecked")
    List<ChildTransfer> list = query.list();

    pager.setList(list);

    return pager;
  }
Example #30
0
 public int getBuySizeMessageByType(int type) {
   String sql = "select count(*) from Message m where m.type=?";
   Query query = this.getQuery(sql);
   query.setParameter(0, type);
   Object count = query.uniqueResult();
   return ((Long) count).intValue();
 }