📄 dbexpr.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:11 CET 2003 --><TITLE>DbExpr</TITLE><META NAME="keywords" CONTENT="javatools.db.DbExpr,DbExpr class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><SCRIPT>function asd(){parent.document.title="DbExpr";}</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/DbDynamicConstraint.html"><B>PREV CLASS</B></A> <A HREF="../../javatools/db/DbExprFuncDef.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="DbExpr.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 DbExpr</H2><PRE>java.lang.Object | +--<B>javatools.db.DbExpr</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../javatools/db/DbTableUser.html">DbTableUser</A></DD></DL><DL><DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../javatools/db/DbColumn.html">DbColumn</A>, <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A>, <A HREF="../../javatools/db/DbExprFuncDef.html">DbExprFuncDef</A>, <A HREF="../../javatools/db/DbLiteral.html">DbLiteral</A>, <A HREF="../../javatools/db/DbMiscExpr.html">DbMiscExpr</A>, <A HREF="../../javatools/db/DbParenthesis.html">DbParenthesis</A>, <A HREF="../../javatools/db/DbSelector.html">DbSelector</A>, <A HREF="../../javatools/db/DbValueList.html">DbValueList</A></DD></DL><HR><DL><DT>public abstract class <B>DbExpr</B><DT>extends java.lang.Object<DT>implements <A HREF="../../javatools/db/DbTableUser.html">DbTableUser</A></DL><P>An sql expression class. This is the abstract base class for any type of SQL expression.<P><P><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/DbExpr.html#DbExpr(javatools.db.DbDatabase)">DbExpr</A></B>(<A HREF="../../javatools/db/DbDatabase.html">DbDatabase</A> db)</CODE><BR> Constructor for the DbExpr object</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> <A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#and(javatools.db.DbExpr)">and</A></B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A> e)</CODE><BR> Returns an expression created as an "and" 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> <A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#containsAllStrings(java.util.List)">containsAllStrings</A></B>(java.util.List values)</CODE><BR> Creates an expression to be used to search in char columns containing one of the specified strings.</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#containsAllStrings(java.lang.String[])">containsAllStrings</A></B>(java.lang.String[] values)</CODE><BR> Creates an expression to be used to search in char columns containing one of the specified strings.</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#count()">count</A></B>()</CODE><BR> Returns the count expression for the current expression. </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#dateTrunc()">dateTrunc</A></B>()</CODE><BR> Truncs the date? </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#equal(java.lang.Object)">equal</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being equal to another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>abstract java.lang.String</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#getQueryString()">getQueryString</A></B>()</CODE><BR> Any DbExpr needs to be able to convert into the SQL string equivilent.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#greaterThan(java.lang.Object)">greaterThan</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being greater than another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#greaterThanOrEqual(java.lang.Object)">greaterThanOrEqual</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being greater than or equal to another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#in(java.util.Collection)">in</A></B>(java.util.Collection valueList)</CODE><BR> Returns an expression that means "IN (value1, value2, ..., valuen)"</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#in(java.lang.Object)">in</A></B>(java.lang.Object o)</CODE><BR> Returns an expression to represent the "in" clause.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#isNotNull()">isNotNull</A></B>()</CODE><BR> Gets the notNull attribute of the DbExpr object</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#isNull()">isNull</A></B>()</CODE><BR> Gets the null attribute of the DbExpr object</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#lessThan(java.lang.Object)">lessThan</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being less than another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#lessThanOrEqual(java.lang.Object)">lessThanOrEqual</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being less than or equal to another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#like(java.lang.Object)">like</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being LIKE another value.</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#lower()">lower</A></B>()</CODE><BR> Returns an expression in which it will take the lowercase value for current expression.</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#max()">max</A></B>()</CODE><BR> Returns an expression in which it will take the max value for current expression.</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#min()">min</A></B>()</CODE><BR> Returns an expression in which it will take the max value for current expression.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#notEqual(java.lang.Object)">notEqual</A></B>(java.lang.Object o)</CODE><BR> Return an expression representing this column being equal to another value.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#notIn(java.util.Collection)">notIn</A></B>(java.util.Collection valueList)</CODE><BR> Returns an expression that means "NOT IN (value1, value2, ..., valuen)"</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbCriterion.html">DbCriterion</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbExpr.html#notIn(java.lang.Object)">notIn</A></B>(java.lang.Object o)</CODE><BR> Returns an expression to represent the "not in" clause.</TD></TR>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -