List of where() Examples

Examples of where()

br.com.objectos.comuns.relational.search.Join.where()
com.adaptrex.core.ext.data.Store.where()
com.atlassian.jira.jql.builder.JqlQueryBuilder.where()
com.baasbox.util.QueryParams.where()
com.boco.bomc.vpn.db.bean.QueryCondition.where()
com.datastax.driver.core.querybuilder.Delete.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Select.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.Assignments.where()
com.mysema.query.jpa.hibernate.HibernateQuery.where()
com.mysema.query.jpa.impl.JPAQuery.where()
com.mysema.query.sql.dml.SQLDeleteClause.where()
com.mysema.query.sql.dml.SQLUpdateClause.where()
com.mysql.clusterj.query.QueryDomainType.where()
com.taobao.tdhs.client.easy.Query.where()
start where condition for index @return Where
com.workingdogs.village.TableDataSet.where()
Sets the value for the SQL portion of the WHERE statement @param where TODO: DOCUMENT ME! @return instance of self @throws DataSetException TODO: DOCUMENT ME!
javax.persistence.criteria.CriteriaDelete.where()
Modify the query to restrict the target of the deletion according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.CriteriaQuery.where()
javax.persistence.criteria.CriteriaUpdate.where()
Modify the query to restrict the target of the update according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.Subquery.where()
Modify the subquery to restrict the result according to the specified boolean expression. Replaces the previously added restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method. @param restriction a simple or compound boolean expression @return the modified subquery
net.sf.domainbeans.operation.annotation.Db.query.where()
nl.giantit.minecraft.database.query.DeleteQuery.where()
org.apache.empire.db.DBCommand.where()
Adds a compare expression to the list of constraints. If another restriction already exists for the same column it will be replaced. @param expr the DBCompareExpr object
org.apache.gora.sql.statement.Delete.where()
org.apache.isis.applib.annotation.Disabled.where()
org.apache.isis.applib.annotation.Hidden.where()
org.apache.isis.core.metamodel.facets.all.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacetAbstract.where()
org.apache.isis.core.progmodel.facets.members.hidden.HiddenFacetAbstract.where()
org.apache.juddi.query.util.DynamicQuery.WHERE()
org.apache.metamodel.query.Query.where()
org.apache.openjpa.jdbc.sql.Select.where()
Add the given where conditions.
org.apache.openjpa.persistence.query.DomainObject.where()
org.apache.openjpa.persistence.query.QueryDefinition.where()
Modifies the query definition to restrict the result of the query according to the specified predicate. Replaces the previously added restriction(s), if any. @param predicate -a simple or compound conditional predicate @return the modified QueryDefinition instance
org.apache.torque.criteria.Criteria.where()
"AND"s Criterion object with the conditions in this Criteria. Equivalent to #and(Criterion) but better to read if this is the first condition to be added to the Criteria. @param criterion A Criterion object. @return A modified Criteria object.
org.beangle.model.query.builder.OqlBuilder.where()
org.jboss.test.deployers.scope.support.TestClassAnnotation.where()
org.nutz.dao.sql.Criteria.where()
org.nutz.dao.util.cri.SimpleCriteria.where()
pt.webdetails.cpf.persistence.Filter.where()

Examples of org.apache.empire.db.DBCommand.where()

        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns
        cmd.select(T_EMP.getColumns());
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));


        // Query Records and print output
        DBReader reader = new DBReader();
        try
        {   // Open Reader

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

        cmd.join(T_EDH.C_EMPLOYEE_ID, Q_MAX_DATE.findQueryColumn(T_EDH.C_EMPLOYEE_ID))
          .where(T_EDH.C_DATE_FROM.is(Q_MAX_DATE.findQueryColumn(MAX_DATE_FROM)));
        cmd.join(T_EMP.C_EMPLOYEE_ID, T_EDH.C_EMPLOYEE_ID);
        cmd.join(T_DEP.C_DEPARTMENT_ID, T_EDH.C_DEPARTMENT_ID);
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));
        // Set Order
        cmd.orderBy(T_EMP.C_LASTNAME);
        cmd.orderBy(T_EMP.C_FIRSTNAME);


        // Query Records and print output

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

        if (department != null)
        {
            comp = comp.and(T_EMP.DEPARTMENT_ID.is(department));
        }


        cmd.where(comp);


        DBReader reader = new DBReader();
        reader.open(cmd, conn);
        List<Employee> lst = reader.getBeanList(Employee.class);
        return lst;

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

            boolean allNull = true;
            DBColumn[] idxColumns = idx.getColumns();
            for (int i=0; i<idxColumns.length; i++)
            {   // Check if column has changed
                Object value = record.getValue(idxColumns[i]);
                cmd.where(idxColumns[i].is(value));
                if (value!=null)
                    allNull = false;
            }
            // Check whether all constraints are null
            if (allNull)

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                {   // Multiple key columns
                    Object value = record.getValue(keyColumns[0]);
                    DBCompareExpr notExpr = keyColumns[0].is(value);
                    for (int i=1; i<keyColumns.length; i++)
                    {   // Check if column has changed
                        cmd.where(keyColumns[i].is(value));
                    }
                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                    DBCompareExpr notExpr = keyColumns[0].is(value);
                    for (int i=1; i<keyColumns.length; i++)
                    {   // Check if column has changed
                        cmd.where(keyColumns[i].is(value));
                    }
                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column
                    Object value = record.getValue(keyColumns[0]);
                    cmd.where(keyColumns[0].isNot(value));

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column
                    Object value = record.getValue(keyColumns[0]);
                    cmd.where(keyColumns[0].isNot(value));
                }
            }
            // Query now
            DBReader reader = new DBReader();
            try {

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

            for (Object[] item : items)
            {
                keys[i++] = StringUtils.arrayToString(item, "");
            }
            if (isInvertSelection())
                cmd.where(keyExpr.notIn(keys));
            else
                cmd.where(keyExpr.in(keys));
        }
        // clear previous settings without the where causes
        cmd.clearSelect();

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                keys[i++] = StringUtils.arrayToString(item, "");
            }
            if (isInvertSelection())
                cmd.where(keyExpr.notIn(keys));
            else
                cmd.where(keyExpr.in(keys));
        }
        // clear previous settings without the where causes
        cmd.clearSelect();
        cmd.clearGroupBy();
        // clear skip and limit!

View Full Code Here

Examples of org.apache.gora.sql.statement.Delete.where()

  }


  @Override
  public long deleteByQuery(Query<K, T> query) throws IOException {
    Delete delete = new Delete().from(sqlTable.getName());
    delete.where(constructWhereClause(query));


    PreparedStatement statement = null;
    try {
      statement = connection.prepareStatement(delete.toString());
      setParametersForPreparedStatement(statement, query);

View Full Code Here

0 1 2 3 4 5 6 7 8

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.