You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by do...@apache.org on 2012/11/01 12:18:34 UTC
svn commit: r1404542 [4/17] - in
/empire-db/site/javadocs/empire-db/org/apache/empire: commons/
commons/class-use/ data/ data/bean/ data/bean/class-use/ data/class-use/
db/ db/class-use/ db/derby/ db/derby/class-use/ db/exceptions/
db/exceptions/class-...
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabase.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabase.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabase.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabase.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBDatabase (Apache Empire-db Core 2.4.0 API)
+DBDatabase (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBDatabase (Apache Empire-db Core 2.4.0
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBDatabase (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBDatabase (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
@@ -378,6 +378,25 @@ This abstract class is the applicaton's
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
+<CODE> int</CODE></FONT></TD>
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#executeDelete(org.apache.empire.db.DBTable, org.apache.empire.db.DBCommand, java.sql.Connection)">executeDelete</A></B>(<A HREF="../../../../org/apache/empire/db/DBTable.html" title="class in org.apache.empire.db">DBTable</A> from,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
+
+<BR>
+ Executes a Delete statement from a command object</TD>
+</TR>
+<TR BGCOLOR="white" CLASS="TableRowColor">
+<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
+<CODE> int</CODE></FONT></TD>
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#executeInsert(org.apache.empire.db.DBCommand, java.sql.Connection)">executeInsert</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
+
+<BR>
+ Executes an Insert statement from a command object</TD>
+</TR>
+<TR BGCOLOR="white" CLASS="TableRowColor">
+<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/ResultSet.html?is-external=true" title="class or interface in java.sql">ResultSet</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#executeQuery(java.lang.String, java.lang.Object[], boolean, java.sql.Connection)">executeQuery</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[] sqlParams,
@@ -385,7 +404,7 @@ This abstract class is the applicaton's
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
- Executes a select SQL-Statement and returns a resultset containing the query results.<BR>
+ Executes a select SQL-Statement and returns a ResultSet containing the query results.<BR>
This function returns a JDBC ResultSet.<BR>
Instead of using this function directly you should use a DBReader object instead.<BR></TD>
</TR>
@@ -396,8 +415,15 @@ This abstract class is the applicaton's
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
- Executes an update, insert or delete SQL-Statement.<BR>
- We recommend to use a DBCommand object in order to build the sqlCmd.<BR></TD>
+ <B>Deprecated.</B> <I>This method has be deprecated in order to avoid missing command parameters for prepared statements
+ <pre>
+ Instead of using this method signature please use any of the following:
+ executeInsert(...)
+ executeUpdate(...)
+ executeDelete(...)
+ or use
+ executeSQL(String sqlCmd, Object[] sqlParams, Connection conn)
+ </pre></I></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
@@ -423,6 +449,15 @@ This abstract class is the applicaton's
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
+<CODE> int</CODE></FONT></TD>
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#executeUpdate(org.apache.empire.db.DBCommand, java.sql.Connection)">executeUpdate</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
+
+<BR>
+ Executes an Update statement from a command object</TD>
+</TR>
+<TR BGCOLOR="white" CLASS="TableRowColor">
+<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static <A HREF="../../../../org/apache/empire/db/DBDatabase.html" title="class in org.apache.empire.db">DBDatabase</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#findByClass(java.lang.Class)">findByClass</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><? extends <A HREF="../../../../org/apache/empire/db/DBDatabase.html" title="class in org.apache.empire.db">DBDatabase</A>> cls)</CODE>
@@ -655,7 +690,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryObjectList(java.lang.String, java.sql.Connection)">queryObjectList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryObjectList(org.apache.empire.db.DBCommand, java.sql.Connection)">queryObjectList</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -665,7 +700,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryObjectList(java.lang.String, java.sql.Connection, java.util.Collection)">queryObjectList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryObjectList(org.apache.empire.db.DBCommand, java.sql.Connection, java.util.Collection)">queryObjectList</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util">Collection</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]> result)</CODE>
@@ -689,7 +724,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../org/apache/empire/commons/Options.html" title="class in org.apache.empire.commons">Options</A></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryOptionList(java.lang.String, java.sql.Connection)">queryOptionList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryOptionList(org.apache.empire.db.DBCommand, java.sql.Connection)">queryOptionList</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -698,7 +733,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryOptionList(java.lang.String, java.sql.Connection, org.apache.empire.commons.Options)">queryOptionList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#queryOptionList(org.apache.empire.db.DBCommand, java.sql.Connection, org.apache.empire.commons.Options)">queryOptionList</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="../../../../org/apache/empire/commons/Options.html" title="class in org.apache.empire.commons">Options</A> result)</CODE>
@@ -726,8 +761,8 @@ This abstract class is the applicaton's
</TR>
</TABLE>
</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(java.lang.Class, java.lang.String, java.sql.Connection)">querySimpleList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(java.lang.Class, org.apache.empire.db.DBCommand, java.sql.Connection)">querySimpleList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -743,8 +778,8 @@ This abstract class is the applicaton's
</TR>
</TABLE>
</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(java.lang.Class, java.lang.String, java.sql.Connection, java.util.Collection)">querySimpleList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(java.lang.Class, org.apache.empire.db.DBCommand, java.sql.Connection, java.util.Collection)">querySimpleList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util">Collection</A><T> result)</CODE>
@@ -775,7 +810,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(java.lang.String, java.sql.Connection)">querySimpleList</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySimpleList(org.apache.empire.db.DBCommand, java.sql.Connection)">querySimpleList</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -784,7 +819,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleInt(java.lang.String, java.sql.Connection)">querySingleInt</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleInt(org.apache.empire.db.DBCommand, java.sql.Connection)">querySingleInt</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -793,7 +828,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleInt(java.lang.String, int, java.sql.Connection)">querySingleInt</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleInt(org.apache.empire.db.DBCommand, int, java.sql.Connection)">querySingleInt</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
int defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
@@ -814,7 +849,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> long</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleLong(java.lang.String, java.sql.Connection)">querySingleLong</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleLong(org.apache.empire.db.DBCommand, java.sql.Connection)">querySingleLong</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -823,7 +858,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> long</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleLong(java.lang.String, long, java.sql.Connection)">querySingleLong</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleLong(org.apache.empire.db.DBCommand, long, java.sql.Connection)">querySingleLong</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
long defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
@@ -844,7 +879,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]</CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleRow(java.lang.String, java.sql.Connection)">querySingleRow</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleRow(org.apache.empire.db.DBCommand, java.sql.Connection)">querySingleRow</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -863,7 +898,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(java.lang.String, java.sql.Connection)">querySingleString</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(org.apache.empire.db.DBCommand, java.sql.Connection)">querySingleString</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -872,8 +907,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(java.lang.String, java.lang.Object[], java.lang.String, java.sql.Connection)">querySingleString</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[] sqlParams,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(org.apache.empire.db.DBCommand, java.lang.String, java.sql.Connection)">querySingleString</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
@@ -883,7 +917,8 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(java.lang.String, java.lang.String, java.sql.Connection)">querySingleString</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleString(java.lang.String, java.lang.Object[], java.lang.String, java.sql.Connection)">querySingleString</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[] sqlParams,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
@@ -893,7 +928,7 @@ This abstract class is the applicaton's
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A></CODE></FONT></TD>
-<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleValue(java.lang.String, java.sql.Connection)">querySingleValue</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabase.html#querySingleValue(org.apache.empire.db.DBCommand, java.sql.Connection)">querySingleValue</A></B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</CODE>
<BR>
@@ -1769,17 +1804,17 @@ public final <A HREF="http://download.or
</DL>
<HR>
-<A NAME="querySingleValue(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleValue(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySingleValue</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A> <B>querySingleValue</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A> <B>querySingleValue</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns the value of the first row/column of a sql-query as an object.
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL-Command<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the value of the first column in the first row of the query</DL>
</DD>
</DL>
@@ -1803,10 +1838,10 @@ public final int <B>querySingleInt</B>(<
</DL>
<HR>
-<A NAME="querySingleInt(java.lang.String, int, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleInt(org.apache.empire.db.DBCommand, int, java.sql.Connection)"><!-- --></A><H3>
querySingleInt</H3>
<PRE>
-public final int <B>querySingleInt</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final int <B>querySingleInt</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
int defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
@@ -1814,23 +1849,23 @@ public final int <B>querySingleInt</B>(<
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>defVal</CODE> - the default value if no value was returned by the database<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>defVal</CODE> - the default value if no value was returned by the database<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a int value</DL>
</DD>
</DL>
<HR>
-<A NAME="querySingleInt(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleInt(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySingleInt</H3>
<PRE>
-public final int <B>querySingleInt</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final int <B>querySingleInt</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns the value of the first row/column of a sql-query as an int.
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a int value</DL>
</DD>
</DL>
@@ -1854,10 +1889,10 @@ public final long <B>querySingleLong</B>
</DL>
<HR>
-<A NAME="querySingleLong(java.lang.String, long, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleLong(org.apache.empire.db.DBCommand, long, java.sql.Connection)"><!-- --></A><H3>
querySingleLong</H3>
<PRE>
-public final long <B>querySingleLong</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final long <B>querySingleLong</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
long defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
@@ -1865,23 +1900,23 @@ public final long <B>querySingleLong</B>
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>defVal</CODE> - the default value<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>defVal</CODE> - the default value<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a long value</DL>
</DD>
</DL>
<HR>
-<A NAME="querySingleLong(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleLong(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySingleLong</H3>
<PRE>
-public final long <B>querySingleLong</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final long <B>querySingleLong</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns the value of the first row/column of a sql-query as a long.
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a long value</DL>
</DD>
</DL>
@@ -1905,10 +1940,10 @@ public final <A HREF="http://download.or
</DL>
<HR>
-<A NAME="querySingleString(java.lang.String, java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleString(org.apache.empire.db.DBCommand, java.lang.String, java.sql.Connection)"><!-- --></A><H3>
querySingleString</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>querySingleString</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>querySingleString</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> defVal,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
@@ -1916,23 +1951,23 @@ public final <A HREF="http://download.or
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>defVal</CODE> - the default value if no value was returned by the database<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>defVal</CODE> - the default value if no value was returned by the database<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a String object, if no result a empty String</DL>
</DD>
</DL>
<HR>
-<A NAME="querySingleString(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleString(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySingleString</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>querySingleString</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>querySingleString</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns the value of the first row/column of a sql-query as a string.
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the result as a String object, if no result a empty String</DL>
</DD>
</DL>
@@ -1959,11 +1994,11 @@ public <T> int <B>querySimpleList<
</DL>
<HR>
-<A NAME="querySimpleList(java.lang.Class, java.lang.String, java.sql.Connection, java.util.Collection)"><!-- --></A><H3>
+<A NAME="querySimpleList(java.lang.Class, org.apache.empire.db.DBCommand, java.sql.Connection, java.util.Collection)"><!-- --></A><H3>
querySimpleList</H3>
<PRE>
public final <T> int <B>querySimpleList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util">Collection</A><T> result)</PRE>
<DL>
@@ -1971,40 +2006,40 @@ public final <T> int <B>querySimpl
If the query has no result, an empty list is returned.
<P>
<DD><DL>
-<DT><B>Type Parameters:</B><DD><CODE>T</CODE> - the type for the list<DT><B>Parameters:</B><DD><CODE>c</CODE> - the class type for the list<DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Type Parameters:</B><DD><CODE>T</CODE> - the type for the list<DT><B>Parameters:</B><DD><CODE>c</CODE> - the class type for the list<DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the number of elements that have been added to the collection</DL>
</DD>
</DL>
<HR>
-<A NAME="querySimpleList(java.lang.Class, java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySimpleList(java.lang.Class, org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySimpleList</H3>
<PRE>
public final <T> <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><T> <B>querySimpleList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang">Class</A><T> c,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns a one dimensional array from an sql query.
The array is filled with the values of the first column.
<P>
<DD><DL>
-<DT><B>Type Parameters:</B><DD><CODE>T</CODE> - the type for the list<DT><B>Parameters:</B><DD><CODE>c</CODE> - the class type for the list<DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Type Parameters:</B><DD><CODE>T</CODE> - the type for the list<DT><B>Parameters:</B><DD><CODE>c</CODE> - the class type for the list<DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>a list of the values of the first column of an sql query</DL>
</DD>
</DL>
<HR>
-<A NAME="querySimpleList(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySimpleList(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySimpleList</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>> <B>querySimpleList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>> <B>querySimpleList</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns a one dimensional array from an sql query.
The array is filled with the values of the first column.
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>a list of values of type Object</DL>
</DD>
</DL>
@@ -2028,10 +2063,10 @@ public int <B>queryOptionList</B>(<A HRE
</DL>
<HR>
-<A NAME="queryOptionList(java.lang.String, java.sql.Connection, org.apache.empire.commons.Options)"><!-- --></A><H3>
+<A NAME="queryOptionList(org.apache.empire.db.DBCommand, java.sql.Connection, org.apache.empire.commons.Options)"><!-- --></A><H3>
queryOptionList</H3>
<PRE>
-public final int <B>queryOptionList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final int <B>queryOptionList</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="../../../../org/apache/empire/commons/Options.html" title="class in org.apache.empire.commons">Options</A> result)</PRE>
<DL>
@@ -2039,23 +2074,23 @@ public final int <B>queryOptionList</B>(
The option list is filled with the values of the first and second column.
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>an Options object containing a set a of values and their corresponding names</DL>
</DD>
</DL>
<HR>
-<A NAME="queryOptionList(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="queryOptionList(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
queryOptionList</H3>
<PRE>
-public final <A HREF="../../../../org/apache/empire/commons/Options.html" title="class in org.apache.empire.commons">Options</A> <B>queryOptionList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="../../../../org/apache/empire/commons/Options.html" title="class in org.apache.empire.commons">Options</A> <B>queryOptionList</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns a list of key value pairs from an sql query.
The option list is filled with the values of the first and second column.
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>an Options object containing a set a of values and their corresponding names</DL>
</DD>
</DL>
@@ -2082,10 +2117,10 @@ public int <B>queryObjectList</B>(<A HRE
</DL>
<HR>
-<A NAME="queryObjectList(java.lang.String, java.sql.Connection, java.util.Collection)"><!-- --></A><H3>
+<A NAME="queryObjectList(org.apache.empire.db.DBCommand, java.sql.Connection, java.util.Collection)"><!-- --></A><H3>
queryObjectList</H3>
<PRE>
-public final int <B>queryObjectList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final int <B>queryObjectList</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util">Collection</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]> result)</PRE>
<DL>
@@ -2095,23 +2130,23 @@ public final int <B>queryObjectList</B>(
Otherwise a DBReader should be used!</p>
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>a list of object arrays</DL>
</DD>
</DL>
<HR>
-<A NAME="queryObjectList(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="queryObjectList(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
queryObjectList</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]> <B>queryObjectList</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</A><<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[]> <B>queryObjectList</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns the result of a query as a list Object-Arrays
This function should only be used for small lists.
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL statement<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>a list of object arrays</DL>
</DD>
</DL>
@@ -2134,17 +2169,17 @@ public <A HREF="http://download.oracle.c
</DL>
<HR>
-<A NAME="querySingleRow(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
+<A NAME="querySingleRow(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
querySingleRow</H3>
<PRE>
-public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[] <B>querySingleRow</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+public final <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A>[] <B>querySingleRow</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
<DD>Returns all values of the first row of a sql-query as an array.
If the query does not return a result a QueryNoResultException is thrown
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL-Command<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the Command object that contains the select statement<DD><CODE>conn</CODE> - a valid connection to the database.
<DT><B>Returns:</B><DD>the values of the first row</DL>
</DD>
</DL>
@@ -2185,16 +2220,68 @@ public final int <B>executeSQL</B>(<A HR
<A NAME="executeSQL(java.lang.String, java.sql.Connection)"><!-- --></A><H3>
executeSQL</H3>
<PRE>
-public final int <B>executeSQL</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
- <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
+<FONT SIZE="-1"><A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Deprecated.html?is-external=true" title="class or interface in java.lang">@Deprecated</A>
+</FONT>public final int <B>executeSQL</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> sqlCmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
-<DD>Executes an update, insert or delete SQL-Statement.<BR>
- We recommend to use a DBCommand object in order to build the sqlCmd.<BR>
- <P>
+<DD><B>Deprecated.</B> <I>This method has be deprecated in order to avoid missing command parameters for prepared statements
+ <pre>
+ Instead of using this method signature please use any of the following:
+ executeInsert(...)
+ executeUpdate(...)
+ executeDelete(...)
+ or use
+ executeSQL(String sqlCmd, Object[] sqlParams, Connection conn)
+ </pre></I>
<P>
<DD><DL>
-<DT><B>Parameters:</B><DD><CODE>sqlCmd</CODE> - the SQL-Command<DD><CODE>conn</CODE> - a valid connection to the database.
-<DT><B>Returns:</B><DD>the row count for insert, update or delete or 0 for SQL statements that return nothing</DL>
+</DL>
+</DD>
+</DL>
+<HR>
+
+<A NAME="executeInsert(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
+executeInsert</H3>
+<PRE>
+public final int <B>executeInsert</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
+<DL>
+<DD>Executes an Insert statement from a command object
+<P>
+<DD><DL>
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the command object containing the insert command<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Returns:</B><DD>the number of records that have been inserted with the supplied statement</DL>
+</DD>
+</DL>
+<HR>
+
+<A NAME="executeUpdate(org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
+executeUpdate</H3>
+<PRE>
+public final int <B>executeUpdate</B>(<A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
+<DL>
+<DD>Executes an Update statement from a command object
+<P>
+<DD><DL>
+<DT><B>Parameters:</B><DD><CODE>cmd</CODE> - the command object containing the update command<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Returns:</B><DD>the number of records that have been updated with the supplied statement</DL>
+</DD>
+</DL>
+<HR>
+
+<A NAME="executeDelete(org.apache.empire.db.DBTable, org.apache.empire.db.DBCommand, java.sql.Connection)"><!-- --></A><H3>
+executeDelete</H3>
+<PRE>
+public final int <B>executeDelete</B>(<A HREF="../../../../org/apache/empire/db/DBTable.html" title="class in org.apache.empire.db">DBTable</A> from,
+ <A HREF="../../../../org/apache/empire/db/DBCommand.html" title="class in org.apache.empire.db">DBCommand</A> cmd,
+ <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
+<DL>
+<DD>Executes a Delete statement from a command object
+<P>
+<DD><DL>
+<DT><B>Parameters:</B><DD><CODE>from</CODE> - the database table from which to delete records<DD><CODE>cmd</CODE> - the command object containing the delete constraints<DD><CODE>conn</CODE> - a valid connection to the database.
+<DT><B>Returns:</B><DD>the number of records that have been deleted with the supplied statement</DL>
</DD>
</DL>
<HR>
@@ -2207,7 +2294,7 @@ public <A HREF="http://download.oracle.c
boolean scrollable,
<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/sql/Connection.html?is-external=true" title="class or interface in java.sql">Connection</A> conn)</PRE>
<DL>
-<DD>Executes a select SQL-Statement and returns a resultset containing the query results.<BR>
+<DD>Executes a select SQL-Statement and returns a ResultSet containing the query results.<BR>
This function returns a JDBC ResultSet.<BR>
Instead of using this function directly you should use a DBReader object instead.<BR>
<P>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSeqTable.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSeqTable.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSeqTable.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSeqTable.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBDatabaseDriver.DBSeqTable (Apache Empire-db Core 2.4.0 API)
+DBDatabaseDriver.DBSeqTable (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBDatabaseDriver.DBSeqTable (Apache Empi
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBDatabaseDriver.DBSeqTable (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBDatabaseDriver.DBSeqTable (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
@@ -234,7 +234,7 @@ This class is used to emulate sequences
<TH ALIGN="left"><B>Methods inherited from class org.apache.empire.db.<A HREF="../../../../org/apache/empire/db/DBRowSet.html" title="class in org.apache.empire.db">DBRowSet</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
-<TD><CODE><A HREF="../../../../org/apache/empire/db/DBRowSet.html#addColumnReference(org.apache.empire.db.DBColumn, org.apache.empire.db.DBColumn)">addColumnReference</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#addReferencedColumns(java.util.Set)">addReferencedColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#completeInitRecord(org.apache.empire.db.DBRecord)">completeInitRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#count()">count</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteAllReferences(java.lang.Object[], java.sql.Connection)">deleteAllReferences</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteRecord(java.lang.Object, java.sql.Connection)">deleteRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteReferenceRecords(org.apache.empire.db.DBRelation.DBReference[], java.lang.Object[], java.sql.Connection)">deleteReferenceRecords</A>, <A HREF="../../../../org/
apache/empire/db/DBRowSet.html#equals(java.lang.Object)">equals</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#findById(java.lang.String)">findById</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumn(int)">getColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumn(java.lang.String)">getColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnIndex(org.apache.empire.data.Column)">getColumnIndex</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnIndex(org.apache.empire.db.DBColumn)">getColumnIndex</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnReferences()">getColumnReferences</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumns()">getColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getComment()">getComment</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getDatabase()">getDatabase</A>, <A HREF="../../../../org/
apache/empire/db/DBRowSet.html#getFullName()">getFullName</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getId()">getId</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getKeyColumns()">getKeyColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getRecordKey(org.apache.empire.db.DBRecord)">getRecordKey</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getRenameTablePhrase()">getRenameTablePhrase</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getTimestampColumn()">getTimestampColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#initRecord(org.apache.empire.db.DBRecord, org.apache.empire.db.DBRecordData)">initRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#initRecord(org.apache.empire.db.DBRecord, java.lang.Object[])">initRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#isColumnReadOnly(org.apache.empire.db.DBColumn)">isColumnReadOnly</A>, <A HREF="../../../.
./org/apache/empire/db/DBRowSet.html#isKeyColumn(org.apache.empire.db.DBColumn)">isKeyColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#prepareInitRecord(org.apache.empire.db.DBRecord, int, java.lang.Object)">prepareInitRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#readRecord(org.apache.empire.db.DBRecord, org.apache.empire.db.DBCommand, java.sql.Connection)">readRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#readRecord(org.apache.empire.db.DBRecord, java.lang.Object[], java.sql.Connection)">readRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#recordExists(java.lang.Object[], java.sql.Connection)">recordExists</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#recordExists(java.lang.Object, java.sql.Connection)">recordExists</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#setComment(java.lang.String)">setComment</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#s
etKeyConstraints(org.apache.empire.db.DBCommand, java.lang.Object[])">setKeyConstraints</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#setTimestampColumn(org.apache.empire.db.DBColumn)">setTimestampColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#updateRecord(org.apache.empire.db.DBRecord, java.sql.Connection)">updateRecord</A></CODE></TD>
+<TD><CODE><A HREF="../../../../org/apache/empire/db/DBRowSet.html#addColumnReference(org.apache.empire.db.DBColumn, org.apache.empire.db.DBColumn)">addColumnReference</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#addReferencedColumns(java.util.Set)">addReferencedColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#completeInitRecord(org.apache.empire.db.DBRecord)">completeInitRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#count()">count</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteAllReferences(java.lang.Object[], java.sql.Connection)">deleteAllReferences</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteRecord(java.lang.Object, java.sql.Connection)">deleteRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#deleteReferenceRecords(org.apache.empire.db.DBRelation.DBReference[], java.lang.Object[], java.sql.Connection)">deleteReferenceRecords</A>, <A HREF="../../../../org/
apache/empire/db/DBRowSet.html#equals(java.lang.Object)">equals</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#findById(java.lang.String)">findById</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumn(int)">getColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumn(java.lang.String)">getColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnIndex(org.apache.empire.data.Column)">getColumnIndex</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnIndex(org.apache.empire.db.DBColumn)">getColumnIndex</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumnReferences()">getColumnReferences</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getColumns()">getColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getComment()">getComment</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getDatabase()">getDatabase</A>, <A HREF="../../../../org/
apache/empire/db/DBRowSet.html#getFullName()">getFullName</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getId()">getId</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getKeyColumns()">getKeyColumns</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getRecordKey(org.apache.empire.db.DBRecord)">getRecordKey</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getRenameTablePhrase()">getRenameTablePhrase</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#getTimestampColumn()">getTimestampColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#initRecord(org.apache.empire.db.DBRecord, org.apache.empire.db.DBRecordData)">initRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#initRecord(org.apache.empire.db.DBRecord, java.lang.Object[], boolean)">initRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#isColumnReadOnly(org.apache.empire.db.DBColumn)">isColumnReadOnly</A>, <A HREF=".
./../../../org/apache/empire/db/DBRowSet.html#isKeyColumn(org.apache.empire.db.DBColumn)">isKeyColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#prepareInitRecord(org.apache.empire.db.DBRecord, java.lang.Object, boolean)">prepareInitRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#readRecord(org.apache.empire.db.DBRecord, org.apache.empire.db.DBCommand, java.sql.Connection)">readRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#readRecord(org.apache.empire.db.DBRecord, java.lang.Object[], java.sql.Connection)">readRecord</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#recordExists(java.lang.Object[], java.sql.Connection)">recordExists</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#recordExists(java.lang.Object, java.sql.Connection)">recordExists</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#setComment(java.lang.String)">setComment</A>, <A HREF="../../../../org/apache/empire/db/DB
RowSet.html#setKeyConstraints(org.apache.empire.db.DBCommand, java.lang.Object[])">setKeyConstraints</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#setTimestampColumn(org.apache.empire.db.DBColumn)">setTimestampColumn</A>, <A HREF="../../../../org/apache/empire/db/DBRowSet.html#updateRecord(org.apache.empire.db.DBRecord, java.sql.Connection)">updateRecord</A></CODE></TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_org.apache.empire.db.DBExpr"><!-- --></A>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSetGenKeys.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSetGenKeys.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSetGenKeys.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.DBSetGenKeys.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBDatabaseDriver.DBSetGenKeys (Apache Empire-db Core 2.4.0 API)
+DBDatabaseDriver.DBSetGenKeys (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBDatabaseDriver.DBSetGenKeys (Apache Em
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBDatabaseDriver.DBSetGenKeys (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBDatabaseDriver.DBSetGenKeys (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDatabaseDriver.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBDatabaseDriver (Apache Empire-db Core 2.4.0 API)
+DBDatabaseDriver (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBDatabaseDriver (Apache Empire-db Core
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBDatabaseDriver (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBDatabaseDriver (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
@@ -100,7 +100,7 @@ Class DBDatabaseDriver</H2>
<DT><B>All Implemented Interfaces:</B> <DD><A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io">Serializable</A></DD>
</DL>
<DL>
-<DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../../../org/apache/empire/db/derby/DBDatabaseDriverDerby.html" title="class in org.apache.empire.db.derby">DBDatabaseDriverDerby</A>, <A HREF="../../../../org/apache/empire/db/h2/DBDatabaseDriverH2.html" title="class in org.apache.empire.db.h2">DBDatabaseDriverH2</A>, <A HREF="../../../../org/apache/empire/db/hsql/DBDatabaseDriverHSql.html" title="class in org.apache.empire.db.hsql">DBDatabaseDriverHSql</A>, <A HREF="../../../../org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.html" title="class in org.apache.empire.db.sqlserver">DBDatabaseDriverMSSQL</A>, <A HREF="../../../../org/apache/empire/db/mysql/DBDatabaseDriverMySQL.html" title="class in org.apache.empire.db.mysql">DBDatabaseDriverMySQL</A>, <A HREF="../../../../org/apache/empire/db/oracle/DBDatabaseDriverOracle.html" title="class in org.apache.empire.db.oracle">DBDatabaseDriverOracle</A>, <A HREF="../../../../org/apache/empire/db/postgresql/DBDatabaseDriverPo
stgreSQL.html" title="class in org.apache.empire.db.postgresql">DBDatabaseDriverPostgreSQL</A></DD>
+<DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../../../org/apache/empire/db/derby/DBDatabaseDriverDerby.html" title="class in org.apache.empire.db.derby">DBDatabaseDriverDerby</A>, <A HREF="../../../../org/apache/empire/db/h2/DBDatabaseDriverH2.html" title="class in org.apache.empire.db.h2">DBDatabaseDriverH2</A>, <A HREF="../../../../org/apache/empire/db/hsql/DBDatabaseDriverHSql.html" title="class in org.apache.empire.db.hsql">DBDatabaseDriverHSql</A>, <A HREF="../../../../org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.html" title="class in org.apache.empire.db.sqlserver">DBDatabaseDriverMSSQL</A>, <A HREF="../../../../org/apache/empire/db/mysql/DBDatabaseDriverMySQL.html" title="class in org.apache.empire.db.mysql">DBDatabaseDriverMySQL</A>, <A HREF="../../../../org/apache/empire/db/oracle/DBDatabaseDriverOracle.html" title="class in org.apache.empire.db.oracle">DBDatabaseDriverOracle</A>, <A HREF="../../../../org/apache/empire/db/postgresql/DBDatabaseDriverPo
stgreSQL.html" title="class in org.apache.empire.db.postgresql">DBDatabaseDriverPostgreSQL</A>, <A HREF="../../../../org/apache/empire/db/sqlite/DBDatabaseDriverSQLite.html" title="class in org.apache.empire.db.sqlite">DBDatabaseDriverSQLite</A></DD>
</DL>
<HR>
<DL>
@@ -780,6 +780,15 @@ The DBDatabaseDriver class is an abstrac
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
+<CODE>protected <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD>
+<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabaseDriver.html#getSQLNumberString(java.lang.Object, org.apache.empire.data.DataType)">getSQLNumberString</A></B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A> value,
+ <A HREF="../../../../org/apache/empire/data/DataType.html" title="enum in org.apache.empire.data">DataType</A> type)</CODE>
+
+<BR>
+ encodes a numeric value for an SQL command string.</TD>
+</TR>
+<TR BGCOLOR="white" CLASS="TableRowColor">
+<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>abstract <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/apache/empire/db/DBDatabaseDriver.html#getSQLPhrase(int)">getSQLPhrase</A></B>(int phrase)</CODE>
@@ -1762,6 +1771,24 @@ public <A HREF="http://download.oracle.c
</DL>
<HR>
+<A NAME="getSQLNumberString(java.lang.Object, org.apache.empire.data.DataType)"><!-- --></A><H3>
+getSQLNumberString</H3>
+<PRE>
+protected <A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</A> <B>getSQLNumberString</B>(<A HREF="http://download.oracle.com/javase/1.5.0/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</A> value,
+ <A HREF="../../../../org/apache/empire/data/DataType.html" title="enum in org.apache.empire.data">DataType</A> type)</PRE>
+<DL>
+<DD>encodes a numeric value for an SQL command string.
+<P>
+<DD><DL>
+</DL>
+</DD>
+<DD><DL>
+<DT><B>Parameters:</B><DD><CODE>value</CODE> - the numeric value<DD><CODE>type</CODE> - the number data type
+<DT><B>Returns:</B><DD>the string reprentation of the number</DL>
+</DD>
+</DL>
+<HR>
+
<A NAME="getSQLDateTimeString(java.lang.Object, int, int, int)"><!-- --></A><H3>
getSQLDateTimeString</H3>
<PRE>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDriverFeature.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDriverFeature.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDriverFeature.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBDriverFeature.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBDriverFeature (Apache Empire-db Core 2.4.0 API)
+DBDriverFeature (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBDriverFeature (Apache Empire-db Core 2
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBDriverFeature (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBDriverFeature (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpr.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpr.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpr.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpr.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBExpr (Apache Empire-db Core 2.4.0 API)
+DBExpr (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBExpr (Apache Empire-db Core 2.4.0 API)
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBExpr (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBExpr (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpressionIndex.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpressionIndex.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpressionIndex.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBExpressionIndex.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBExpressionIndex (Apache Empire-db Core 2.4.0 API)
+DBExpressionIndex (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBExpressionIndex (Apache Empire-db Core
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBExpressionIndex (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBExpressionIndex (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBIndex.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBIndex.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBIndex.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBIndex.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBIndex (Apache Empire-db Core 2.4.0 API)
+DBIndex (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBIndex (Apache Empire-db Core 2.4.0 API
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBIndex (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBIndex (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBJoinType.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBJoinType.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBJoinType.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBJoinType.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBJoinType (Apache Empire-db Core 2.4.0 API)
+DBJoinType (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBJoinType (Apache Empire-db Core 2.4.0
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBJoinType (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBJoinType (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>
Modified: empire-db/site/javadocs/empire-db/org/apache/empire/db/DBObject.html
URL: http://svn.apache.org/viewvc/empire-db/site/javadocs/empire-db/org/apache/empire/db/DBObject.html?rev=1404542&r1=1404541&r2=1404542&view=diff
==============================================================================
--- empire-db/site/javadocs/empire-db/org/apache/empire/db/DBObject.html (original)
+++ empire-db/site/javadocs/empire-db/org/apache/empire/db/DBObject.html Thu Nov 1 11:18:21 2012
@@ -2,13 +2,13 @@
<!--NewPage-->
<HTML>
<HEAD>
-<!-- Generated by javadoc (build 1.6.0_33) on Tue Jul 31 13:24:54 CEST 2012 -->
+<!-- Generated by javadoc (build 1.6.0_33) on Thu Oct 25 10:06:22 CEST 2012 -->
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>
-DBObject (Apache Empire-db Core 2.4.0 API)
+DBObject (Apache Empire-db Core 2.4.1 API)
</TITLE>
-<META NAME="date" CONTENT="2012-07-31">
+<META NAME="date" CONTENT="2012-10-25">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style">
@@ -16,7 +16,7 @@ DBObject (Apache Empire-db Core 2.4.0 AP
function windowTitle()
{
if (location.href.indexOf('is-external=true') == -1) {
- parent.document.title="DBObject (Apache Empire-db Core 2.4.0 API)";
+ parent.document.title="DBObject (Apache Empire-db Core 2.4.1 API)";
}
}
</SCRIPT>