Examples of org.apache.empire.db.expr.compare.DBCompareColExpr

org.apache.empire.db.expr.compare.DBCompareColExpr

This class is used for defining filter constraints based on a column expression in SQL

There is no need to explicitly create instances of this class.
Instead use any of the following functions:
{@link DBColumnExpr#is(Object) }, {@link DBColumnExpr#isBetween(Object,Object) }, {@link DBColumnExpr#isGreaterThan(Object) }, {@link DBColumnExpr#isLessOrEqual(Object) }, {@link DBColumnExpr#isMoreOrEqual(Object) }, {@link DBColumnExpr#isNot(Object) }, {@link DBColumnExpr#isNotBetween(Object,Object) }, {@link DBColumnExpr#isSmallerThan(Object) }, {@link DBColumnExpr#like(Object) }, {@link DBColumnExpr#like(String,char) }, {@link DBColumnExpr#likeLower(String) }, {@link DBColumnExpr#likeUpper(String) }

            for (i = 0; cmd.where != null && i < cmd.where.size(); i++)
            {
                DBCompareExpr cmp = cmd.where.get(i);
                if (cmp instanceof DBCompareColExpr)
                {   // Check whether constraint belongs to update table
                    DBCompareColExpr cmpExpr = (DBCompareColExpr) cmp;
                    DBColumn col = cmpExpr.getColumnExpr().getUpdateColumn();
                    if (col!=null && col.getRowSet() == table)
                    {  // add the constraint
                      if (cmpExpr.getValue() instanceof DBCmdParam)
                      {  // Create a new command param
                        DBColumnExpr colExpr = cmpExpr.getColumnExpr();
                        DBCmdParam param =(DBCmdParam)cmpExpr.getValue(); 
                        DBCmdParam value = upd.addParam(colExpr, param.getValue());
                        cmp = new DBCompareColExpr(colExpr, cmpExpr.getCmpop(), value);
                      }
                        upd.where(cmp);
                    }    
                } 
                else

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.

Examples of org.apache.empire.db.expr.compare.DBCompareColExpr

Related Classes of org.apache.empire.db.expr.compare.DBCompareColExpr