Java Doc for SelectStatement.java in » Rule-Engine » Mandarax » org » mandarax » jdbc » server » sql » Java Source Code / Java DocumentationJava Source Code and Java Documentation
Java Source Code / Java Documentation
1.
6.0 JDK Core
2.
6.0 JDK Modules
3.
6.0 JDK Modules com.sun
4.
6.0 JDK Modules com.sun.java
5.
6.0 JDK Modules sun
6.
6.0 JDK Platform
7.
Ajax
8.
Apache Harmony Java SE
9.
Aspect oriented
10.
Authentication Authorization
11.
Blogger System
12.
Build
13.
Byte Code
14.
Cache
15.
Chart
16.
Chat
17.
Code Analyzer
18.
Collaboration
19.
Content Management System
20.
Database Client
21.
Database DBMS
22.
Database JDBC Connection Pool
23.
Database ORM
24.
Development
25.
EJB Server geronimo
26.
EJB Server GlassFish
27.
EJB Server JBoss 4.2.1
28.
EJB Server resin 3.1.5
29.
ERP CRM Financial
30.
ESB
31.
Forum
32.
GIS
33.
Graphic Library
34.
Groupware
35.
HTML Parser
36.
IDE
37.
IDE Eclipse
38.
IDE Netbeans
39.
Installer
40.
Internationalization Localization
41.
Inversion of Control
42.
Issue Tracking
43.
J2EE
44.
JBoss
45.
JMS
46.
JMX
47.
Library
48.
Mail Clients
49.
Net
50.
Parser
51.
PDF
52.
Portal
53.
Profiler
54.
Project Management
55.
Report
56.
RSS RDF
57.
Rule Engine
58.
Science
59.
Scripting
60.
Search Engine
61.
Security
62.
Sevlet Container
63.
Source Control
64.
Swing Library
65.
Template Engine
66.
Test Coverage
67.
Testing
68.
UML
69.
Web Crawler
70.
Web Framework
71.
Web Mail
72.
Web Server
73.
Web Services
74.
Web Services apache cxf 2.0.1
75.
Web Services AXIS2
76.
Wiki Engine
77.
Workflow Engines
78.
XML
79.
XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation
»
Rule Engine
»
Mandarax
»
org.mandarax.jdbc.server.sql
Source Cross Reference
Class Diagram
Java Document (Java Doc)
java.lang
.Object
org.mandarax.jdbc.server.sql
.SQLObject
org.mandarax.jdbc.server.sql
.SelectStatement
SelectStatement
public
class SelectStatement extends
SQLObject
(Code)
Represents the SQL SELECT statement.
author:
Jens Dietrich
version:
3.3.2 <29 December 2004>
since:
3.0
Inner Class :class CountAllResultSet extends
CachedResultSet
Constructor Summary
public
SelectStatement
()
Constructor.
public
SelectStatement
(
String
tableName)
Constructor.
public
SelectStatement
(
String
tableName,
String
columns)
Constructor.
public
SelectStatement
(
String
tableName,
String
[] columns)
Constructor.
Method Summary
public
ResultSet
applyFilters
(
ResultSet
rs)
Apply clauses in the select filters (WHERE, ORDER BY) as filters.
public
Query
asMandaraxQuery
()
Build a mandarax query.
public
void
bind
(int index,
Object
value)
Bind a host variable.
public
void
checkBindings
()
Check whether all host variables are bound - throw an exception if not.
List
getColumnNames
()
Get a list of column names from the SELECT statement.
List
getColumns
()
Get a list of column terms from the SELECT statement.
public
org.mandarax.jdbc.server.sql.FromClause
getFromClause
()
Getter for property fromClause.
public
GroupByClause
getGroupByClause
()
Returns the GROUP BY clause.
public
HavingClause
getHavingClause
()
Returns the HAVING clause.
public
KnowledgeBase
getKB
()
Get the knowledge base.
public
OrderByClause
getOrderByClause
()
Returns the ORDER BY clause.
public
Predicate
getResultSetPredicate
()
Get the predicate in the final result set.
public
org.mandarax.jdbc.server.sql.SelectClause
getSelectClause
()
Getter for property selectClause.
public
org.mandarax.jdbc.server.sql.WhereClause
getWhereClause
()
Getter for property whereClause.
public
boolean
hasHostVariables
()
Indicates whether this statement has host variables.
public
boolean
isBound
(int index)
Indicates whether a host variable has been bound.
public
boolean
isDistinct
()
public
void
normalize
(
Map
typesByColumn)
Normalize the statement.
public
synchronized void
prepare
()
Prepare the statement, i.e.
public
void
print
(
StringBuffer
out)
Print the object on a buffer in order to display the parsed SQL.
public
void
reset
(int index)
Reset a host variable.
public
void
resetAll
()
Resets all host variables.
public
boolean
sameAs
(
Object
obj)
Compares objects.
public
void
setDistinct
(boolean distinct)
Sets the distinct.
public
void
setFromClause
(
org.mandarax.jdbc.server.sql.FromClause
fromClause)
Setter for property fromClause.
public
void
setGroupByClause
(
GroupByClause
groupByClause)
Sets the GROUP BY clause.
public
void
setHavingClause
(
HavingClause
havingClause)
Sets the HAVING clause.
public
void
setKB
(
KnowledgeBase
kb)
Sets the kb.
public
void
setOrderByClause
(
OrderByClause
orderByClause)
Sets the ORDER BY clause.
public
void
setSelect2Star
()
Set the select clause to a star.
public
void
setSelectClause
(
org.mandarax.jdbc.server.sql.SelectClause
selectClause)
Setter for property selectClause.
public
void
setSelectColumnList
(
String
[] cols)
Set a column list.
public
void
setTableName
(
String
tableName)
Set the table name.
public
void
setWhereClause
(
WhereClause
whereClause)
Sets the whereClause.
Constructor Detail
SelectStatement
public
SelectStatement()
(Code)
Constructor.
SelectStatement
public
SelectStatement(
String
tableName)
(Code)
Constructor.
Parameters:
tableName - a table name
SelectStatement
public
SelectStatement(
String
tableName,
String
columns)
(Code)
Constructor.
Parameters:
tableName - a table name
Parameters:
columns - - comma separated column names or a *
SelectStatement
public
SelectStatement(
String
tableName,
String
[] columns)
(Code)
Constructor.
Parameters:
tableName - a table name
Parameters:
columns - - an array of column names
Method Detail
applyFilters
public
ResultSet
applyFilters(
ResultSet
rs) throws
InferenceException
(Code)
Apply clauses in the select filters (WHERE, ORDER BY) as filters.
Parameters:
rs - the result set the filtered result set
asMandaraxQuery
public
Query
asMandaraxQuery() throws
JDBCException
(Code)
Build a mandarax query. a mandarax query.
bind
public
void bind(int index,
Object
value)
(Code)
Bind a host variable.
Parameters:
value - a value
Parameters:
index - a slot index (starting with 1)
exception:
illegal - argument exception
checkBindings
public
void checkBindings() throws
JDBCException
(Code)
Check whether all host variables are bound - throw an exception if not.
getColumnNames
List
getColumnNames() throws
InferenceException
(Code)
Get a list of column names from the SELECT statement. a list of column names
getColumns
List
getColumns() throws
InferenceException
(Code)
Get a list of column terms from the SELECT statement. a list of column terms
getFromClause
public
org.mandarax.jdbc.server.sql.FromClause
getFromClause()
(Code)
Getter for property fromClause. Value of property fromClause.
getGroupByClause
public
GroupByClause
getGroupByClause()
(Code)
Returns the GROUP BY clause. the GROUP BY clause
getHavingClause
public
HavingClause
getHavingClause()
(Code)
Returns the HAVING clause. the HAVING clause to set
getKB
public
KnowledgeBase
getKB()
(Code)
Get the knowledge base. a knowledge base
getOrderByClause
public
OrderByClause
getOrderByClause()
(Code)
Returns the ORDER BY clause. the ORDER BY clause
getResultSetPredicate
public
Predicate
getResultSetPredicate()
(Code)
Get the predicate in the final result set. a predicate
getSelectClause
public
org.mandarax.jdbc.server.sql.SelectClause
getSelectClause()
(Code)
Getter for property selectClause. Value of property selectClause.
getWhereClause
public
org.mandarax.jdbc.server.sql.WhereClause
getWhereClause()
(Code)
Getter for property whereClause. Value of property whereClause.
hasHostVariables
public
boolean hasHostVariables()
(Code)
Indicates whether this statement has host variables.
isBound
public
boolean isBound(int index)
(Code)
Indicates whether a host variable has been bound.
Parameters:
index - a slot index (starting with 1) a boolean
exception:
illegal - argument exception
isDistinct
public
boolean isDistinct()
(Code)
boolean
normalize
public
void normalize(
Map
typesByColumn)
(Code)
Normalize the statement. I.e. remove redundant nestings, set types fro context, etc
Parameters:
typesByColumn - associations between column names and (SQL) types
prepare
public
synchronized void prepare()
(Code)
Prepare the statement, i.e. gather the host variables.
print
public
void print(
StringBuffer
out)
(Code)
Print the object on a buffer in order to display the parsed SQL.
Parameters:
out - a string bufer to print on
reset
public
void reset(int index)
(Code)
Reset a host variable.
Parameters:
index - a slot index (starting with 1)
exception:
illegal - argument exception
resetAll
public
void resetAll()
(Code)
Resets all host variables.
sameAs
public
boolean sameAs(
Object
obj)
(Code)
Compares objects.
Parameters:
obj - another object. a boolean
setDistinct
public
void setDistinct(boolean distinct)
(Code)
Sets the distinct.
Parameters:
distinct - The distinct to set
setFromClause
public
void setFromClause(
org.mandarax.jdbc.server.sql.FromClause
fromClause)
(Code)
Setter for property fromClause.
Parameters:
fromClause - New value of property fromClause.
setGroupByClause
public
void setGroupByClause(
GroupByClause
groupByClause)
(Code)
Sets the GROUP BY clause.
Parameters:
groupByClause - the GROUP BY clause
setHavingClause
public
void setHavingClause(
HavingClause
havingClause)
(Code)
Sets the HAVING clause.
Parameters:
havingClause - the HAVING clause to set
setKB
public
void setKB(
KnowledgeBase
kb)
(Code)
Sets the kb.
Parameters:
kb - The knowledge base to set
setOrderByClause
public
void setOrderByClause(
OrderByClause
orderByClause)
(Code)
Sets the ORDER BY clause.
Parameters:
orderByClause - The ORDER BY clause to set
setSelect2Star
public
void setSelect2Star()
(Code)
Set the select clause to a star.
setSelectClause
public
void setSelectClause(
org.mandarax.jdbc.server.sql.SelectClause
selectClause)
(Code)
Setter for property selectClause.
Parameters:
selectClause - New value of property selectClause.
setSelectColumnList
public
void setSelectColumnList(
String
[] cols)
(Code)
Set a column list.
Parameters:
cols - an array of column names
setTableName
public
void setTableName(
String
tableName)
(Code)
Set the table name.
Parameters:
tableName - the table name
setWhereClause
public
void setWhereClause(
WhereClause
whereClause)
(Code)
Sets the whereClause.
Parameters:
whereClause - The whereClause to set
Methods inherited from
org.mandarax.jdbc.server.sql.SQLObject
abstract
public
void normalize(
Map
typesByColumn)
(Code)
(Java Doc)
abstract
public
void print(
StringBuffer
out)
(Code)
(Java Doc)
public
String
toString()
(Code)
(Java Doc)
Methods inherited from
java.lang.Object
native
protected
Object
clone() throws
CloneNotSupportedException
(Code)
(Java Doc)
public
boolean equals(
Object
obj)
(Code)
(Java Doc)
protected
void finalize() throws
Throwable
(Code)
(Java Doc)
final native
public
Class
> getClass()
(Code)
(Java Doc)
native
public
int hashCode()
(Code)
(Java Doc)
final native
public
void notify()
(Code)
(Java Doc)
final native
public
void notifyAll()
(Code)
(Java Doc)
public
String
toString()
(Code)
(Java Doc)
final native
public
void wait(long timeout) throws
InterruptedException
(Code)
(Java Doc)
final
public
void wait(long timeout, int nanos) throws
InterruptedException
(Code)
(Java Doc)
final
public
void wait() throws
InterruptedException
(Code)
(Java Doc)
www.java2java.com
|
Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.