com.toolsverse.etl.sql

Class NamedParameterPreparedStatement

Object

com.toolsverse.etl.sql.DelegatingPreparedStatement

com.toolsverse.etl.sql.NamedParameterPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class NamedParameterPreparedStatement
extends DelegatingPreparedStatement

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) static class	NamedParameterPreparedStatement.ParseResult Class to hold the results of SQL parsing (used by factory methods)

Field Summary

Fields inherited from interface Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Method Summary

Modifier and Type	Method and Description
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql)
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql, int autoGeneratedKeys)
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql, int[] columnIndexes)
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql, int resultSetType, int resultSetConcurrency)
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
static NamedParameterPreparedStatement	createNamedParameterPreparedStatement(Connection conn, String sql, String[] columnNames)
List<TypedKeyValue<String,String>>	getOrderedParameters() Gets the ordered parameters.
Collection<Integer>	getParameterIndexes(String parameter)
boolean	hasNamedParameters()
static NamedParameterPreparedStatement.ParseResult	parse(String query) Parse the query string containing named parameters and result a parse result, which holds the parsed sql (named parameters replaced by standard '?' parameters and an ordered list of the named parameters.
void	setAsciiStream(String parameter, InputStream x)
void	setBigDecimal(String parameter, BigDecimal x)
void	setBinaryStream(String parameter, InputStream x, int length)
void	setBoolean(String parameter, boolean x)
void	setByte(String parameter, byte x)
void	setBytes(String parameter, byte[] x)
void	setDate(String parameter, Date x)
void	setDouble(String parameter, float x)
void	setFloat(String parameter, float x)
void	setInt(String parameter, int x)
void	setLong(String parameter, long x)
void	setNull(String parameter, int sqlType)
void	setObject(String parameter, Object x)
void	setObject(String parameter, Object x, int targetSqlType)
void	setObject(String parameter, Object x, int targetSqlType, int scale)
void	setShort(String parameter, short x)
void	setString(String parameter, String x)
void	setTime(String parameter, Time x)
void	setTimestamp(String parameter, Timestamp x)
void	setUnicodeStream(String parameter, InputStream x, int length) Deprecated.

Methods inherited from class com.toolsverse.etl.sql.DelegatingPreparedStatement

addBatch, addBatch, cancel, clearBatch, clearParameters, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getDelegate, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMetaData, getMoreResults, getMoreResults, getParameterMetaData, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setCursorName, setDate, setDate, setDouble, setEscapeProcessing, setFetchDirection, setFetchSize, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setPoolable, setQueryTimeout, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, unwrap

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface Statement

executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows

Method Detail

parse

public static NamedParameterPreparedStatement.ParseResult parse(String query)

Parse the query string containing named parameters and result a parse result, which holds the parsed sql (named parameters replaced by standard '?' parameters and an ordered list of the named parameters. SQL parsing code borrowed from Adam Crume. Thanks Adam. See http://www.javaworld.com/article/2077706/core-java/named-parameters-for-preparedstatement.html?page=2

Parameters:

query - Query containing named parameters

Returns:

ParseResult

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql)
                                                                             throws SQLException

Throws:

SQLException

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql,
                                                                                    int autoGeneratedKeys)
                                                                             throws SQLException

Throws:

SQLException

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql,
                                                                                    int[] columnIndexes)
                                                                             throws SQLException

Throws:

SQLException

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql,
                                                                                    String[] columnNames)
                                                                             throws SQLException

Throws:

SQLException

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql,
                                                                                    int resultSetType,
                                                                                    int resultSetConcurrency)
                                                                             throws SQLException

Throws:

SQLException

createNamedParameterPreparedStatement

public static NamedParameterPreparedStatement createNamedParameterPreparedStatement(Connection conn,
                                                                                    String sql,
                                                                                    int resultSetType,
                                                                                    int resultSetConcurrency,
                                                                                    int resultSetHoldability)
                                                                             throws SQLException

Throws:

SQLException

hasNamedParameters

public boolean hasNamedParameters()

getParameterIndexes

public Collection<Integer> getParameterIndexes(String parameter)

setNull

public void setNull(String parameter,
                    int sqlType)
             throws SQLException

Throws:

SQLException

setBoolean

public void setBoolean(String parameter,
                       boolean x)
                throws SQLException

Throws:

SQLException

setByte

public void setByte(String parameter,
                    byte x)
             throws SQLException

Throws:

SQLException

setShort

public void setShort(String parameter,
                     short x)
              throws SQLException

Throws:

SQLException

setInt

public void setInt(String parameter,
                   int x)
            throws SQLException

Throws:

SQLException

setLong

public void setLong(String parameter,
                    long x)
             throws SQLException

Throws:

SQLException

setFloat

public void setFloat(String parameter,
                     float x)
              throws SQLException

Throws:

SQLException

setDouble

public void setDouble(String parameter,
                      float x)
               throws SQLException

Throws:

SQLException

setBigDecimal

public void setBigDecimal(String parameter,
                          BigDecimal x)
                   throws SQLException

Throws:

SQLException

setString

public void setString(String parameter,
                      String x)
               throws SQLException

Throws:

SQLException

setBytes

public void setBytes(String parameter,
                     byte[] x)
              throws SQLException

Throws:

SQLException

setDate

public void setDate(String parameter,
                    Date x)
             throws SQLException

Throws:

SQLException

setTime

public void setTime(String parameter,
                    Time x)
             throws SQLException

Throws:

SQLException

setTimestamp

public void setTimestamp(String parameter,
                         Timestamp x)
                  throws SQLException

Throws:

SQLException

setAsciiStream

public void setAsciiStream(String parameter,
                           InputStream x)
                    throws SQLException

Throws:

SQLException

setUnicodeStream

@Deprecated
public void setUnicodeStream(String parameter,
                                          InputStream x,
                                          int length)
                                   throws SQLException

Deprecated.

Throws:

SQLException

setBinaryStream

public void setBinaryStream(String parameter,
                            InputStream x,
                            int length)
                     throws SQLException

Throws:

SQLException

setObject

public void setObject(String parameter,
                      Object x,
                      int targetSqlType,
                      int scale)
               throws SQLException

Throws:

SQLException

setObject

public void setObject(String parameter,
                      Object x,
                      int targetSqlType)
               throws SQLException

Throws:

SQLException

setObject

public void setObject(String parameter,
                      Object x)
               throws SQLException

Throws:

SQLException

getOrderedParameters

public List<TypedKeyValue<String,String>> getOrderedParameters()

Gets the ordered parameters.

Returns:

the ordered parameters