Example usage for com.liferay.portal.kernel.dao.orm Query setString

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm Query setString.

Prototype

public Query setString(String name, String value);

Source Link

Usage

From source file:com.liferay.mail.service.persistence.CyrusVirtualPersistenceImpl.java

License:Open Source License

public List<CyrusVirtual> findByUserId(long userId) throws SystemException {
    Session session = null;// ww w .j  a  v  a2 s . co  m

    try {
        session = openSession();

        Query q = session.createQuery(FIND_BY_USER_ID);

        q.setString(0, String.valueOf(userId));

        return q.list();
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.mail.service.persistence.CyrusVirtualPersistenceImpl.java

License:Open Source License

public void removeByUserId(long userId) throws SystemException {
    Session session = null;/*from  w w w  . jav  a 2 s  . co m*/

    try {
        session = openSession();

        Query q = session.createQuery(FIND_BY_USER_ID);

        q.setString(0, String.valueOf(userId));

        Iterator<CyrusVirtual> itr = q.iterate();

        while (itr.hasNext()) {
            CyrusVirtual virtual = itr.next();

            session.delete(virtual);
        }

        closeSession(session);
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}

---