<!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> SQLGenerator </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="SQLGenerator"; } } </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/SQLFactory.Ident.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.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/SQLGenerator.html" target="_top"><B>FRAMES</B></A> <A HREF="SQLGenerator.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: NESTED | 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 SQLGenerator</H2> <DL> <DT><B>All Known Subinterfaces:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/db2/DB2SQLGenerator.html" title="interface in org.apache.ws.jaxme.sqls.db2">DB2SQLGenerator</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/hsqldb/HsqlDbSQLGenerator.html" title="interface in org.apache.ws.jaxme.sqls.hsqldb">HsqlDbSQLGenerator</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/oracle/OraSQLGenerator.html" title="interface in org.apache.ws.jaxme.sqls.oracle">OraSQLGenerator</A></DD> </DL> <DL> <DT><B>All Known Implementing Classes:</B> <DD><A HREF="../../../../../org/apache/ws/jaxme/sqls/db2/DB2SQLGeneratorImpl.html" title="class in org.apache.ws.jaxme.sqls.db2">DB2SQLGeneratorImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/hsqldb/HsqlDbSQLGeneratorImpl.html" title="class in org.apache.ws.jaxme.sqls.hsqldb">HsqlDbSQLGeneratorImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/oracle/OraSQLGeneratorImpl.html" title="class in org.apache.ws.jaxme.sqls.oracle">OraSQLGeneratorImpl</A>, <A HREF="../../../../../org/apache/ws/jaxme/sqls/impl/SQLGeneratorImpl.html" title="class in org.apache.ws.jaxme.sqls.impl">SQLGeneratorImpl</A></DD> </DL> <HR> <DL> <DT><PRE>public interface <B>SQLGenerator</B></DL> </PRE> <P> <p>An SQL generator.</p> <P> <P> <DL> <DT><B>Author:</B></DT> <DD><a href="mailto:joe@ispsoft.de">Jochen Wiedmann</a></DD> </DL> <HR> <P> <!-- ========== 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> java.lang.String</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getConstraint(org.apache.ws.jaxme.sqls.Constraint)">getConstraint</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Constraint.html" title="interface in org.apache.ws.jaxme.sqls">Constraint</A> pConstraint)</CODE> <BR> Generates the WHERE clause of a SELECT, UPDATE, or DELETE statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.ForeignKey)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A> pKey)</CODE> <BR> Generates a CREATE FOREIGN KEY statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Index)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> pIndex)</CODE> <BR> Generates a CREATE INDEX statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Schema)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema)</CODE> <BR> Generates a <code>CREATE SCHEMA</code> statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Schema, boolean)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema, boolean pAll)</CODE> <BR> Generates <code>CREATE</code> statements for the schema.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Table)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable)</CODE> <BR> Generates a CREATE TABLE statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Table, boolean)">getCreate</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable, boolean pAll)</CODE> <BR> Generates <code>CREATE</code> statements for the table.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.ForeignKey)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A> pKey)</CODE> <BR> Generates a DROP FOEIGN KEY statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Index)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> pIndex)</CODE> <BR> Generates a DROP INDEX statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Schema)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema)</CODE> <BR> Generates a DROP SCHEMA statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Schema, boolean)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema, boolean pAll)</CODE> <BR> Generates <code>DROP</code> statements for the schema.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Table)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable)</CODE> <BR> Generates a DROP TABLE statement.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Collection</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Table, boolean)">getDrop</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable, boolean pAll)</CODE> <BR> Generates <code>DROP</code> statements for the table.</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/SQLGenerator.html#getLineTerminator()">getLineTerminator</A></B>()</CODE> <BR> Returns the line terminator.</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/SQLGenerator.html#getQuery(org.apache.ws.jaxme.sqls.Statement)">getQuery</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html" title="interface in org.apache.ws.jaxme.sqls">Statement</A> pStatement)</CODE> <BR> Generates an INSERT, UPDATE, DELETE or SELECT statement.</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/SQLGenerator.html#getStatementTerminator()">getStatementTerminator</A></B>()</CODE> <BR> Returns the statement terminator.</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/SQLGenerator.html#getWhereClause(org.apache.ws.jaxme.sqls.SelectStatement)">getWhereClause</A></B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement</A> pQuery)</CODE> <BR> Returns the <code>WHERE ...</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#setLineTerminator(java.lang.String)">setLineTerminator</A></B>(java.lang.String pTerminator)</CODE> <BR> Sets the line terminator.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#setStatementTerminator(java.lang.String)">setStatementTerminator</A></B>(java.lang.String pTerminator)</CODE> <BR> Sets the statement terminator.</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="getCreate(org.apache.ws.jaxme.sqls.Schema)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema)</PRE> <DL> <DD><p>Generates a <code>CREATE SCHEMA</code> statement. Doesn't create <code>CREATE TABLE</code> or similar statements.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getCreate(org.apache.ws.jaxme.sqls.Schema, boolean)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema, boolean pAll)</PRE> <DL> <DD><p>Generates <code>CREATE</code> statements for the schema.</p> <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>pAll</CODE> - If this parameter is set to true, then the method is equivalent to <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Schema)"><CODE>getCreate(Schema)</CODE></A>. Otherwise the returned collection will also include <code>CREATE</code> statements for all the tables and indexes in the schema. These additional statements are created by invoking <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Table, boolean)"><CODE>getCreate(Table,boolean)</CODE></A> for all the tables in the schema.</p></DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.Schema)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema)</PRE> <DL> <DD><p>Generates a DROP SCHEMA statement. Doesn't create <code>DROP TABLE</code> or similar statements.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.Schema, boolean)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Schema.html" title="interface in org.apache.ws.jaxme.sqls">Schema</A> pSchema, boolean pAll)</PRE> <DL> <DD><p>Generates <code>DROP</code> statements for the schema.</p> <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>pAll</CODE> - If this parameter is set to true, then the method is equivalent to <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Schema)"><CODE>getDrop(Schema)</CODE></A>. Otherwise the returned collection will also include <code>DROP</code> statements for all the tables and indexes in the schema. These additional statements are created by invoking <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Table, boolean)"><CODE>getDrop(Table,boolean)</CODE></A> for all the tables in the schema.</p></DL> </DD> </DL> <HR> <A NAME="getCreate(org.apache.ws.jaxme.sqls.Table)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable)</PRE> <DL> <DD><p>Generates a CREATE TABLE statement. Doesn't create <code>CREATE INDEX</code> or similar statements.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getCreate(org.apache.ws.jaxme.sqls.Table, boolean)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable, boolean pAll)</PRE> <DL> <DD><p>Generates <code>CREATE</code> statements for the table.</p> <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>pAll</CODE> - If this parameter is set to true, then the method is equivalent to <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Table)"><CODE>getCreate(Table)</CODE></A>. Otherwise the returned collection will also include <code>CREATE</code> statements for the indexes, which are defined on the table. These additional statements are created by invoking <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.Index)"><CODE>getCreate(Index)</CODE></A> and <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getCreate(org.apache.ws.jaxme.sqls.ForeignKey)"><CODE>getCreate(ForeignKey)</CODE></A> for all the indexes in the schema.</p></DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.Table)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable)</PRE> <DL> <DD><p>Generates a DROP TABLE statement. Doesn't create <code>DROP INDEX</code> or similar statements.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.Table, boolean)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Table.html" title="interface in org.apache.ws.jaxme.sqls">Table</A> pTable, boolean pAll)</PRE> <DL> <DD><p>Generates <code>DROP</code> statements for the table.</p> <P> <DD><DL> <DT><B>Parameters:</B><DD><CODE>pAll</CODE> - If this parameter is set to true, then the method is equivalent to <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Table)"><CODE>getDrop(Table)</CODE></A>. Otherwise the returned collection will also include <code>DROP</code> statements for the indexes, which are defined on the table. These additional statements are created by invoking <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.Index)"><CODE>getDrop(Index)</CODE></A> and <A HREF="../../../../../org/apache/ws/jaxme/sqls/SQLGenerator.html#getDrop(org.apache.ws.jaxme.sqls.ForeignKey)"><CODE>getDrop(ForeignKey)</CODE></A> for all the indexes in the schema.</p></DL> </DD> </DL> <HR> <A NAME="getCreate(org.apache.ws.jaxme.sqls.Index)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> pIndex)</PRE> <DL> <DD><p>Generates a CREATE INDEX statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.Index)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Index.html" title="interface in org.apache.ws.jaxme.sqls">Index</A> pIndex)</PRE> <DL> <DD><p>Generates a DROP INDEX statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getCreate(org.apache.ws.jaxme.sqls.ForeignKey)"><!-- --></A><H3> getCreate</H3> <PRE> java.util.Collection <B>getCreate</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A> pKey)</PRE> <DL> <DD><p>Generates a CREATE FOREIGN KEY statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getDrop(org.apache.ws.jaxme.sqls.ForeignKey)"><!-- --></A><H3> getDrop</H3> <PRE> java.util.Collection <B>getDrop</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/ForeignKey.html" title="interface in org.apache.ws.jaxme.sqls">ForeignKey</A> pKey)</PRE> <DL> <DD><p>Generates a DROP FOEIGN KEY statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getQuery(org.apache.ws.jaxme.sqls.Statement)"><!-- --></A><H3> getQuery</H3> <PRE> java.lang.String <B>getQuery</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.html" title="interface in org.apache.ws.jaxme.sqls">Statement</A> pStatement)</PRE> <DL> <DD><p>Generates an INSERT, UPDATE, DELETE or SELECT statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getConstraint(org.apache.ws.jaxme.sqls.Constraint)"><!-- --></A><H3> getConstraint</H3> <PRE> java.lang.String <B>getConstraint</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/Constraint.html" title="interface in org.apache.ws.jaxme.sqls">Constraint</A> pConstraint)</PRE> <DL> <DD><p>Generates the WHERE clause of a SELECT, UPDATE, or DELETE statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getWhereClause(org.apache.ws.jaxme.sqls.SelectStatement)"><!-- --></A><H3> getWhereClause</H3> <PRE> java.lang.String <B>getWhereClause</B>(<A HREF="../../../../../org/apache/ws/jaxme/sqls/SelectStatement.html" title="interface in org.apache.ws.jaxme.sqls">SelectStatement</A> pQuery)</PRE> <DL> <DD><p>Returns the <code>WHERE ... ORDER BY ...</code> part of the SELECT statement.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setStatementTerminator(java.lang.String)"><!-- --></A><H3> setStatementTerminator</H3> <PRE> void <B>setStatementTerminator</B>(java.lang.String pTerminator)</PRE> <DL> <DD><p>Sets the statement terminator. A non-null value will be appended to all generated statements. Defaults to null.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getStatementTerminator()"><!-- --></A><H3> getStatementTerminator</H3> <PRE> java.lang.String <B>getStatementTerminator</B>()</PRE> <DL> <DD><p>Returns the statement terminator. A non-null value will be appended to all generated statements. Defaults to null.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setLineTerminator(java.lang.String)"><!-- --></A><H3> setLineTerminator</H3> <PRE> void <B>setLineTerminator</B>(java.lang.String pTerminator)</PRE> <DL> <DD><p>Sets the line terminator. A non-null value indicates that the generated statements should be made human readable by splitting them over multiple lines. A null value ensures that a statement consists of a single line only. Defaults to "\n".</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getLineTerminator()"><!-- --></A><H3> getLineTerminator</H3> <PRE> java.lang.String <B>getLineTerminator</B>()</PRE> <DL> <DD><p>Returns the line terminator. A non-null value indicates that the generated statements should be made human readable by splitting them over multiple lines. A null value ensures that a statement consists of a single line only. Defaults to "\n".</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/SQLFactory.Ident.html" title="interface in org.apache.ws.jaxme.sqls"><B>PREV CLASS</B></A> <A HREF="../../../../../org/apache/ws/jaxme/sqls/Statement.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/SQLGenerator.html" target="_top"><B>FRAMES</B></A> <A HREF="SQLGenerator.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: NESTED | 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>