📄 dbselector.html
字号:
<BR> Gets a column in the column list.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> java.lang.String</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbSelector.html#getQueryString()">getQueryString</A></B>()</CODE><BR> Get the query string represented by this query.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbSelector.html#getWhere()">getWhere</A></B>()</CODE><BR> Returns the where condition.</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="../../javatools/db/DbSelector.html#selectTables(java.util.Set)">selectTables</A></B>(java.util.Set c)</CODE><BR> Creates a SELECT instruction with given tables.</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="../../javatools/db/DbSelector.html#setDistinct(boolean)">setDistinct</A></B>(boolean pDistinct)</CODE><BR> Sets the value to control whether to put the DISTINCT clause or not.</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="../../javatools/db/DbSelector.html#setLimit(int)">setLimit</A></B>(int n)</CODE><BR> Don't get the whole result set, get only a limited number of rows. </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="../../javatools/db/DbSelector.html#setOffset(int)">setOffset</A></B>(int n)</CODE><BR> Don't get the first results, but skip n result rows. </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="../../javatools/db/DbSelector.html#setOrderBy(java.util.List)">setOrderBy</A></B>(java.util.List l)</CODE><BR> Set the entire orderby list in one go.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbSelector.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></B>(java.sql.PreparedStatement stmt, int i)</CODE><BR> Puts data into statement.</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="../../javatools/db/DbSelector.html#setWhere(javatools.db.DbExpr)">setWhere</A></B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> where)</CODE><BR> Set the where condition for this query.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> java.lang.String</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbSelector.html#toString()">toString</A></B>()</CODE><BR> Converts this selector in a string.</TD></TR></TABLE> <A NAME="methods_inherited_from_class_javatools.db.DbExpr"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"><TD><B>Methods inherited from class javatools.db.<A HREF="../../javatools/db/DbExpr.html">DbExpr</A></B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="../../javatools/db/DbExpr.html#and(javatools.db.DbExpr)">and</A>, <A HREF="../../javatools/db/DbExpr.html#containsAllStrings(java.util.List)">containsAllStrings</A>, <A HREF="../../javatools/db/DbExpr.html#containsAllStrings(java.lang.String[])">containsAllStrings</A>, <A HREF="../../javatools/db/DbExpr.html#count()">count</A>, <A HREF="../../javatools/db/DbExpr.html#dateTrunc()">dateTrunc</A>, <A HREF="../../javatools/db/DbExpr.html#equal(java.lang.Object)">equal</A>, <A HREF="../../javatools/db/DbExpr.html#greaterThan(java.lang.Object)">greaterThan</A>, <A HREF="../../javatools/db/DbExpr.html#greaterThanOrEqual(java.lang.Object)">greaterThanOrEqual</A>, <A HREF="../../javatools/db/DbExpr.html#in(java.util.Collection)">in</A>, <A HREF="../../javatools/db/DbExpr.html#in(java.lang.Object)">in</A>, <A HREF="../../javatools/db/DbExpr.html#isNotNull()">isNotNull</A>, <A HREF="../../javatools/db/DbExpr.html#isNull()">isNull</A>, <A HREF="../../javatools/db/DbExpr.html#lessThan(java.lang.Object)">lessThan</A>, <A HREF="../../javatools/db/DbExpr.html#lessThanOrEqual(java.lang.Object)">lessThanOrEqual</A>, <A HREF="../../javatools/db/DbExpr.html#like(java.lang.Object)">like</A>, <A HREF="../../javatools/db/DbExpr.html#lower()">lower</A>, <A HREF="../../javatools/db/DbExpr.html#max()">max</A>, <A HREF="../../javatools/db/DbExpr.html#min()">min</A>, <A HREF="../../javatools/db/DbExpr.html#notEqual(java.lang.Object)">notEqual</A>, <A HREF="../../javatools/db/DbExpr.html#notIn(java.util.Collection)">notIn</A>, <A HREF="../../javatools/db/DbExpr.html#notIn(java.lang.Object)">notIn</A>, <A HREF="../../javatools/db/DbExpr.html#or(javatools.db.DbExpr)">or</A>, <A HREF="../../javatools/db/DbExpr.html#upper()">upper</A>, <A HREF="../../javatools/db/DbExpr.html#usesTables(java.util.Set)">usesTables</A>, <A HREF="../../javatools/db/DbExpr.html#usesTables(java.util.Set, java.lang.Object)">usesTables</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.Object</B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait</CODE></TD></TR></TABLE> <P><!-- ============ FIELD DETAIL =========== --><!-- ========= CONSTRUCTOR DETAIL ======== --><!-- ============ 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="setWhere(javatools.db.DbExpr)"><!-- --></A><H3>setWhere</H3><PRE>public void <B>setWhere</B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> where)</PRE><DL><DD>Set the where condition for this query.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>where</CODE> - The new where value</DL></DD></DL><HR><A NAME="getWhere()"><!-- --></A><H3>getWhere</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>getWhere</B>()</PRE><DL><DD>Returns the where condition.<P><DD><DL><DT><B>Returns:</B><DD>The stored where condition.</DL></DD></DL><HR><A NAME="setOrderBy(java.util.List)"><!-- --></A><H3>setOrderBy</H3><PRE>public void <B>setOrderBy</B>(java.util.List l)</PRE><DL><DD>Set the entire orderby list in one go.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>l</CODE> - The new orderBy value</DL></DD></DL><HR><A NAME="setSqlValues(java.sql.PreparedStatement, int)"><!-- --></A><H3>setSqlValues</H3><PRE>public int <B>setSqlValues</B>(java.sql.PreparedStatement stmt, int i) throws <A HREF="../../javatools/db/DbException.html">DbException</A>, java.sql.SQLException</PRE><DL><DD>Puts data into statement.<P><DD><DL><DT><B>Specified by:</B><DD><CODE><A HREF="../../javatools/db/DbExpr.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></CODE> in class <CODE><A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>stmt</CODE> - The statement to use.<DD><CODE>i</CODE> - An index (obscure).<DT><B>Returns:</B><DD>An index (obscure).<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.<DD><CODE>java.sql.SQLException</CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="setLimit(int)"><!-- --></A><H3>setLimit</H3><PRE>public void <B>setLimit</B>(int n) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Don't get the whole result set, get only a limited number of rows. Should be used in conjunction with ORDER BY in order to make the returned rows deterministic.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>n</CODE> - The new limit value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="setOffset(int)"><!-- --></A><H3>setOffset</H3><PRE>public void <B>setOffset</B>(int n) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Don't get the first results, but skip n result rows. Should be used in conjunction with ORDER BY in order to make the returned rows deterministic.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>n</CODE> - The new offset value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="getQueryString()"><!-- --></A><H3>getQueryString</H3><PRE>public java.lang.String <B>getQueryString</B>() throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Get the query string represented by this query.<P><DD><DL><DT><B>Specified by:</B><DD><CODE><A HREF="../../javatools/db/DbExpr.html#getQueryString()">getQueryString</A></CODE> in class <CODE><A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></DL></DD><DD><DL><DT><B>Returns:</B><DD>The queryString value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="addColumn(java.lang.Object)"><!-- --></A><H3>addColumn</H3><PRE>public <A HREF="../../javatools/db/DbColumn.html">DbColumn</A> <B>addColumn</B>(java.lang.Object col) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Add the given object to the select column list.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>col</CODE> - A DbColumn, DbExpr or literal value<DT><B>Returns:</B><DD>The column itself.<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="addColumn(java.lang.Object, java.lang.String)"><!-- --></A><H3>addColumn</H3><PRE>public <A HREF="../../javatools/db/DbColumn.html">DbColumn</A> <B>addColumn</B>(java.lang.Object col, java.lang.String as) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Add the given object to the select column list with an "AS" alias.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>col</CODE> - a DbColumn, DbExpr or literal value<DD><CODE>as</CODE> - a column alias<DT><B>Returns:</B><DD>The column itself.⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -