Java Doc for Select.java in  » Database-DBMS » hsql » org » hsqldb » 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 » Database DBMS » hsql » org.hsqldb   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.hsqldb.Select Select class Select (Code) The compiled representation of an SQL SELECT. Extended in successive versions of HSQLDB. author:    Thomas Mueller (Hypersonic SQL Group) version:    1.8.0 since:    Hypersonic SQL Field Summary final static  int NOUNIONUNIONUNIONALLINTERSECTEXCEPT       IntKeyHashMap asteriskPositions       Expression[] exprColumns       Expression havingCondition       int iGroupLen       int iHavingLen       int iOrderLen       int iResultLen       int intoType       boolean isAggregated       boolean isDistinctSelect       boolean isResolved       Expression limitCondition       Expression queryCondition       Result.ResultMetaData resultMetaData       HsqlName sIntoTable       int[] sortDirection       int[] sortOrder       boolean sortUnion       TableFilter[] tFilter       Select[] unionArray       int unionDepth       int unionMaxDepth       Select unionSelect       int unionType      Method Summary static  boolean allColumnsAreDefinedIn(Expression exp, HashSet definedColumns)      Check if all the column names used in the given expression are defined in the given defined column names.  boolean checkResolved(boolean check)      Check all Expression have resolved. public  String describe(Session session)       Result describeResult()       HashMap getColumnAliases()      Experimental. public  StringBuffer getDDL()      Skeleton under development.  int getLimitCount(Session session, int rowCount)      For SELECT LIMIT n m ....  int getLimitStart(Session session)       int getMaxRowCount(Session session, int rowCount)       Result getResult(Session session, int maxrows)      Returns the result of executing this Select. Parameters:   maxrows - may be 0 to indicate no limit on the number of rows.Positive values limit the size of the result set.  Object getValue(Session session, int type)      Returns a single value result or throws if the result has more than one row with one value.  boolean isResolved()       void prepareResult(Session session)      Resolves expressions and pepares thre metadata for the result.  void prepareUnions()      This is called externally only on the first Select in a UNION chain.  void resolve(Session session)       boolean resolveAll(Session session, boolean check)       void resolveTables(TableFilter f)      Resolves the tables for all the Expression in the Select object if it is possible to do so with the given TableFilter.  void resolveTablesUnion(TableFilter f)       void resolveTypes(Session session)      Sets the types of all the expressions that have so far resolved.  void resolveUnionColumnTypes()      Converts the types of the columns in set operations to those in the first Select. Field Detail NOUNIONUNIONUNIONALLINTERSECTEXCEPT final static int NOUNIONUNIONUNIONALLINTERSECTEXCEPT(Code) asteriskPositions IntKeyHashMap asteriskPositions(Code) exprColumns Expression[] exprColumns(Code) havingCondition Expression havingCondition(Code) iGroupLen int iGroupLen(Code) iHavingLen int iHavingLen(Code) iOrderLen int iOrderLen(Code) iResultLen int iResultLen(Code) intoType int intoType(Code) isAggregated boolean isAggregated(Code) isDistinctSelect boolean isDistinctSelect(Code) isResolved boolean isResolved(Code) limitCondition Expression limitCondition(Code) queryCondition Expression queryCondition(Code) resultMetaData Result.ResultMetaData resultMetaData(Code) sIntoTable HsqlName sIntoTable(Code) sortDirection int[] sortDirection(Code) sortOrder int[] sortOrder(Code) sortUnion boolean sortUnion(Code) tFilter TableFilter[] tFilter(Code) unionArray Select[] unionArray(Code) unionDepth int unionDepth(Code) unionMaxDepth int unionMaxDepth(Code) unionSelect Select unionSelect(Code) unionType int unionType(Code) Method Detail allColumnsAreDefinedIn static boolean allColumnsAreDefinedIn(Expression exp, HashSet definedColumns)(Code) Check if all the column names used in the given expression are defined in the given defined column names. checkResolved boolean checkResolved(boolean check) throws HsqlException(Code) Check all Expression have resolved. Return true or false as a result. Throw if false and check parameter is true. throws:   HsqlException - describe public String describe(Session session)(Code) describeResult Result describeResult()(Code) getColumnAliases HashMap getColumnAliases()(Code) Experimental. Map the column aliases to expressions in order to resolve alias names in WHERE clauses getDDL public StringBuffer getDDL() throws HsqlException(Code) Skeleton under development. Needs a lot of work. getLimitCount int getLimitCount(Session session, int rowCount) throws HsqlException(Code) For SELECT LIMIT n m .... finds cases where the result does not have to be fully built and returns an adjusted rowCount with LIMIT params. getLimitStart int getLimitStart(Session session) throws HsqlException(Code) getMaxRowCount int getMaxRowCount(Session session, int rowCount) throws HsqlException(Code) translate the rowCount into total number of rows needed from query, including any rows skipped at the beginning getResult Result getResult(Session session, int maxrows) throws HsqlException(Code) Returns the result of executing this Select. Parameters:   maxrows - may be 0 to indicate no limit on the number of rows.Positive values limit the size of the result set. the result of executing this Select throws:   HsqlException - if a database access error occurs getValue Object getValue(Session session, int type) throws HsqlException(Code) Returns a single value result or throws if the result has more than one row with one value. Parameters:   type - data type Parameters:   session - context the single valued result throws:   HsqlException - isResolved boolean isResolved()(Code) prepareResult void prepareResult(Session session) throws HsqlException(Code) Resolves expressions and pepares thre metadata for the result. prepareUnions void prepareUnions() throws HsqlException(Code) This is called externally only on the first Select in a UNION chain. resolve void resolve(Session session) throws HsqlException(Code) Method declaration throws:   HsqlException - resolveAll boolean resolveAll(Session session, boolean check) throws HsqlException(Code) resolveTables void resolveTables(TableFilter f) throws HsqlException(Code) Resolves the tables for all the Expression in the Select object if it is possible to do so with the given TableFilter. Parameters:   f - throws:   HsqlException - resolveTablesUnion void resolveTablesUnion(TableFilter f) throws HsqlException(Code) resolveTypes void resolveTypes(Session session) throws HsqlException(Code) Sets the types of all the expressions that have so far resolved. throws:   HsqlException - resolveUnionColumnTypes void resolveUnionColumnTypes() throws HsqlException(Code) Converts the types of the columns in set operations to those in the first Select. 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)