dbcriterion.html

Medi 这是一个基于Java的媒体文件归档器工具

<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>
&nbsp;<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>
&nbsp;
<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="DbCriterion(javatools.db.DbDatabase, java.lang.Object, java.lang.String, java.lang.Object)"><!-- --></A><H3>
DbCriterion</H3>
<PRE>
public <B>DbCriterion</B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A>&nbsp;db,
                   java.lang.Object&nbsp;c1,
                   java.lang.String&nbsp;op,
                   java.lang.Object&nbsp;c2)</PRE>
<DL>
<DD>Builds a new DbCriterion object.
<P>
<DT><B>Parameters:</B><DD><CODE>db</CODE> - The database for this operation.<DD><CODE>c1</CODE> - The first term.<DD><CODE>op</CODE> - The operator.<DD><CODE>c2</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>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 requested 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&nbsp;ps,
                        int&nbsp;i)
                 throws <A HREF="../../javatools/db/DbException.html">DbException</A>,
                        java.sql.SQLException</PRE>
<DL>
<DD>Sets the real values in the passed statement. Anyway it is an obscure method,
 call Chris Bitmead.
<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>ps</CODE> - The statement to put data into.<DD><CODE>i</CODE> - An index.
<DT><B>Returns:</B><DD>An index.
<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="usesTables(java.util.Set)"><!-- --></A><H3>
usesTables</H3>
<PRE>
public void <B>usesTables</B>(java.util.Set&nbsp;c)</PRE>
<DL>
<DD>Adds to the passed set, 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><DT><B>Overrides:</B><DD><CODE><A HREF="../../javatools/db/DbExpr.html#usesTables(java.util.Set)">usesTables</A></CODE> in class <CODE><A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>c</CODE> - The set to add tables to.</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>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../javatools/db/DbConstraint.html"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../javatools/db/DbDatabase.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>  &nbsp;
&nbsp;<A HREF="DbCriterion.html" TARGET="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;
<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:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<!-- =========== END OF NAVBAR =========== -->

<HR>

</BODY>
</HTML>