com.axiomalaska.jdbc

Class NamedParameterPreparedStatement

java.lang.Object

com.axiomalaska.jdbc.DelegatingPreparedStatement

com.axiomalaska.jdbc.NamedParameterPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class NamedParameterPreparedStatement
extends DelegatingPreparedStatement

Field Summary

Fields inherited from interface java.sql.Statement

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

Method Summary

Methods

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)
boolean	hasNamedParameters()
static com.axiomalaska.jdbc.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.axiomalaska.jdbc.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 java.lang.Object

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

Method Detail

parse

public static com.axiomalaska.jdbc.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()

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