Java Doc for Select.java in  » Database-DBMS » h2database » org » h2 » command » 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 » Database DBMS » h2database » org.h2.command.dml   Source Cross Reference   Class Diagram   Java Document (Java Doc)   org.h2.command.dml.Query    org.h2.command.dml.Select Select public class Select extends Query (Code) This class represents a simple SELECT statement. For each select statement, visibleColumnCount <= distinctColumnCount <= expressionCount. The expression list count could include ORDER BY and GROUP BY expressions that are not in the select list. The call sequence is init(), mapColumns() if it's a subquery, prepare(). author:    Thomas Mueller author:    Joel Turkel (Group sorted query) Constructor Summary public   Select(Session session)      Method Summary public  void addCondition(Expression cond)      Add a condition to the list of conditions. public  void addGlobalCondition(Parameter param, int columnId, int comparisonType)      public  void addTableFilter(TableFilter filter, boolean isTop)      Add a table to the query. public  int getColumnCount()      public  double getCost()      public  HashMap getCurrentGroup()      public  ObjectArray getExpressions()      public  String getFirstColumnAlias(Session session)      public  String getPlanSQL()      public  HashSet getTables()      public  ObjectArray getTopFilters()      public  TableFilter getTopTableFilter()      public  void init()      public  boolean isEverything(ExpressionVisitor visitor)      public  boolean isQuickQuery()      public  boolean isReadOnly()      public  void mapColumns(ColumnResolver resolver, int level)      public  void prepare()      public  LocalResult queryMeta()      public  LocalResult queryWithoutCache(int maxRows)      public  void setDistinct(boolean b)      public  void setEvaluatable(TableFilter tableFilter, boolean b)      public  void setExpressions(ObjectArray expressions)      public  void setForUpdate(boolean b)      public  void setGroupBy(ObjectArray group)      public  void setGroupQuery()      public  void setHaving(Expression having)      public  void setOrder(ObjectArray order)      public  void updateAggregate(Session session)      Constructor Detail Select public Select(Session session)(Code) Method Detail addCondition public void addCondition(Expression cond)(Code) Add a condition to the list of conditions. Parameters:   cond - the condition to add addGlobalCondition public void addGlobalCondition(Parameter param, int columnId, int comparisonType) throws SQLException(Code) addTableFilter public void addTableFilter(TableFilter filter, boolean isTop)(Code) Add a table to the query. Parameters:   filter - the table to add Parameters:   isTop - if the table can be the first table in the query plan getColumnCount public int getColumnCount()(Code) getCost public double getCost()(Code) getCurrentGroup public HashMap getCurrentGroup()(Code) getExpressions public ObjectArray getExpressions()(Code) getFirstColumnAlias public String getFirstColumnAlias(Session session)(Code) getPlanSQL public String getPlanSQL()(Code) getTables public HashSet getTables()(Code) getTopFilters public ObjectArray getTopFilters()(Code) getTopTableFilter public TableFilter getTopTableFilter()(Code) init public void init() throws SQLException(Code) isEverything public boolean isEverything(ExpressionVisitor visitor)(Code) isQuickQuery public boolean isQuickQuery()(Code) isReadOnly public boolean isReadOnly()(Code) mapColumns public void mapColumns(ColumnResolver resolver, int level) throws SQLException(Code) prepare public void prepare() throws SQLException(Code) queryMeta public LocalResult queryMeta() throws SQLException(Code) queryWithoutCache public LocalResult queryWithoutCache(int maxRows) throws SQLException(Code) setDistinct public void setDistinct(boolean b)(Code) setEvaluatable public void setEvaluatable(TableFilter tableFilter, boolean b)(Code) setExpressions public void setExpressions(ObjectArray expressions)(Code) setForUpdate public void setForUpdate(boolean b)(Code) setGroupBy public void setGroupBy(ObjectArray group)(Code) setGroupQuery public void setGroupQuery()(Code) setHaving public void setHaving(Expression having)(Code) setOrder public void setOrder(ObjectArray order)(Code) updateAggregate public void updateAggregate(Session session) throws SQLException(Code) Fields inherited from org.h2.command.dml.Query protected Expression limit(Code)(Java Doc) protected Expression offset(Code)(Java Doc) protected int sampleSize(Code)(Java Doc) Methods inherited from org.h2.command.dml.Query abstract public void addGlobalCondition(Parameter param, int columnId, int comparisonType) throws SQLException(Code)(Java Doc) void addParameter(Parameter param)(Code)(Java Doc) abstract public int getColumnCount()(Code)(Java Doc) abstract public double getCost()(Code)(Java Doc) abstract public ObjectArray getExpressions()(Code)(Java Doc) abstract public String getFirstColumnAlias(Session session)(Code)(Java Doc) final public long getMaxDataModificationId()(Code)(Java Doc) final public Value[] getParameterValues() throws SQLException(Code)(Java Doc) abstract public HashSet getTables()(Code)(Java Doc) abstract public void init() throws SQLException(Code)(Java Doc) protected void initOrder(ObjectArray expressions, ObjectArray expressionSQL, ObjectArray orderList, int visible, boolean mustBeInResult) throws SQLException(Code)(Java Doc) abstract public boolean isEverything(ExpressionVisitor visitor)(Code)(Java Doc) final public boolean isEverything(int expressionVisitorType)(Code)(Java Doc) public boolean isQuery()(Code)(Java Doc) public boolean isTransactional()(Code)(Java Doc) abstract public void mapColumns(ColumnResolver resolver, int level) throws SQLException(Code)(Java Doc) public SortOrder prepareOrder(ObjectArray orderList, int expressionCount) throws SQLException(Code)(Java Doc) public LocalResult query(int limit) throws SQLException(Code)(Java Doc) abstract LocalResult queryWithoutCache(int limit) throws SQLException(Code)(Java Doc) abstract public void setDistinct(boolean b)(Code)(Java Doc) abstract public void setEvaluatable(TableFilter tableFilter, boolean b)(Code)(Java Doc) abstract public void setForUpdate(boolean forUpdate)(Code)(Java Doc) public void setLimit(Expression limit)(Code)(Java Doc) public void setOffset(Expression offset)(Code)(Java Doc) abstract public void setOrder(ObjectArray order)(Code)(Java Doc) public void setSampleSize(int sampleSize)(Code)(Java Doc) abstract public void updateAggregate(Session session) throws SQLException(Code)(Java Doc)