示例#1
0
  public static List<Node> findRootNodes(long regionId) {
    EntityManager em = Node.entityManager();
    TypedQuery<Node> q =
        em.createQuery(
            "SELECT o FROM Node AS o WHERE o.parent IS NULL AND dtype = 'Node'", Node.class);
    Node root = q.getSingleResult();

    return findNodesByParent(root, regionId);
  }
 public User findUser(long id) {
   TypedQuery<User> query =
       entityManager.createQuery("SELECT u FROM User u WHERE u.id = " + id + "", User.class);
   try {
     User u = query.getSingleResult();
     u.setPermissions("root"); // TODO: dit moet natuurlijk anders! (moet uit de DB komen)
     return u;
   } catch (NoResultException e) {
   }
   return null;
 }
  @Override
  public Withdrawal get(Trading trading, Currency currency) {
    TypedQuery<Withdrawal> query =
        (TypedQuery<Withdrawal>)
            em.createQuery(
                "SELECT w FROM Withdrawal w WHERE w.pk.trading=:trading AND w.pk.currency=:currency");
    query.setParameter("trading", trading);
    query.setParameter("currency", currency);

    try {
      return query.getSingleResult();
    } catch (NoResultException e) {
      return null;
    }
  }
 public User findUser(String username, String passwd) {
   try {
     TypedQuery<User> query =
         entityManager.createQuery(
             "SELECT u FROM User u WHERE u.username = :username and u.passwd=:passwd", User.class);
     query.setParameter("username", username);
     query.setParameter("passwd", passwd);
     User u = query.getSingleResult();
     u.setPermissions("root"); // TODO: dit moet natuurlijk anders! (moet uit de DB komen)
     return u;
   } catch (NoResultException e) {
     e.printStackTrace();
   }
   return null;
 }