示例#1
0
 @Override
 public List<Bet> getAllBets() {
   Session session = getSessionFactory().getCurrentSession();
   Transaction tx = null;
   List<Bet> bets = null;
   try {
     tx = session.beginTransaction();
     Query query = session.createQuery("from Bet");
     bets = (List<Bet>) query.list();
     java.util.Iterator<Bet> iter = bets.iterator();
     System.out.println(bets);
     while (iter.hasNext()) {
       Bet bet = iter.next();
       System.out.println(
           "Bet: \""
               + bet.getId()
               + "\", "
               + bet.getDate()
               + "\", "
               + bet.getHomeCommand()
               + "\", "
               + bet.getScore()
               + bet.getDate().getClass());
     }
     tx.commit();
   } catch (HibernateException e) {
     if (tx != null) {
       tx.rollback();
     }
     e.printStackTrace();
   } finally {
     if (session.isOpen()) {
       session.close();
     }
   }
   return bets;
 }
示例#2
0
  @Override
  public void updateBet(Bet bet) {
    System.out.println(bet);
    Session session = getSessionFactory().getCurrentSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Query query =
          session.createQuery(
              "update Bet "
                  + "set date = :date,"
                  + "score = :score,"
                  + "homeCommand = :homeCommand,"
                  + "guestCommand = :guestCommand,"
                  + "koef = :koef,"
                  + "league = :league,"
                  + "result = :result,"
                  + "type = :type,"
                  + "value = :value"
                  + " where id = :id ");
      query.setParameter("id", bet.getId());
      query.setParameter("date", bet.getDate());
      query.setParameter("score", bet.getScore());
      query.setParameter("homeCommand", bet.getHomeCommand());
      query.setParameter("guestCommand", bet.getGuestCommand());
      query.setParameter("koef", bet.getKoef());
      query.setParameter("league", bet.getLeague());
      query.setParameter("result", bet.getResult());
      query.setParameter("type", bet.getType());
      query.setParameter("value", bet.getValue());

      int result = query.executeUpdate();
      System.out.println(result);
      tx.commit();
    } catch (HibernateException e) {
      if (tx != null) {
        tx.rollback();
      }
      e.printStackTrace();
    } finally {
      if (session.isOpen()) {
        session.close();
      }
    }
  }