Examples of DBQuery

com.manatee.multiple.v2.db.DbQuery
@author 6806291@google.com (Gary Lee) @QQ 6806291 @date 2012-10-24
jodd.db.DbQuery
Encapsulates {@link Statement} and all its operations.
It may be:
- used in an un-managed way, created directly from connection;
- managed by {@link DbSession};
- managed by {@link jodd.db.DbThreadSession} i.e. {@link ThreadDbSessionHolder}.
Query life-cycle states:
- 1) created: statement == null, initialized == false
- 2) initialized: statement != null, initialized == true
- 3) closed: statement == null, initialized == true
org.apache.empire.db.DBQuery
This class can be used to wrap a query from a DBCommand and use it like a DBRowSet.
You may use this class for two purposes:
- In oder to define subqueries simply define a command object with the subquery and wrap it inside a DBQuery. Then in a second command object you can reference this Query to join with your other tables and views. In order to join other columns with your query use findQueryColumn(DBColumnExpr expr) to get the query column object for a given column expression in the original select clause.
- With a key supplied you can have an updateable query that will update several records at once.
org.olat.core.commons.persistence.DBQuery
A DBQuery is @author Andreas

Examples of org.olat.core.commons.persistence.DBQuery

   * @see org.olat.group.context.BGContextManager#countGroupsOfType(java.lang.String)
   */
  public int countGroupsOfType(String groupType) {
    DB db = DBFactory.getInstance();
    String q = "select count(bg) from org.olat.group.BusinessGroupImpl bg where bg.type = :type";
    DBQuery query = db.createQuery(q);
    query.setString("type", groupType);
    return ((Long) query.list().get(0)).intValue();
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

   *      org.olat.group.context.BGContext)
   */
  public BusinessGroup findGroupOfBGContext(String groupName, BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select bg from org.olat.group.BusinessGroupImpl bg where bg.groupContext = :context and bg.name = :name";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    query.setString("name", groupName);
    List results = query.list();
    if (results.size() == 0) return null;
    return (BusinessGroup) results.get(0);
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

  public BusinessGroup findGroupAttendedBy(Identity identity, String groupName, BGContext bgContext) {
    String query = "select bgi from " + "  org.olat.group.BusinessGroupImpl as bgi "
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl as sgmi" + " where bgi.name = :name "
        + " and bgi.partipiciantGroup =  sgmi.securityGroup" + " and sgmi.identity = :identId" + " and bgi.groupContext = :context";
    DB db = DBFactory.getInstance();
    DBQuery dbq = db.createQuery(query);
    dbq.setEntity("identId", identity);
    dbq.setString("name", groupName);
    dbq.setEntity("context", bgContext);
    List res = dbq.list();
    if (res.size() == 0) return null;
    else if (res.size() > 1) throw new AssertException("more than one result row found for (identity, groupname, context) ("
        + identity.getName() + ", " + groupName + ", " + bgContext.getName());
    return (BusinessGroup) res.get(0);
  }

View Full Code Here

Examples of org.olat.core.commons.persistence.DBQuery

  public List getBGOwnersOfBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select distinct id from org.olat.basesecurity.IdentityImpl as id inner join fetch id.user as iuser"
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl sgm" + ", org.olat.group.BusinessGroupImpl bg"
        + " where bg.groupContext = :context" + " and bg.ownerGroup = sgm.securityGroup" + " and sgm.identity = id";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    return query.list();
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.