Examples of StatementAssembly

Class for creating and executing JDBC statements. Allows statements to be assembled incrementally (like a {@link StringBuffer}), but also tracks parameters, shielding the developer from the differences between constructing and using a JDBC {@link java.sql.Statement} and a JDBC {@link java.sql.PreparedStatement}. This class is somewhat skewed towards Oracle, which works more efficiently with prepared staments than simple SQL.

In addition, implements {@link #toString()} in a useful way (you can see theSQL and parameters), which is invaluable when debugging.

{@link #addParameter(int)} (and all overloaded versions of it for scalar types)adds a "?" to the statement and records the parameter value.

{@link #addParameter(Integer)} (and all overloaded version of it for wrappertypes) does the same ... unless the value is null, in which case "NULL" is inserted into the statement.

{@link #addParameterList(int[],String)} (and all overloaded versions of it)simply invokes the appropriate {@link #addParameter(int)}, adding the separator in between parameters. @version $Id: StatementAssembly.java 243791 2004-02-19 17:38:13Z hlship $ @author Howard Lewis Ship

Examples of StatementAssembly

Examples of org.apache.tapestry.contrib.jdbc.StatementAssembly