📄 selectcommand.html
字号:
Gets the number of <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A>s being selected.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../org/axiondb/WhereNode.html">WhereNode</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#getWhere()">getWhere</A></B>()</CODE>
<BR>
Returns the <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>where tree</CODE></A> for this query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setDistinct(boolean)">setDistinct</A></B>(boolean distinct)</CODE>
<BR>
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).</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setFrom(java.util.List)">setFrom</A></B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> tables)</CODE>
<BR>
</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setLimit(org.axiondb.Literal)">setLimit</A></B>(<A HREF="../../../../org/axiondb/Literal.html">Literal</A> limit)</CODE>
<BR>
</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setOffset(org.axiondb.Literal)">setOffset</A></B>(<A HREF="../../../../org/axiondb/Literal.html">Literal</A> offset)</CODE>
<BR>
</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setOrderBy(int, org.axiondb.Selectable)">setOrderBy</A></B>(int i, <A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> node)</CODE>
<BR>
Sets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/OrderNode.html"><CODE>OrderNode</CODE></A> in my order by clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setOrderBy(java.util.List)">setOrderBy</A></B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> orderby)</CODE>
<BR>
Sets the order by clause for this query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setSelect(int, org.axiondb.Selectable)">setSelect</A></B>(int i, <A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> sel)</CODE>
<BR>
Sets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A> being selected.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setSelect(java.util.List)">setSelect</A></B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> columns)</CODE>
<BR>
</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#setWhere(org.axiondb.WhereNode)">setWhere</A></B>(<A HREF="../../../../org/axiondb/WhereNode.html">WhereNode</A> where)</CODE>
<BR>
Sets the <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>where tree</CODE></A> for this query.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/String.html">String</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/axiondb/engine/commands/SelectCommand.html#toString()">toString</A></B>()</CODE>
<BR>
</TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_org.axiondb.engine.commands.BaseAxionCommand"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class org.axiondb.engine.commands.<A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html">BaseAxionCommand</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#appendBindVariables(org.axiondb.Selectable, java.util.List)">appendBindVariables</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#appendBindVariables(org.axiondb.WhereNode, java.util.List)">appendBindVariables</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#assertNotReadOnly(org.axiondb.Database)">assertNotReadOnly</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#bind(int, java.lang.Object)">bind</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#clearBindings()">clearBindings</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#clearBindings(org.axiondb.WhereNode)">clearBindings</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#getEffectedRowCount()">getEffectedRowCount</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#getResultSet()">getResultSet</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#processWhereTree(org.axiondb.WhereNode)">processWhereTree</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#setEffectedRowCount(int)">setEffectedRowCount</A>, <A HREF="../../../../org/axiondb/engine/commands/BaseAxionCommand.html#setResultSet(java.sql.ResultSet)">setResultSet</A></CODE></TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class java.lang.<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html">Object</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#clone()">clone</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#equals(java.lang.Object)">equals</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#finalize()">finalize</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#getClass()">getClass</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#hashCode()">hashCode</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#notify()">notify</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#notifyAll()">notifyAll</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#wait()">wait</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#wait(long)">wait</A>, <A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/lang/Object.html#wait(long, int)">wait</A></CODE></TD>
</TR>
</TABLE>
<P>
<!-- ============ FIELD DETAIL =========== -->
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<A NAME="constructor_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TD>
</TR>
</TABLE>
<A NAME="SelectCommand()"><!-- --></A><H3>
SelectCommand</H3>
<PRE>
public <B>SelectCommand</B>()</PRE>
<DL>
</DL>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>
<A NAME="setSelect(java.util.List)"><!-- --></A><H3>
setSelect</H3>
<PRE>
public void <B>setSelect</B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> columns)</PRE>
<DL>
</DL>
<HR>
<A NAME="addSelect(org.axiondb.Selectable)"><!-- --></A><H3>
addSelect</H3>
<PRE>
public void <B>addSelect</B>(<A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> column)</PRE>
<DL>
<DD>Adds a <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A> to the list of items being selected.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>column</CODE> - the <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A> to add<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="getSelect(int)"><!-- --></A><H3>
getSelect</H3>
<PRE>
public <A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> <B>getSelect</B>(int i)</PRE>
<DL>
<DD>Gets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A> being selected. 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="setSelect(int, org.axiondb.Selectable)"><!-- --></A><H3>
setSelect</H3>
<PRE>
public void <B>setSelect</B>(int i, <A HREF="../../../../org/axiondb/Selectable.html">Selectable</A> sel)</PRE>
<DL>
<DD>Sets the <i>i</i><sup>th</sup> <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A> being selected.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>i</CODE> - the zero-based index<DD><CODE>sel</CODE> - the new <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</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="getSelectCount()"><!-- --></A><H3>
getSelectCount</H3>
<PRE>
public int <B>getSelectCount</B>()</PRE>
<DL>
<DD>Gets the number of <A HREF="../../../../org/axiondb/Selectable.html"><CODE>Selectable</CODE></A>s being selected.</DL>
<HR>
<A NAME="setFrom(java.util.List)"><!-- --></A><H3>
setFrom</H3>
<PRE>
public void <B>setFrom</B>(<A HREF="http://java.sun.com/products/jdk/1.3/docs/api/java/util/List.html">List</A> tables)</PRE>
<DL>
</DL>
<HR>
<A NAME="addFrom(org.axiondb.TableIdentifier)"><!-- --></A><H3>
addFrom</H3>
<PRE>
public void <B>addFrom</B>(<A HREF="../../../../org/axiondb/TableIdentifier.html">TableIdentifier</A> table)</PRE>
<DL>
<DD>Adds a <A HREF="../../../../org/axiondb/TableIdentifier.html"><CODE>TableIdentifier</CODE></A> to the list of tables being selected from.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>table</CODE> - a <A HREF="../../../../org/axiondb/TableIdentifier.html"><CODE>TableIdentifier</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="getFrom(int)"><!-- --></A><H3>
getFrom</H3>
<PRE>
public <A HREF="../../../../org/axiondb/TableIdentifier.html">TableIdentifier</A> <B>getFrom</B>(int i)</PRE>
<DL>
<DD>Gets the <i>i</i><sup>th</sup> table being selected. 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="getFromCount()"><!-- --></A><H3>
getFromCount</H3>
<PRE>
public int <B>getFromCount</B>()</PRE>
<DL>
<DD>Gets the number of tables being from.</DL>
<HR>
<A NAME="setWhere(org.axiondb.WhereNode)"><!-- --></A><H3>
setWhere</H3>
<PRE>
public void <B>setWhere</B>(<A HREF="../../../../org/axiondb/WhereNode.html">WhereNode</A> where)</PRE>
<DL>
<DD>Sets the <A HREF="../../../../org/axiondb/WhereNode.html"><CODE>where tree</CODE></A> for this query.<DD><DL>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -