Java Doc for SelectStatement.java in  » Content-Management-System » harmonise » org » openharmonise » commons » dsi » dml » 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 » Content Management System » harmonise » org.openharmonise.commons.dsi.dml   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.openharmonise.commons.dsi.dml.AbstractDMLStatement       org.openharmonise.commons.dsi.dml.SelectStatement SelectStatement public class SelectStatement extends AbstractDMLStatement (Code) A DML select statement query. author:    Michael Bell version:    $Revision: 1.2 $ Field Summary public static  String ORDER_ASCENDING      Constant to indicate results should be ordered in ascending order. public static  String ORDER_DESCENDING      Constant to indicate results should be ordered in descending order. Constructor Summary public   SelectStatement()      Constructs a select statement. Method Summary public  void addJoinCondition(ColumnRef colref1, ColumnRef colref2)      Adds an inner join condition to this query. public  void addJoinConditions(JoinConditions join)      Adds a collection of join conditions to this query. public  void addOrderBy(ColumnRef colref)      Add column reference to order the results of this select statement by. public  void addOrderBy(ColumnRef colref, String orderDir)      Add column reference to order the results of this select statement by. public  void addOrderBy(Map byColMap)      Add order by column reference to ordering direction mappings to this select statement. public  void addOuterJoinCondition(ColumnRef innerMember, ColumnRef outerMember)      Adds an outer join condition to this query. public  void addSelectColumn(int i)      Adds a constant to be returned in select statement result. public  void addSelectColumn(ColumnRef colref)      Adds a column reference to be added to list of columns to be returned by this query. public  void addSelectColumns(List colrefs)      Adds list of column references to be added to list of columns to be returned by this query. public  void addSelectMaxColumn(ColumnRef colref)      Adds a column to be returned in select column with the 'max()' function applied. public  void addWhereCondition(WhereCondition where)      public  void addWhereCondition(WhereConditionGroup where)      public  void clear()      public  boolean containsSelectColumn(ColumnRef colRef)      Returns true if colRef is a select column. public  JoinConditions getJoinConditions()      Returns the collection of join conditions applicable to this query. public  int getLimit()      Returns the maximum number of rows that can be returned by this query. public  Set getOrderByColumns()      Returns the Set of column references to order the results of this select statment by. public  String getOrderByDirection(ColumnRef colref)      Returns the ordering direction for the specified 'order by' column. public  int getResultSetIndex(ColumnRef colRef)      Returns the index of the ColumnRef object in result set of this query. public  List getSelectColumns()      Returns the list of column references to be returned by this query. public  List getSelectMaxColumns()      Returns the list of column references which have to have the 'max()' function applied to by the query. public  boolean hasJoinConditions()      Returns true if this query has join conditions. public  boolean isDistinct()      Returns true if the results of this query should be distinct. public  boolean isLimit()      Returns true if a maximum number of rows that can be returned by this query has been set. public  void setDistinct(boolean bIsDistinct)      Sets whether this query will return distinct results. public  void setLimit(int num)      Sets the maximum number of rows that can be returned by this query. public  void setOrderBy(ColumnRef colref)      Set the column reference which is to be used to order the result of this query. Field Detail ORDER_ASCENDING public static String ORDER_ASCENDING(Code) Constant to indicate results should be ordered in ascending order. ORDER_DESCENDING public static String ORDER_DESCENDING(Code) Constant to indicate results should be ordered in descending order. Constructor Detail SelectStatement public SelectStatement()(Code) Constructs a select statement. Method Detail addJoinCondition public void addJoinCondition(ColumnRef colref1, ColumnRef colref2) throws DataStoreException(Code) Adds an inner join condition to this query. Parameters:   colref1 - the left column reference for this join Parameters:   colref2 - the right column reference for this join throws:   DataStoreException - if the join is invalid addJoinConditions public void addJoinConditions(JoinConditions join) throws DataStoreException(Code) Adds a collection of join conditions to this query. Parameters:   join - the collection of join conditions throws:   DataStoreException - if an error occurs merging the join conditions addOrderBy public void addOrderBy(ColumnRef colref)(Code) Add column reference to order the results of this select statement by. Parameters:   colref - the column reference addOrderBy public void addOrderBy(ColumnRef colref, String orderDir)(Code) Add column reference to order the results of this select statement by. Parameters:   colref - the column reference Parameters:   orderDir - the direction of ordering addOrderBy public void addOrderBy(Map byColMap)(Code) Add order by column reference to ordering direction mappings to this select statement. Parameters:   byColMap - Map of column reference ordering direction pairs addOuterJoinCondition public void addOuterJoinCondition(ColumnRef innerMember, ColumnRef outerMember) throws DataStoreException(Code) Adds an outer join condition to this query. Parameters:   innerMember - the inner memeber column reference of this join Parameters:   outerMember - the outer memeber column reference of this join throws:   DataStoreException - if the join is invalid addSelectColumn public void addSelectColumn(int i)(Code) Adds a constant to be returned in select statement result. Parameters:   i - int constant to be returned by query addSelectColumn public void addSelectColumn(ColumnRef colref)(Code) Adds a column reference to be added to list of columns to be returned by this query. Parameters:   colref - addSelectColumns public void addSelectColumns(List colrefs)(Code) Adds list of column references to be added to list of columns to be returned by this query. Parameters:   colrefs - list of ColumnRefs to be returned addSelectMaxColumn public void addSelectMaxColumn(ColumnRef colref)(Code) Adds a column to be returned in select column with the 'max()' function applied. Parameters:   colref - the column reference addWhereCondition public void addWhereCondition(WhereCondition where) throws DataStoreException(Code) addWhereCondition public void addWhereCondition(WhereConditionGroup where) throws DataStoreException(Code) clear public void clear()(Code) containsSelectColumn public boolean containsSelectColumn(ColumnRef colRef)(Code) Returns true if colRef is a select column. Parameters:   colRef - the column reference true if colRef is a select column. getJoinConditions public JoinConditions getJoinConditions()(Code) Returns the collection of join conditions applicable to this query. the collection of join conditions getLimit public int getLimit()(Code) Returns the maximum number of rows that can be returned by this query. the maximum number of rows that can be returned getOrderByColumns public Set getOrderByColumns()(Code) Returns the Set of column references to order the results of this select statment by. the Set of column references getOrderByDirection public String getOrderByDirection(ColumnRef colref)(Code) Returns the ordering direction for the specified 'order by' column. Parameters:   colref - the column reference the ordering direction getResultSetIndex public int getResultSetIndex(ColumnRef colRef)(Code) Returns the index of the ColumnRef object in result set of this query. Parameters:   colRef - the column reference the index of the column in the result set getSelectColumns public List getSelectColumns()(Code) Returns the list of column references to be returned by this query. the list of column references to be returned by this query getSelectMaxColumns public List getSelectMaxColumns()(Code) Returns the list of column references which have to have the 'max()' function applied to by the query. the list of column references hasJoinConditions public boolean hasJoinConditions()(Code) Returns true if this query has join conditions. true if this query has join conditions. isDistinct public boolean isDistinct()(Code) Returns true if the results of this query should be distinct. true if the results should be distinct isLimit public boolean isLimit()(Code) Returns true if a maximum number of rows that can be returned by this query has been set. true if a limit has been set setDistinct public void setDistinct(boolean bIsDistinct)(Code) Sets whether this query will return distinct results. Parameters:   bIsDistinct - true if the results should be distinct setLimit public void setLimit(int num)(Code) Sets the maximum number of rows that can be returned by this query. Parameters:   num - maximum number of rows to be returned setOrderBy public void setOrderBy(ColumnRef colref)(Code) Set the column reference which is to be used to order the result of this query. Parameters:   colref - the column reference throws:   DataStoreException - Fields inherited from org.openharmonise.commons.dsi.dml.AbstractDMLStatement protected Vector m_TableAliases(Code)(Java Doc) protected Vector m_Tables(Code)(Java Doc) protected boolean m_bIsAliasListComplete(Code)(Java Doc) protected WhereConditionGroup m_where(Code)(Java Doc) Methods inherited from org.openharmonise.commons.dsi.dml.AbstractDMLStatement public void addTableAlias(String sTable, String sAlias) throws DataStoreException(Code)(Java Doc) public void addWhereCondition(ColumnRef colref, String sOperator, int val) throws DataStoreException(Code)(Java Doc) public void addWhereCondition(ColumnRef colref, String sOperator, Object val) throws DataStoreException(Code)(Java Doc) public void addWhereCondition(ColumnRef colref, String sOperator, List vals) throws DataStoreException(Code)(Java Doc) public void addWhereCondition(WhereConditionGroup where) throws DataStoreException(Code)(Java Doc) public void addWhereCondition(WhereCondition where) throws DataStoreException(Code)(Java Doc) public void clear()(Code)(Java Doc) public String getTableAlias(String sTable)(Code)(Java Doc) public String getTableName(String sAlias)(Code)(Java Doc) public WhereConditionGroup getWhereConditions()(Code)(Java Doc) public boolean hasWhereClause()(Code)(Java Doc) public boolean hasWhereConditions()(Code)(Java Doc) public boolean isAlias(String sAlias) throws DataStoreException(Code)(Java Doc) public void setWhereConditionStringingOperator(String sOp) throws DataStoreException(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)