📄 dbandexpr.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN""http://www.w3.org/TR/REC-html40/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc on Wed Jan 15 11:28:10 CET 2003 --><TITLE>DbAndExpr</TITLE><META NAME="keywords" CONTENT="javatools.db.DbAndExpr,DbAndExpr class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><SCRIPT>function asd(){parent.document.title="DbAndExpr";}</SCRIPT><BODY BGCOLOR="white" onload="asd();"><!-- ========== START OF NAVBAR ========== --><A NAME="navbar_top"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0"><TR><TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_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="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="../../javatools/db/DbAbstractTable.html"><B>PREV CLASS</B></A> <A HREF="../../javatools/db/DbCachedIterator.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="DbAndExpr.html" TARGET="_top"><B>NO FRAMES</B></A> <SCRIPT> <!-- if(window==top) { document.writeln('<A HREF="../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A>'); } //--></SCRIPT><NOSCRIPT><A HREF="../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A></NOSCRIPT></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | 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><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">javatools.db</FONT><BR>Class DbAndExpr</H2><PRE>java.lang.Object | +--<A HREF="../../javatools/db/DbExpr.html">javatools.db.DbExpr</A> | +--<A HREF="../../javatools/db/DbCriterion.html">javatools.db.DbCriterion</A> | +--<B>javatools.db.DbAndExpr</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../javatools/db/DbTableUser.html">DbTableUser</A></DD></DL><HR><DL><DT>public class <B>DbAndExpr</B><DT>extends <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></DL><P>An expression of the form A AND B. The reason we have this class as well as DbCriterion, is that this class will optimise away unnecessary segments. i.e. A AND TRUE will be optimised to just A. The reason you may find a TRUE expression in your code is the use of DbDatabase.trueExpr(). Of course we could just leave the dummy true expressions in the final SQL and presumably the dbms can optimise it away fine, but it looks a bit ugly and nasty to have these dummy expressions in the result.<P><P><DL><DT><B>See Also:</B><DD><A HREF="../../javatools/db/DbTrueExpr.html"><CODE>DbTrueExpr</CODE></A></DL><HR><P><!-- ======== NESTED CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../javatools/db/DbAndExpr.html#DbAndExpr(javatools.db.DbDatabase, java.lang.Object, java.lang.Object)">DbAndExpr</A></B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db, java.lang.Object o1, java.lang.Object o2)</CODE><BR> Builds a new "and" expression in the form "o1 AND o2".</TD></TR></TABLE> <!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></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/DbAndExpr.html#getQueryString()">getQueryString</A></B>()</CODE><BR> Returns the query string related to this expression.</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/DbAndExpr.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></B>(java.sql.PreparedStatement ps, int i)</CODE><BR> Obscure... </TD></TR></TABLE> <A NAME="methods_inherited_from_class_javatools.db.DbCriterion"><!-- --></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/DbCriterion.html">DbCriterion</A></B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="../../javatools/db/DbCriterion.html#usesTables(java.util.Set)">usesTables</A></CODE></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, 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, 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="DbAndExpr(javatools.db.DbDatabase, java.lang.Object, java.lang.Object)"><!-- --></A><H3>DbAndExpr</H3><PRE>public <B>DbAndExpr</B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db, java.lang.Object o1, java.lang.Object o2)</PRE><DL><DD>Builds a new "and" expression in the form "o1 AND o2".<P><DT><B>Parameters:</B><DD><CODE>db</CODE> - The database used to build this expression.<DD><CODE>o1</CODE> - The first term.<DD><CODE>o2</CODE> - The second term.</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="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>Returns the query string related to this expression.<P><DD><DL><DT><B>Overrides:</B><DD><CODE><A HREF="../../javatools/db/DbCriterion.html#getQueryString()">getQueryString</A></CODE> in class <CODE><A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></DL></DD><DD><DL><DT><B>Returns:</B><DD>The needed string.<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="setSqlValues(java.sql.PreparedStatement, int)"><!-- --></A><H3>setSqlValues</H3><PRE>public int <B>setSqlValues</B>(java.sql.PreparedStatement ps, int i) throws java.sql.SQLException, <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Obscure... Talk to Chris.<P><DD><DL><DT><B>Overrides:</B><DD><CODE><A HREF="../../javatools/db/DbCriterion.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></CODE> in class <CODE><A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></DL></DD><DD><DL><DT><B>Parameters:</B><DD><CODE>ps</CODE> - The prepared statement.<DD><CODE>i</CODE> - The index.<DT><B>Returns:</B><DD>The return value<DT><B>Throws:</B><DD><CODE>java.sql.SQLException</CODE> - If something goes wrong.<DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</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=3 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="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="../../javatools/db/DbAbstractTable.html"><B>PREV CLASS</B></A> <A HREF="../../javatools/db/DbCachedIterator.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="DbAndExpr.html" TARGET="_top"><B>NO FRAMES</B></A> <SCRIPT> <!-- if(window==top) { document.writeln('<A HREF="../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A>'); } //--></SCRIPT><NOSCRIPT><A HREF="../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A></NOSCRIPT></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | 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></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -