|
BEA Systems, Inc. | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--weblogic.db.jdbc.SelectStmt
SelectStmt objects are used to help build vendor-neutral Select statements with query-by-example (QBE) support. You are not limited to a single table name when constructing a SelectStmt object, although the usage of the object may dictate when a join of one or more tables is useful; a SelectStmt object associated with a TableDataSet cannot create a join, since a TableDataSet is, by definition, derived from a single table. But you can create a join with a SelectStmt that is associated with a QueryDataSet, which has no limitations on the scope of its data retrieval.
For an implementation and usage see the Developers Guide.
Constructor Summary | |
SelectStmt(int dbtype)
SelectStmt constructor. |
Method Summary | |
SelectStmt |
addQbe(java.lang.String attrib,
float val)
Sets the QBE value for the specified attribute to a float value. |
SelectStmt |
addQbe(java.lang.String attrib,
int val)
Sets the QBE value for the specified attribute to an int value. |
SelectStmt |
addQbe(java.lang.String attrib,
java.lang.String val)
Sets the QBE value for the specified attribute to a string value. |
SelectStmt |
addUnquotedQbe(java.lang.String attrib,
java.lang.String val)
Sets the QBE value for the specified attribute to an int value. |
SelectStmt |
clearQbe()
Clears the QBE clauses for all attributes. |
SelectStmt |
clearQbe(java.lang.String attrib)
Clears the QBE clause for the specified attribute. |
SelectStmt |
field(java.lang.String attribute)
Adds an element to the SELECT list of a SelectStmt object. |
SelectStmt |
field(java.lang.String attribute,
java.lang.String alias)
Adds an element and its alias to the SELECT list of a SelectStmt object. |
SelectStmt |
from(java.lang.String str)
Adds a FROM clause to the SelectStmt object. |
protected java.lang.String |
getFields()
|
java.lang.String |
getQbeWhere()
Returns the WHERE clause of the SelectStmt object. |
SelectStmt |
group(java.lang.String str)
Adds a GROUP BY clause to the SelectStmt object. |
SelectStmt |
having(java.lang.String str)
Adds a HAVING clause to the SelectStmt object. |
SelectStmt |
order(java.lang.String str)
Adds an ORDER BY clause to the SelectStmt object. |
protected java.lang.String |
orderString()
|
SelectStmt |
setQbe(java.lang.String attrib,
float val)
Sets the QBE value for the specified attribute to a float value. |
SelectStmt |
setQbe(java.lang.String attrib,
float[] val)
Sets the QBE value for the specified attribute to an array of float values. |
SelectStmt |
setQbe(java.lang.String attrib,
int val)
Sets the QBE value for the specified attribute to an int value. |
SelectStmt |
setQbe(java.lang.String attrib,
int[] val)
Sets the QBE value for the specified attribute to an array of int values. |
SelectStmt |
setQbe(java.lang.String attrib,
java.lang.String val)
Sets the QBE value for the specified attribute to a string value. |
SelectStmt |
setQbe(java.lang.String attrib,
java.lang.String[] val)
Sets the QBE value for the specified attribute to an array of string values. |
SelectStmt |
setUnquotedQbe(java.lang.String attrib,
java.lang.String val)
Sets the QBE value for the specified attribute to a string value. |
SelectStmt |
setUnquotedQbe(java.lang.String attrib,
java.lang.String[] val)
Sets the QBE value for the specified attribute to an array of string values. |
java.lang.String |
toString()
Returns the complete SELECT statement for the SelectStmt object. |
SelectStmt |
unique()
Adds a UNIQUE clause to the SelectStmt object. |
SelectStmt |
where(java.lang.String str)
Adds a WHERE clause to the SelectStmt object. |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
wait,
wait,
wait |
Constructor Detail |
public SelectStmt(int dbtype)
dbtype
- Database type Enum found in weblogic.db.jdbc.EnumsEnums
Method Detail |
public SelectStmt field(java.lang.String attribute)
attribute
- Column name or expressionpublic SelectStmt field(java.lang.String attribute, java.lang.String alias)
attribute
- Column name or expressionalias
- Alias for attributeprotected java.lang.String getFields()
public SelectStmt unique()
public SelectStmt from(java.lang.String str)
public SelectStmt where(java.lang.String str)
public SelectStmt order(java.lang.String str)
protected java.lang.String orderString()
public SelectStmt group(java.lang.String str)
public SelectStmt having(java.lang.String str)
public SelectStmt setQbe(java.lang.String attrib, int val)
attrib
- Attributeval
- Integer valuepublic SelectStmt setQbe(java.lang.String attrib, float val)
attrib
- Attributeval
- Floating-point valuepublic SelectStmt setQbe(java.lang.String attrib, java.lang.String val)
attrib
- Attributeval
- String valuepublic SelectStmt setUnquotedQbe(java.lang.String attrib, java.lang.String val)
attrib
- Attributeval
- String valuepublic SelectStmt setQbe(java.lang.String attrib, int[] val)
attrib
- Attributeval
- Array of integer valuespublic SelectStmt setQbe(java.lang.String attrib, float[] val)
attrib
- Attributeval
- Array of floating-point valuespublic SelectStmt setQbe(java.lang.String attrib, java.lang.String[] val)
attrib
- Attributeval
- Array of string valuespublic SelectStmt setUnquotedQbe(java.lang.String attrib, java.lang.String[] val)
attrib
- Attributeval
- Array of string valuespublic SelectStmt addQbe(java.lang.String attrib, int val)
attrib
- Attributeval
- Integer valuepublic SelectStmt addQbe(java.lang.String attrib, float val)
attrib
- Attributeval
- Floating-point valuepublic SelectStmt addQbe(java.lang.String attrib, java.lang.String val)
attrib
- Attributeval
- String valuepublic SelectStmt addUnquotedQbe(java.lang.String attrib, java.lang.String val)
attrib
- Attributeval
- Object valuepublic SelectStmt clearQbe(java.lang.String attrib)
attrib
- Attributepublic SelectStmt clearQbe()
public java.lang.String getQbeWhere()
public java.lang.String toString()
|
Documentation is available at http://e-docs.bea.com/wls/docs61 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |