Examples of DBValueExpr


Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param dataType the data type of the column
     * @return true if the column was successfully added or false otherwise
     */
    protected final DBViewColumn addColumn(String columnName, DataType dataType)
    { // find column by name
        return new DBViewColumn(this, columnName, new DBValueExpr(db, null, dataType));
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     *
     * @return a DBValueExpr object
     */
    public DBValueExpr getSystemDateExpr()
    {
        return new DBValueExpr(this, SYSDATE, DataType.DATETIME);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the String value
     * @return the new DBValueExpr object
     */
    public DBValueExpr getValueExpr(String value)
    {
        return new DBValueExpr(this, value, DataType.TEXT);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the Boolean value
     * @return the new DBValueExpr object
     */
    public DBValueExpr getValueExpr(boolean value)
    {
        return new DBValueExpr(this, value, DataType.BOOL);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the int value
     * @return the new DBValueExpr object
     */
    public DBValueExpr getValueExpr(int value)
    {
        return new DBValueExpr(this, Integer.valueOf(value), DataType.INTEGER);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the long value
     * @return the new DBValueExpr object
     */
    public DBValueExpr getValueExpr(long value)
    {
        return new DBValueExpr(this, Long.valueOf(value), DataType.INTEGER);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param dataType the database systems data type used for this value
     * @return the new DBValueExpr object
     */
    public DBValueExpr getValueExpr(Object value, DataType dataType)
    {
        return new DBValueExpr(this, value, dataType);
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the Object value
     * @return the new DBCompareColExpr object
     */
    public DBCompareColExpr likeUpper(String value)
    {
        DBValueExpr expr = new DBValueExpr(getDatabase(), value, DataType.TEXT);
        return new DBCompareColExpr(this.upper(), DBCmpType.LIKE, expr.upper());
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param value the Object value
     * @return the new DBCompareColExpr object
     */
    public DBCompareColExpr likeLower(String value)
    {
        DBValueExpr expr = new DBValueExpr(getDatabase(), value, DataType.TEXT);
        return new DBCompareColExpr(this.lower(), DBCmpType.LIKE, expr.lower());
    }
View Full Code Here

Examples of org.apache.empire.db.expr.column.DBValueExpr

     * @param escape the escape character
     * @return the new DBCompareColExpr object
     */
    public DBCompareColExpr like(String value, char escape)
    {
        DBValueExpr  textExpr = new DBValueExpr(getDatabase(), value, DataType.TEXT);
        DBFuncExpr escapeExpr = new DBFuncExpr(textExpr, DBDatabaseDriver.SQL_FUNC_ESCAPE, new Object[] { String.valueOf(escape) }, getUpdateColumn(), false, DataType.TEXT );
        return cmp(DBCmpType.LIKE, escapeExpr);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.