Java Doc for Query.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)   java.lang.Object    org.h2.command.Prepared       org.h2.command.dml.Query All known Subclasses:   org.h2.command.dml.SelectUnion,  org.h2.command.dml.Select, Query abstract public class Query extends Prepared (Code) Represents a SELECT statement (simple, or union). Field Summary protected  Expression limit      The limit expression as specified in the LIMIT or TOP clause. protected  Expression offset      The offset expression as specified in the LIMIT .. protected  int sampleSize      Constructor Summary public   Query(Session session)      Method Summary abstract public  void addGlobalCondition(Parameter param, int columnId, int comparisonType)      Add a condition to the query.  void addParameter(Parameter param)      abstract public  int getColumnCount()      Get the column count of this query. abstract public  double getCost()      Calculate the cost to execute this query. abstract public  ObjectArray getExpressions()      The the list of select expressions. abstract public  String getFirstColumnAlias(Session session)      Get the alias (or column name) of the first column. final public  long getMaxDataModificationId()      final public  Value[] getParameterValues()      abstract public  HashSet getTables()      Get all tables that are involved in this query. abstract public  void init()      Initialize the query. protected  void initOrder(ObjectArray expressions, ObjectArray expressionSQL, ObjectArray orderList, int visible, boolean mustBeInResult)      abstract public  boolean isEverything(ExpressionVisitor visitor)      Check if this expression and all sub-expressions can fulfill a criteria. final public  boolean isEverything(int expressionVisitorType)      Visit all expressions and subqueries in this query using the visitor pattern. public  boolean isQuery()      public  boolean isTransactional()      abstract public  void mapColumns(ColumnResolver resolver, int level)      Map the columns to the given column resolver. public  SortOrder prepareOrder(ObjectArray orderList, int expressionCount)      Create a SortOrder object given the list of SelectOrderBy objects. public  LocalResult query(int limit)      abstract  LocalResult queryWithoutCache(int limit)      Execute the query without checking the cache. abstract public  void setDistinct(boolean b)      Set the distinct flag. abstract public  void setEvaluatable(TableFilter tableFilter, boolean b)      Change the evaluatable flag. abstract public  void setForUpdate(boolean forUpdate)      Set the 'for update' flag. public  void setLimit(Expression limit)      public  void setOffset(Expression offset)      abstract public  void setOrder(ObjectArray order)      Set the order by list. public  void setSampleSize(int sampleSize)      abstract public  void updateAggregate(Session session)      Update all aggregate function values. Field Detail limit protected Expression limit(Code) The limit expression as specified in the LIMIT or TOP clause. offset protected Expression offset(Code) The offset expression as specified in the LIMIT .. OFFSET clause. sampleSize protected int sampleSize(Code) The sample size Constructor Detail Query public Query(Session session)(Code) Method Detail addGlobalCondition abstract public void addGlobalCondition(Parameter param, int columnId, int comparisonType) throws SQLException(Code) Add a condition to the query. This is used for views. Parameters:   param - the parameter Parameters:   columnId - the column index (0 meaning the first column) Parameters:   comparisonType - the comparison type addParameter void addParameter(Parameter param)(Code) getColumnCount abstract public int getColumnCount()(Code) Get the column count of this query. the column count getCost abstract public double getCost()(Code) Calculate the cost to execute this query. the cost getExpressions abstract public ObjectArray getExpressions()(Code) The the list of select expressions. This may include invisible expressions such as order by expressions. the list of expressions getFirstColumnAlias abstract public String getFirstColumnAlias(Session session)(Code) Get the alias (or column name) of the first column. This is used to convert IN(SELECT ...) queries to inner joins. Parameters:   session - the session the alias or column name getMaxDataModificationId final public long getMaxDataModificationId()(Code) getParameterValues final public Value[] getParameterValues() throws SQLException(Code) getTables abstract public HashSet getTables()(Code) Get all tables that are involved in this query. the set of tables init abstract public void init() throws SQLException(Code) Initialize the query. initOrder protected void initOrder(ObjectArray expressions, ObjectArray expressionSQL, ObjectArray orderList, int visible, boolean mustBeInResult) throws SQLException(Code) isEverything abstract public boolean isEverything(ExpressionVisitor visitor)(Code) Check if this expression and all sub-expressions can fulfill a criteria. If any part returns false, the result is false. Parameters:   visitor - the visitor if the criteria can be fulfilled isEverything final public boolean isEverything(int expressionVisitorType)(Code) Visit all expressions and subqueries in this query using the visitor pattern. Parameters:   expressionVisitorType - the visitor type true if no component returned false isQuery public boolean isQuery()(Code) isTransactional public boolean isTransactional()(Code) mapColumns abstract public void mapColumns(ColumnResolver resolver, int level) throws SQLException(Code) Map the columns to the given column resolver. Parameters:   resolver - the resolver Parameters:   level - the subquery level (0 is the top level query, 1 is the firstsubquery level) prepareOrder public SortOrder prepareOrder(ObjectArray orderList, int expressionCount) throws SQLException(Code) Create a SortOrder object given the list of SelectOrderBy objects. The expression list is extended if necessary. Parameters:   orderList - a list of SelectOrderBy elements Parameters:   expressionCount - the number of columns in the query the SortOrder object query public LocalResult query(int limit) throws SQLException(Code) queryWithoutCache abstract LocalResult queryWithoutCache(int limit) throws SQLException(Code) Execute the query without checking the cache. Parameters:   limit - the limit as specified in the JDBC method call the result setDistinct abstract public void setDistinct(boolean b)(Code) Set the distinct flag. Parameters:   b - the new value setEvaluatable abstract public void setEvaluatable(TableFilter tableFilter, boolean b)(Code) Change the evaluatable flag. This is used when building the execution plan. Parameters:   tableFilter - the table filter Parameters:   b - the new value setForUpdate abstract public void setForUpdate(boolean forUpdate)(Code) Set the 'for update' flag. Parameters:   forUpdate - the new setting setLimit public void setLimit(Expression limit)(Code) setOffset public void setOffset(Expression offset)(Code) setOrder abstract public void setOrder(ObjectArray order)(Code) Set the order by list. Parameters:   order - the order by list setSampleSize public void setSampleSize(int sampleSize)(Code) updateAggregate abstract public void updateAggregate(Session session) throws SQLException(Code) Update all aggregate function values. Parameters:   session - the session Fields inherited from org.h2.command.Prepared protected int headPos(Code)(Java Doc) protected ObjectArray parameters(Code)(Java Doc) protected boolean prepareAlways(Code)(Java Doc) protected Session session(Code)(Java Doc) protected String sql(Code)(Java Doc) Methods inherited from org.h2.command.Prepared public void checkCancelled() throws SQLException(Code)(Java Doc) protected void checkParameters() throws SQLException(Code)(Java Doc) public int getCurrentRowNumber()(Code)(Java Doc) protected int getObjectId(boolean needFresh, boolean dataFile)(Code)(Java Doc) public ObjectArray getParameters()(Code)(Java Doc) public String getPlanSQL()(Code)(Java Doc) public String getSQL()(Code)(Java Doc) public boolean isQuery()(Code)(Java Doc) public boolean isReadOnly()(Code)(Java Doc) abstract public boolean isTransactional()(Code)(Java Doc) public boolean needRecompile() throws SQLException(Code)(Java Doc) public void prepare() throws SQLException(Code)(Java Doc) public LocalResult query(int maxrows) throws SQLException(Code)(Java Doc) abstract public LocalResult queryMeta() throws SQLException(Code)(Java Doc) public void setCommand(Command command)(Code)(Java Doc) protected void setCurrentRowNumber(int rowNumber)(Code)(Java Doc) public void setHeadPos(int headPos)(Code)(Java Doc) public void setObjectId(int i)(Code)(Java Doc) public void setParameterList(ObjectArray parameters)(Code)(Java Doc) public void setPrepareAlways(boolean prepareAlways)(Code)(Java Doc) public void setSQL(String sql)(Code)(Java Doc) public void setSession(Session currentSession)(Code)(Java Doc) public String toString()(Code)(Java Doc) public int update() throws SQLException(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)