javatools.db
Class DbMiscExpr

java.lang.Object
  |
  +--javatools.db.DbExpr
        |
        +--javatools.db.DbMiscExpr

public class DbMiscExpr

extends DbExpr

An SQL expression of the form FUNCNAME(parameter....).

Field Summary

(package private) java.lang.Object[]	args
(package private) java.lang.String	func

Fields inherited from class javatools.db.DbExpr

db

Constructor Summary

DbMiscExpr(DbDatabase db, java.lang.String func)

DbMiscExpr(DbDatabase db, java.lang.String func, java.lang.Object arg1)

DbMiscExpr(DbDatabase db, java.lang.String func, java.lang.Object arg1, java.lang.Object arg2)

Method Summary

java.lang.String	getQueryString() Any DbExpr needs to be able to convert into the SQL string equivilent.
int	setSqlValues(java.sql.PreparedStatement ps, int i) Any DbExpr needs to be able to substitute any parameters as per JDBC "?" substitutions.
void	usesTables(java.util.Set coll) Description of the Method

Methods inherited from class javatools.db.DbExpr

and, dateTrunc, equal, getString, greaterThan, greaterThanOrEqual, in, isNotNull, isNull, lessThan, lessThanOrEqual, like, lower, max, min, notEqual, notIn, or, setSqlValue, upper, usesTables

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

func

java.lang.String func

args

java.lang.Object[] args

Constructor Detail

DbMiscExpr

public DbMiscExpr(DbDatabase db,
                  java.lang.String func)

DbMiscExpr

public DbMiscExpr(DbDatabase db,
                  java.lang.String func,
                  java.lang.Object arg1)

DbMiscExpr

public DbMiscExpr(DbDatabase db,
                  java.lang.String func,
                  java.lang.Object arg1,
                  java.lang.Object arg2)

Method Detail

getQueryString

public java.lang.String getQueryString()
                                throws DbException

Description copied from class: DbExpr

Any DbExpr needs to be able to convert into the SQL string equivilent.

Specified by:

getQueryString in class DbExpr

Returns:

The queryString value

Throws:

DbException - Description of Exception

setSqlValues

public int setSqlValues(java.sql.PreparedStatement ps,
                        int i)
                 throws DbException,
                        java.sql.SQLException

Description copied from class: DbExpr

Any DbExpr needs to be able to substitute any parameters as per JDBC "?" substitutions.

Specified by:

setSqlValues in class DbExpr

Parameters:

ps - The new sqlValues value

i - The new sqlValues value

Returns:

Description of the Returned Value

Throws:

DbException - Description of Exception

java.sql.SQLException - Description of Exception

usesTables

public void usesTables(java.util.Set coll)

Description copied from class: DbExpr

Description of the Method

Overrides:

usesTables in class DbExpr

Parameters:

coll - Description of Parameter