Example usage for org.hibernate Query setString

Introduction

In this page you can find the example usage for org.hibernate Query setString.

Prototype

@Deprecated
@SuppressWarnings("unchecked")
default Query<R> setString(String name, String val)

Source Link

Document

Bind a named String-valued parameter.

Usage

From source file:com.appeligo.alerts.KeywordAlert.java

License:Apache License

@SuppressWarnings("unchecked")
public static KeywordAlert getByNormalizedQuery(User user, String query) {
    Permissions.checkUser(user);/* w  ww . j  a  v a  2  s  .c  o  m*/
    Session session = getSession();
    Query hqlQuery = session.getNamedQuery("KeywordAlert.getByNormalizedQuery");
    hqlQuery.setLong("userId", user.getUserId());
    hqlQuery.setString("normalizedQuery", query);
    List<KeywordAlert> programAlerts = hqlQuery.list();
    if (programAlerts.size() > 0) {
        return programAlerts.get(0);
    } else {
        return null;
    }
}

From source file:com.appeligo.alerts.KeywordMatch.java

License:Apache License

public static KeywordMatch getKeywordMatch(long keywordAlertId, String programId) {
    Session session = getSession();/*  ww w. ja  v  a2s .  c o m*/
    Query query = session.getNamedQuery("KeywordMatch.getKeywordMatch");
    query.setLong("keywordAlertId", keywordAlertId);
    query.setString("programId", programId);
    return (KeywordMatch) query.uniqueResult();
}

From source file:com.appeligo.alerts.ProgramAlert.java

License:Apache License

public static void markDeletedForProgram(User user, String programId) {
    Permissions.checkUser(user);/* w w  w.  j  a va2s.c  o m*/
    Session session = getSession();
    Query query = session.getNamedQuery("ProgramAlert.markDeletedForProgram");
    query.setEntity("user", user);
    query.setString("programId", programId);
    query.executeUpdate();
}

From source file:com.appeligo.alerts.ProgramAlert.java

License:Apache License

@SuppressWarnings("unchecked")
public static List<ProgramAlert> getByProgramId(User user, String programId) {
    Permissions.checkUser(user);//from   w w  w  .  j  a  v a 2s.  c o m
    Session session = getSession();
    Query query = session.getNamedQuery("ProgramAlert.getByProgramIdForUser");
    query.setEntity("user", user);
    query.setString("programId", programId);
    List<ProgramAlert> programAlerts = query.list();
    return programAlerts;
}

From source file:com.appeligo.search.entity.Favorite.java

License:Apache License

public static Favorite findFavoriteProgram(User user, String programId) {
    Permissions.checkUser(user);/*from   w  ww . ja  v  a  2 s.  c o  m*/
    Session session = getSession();
    Query query = session.getNamedQuery("Favorite.getProgram");
    query.setEntity("user", user);
    query.setString("programId", programId);
    return (Favorite) query.uniqueResult();
}

From source file:com.appeligo.search.entity.Friend.java

License:Apache License

public static Friend findByEmail(User user, String email) {
    Session session = getSession();//from   ww  w . ja  v  a2s.  c o m
    Query query = session.getNamedQuery("Friend.getByEmail");
    query.setString("email", email);
    query.setEntity("user", user);
    return (Friend) query.uniqueResult();
}

From source file:com.appeligo.search.entity.Friend.java

License:Apache License

@SuppressWarnings("unchecked")
public static List<Friend> findInvites(User user) {
    Session session = getSession();/*from w ww.  j a v a 2s.  c  o m*/
    Query query = session.getNamedQuery("Friend.getInvites");
    query.setString("email", user.getPrimaryEmail());
    query.setEntity("invitee", user);
    return query.list();
}

From source file:com.appeligo.search.entity.Friend.java

License:Apache License

public static int getInviteCount(User user) {
    Session session = getSession();/*w w  w .ja v a2 s  .co  m*/
    Query query = session.getNamedQuery("Friend.getInviteCount");
    query.setString("email", user.getPrimaryEmail());
    return (Integer) query.uniqueResult();
}

From source file:com.appeligo.search.entity.Rating.java

License:Apache License

public static Rating findProgramRating(User user, String programId) {
    Permissions.checkUser(user);//  w  ww .  java 2 s. c  om
    Session session = getSession();
    Query query = session.getNamedQuery("Rating.getProgram");
    query.setEntity("user", user);
    query.setString("programId", programId);
    return (Rating) query.uniqueResult();
}

From source file:com.appeligo.search.entity.ToNotify.java

License:Apache License

/**
 * /*  ww  w. j av a  2 s .c  o m*/
 * @param email
 * @return
 */
public static ToNotify findByEmail(String email) {
    Session session = getSession();
    Query query = session.getNamedQuery("ToNotify.findByEmail");
    query.setString("email", email);
    return (ToNotify) query.uniqueResult();
}