📄 selectcommand.html
字号:
<DT><B>Parameters:</B><DD><CODE>where</CODE> - a <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>WhereNode</CODE></A><DT><B>Throws:</B><DD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/IllegalStateException.html">IllegalStateException</A></CODE> - if I have already been resolved</DL>
</DD>
</DL>
<HR>
<A NAME="getWhere()"><!-- --></A><H3>
getWhere</H3>
<PRE>
public <A HREF="../../../../org/axiondb/WhereNode.html">WhereNode</A> <B>getWhere</B>()</PRE>
<DL>
<DD>Returns the <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>where tree</CODE></A> for this query. Clients should treat the returned value as immutable.<DD><DL>
<DT><B>Returns:</B><DD>the <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>where tree</CODE></A> for this query, or <tt>null</tt>.</DL>
</DD>
</DL>
<HR>
<A NAME="setOrderBy(java.util.List)"><!-- --></A><H3>
setOrderBy</H3>
<PRE>
public void <B>setOrderBy</B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> orderby)</PRE>
<DL>
<DD>Sets the order by clause for this query.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>orderby</CODE> - a <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html"><CODE>List</CODE></A> of <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A>s.<DT><B>Throws:</B><DD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/IllegalStateException.html">IllegalStateException</A></CODE> - if I have already been resolved</DL>
</DD>
</DL>
<HR>
<A NAME="addOrderBy(org.axiondb.OrderNode)"><!-- --></A><H3>
addOrderBy</H3>
<PRE>
public void <B>addOrderBy</B>(<A HREF="../../../../org/axiondb/OrderNode.html">OrderNode</A> orderby)</PRE>
<DL>
<DD>Appends an <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A> to the order by clause for this query<DD><DL>
<DT><B>Parameters:</B><DD><CODE>orderby</CODE> - an <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A> to append<DT><B>Throws:</B><DD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/IllegalStateException.html">IllegalStateException</A></CODE> - if I have already been resolved</DL>
</DD>
</DL>
<HR>
<A NAME="getOrderBy(int)"><!-- --></A><H3>
getOrderBy</H3>
<PRE>
public <A HREF="../../../../org/axiondb/OrderNode.html">OrderNode</A> <B>getOrderBy</B>(int i)</PRE>
<DL>
<DD>Gets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A> in my order by clause. Clients should treat the returned value as immutable.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>i</CODE> - the zero-based index</DL>
</DD>
</DL>
<HR>
<A NAME="setOrderBy(int, org.axiondb.Selectable)"><!-- --></A><H3>
setOrderBy</H3>
<PRE>
public void <B>setOrderBy</B>(int i, <A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> node)</PRE>
<DL>
<DD>Sets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A> in my order by clause.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>i</CODE> - the zero-based index<DD><CODE>node</CODE> - the new <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A><DT><B>Throws:</B><DD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/IllegalStateException.html">IllegalStateException</A></CODE> - if I have already been resolved</DL>
</DD>
</DL>
<HR>
<A NAME="getOrderByCount()"><!-- --></A><H3>
getOrderByCount</H3>
<PRE>
public int <B>getOrderByCount</B>()</PRE>
<DL>
<DD>Gets the number of <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A>s in my query.</DL>
<HR>
<A NAME="setDistinct(boolean)"><!-- --></A><H3>
setDistinct</H3>
<PRE>
public void <B>setDistinct</B>(boolean distinct)</PRE>
<DL>
<DD>Determines if the <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/ResultSet.html"><CODE>ResultSet</CODE></A> generated from this object will contain distinct tuples (default is false).<DD><DL>
<DT><B>Parameters:</B><DD><CODE>distinct</CODE> - true for distinct tuples</DL>
</DD>
</DL>
<HR>
<A NAME="getDistinct()"><!-- --></A><H3>
getDistinct</H3>
<PRE>
public boolean <B>getDistinct</B>()</PRE>
<DL>
<DD>Indicates if the <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/ResultSet.html"><CODE>ResultSet</CODE></A> generated from this object will contain distinct tuples.<DD><DL>
<DT><B>Returns:</B><DD><code>true</code> for distinct tuples</DL>
</DD>
</DL>
<HR>
<A NAME="setLimit(org.axiondb.Literal)"><!-- --></A><H3>
setLimit</H3>
<PRE>
public void <B>setLimit</B>(<A HREF="../../../../org/axiondb/Literal.html">Literal</A> limit)</PRE>
<DL>
</DL>
<HR>
<A NAME="getLimit()"><!-- --></A><H3>
getLimit</H3>
<PRE>
public <A HREF="../../../../org/axiondb/Literal.html">Literal</A> <B>getLimit</B>()</PRE>
<DL>
</DL>
<HR>
<A NAME="setOffset(org.axiondb.Literal)"><!-- --></A><H3>
setOffset</H3>
<PRE>
public void <B>setOffset</B>(<A HREF="../../../../org/axiondb/Literal.html">Literal</A> offset)</PRE>
<DL>
</DL>
<HR>
<A NAME="getOffset()"><!-- --></A><H3>
getOffset</H3>
<PRE>
public <A HREF="../../../../org/axiondb/Literal.html">Literal</A> <B>getOffset</B>()</PRE>
<DL>
</DL>
<HR>
<A NAME="executeQuery(org.axiondb.Database)"><!-- --></A><H3>
executeQuery</H3>
<PRE>
public <A HREF="../../../../org/axiondb/jdbc/AxionResultSet.html">AxionResultSet</A> <B>executeQuery</B>(<A HREF="../../../../org/axiondb/Database.html">Database</A> db) throws <A HREF="../../../../org/axiondb/AxionException.html">AxionException</A></PRE>
<DL>
<DD>Execute this command, returning a <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/ResultSet.html"><CODE>ResultSet</CODE></A>.<DD><DL>
<DT><B>Returns:</B><DD>the <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/ResultSet.html"><CODE>ResultSet</CODE></A> generated by this command.<DT><B>Throws:</B><DD><CODE>SQLException</CODE> - </DL>
</DD>
</DL>
<HR>
<A NAME="getBindVariableIterator()"><!-- --></A><H3>
getBindVariableIterator</H3>
<PRE>
protected <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/Iterator.html">Iterator</A> <B>getBindVariableIterator</B>()</PRE>
<DL>
<DD><B>Description copied from class: <CODE><A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html">BaseAxionCommand</A></CODE></B></DD>
<DD>Returns an <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/Iterator.html"><CODE>Iterator</CODE></A> over all my <A HREF="../../../../org/axiondb/BindVariable.html"><CODE>BindVariable</CODE></A>s, in the proper order. Default impl returns empty iterator.<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#getBindVariableIterator()">getBindVariableIterator</A></CODE> in class <CODE><A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html">BaseAxionCommand</A></CODE></DL>
</DD>
</DL>
<HR>
<A NAME="executeUpdate(org.axiondb.Database)"><!-- --></A><H3>
executeUpdate</H3>
<PRE>
public int <B>executeUpdate</B>(<A HREF="../../../../org/axiondb/Database.html">Database</A> database) throws <A HREF="../../../../org/axiondb/AxionException.html">AxionException</A></PRE>
<DL>
<DD>Unsupported<DD>Following copied from interface: <CODE>org.axiondb.AxionCommand</CODE></DD>
<DD><DL>
<DT><B>Returns:</B><DD>the number of rows modified<DT><B>See Also: </B><DD><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String)"><CODE>Statement.executeUpdate(java.lang.String)</CODE></A>,
<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/PreparedStatement.html#executeUpdate()"><CODE>PreparedStatement.executeUpdate()</CODE></A></DL>
</DD>
</DL>
<HR>
<A NAME="execute(org.axiondb.Database)"><!-- --></A><H3>
execute</H3>
<PRE>
public boolean <B>execute</B>(<A HREF="../../../../org/axiondb/Database.html">Database</A> database) throws <A HREF="../../../../org/axiondb/AxionException.html">AxionException</A></PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../org/axiondb/AxionCommand.html">AxionCommand</A></CODE></B></DD>
<DD>Executes an SQL statement that may return multiple results.<DD>Following copied from interface: <CODE>org.axiondb.AxionCommand</CODE></DD>
<DD><DL>
<DT><B>Returns:</B><DD><tt>true</tt> if one or more <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/ResultSet.html"><CODE>ResultSet</CODE></A>s were generated, <tt>false</tt> otherwise<DT><B>See Also: </B><DD><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/Statement.html#execute(java.lang.String)"><CODE>Statement.execute(java.lang.String)</CODE></A>,
<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/sql/PreparedStatement.html#execute()"><CODE>PreparedStatement.execute()</CODE></A></DL>
</DD>
</DL>
<HR>
<A NAME="toString()"><!-- --></A><H3>
toString</H3>
<PRE>
public <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/String.html">String</A> <B>toString</B>()</PRE>
<DL>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#toString()">toString</A></CODE> in class <CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html">Object</A></CODE></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>
<!-- ========== START OF NAVBAR ========== -->
<A NAME="navbar_bottom"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/SelectCommand.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../org/axiondb/engine/commands/RemountCommand.html"><B>PREV CLASS</B></A>
<A HREF="../../../../org/axiondb/engine/commands/ShutdownCommand.html"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../../index.html" TARGET="_top"><B>FRAMES</B></A>
<A HREF="SelectCommand.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
SUMMARY: INNER | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<!-- =========== END OF NAVBAR =========== -->
<HR>
Copyright © 2002-2003 Axion Development Team. All Rights Reserved.
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -