📄 dborexpr.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:12 CET 2003 --><TITLE>DbOrExpr</TITLE><META NAME="keywords" CONTENT="javatools.db.DbOrExpr,DbOrExpr class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><SCRIPT>function asd(){parent.document.title="DbOrExpr";}</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/DbOrderBy.html"><B>PREV CLASS</B></A> <A HREF="../../javatools/db/DbParenthesis.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="DbOrExpr.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 DbOrExpr</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.DbOrExpr</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>DbOrExpr</B><DT>extends <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></DL><P>An expression of the form A OR B. The reason we have this class as well as DbCriterion, is that this class will optimise away unnecessary segments. i.e. A OR FALSE will be optimised to just A. The reason you may find a FALSE expression in your code is the use of DbDatabase.falseExpr(). This is a very convenient thing for dynamically generated queries. Of course we could just leave the dummy false 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><CODE>DbFalseExpr.</CODE></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/DbOrExpr.html#DbOrExpr(javatools.db.DbDatabase, java.lang.Object, java.lang.Object)">DbOrExpr</A></B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db, java.lang.Object o1, java.lang.Object o2)</CODE><BR> Creates a new OR expression.</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/DbOrExpr.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/DbOrExpr.html#setSqlValues(java.sql.PreparedStatement, int)">setSqlValues</A></B>(java.sql.PreparedStatement ps, int i)</CODE><BR> Puts data into a statement.</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="DbOrExpr(javatools.db.DbDatabase, java.lang.Object, java.lang.Object)"><!-- --></A><H3>DbOrExpr</H3><PRE>public <B>DbOrExpr</B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db, java.lang.Object o1, java.lang.Object o2)</PRE><DL><DD>Creates a new OR expression.<P><DT><B>Parameters:</B><DD><CODE>db</CODE> - The database that will be used.<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="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>Puts data into a statement.<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 statement.<DD><CODE>i</CODE> - An index (obscure).<DT><B>Returns:</B><DD>An index (obscure).<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><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>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 requested query string.<DT><B>Throws:</B><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/DbOrderBy.html"><B>PREV CLASS</B></A> <A HREF="../../javatools/db/DbParenthesis.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="DbOrExpr.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 + -