<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <!--NewPage--> <HTML> <HEAD> <!-- Generated by javadoc (build 1.6.0_18) on Sat Dec 04 05:26:45 UTC 2010 --> <TITLE> Table </TITLE> <META NAME="date" CONTENT="2010-12-04"> <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style"> <SCRIPT type="text/javascript"> function windowTitle() { if (location.href.indexOf('is-external=true') == -1) { parent.document.title="Table"; } } </SCRIPT> <NOSCRIPT> </NOSCRIPT> </HEAD> <BODY BGCOLOR="white" onload="windowTitle();"> <HR> <!-- ========= START OF TOP NAVBAR ======= --> <A NAME="navbar_top"><!-- --></A> <A HREF="#skip-navbar_top" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_top_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <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="../../../../../org/apache/ws/jaxme/sqls/StringColumn.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls"><B>NEXT CLASS</B></A></FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../index.html?org/apache/ws/jaxme/sqls/Table.html" target="_top"><B>FRAMES</B></A> <A HREF="Table.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_top"></A> <!-- ========= END OF TOP NAVBAR ========= --> <HR> <!-- ======== START OF CLASS DATA ======== --> <H2> <FONT SIZE="-1"> org.apache.ws.jaxme.sqls</FONT> <BR> Interface Table</H2> <DL> <DT><B>All Known Subinterfaces:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/db2/DB2Table.html" title="interface in org.apache.ws.jaxme.sqls.db2">DB2Table</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/hsqldb/HsqlDbTable.html" title="interface in org.apache.ws.jaxme.sqls.hsqldb">HsqlDbTable</A></DD> </DL> <DL> <DT><B>All Known Implementing Classes:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/db2/DB2TableImpl.html" title="class in org.apache.ws.jaxme.sqls.db2">DB2TableImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/hsqldb/HsqlDbTableImpl.html" title="class in org.apache.ws.jaxme.sqls.hsqldb">HsqlDbTableImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/impl/TableImpl.html" title="class in org.apache.ws.jaxme.sqls.impl">TableImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/impl/ViewImpl.html" title="class in org.apache.ws.jaxme.sqls.impl">ViewImpl</A></DD> </DL> <HR> <DL> <DT><PRE>public interface <B>Table</B></DL> </PRE> <P> <p>Abstract description of a table.</p> <P> <P> <DL> <DT><B>Author:</B></DT> <DD><a href="mailto:joe@ispsoft.de">Jochen Wiedmann</a></DD> </DL> <HR> <P> <!-- ======== NESTED CLASS SUMMARY ======== --> <A NAME="nested_class_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Nested Class Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static interface</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls">Table.Name</A></B></CODE> <BR> </TD> </TR> </TABLE> <!-- ========== METHOD SUMMARY =========== --> <A NAME="method_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Method Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getColumn(org.apache.ws.jaxme.sqls.Column.Name)">getColumn</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Name.html" title="interface in org.apache.ws.jaxme.sqls">Column.Name</A> name)</CODE> <BR> Returns the column with the given name or null, if no such column exists.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getColumn(java.lang.String)">getColumn</A></B>(java.lang.String name)</CODE> <BR> Returns the column with the given name or null, if no such column exists.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Iterator</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getColumns()">getColumns</A></B>()</CODE> <BR> Returns the table columns.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/DeleteStatement.html" title="interface in org.apache.ws.jaxme.sqls">DeleteStatement</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getDeleteStatement()">getDeleteStatement</A></B>()</CODE> <BR> Returns an UPDATE statement for updating a column in the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Iterator</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getForeignKeys()">getForeignKeys</A></B>()</CODE> <BR> Returns an <CODE>Iterator</CODE> to the foreign keys defined on the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Iterator</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getIndexes()">getIndexes</A></B>()</CODE> <BR> Returns an <CODE>Iterator</CODE> to the indexes defined on the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/InsertStatement.html" title="interface in org.apache.ws.jaxme.sqls">InsertStatement</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getInsertStatement()">getInsertStatement</A></B>()</CODE> <BR> Returns an INSERT statement for filling all the values.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls">Table.Name</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getName()">getName</A></B>()</CODE> <BR> Returns the table name.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getPrimaryKey()">getPrimaryKey</A></B>()</CODE> <BR> Returns the tables primary key, if any, or null, if the table doesn't have a primary key.</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="../../../../../org/apache/ws/jaxme/sqls/Table.html#getQName()">getQName</A></B>()</CODE> <BR> Returns the tables qualified name, which is <code>getSchema().getName() + "." + getName()</code>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getSchema()">getSchema</A></B>()</CODE> <BR> Returns the table schema.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getSelectStatement()">getSelectStatement</A></B>()</CODE> <BR> Returns a SELECT statement for selecting all the columns.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/UpdateStatement.html" title="interface in org.apache.ws.jaxme.sqls">UpdateStatement</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#getUpdateStatement()">getUpdateStatement</A></B>()</CODE> <BR> Returns an UPDATE statement for updating a column in the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newColumn(org.apache.ws.jaxme.sqls.Column.Name, org.apache.ws.jaxme.sqls.Column.Type)">newColumn</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Name.html" title="interface in org.apache.ws.jaxme.sqls">Column.Name</A> name, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Type.html" title="interface in org.apache.ws.jaxme.sqls">Column.Type</A> pType)</CODE> <BR> Creates a new column.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newColumn(java.lang.String, org.apache.ws.jaxme.sqls.Column.Type)">newColumn</A></B>(java.lang.String name, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Type.html" title="interface in org.apache.ws.jaxme.sqls">Column.Type</A> pType)</CODE> <BR> Creates a new column.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newForeignKey(org.apache.ws.jaxme.sqls.Table)">newForeignKey</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pReferencedTable)</CODE> <BR> Creates a new foreign key referencing the given table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newIndex()">newIndex</A></B>()</CODE> <BR> Creates a new, non-unique index on the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newKey()">newKey</A></B>()</CODE> <BR> Creates a new, unique index on the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html#newPrimaryKey()">newPrimaryKey</A></B>()</CODE> <BR> Creates a new primary key on the table.</TD> </TR> </TABLE> <P> <!-- ============ METHOD DETAIL ========== --> <A NAME="method_detail"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> <B>Method Detail</B></FONT></TH> </TR> </TABLE> <A NAME="getName()"><!-- --></A><H3> getName</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls">Table.Name</A> <B>getName</B>()</PRE> <DL> <DD><p>Returns the table name.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getSchema()"><!-- --></A><H3> getSchema</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> <B>getSchema</B>()</PRE> <DL> <DD><p>Returns the table schema.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getColumns()"><!-- --></A><H3> getColumns</H3> <PRE> java.util.Iterator <B>getColumns</B>()</PRE> <DL> <DD><p>Returns the table columns.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newColumn(org.apache.ws.jaxme.sqls.Column.Name, org.apache.ws.jaxme.sqls.Column.Type)"><!-- --></A><H3> newColumn</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A> <B>newColumn</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Name.html" title="interface in org.apache.ws.jaxme.sqls">Column.Name</A> name, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Type.html" title="interface in org.apache.ws.jaxme.sqls">Column.Type</A> pType)</PRE> <DL> <DD><p>Creates a new column.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newColumn(java.lang.String, org.apache.ws.jaxme.sqls.Column.Type)"><!-- --></A><H3> newColumn</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A> <B>newColumn</B>(java.lang.String name, <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Type.html" title="interface in org.apache.ws.jaxme.sqls">Column.Type</A> pType)</PRE> <DL> <DD><p>Creates a new column.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getColumn(org.apache.ws.jaxme.sqls.Column.Name)"><!-- --></A><H3> getColumn</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A> <B>getColumn</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.Name.html" title="interface in org.apache.ws.jaxme.sqls">Column.Name</A> name)</PRE> <DL> <DD><p>Returns the column with the given name or null, if no such column exists.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getColumn(java.lang.String)"><!-- --></A><H3> getColumn</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Column.html" title="interface in org.apache.ws.jaxme.sqls">Column</A> <B>getColumn</B>(java.lang.String name)</PRE> <DL> <DD><p>Returns the column with the given name or null, if no such column exists.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newKey()"><!-- --></A><H3> newKey</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> <B>newKey</B>()</PRE> <DL> <DD><p>Creates a new, unique index on the table.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newIndex()"><!-- --></A><H3> newIndex</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> <B>newIndex</B>()</PRE> <DL> <DD><p>Creates a new, non-unique index on the table.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newPrimaryKey()"><!-- --></A><H3> newPrimaryKey</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> <B>newPrimaryKey</B>()</PRE> <DL> <DD><p>Creates a new primary key on the table.</p> <P> <DD><DL> <DT><B>Throws:</B> <DD><CODE>java.lang.IllegalStateException</CODE> - A primary key has already been created.</DL> </DD> </DL> <HR> <A NAME="newForeignKey(org.apache.ws.jaxme.sqls.Table)"><!-- --></A><H3> newForeignKey</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A> <B>newForeignKey</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pReferencedTable)</PRE> <DL> <DD><p>Creates a new foreign key referencing the given table.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getInsertStatement()"><!-- --></A><H3> getInsertStatement</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/InsertStatement.html" title="interface in org.apache.ws.jaxme.sqls">InsertStatement</A> <B>getInsertStatement</B>()</PRE> <DL> <DD><p>Returns an INSERT statement for filling all the values. In other words: If the table FOO has the columns A, B, and C, then the statement <code>INSERT INTO FOO (A,B,C) VALUES (?, ?, ?)</code> will be returned.</p> <P> <DD><DL> <DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html#newInsertStatement()"><CODE>SQLFactory.newInsertStatement()</CODE></A></DL> </DD> </DL> <HR> <A NAME="getSelectStatement()"><!-- --></A><H3> getSelectStatement</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement</A> <B>getSelectStatement</B>()</PRE> <DL> <DD><p>Returns a SELECT statement for selecting all the columns. In other words: If the table FOO has the columns A, B, and C, then the statement <code>SELECT A, B, C FROM FOO</code> will be returned.</p> <P> <DD><DL> <DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html#newSelectStatement()"><CODE>SQLFactory.newSelectStatement()</CODE></A></DL> </DD> </DL> <HR> <A NAME="getUpdateStatement()"><!-- --></A><H3> getUpdateStatement</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/UpdateStatement.html" title="interface in org.apache.ws.jaxme.sqls">UpdateStatement</A> <B>getUpdateStatement</B>()</PRE> <DL> <DD><p>Returns an UPDATE statement for updating a column in the table. In other words: If the table FOO has the columns A, B, C and D with the primary key columns A and B, then the statement <code>UPDATE FOO SET C = ?, D = ? WHERE A = ? AND B = ?</code> will be returned.</p> <P> <DD><DL> <DT><B>Throws:</B> <DD><CODE>java.lang.IllegalStateException</CODE> - The table doesn't have a primary key.<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html#newUpdateStatement()"><CODE>SQLFactory.newUpdateStatement()</CODE></A></DL> </DD> </DL> <HR> <A NAME="getDeleteStatement()"><!-- --></A><H3> getDeleteStatement</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/DeleteStatement.html" title="interface in org.apache.ws.jaxme.sqls">DeleteStatement</A> <B>getDeleteStatement</B>()</PRE> <DL> <DD><p>Returns an UPDATE statement for updating a column in the table. In other words: If the table FOO has the primary key columns A and B, then the statement <code>DELETE FROM FOO WHERE A = ? AND B = ?</code> will be returned.</p> <P> <DD><DL> <DT><B>Throws:</B> <DD><CODE>java.lang.IllegalStateException</CODE> - The table doesn't have a primary key.<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html#newDeleteStatement()"><CODE>SQLFactory.newDeleteStatement()</CODE></A></DL> </DD> </DL> <HR> <A NAME="getQName()"><!-- --></A><H3> getQName</H3> <PRE> java.lang.String <B>getQName</B>()</PRE> <DL> <DD><p>Returns the tables qualified name, which is <code>getSchema().getName() + "." + getName()</code>. If the schema is the default schema, returns <code>getName()</code>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getPrimaryKey()"><!-- --></A><H3> getPrimaryKey</H3> <PRE> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> <B>getPrimaryKey</B>()</PRE> <DL> <DD><p>Returns the tables primary key, if any, or null, if the table doesn't have a primary key.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getIndexes()"><!-- --></A><H3> getIndexes</H3> <PRE> java.util.Iterator <B>getIndexes</B>()</PRE> <DL> <DD><p>Returns an <CODE>Iterator</CODE> to the indexes defined on the table. This iterator includes the primary key, if any.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getForeignKeys()"><!-- --></A><H3> getForeignKeys</H3> <PRE> java.util.Iterator <B>getForeignKeys</B>()</PRE> <DL> <DD><p>Returns an <CODE>Iterator</CODE> to the foreign keys defined on the table.</p> <P> <DD><DL> </DL> </DD> </DL> <!-- ========= END OF CLASS DATA ========= --> <HR> <!-- ======= START OF BOTTOM NAVBAR ====== --> <A NAME="navbar_bottom"><!-- --></A> <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_bottom_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <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="../../../../../org/apache/ws/jaxme/sqls/StringColumn.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.Name.html" title="interface in org.apache.ws.jaxme.sqls"><B>NEXT CLASS</B></A></FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../index.html?org/apache/ws/jaxme/sqls/Table.html" target="_top"><B>FRAMES</B></A> <A HREF="Table.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_bottom"></A> <!-- ======== END OF BOTTOM NAVBAR ======= --> <HR> </BODY> </HTML>