📄 dbexpr.html
字号:
<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/DbExpr.html#or(javatools.db.DbExpr)">or</A></B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> e)</CODE><BR> Returns an expression created as an "or" between the current expression and another expression.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>abstract int</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></B>(java.sql.PreparedStatement ps, int i)</CODE><BR> Any DbExpr needs to be able to substitute any parameters as per JDBC "?" </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/DbExpr.html#upper()">upper</A></B>()</CODE><BR> Returns an expression in which it will take the uppercase value for current expression.</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/DbExpr.html#usesTables(java.util.Set)">usesTables</A></B>(java.util.Set c)</CODE><BR> Adds to the passed set all the tables used by this expression.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static void</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#usesTables(java.util.Set, java.lang.Object)">usesTables</A></B>(java.util.Set c, java.lang.Object o)</CODE><BR> Adds to the passed set all the tables used by an expression.</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, toString, wait, wait, wait</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="DbExpr(javatools.db.DbDatabase)"><!-- --></A><H3>DbExpr</H3><PRE>public <B>DbExpr</B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db)</PRE><DL><DD>Constructor for the DbExpr object<P><DT><B>Parameters:</B><DD><CODE>db</CODE> - The database to be used.</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="usesTables(java.util.Set, java.lang.Object)"><!-- --></A><H3>usesTables</H3><PRE>public static void <B>usesTables</B>(java.util.Set c, java.lang.Object o)</PRE><DL><DD>Adds to the passed set all the tables used by an expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>c</CODE> - The set to add used tables to.<DD><CODE>o</CODE> - The expression to find tables from.</DL></DD></DL><HR><A NAME="setSqlValues(java.sql.PreparedStatement, int)"><!-- --></A><H3>setSqlValues</H3><PRE>public abstract int <B>setSqlValues</B>(java.sql.PreparedStatement ps, int i) throws <A HREF="../../javatools/db/DbException.html">DbException</A>, java.sql.SQLException</PRE><DL><DD>Any DbExpr needs to be able to substitute any parameters as per JDBC "?" substitutions.<P><DD><DL></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>ps</CODE> - The PreparedStatement<DD><CODE>i</CODE> - The new sqlValues value<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="getQueryString()"><!-- --></A><H3>getQueryString</H3><PRE>public abstract java.lang.String <B>getQueryString</B>() throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Any DbExpr needs to be able to convert into the SQL string equivilent.<P><DD><DL></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="isNull()"><!-- --></A><H3>isNull</H3><PRE>public <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A> <B>isNull</B>()</PRE><DL><DD>Gets the null attribute of the DbExpr object<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The null value</DL></DD></DL><HR><A NAME="isNotNull()"><!-- --></A><H3>isNotNull</H3><PRE>public <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A> <B>isNotNull</B>()</PRE><DL><DD>Gets the notNull attribute of the DbExpr object<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The notNull value</DL></DD></DL><HR><A NAME="usesTables(java.util.Set)"><!-- --></A><H3>usesTables</H3><PRE>public void <B>usesTables</B>(java.util.Set c)</PRE><DL><DD>Adds to the passed set all the tables used by this expression.<P><DD><DL><DT><B>Specified by:</B><DD><CODE><A HREF="../../javatools/db/DbTableUser.html#usesTables(java.util.Set)">usesTables</A></CODE> in interface <CODE><A HREF="../../javatools/db/DbTableUser.html">DbTableUser</A></CODE></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>c</CODE> - The set to add tables to.</DL></DD></DL><HR><A NAME="and(javatools.db.DbExpr)"><!-- --></A><H3>and</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>and</B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> e)</PRE><DL><DD>Returns an expression created as an "and" between the current expression and another expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>e</CODE> - The expression with which it will build the "and" expression.<DT><B>Returns:</B><DD>The resulting "and" expression.</DL></DD></DL><HR><A NAME="or(javatools.db.DbExpr)"><!-- --></A><H3>or</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>or</B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> e)</PRE><DL><DD>Returns an expression created as an "or" between the current expression and another expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>e</CODE> - The expression with which it will build the "and" expression.<DT><B>Returns:</B><DD>The resulting "or" expression.</DL></DD></DL><HR><A NAME="max()"><!-- --></A><H3>max</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>max</B>()</PRE><DL><DD>Returns an expression in which it will take the max value for current expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The expression representing the max value for this expression.</DL></DD></DL><HR><A NAME="min()"><!-- --></A><H3>min</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>min</B>()</PRE><DL><DD>Returns an expression in which it will take the max value for current expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The expression representing the max value for this expression.</DL></DD></DL><HR><A NAME="upper()"><!-- --></A><H3>upper</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>upper</B>()</PRE><DL><DD>Returns an expression in which it will take the uppercase value for current expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The uppercase for this expression.</DL></DD></DL><HR><A NAME="lower()"><!-- --></A><H3>lower</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>lower</B>()</PRE><DL><DD>Returns an expression in which it will take the lowercase value for current expression.<P><DD><DL></DL></DD><DD><DL><DT><B>Returns:</B><DD>The lowercase for this expression.</DL></DD></DL><HR><A NAME="count()"><!-- --></A><H3>count</H3><PRE>public <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> <B>count</B>()</PRE><DL><DD>Returns the count expression for the current expression. It is effective only with a <CODE>DbLiteral</CODE> expression, containing <CODE>"*"</CODE>.<P><DD><DL>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -