dbselector.html

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

<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="getColumn(int)"><!-- --></A><H3>
getColumn</H3>
<PRE>
public <A HREF="../../javatools/db/DbColumn.html">DbColumn</A> <B>getColumn</B>(int&nbsp;index)</PRE>
<DL>
<DD>Gets a column in the column list.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>index</CODE> - The column to be got.
<DT><B>Returns:</B><DD>The requested column.</DL>
</DD>
</DL>
<HR>

<A NAME="addAll(javatools.db.DbAbstractTable)"><!-- --></A><H3>
addAll</H3>
<PRE>
public void <B>addAll</B>(<A HREF="../../javatools/db/DbAbstractTable.html">DbAbstractTable</A>&nbsp;table)
            throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Add all the columns from the given table to the select list. A bit like
 SELECT * from table.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>table</CODE> - the table whose columns we wish to add
<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="addAllExcept(javatools.db.DbAbstractTable, javatools.db.DbColumn)"><!-- --></A><H3>
addAllExcept</H3>
<PRE>
public void <B>addAllExcept</B>(<A HREF="../../javatools/db/DbAbstractTable.html">DbAbstractTable</A>&nbsp;table,
                         <A HREF="../../javatools/db/DbColumn.html">DbColumn</A>&nbsp;o)
                  throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Add all the columns from the given table to the select list. A bit like
 SELECT * from table.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>table</CODE> - the table whose columns we wish to add<DD><CODE>o</CODE> - The feature to be added to the AllExcept attribute
<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="addAllExcept(javatools.db.DbAbstractTable, java.util.Set)"><!-- --></A><H3>
addAllExcept</H3>
<PRE>
public void <B>addAllExcept</B>(<A HREF="../../javatools/db/DbAbstractTable.html">DbAbstractTable</A>&nbsp;table,
                         java.util.Set&nbsp;set)
                  throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Add all the columns from the given table to the select list. A bit like
 SELECT * from table.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>table</CODE> - the table whose columns we wish to add<DD><CODE>set</CODE> - The feature to be added to the AllExcept attribute
<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="addOrderBy(javatools.db.DbExpr, boolean)"><!-- --></A><H3>
addOrderBy</H3>
<PRE>
public void <B>addOrderBy</B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A>&nbsp;column,
                       boolean&nbsp;desc)</PRE>
<DL>
<DD>Add an ORDER BY clause to this select. The column actually need not be a
  plain column. It could be a column with a function applied. e.g.
  addOrderBy(table.getColumn("NAME").upper, false);
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>column</CODE> - the column to order by<DD><CODE>desc</CODE> - whether to sort in descending order</DL>
</DD>
</DL>
<HR>

<A NAME="addGroupBy(javatools.db.DbExpr)"><!-- --></A><H3>
addGroupBy</H3>
<PRE>
public void <B>addGroupBy</B>(<A HREF="../../javatools/db/DbExpr.html">DbExpr</A>&nbsp;column)</PRE>
<DL>
<DD>Adds a GROUP BY column to this select.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>column</CODE> - The column to add in the GROUP BY clause.</DL>
</DD>
</DL>
<HR>

<A NAME="setDistinct(boolean)"><!-- --></A><H3>
setDistinct</H3>
<PRE>
public void <B>setDistinct</B>(boolean&nbsp;pDistinct)</PRE>
<DL>
<DD>Sets the value to control whether to put the DISTINCT clause or not.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>pDistinct</CODE> - <CODE>true</CODE>: clause DISTINCT will be put;
 <CODE>false</CODE>: clause DISTINCT will not be put.</DL>
</DD>
</DL>
<HR>

<A NAME="addJoinedTable(javatools.db.DbJoinedTable)"><!-- --></A><H3>
addJoinedTable</H3>
<PRE>
public void <B>addJoinedTable</B>(<A HREF="../../javatools/db/DbJoinedTable.html">DbJoinedTable</A>&nbsp;joinedTable)</PRE>
<DL>
<DD>Adds a joined table.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>joinedTable</CODE> - The joined table to add.</DL>
</DD>
</DL>
<HR>

<A NAME="executeToResultSet(javatools.db.DbConnection)"><!-- --></A><H3>
executeToResultSet</H3>
<PRE>
public void <B>executeToResultSet</B>(<A HREF="../../javatools/db/DbConnection.html">DbConnection</A>&nbsp;dbcon)
                        throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Execute and get a JDBC ResultSet.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>dbcon</CODE> - The connection to use.
<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="execute(javatools.db.DbConnection)"><!-- --></A><H3>
execute</H3>
<PRE>
public <A HREF="../../javatools/db/DbTable.html">DbTable</A> <B>execute</B>(<A HREF="../../javatools/db/DbConnection.html">DbConnection</A>&nbsp;dbcon)
                throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Execute and return a DbTable.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>dbcon</CODE> - The connection to use.
<DT><B>Returns:</B><DD>The result, in a DbTable.
<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="execute()"><!-- --></A><H3>
execute</H3>
<PRE>
public <A HREF="../../javatools/db/DbTable.html">DbTable</A> <B>execute</B>()
                throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE>
<DL>
<DD>Execute and return a DbTable with the default DbConnection.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>The result, in a DbTable
<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="toString()"><!-- --></A><H3>
toString</H3>
<PRE>
public java.lang.String <B>toString</B>()</PRE>
<DL>
<DD>Converts this selector in a string.
<P>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE>toString</CODE> in class <CODE>java.lang.Object</CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The requested string.</DL>
</DD>
</DL>
<HR>

<A NAME="selectTables(java.util.Set)"><!-- --></A><H3>
selectTables</H3>
<PRE>
public void <B>selectTables</B>(java.util.Set&nbsp;c)</PRE>
<DL>
<DD>Creates a SELECT instruction with given tables.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>c</CODE> - A set of tables.</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/DbRowSet.html"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../javatools/db/DbSequence.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="DbSelector.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;CONSTR&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<!-- =========== END OF NAVBAR =========== -->

<HR>

</BODY>
</HTML>