class StatementHelper
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
protected java.sql.Connection |
conn |
private java.util.Map<java.lang.String,java.sql.PreparedStatement> |
statements
Map of SQL text to its PreparedStatement.
|
Constructor and Description |
---|
StatementHelper(java.sql.Connection conn,
boolean autoCommit,
int isolation) |
Modifier and Type | Method and Description |
---|---|
void |
close() |
protected Address |
getAddress(Address address,
java.sql.ResultSet rs,
java.lang.String firstColumnName)
Get the address from a query against an order entry WAREHOUSE, DISTRICT
or CUSTOMER table.
|
protected Address |
getAddress(java.sql.ResultSet rs,
java.lang.String firstColumnName) |
protected java.sql.PreparedStatement |
prepareStatement(java.lang.String sql)
Prepare a statement, looking in the map first.
|
protected void |
reset(java.sql.PreparedStatement ps)
Reset a PreparedStatement.
|
protected final java.sql.Connection conn
private java.util.Map<java.lang.String,java.sql.PreparedStatement> statements
StatementHelper(java.sql.Connection conn, boolean autoCommit, int isolation) throws java.sql.SQLException
java.sql.SQLException
protected java.sql.PreparedStatement prepareStatement(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public void close() throws java.sql.SQLException
java.sql.SQLException
protected void reset(java.sql.PreparedStatement ps) throws java.sql.SQLException
java.sql.SQLException
protected Address getAddress(java.sql.ResultSet rs, java.lang.String firstColumnName) throws java.sql.SQLException
java.sql.SQLException
protected Address getAddress(Address address, java.sql.ResultSet rs, java.lang.String firstColumnName) throws java.sql.SQLException
address
- Object to fill inrs
- ResultSet already positioned on the current row.firstColumnName
- First column that makes up the address.java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.