org.lateralnz.c3d
Class DCPreparedStatement

java.lang.Object
  org.lateralnz.c3d.DCStatement
      org.lateralnz.c3d.DCPreparedStatement

All Implemented Interfaces:

java.io.Serializable, java.sql.PreparedStatement, java.sql.Statement, Constants

public class DCPreparedStatement
extends DCStatement
implements java.sql.PreparedStatement, Constants

See Also:

Serialized Form

Field Summary

protected Column[]	params
protected java.sql.PreparedStatement	queryUpdateRowsPS
protected java.lang.String	queryUpdateRowsSQL
protected java.sql.PreparedStatement	realPS

Fields inherited from class org.lateralnz.c3d.DCStatement

autoGeneratedKeys, CALLABLE, conn, insertKeyColumnIndexes, insertKeyColumns, nocaching, PREPARED, resultsetConcurrency, resultsetHoldability, resultsetType, rs, STATEMENT, statementType, updateCount

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

Fields inherited from interface org.lateralnz.common.util.Constants

AMPERSAND, AND, APPLICATION_X_WWW_FORM_URLENCODED, ASTERISK, AT, BACK_SLASH, CHAR_LEFT_CHEV, CHAR_RIGHT_CHEV, COLON, COMMA, CRLF, DASH, DELETE, DOLLAR, DOT, DOT_CLASS, DOT_JAVA, EIGHT, EMPTY, EQUALS, FALSE, FILE_SEPARATOR, FIVE, FORWARD_SLASH, FOUR, FULLSTOP, HASH, HAT, INSERT, LEFT_BRACE, LEFT_BRACKET, LEFT_CHEV, MAX_LEN_APPCODE, MAX_LEN_APPGROUP, MAX_LEN_MSGCODE, MAX_LEN_MSGTEXT, MINUS_ONE, N, NEWLINE, NINE, NO, NULL_STRING, OFF, ON, ONE, ONE_DAY, ONE_HOUR, ONE_MINUTE, ONE_WEEK, PATH_SEPARATOR, PERCENT, PIPE, PLUS, QUESTION_MARK, QUOTE, REQUIRED, REQUIRES_NEW, RETURN, RIGHT_BRACE, RIGHT_BRACKET, RIGHT_CHEV, SELECT, SEMICOLON, SEVEN, SINGLE_QUOTE, SIX, SPACE, SQ_LEFT_BRACKET, SQ_RIGHT_BRACKET, SUPPORTS, TEXT_HTML, TEXT_PLAIN, TEXT_XML, THREE, TRUE, TWO, UNDERSCORE, UPDATE, UTF_8, Y, YES, ZERO

Constructor Summary

DCPreparedStatement(DCConnection conn, java.lang.String sql, int resultsetType, int resultsetConcurrency, int resultsetHoldability, int autoGeneratedKeys, int[] columnIndexes, java.lang.String[] columnNames)

Method Summary

void	addBatch()
void	clearParameters()
void	close()
boolean	execute()
java.sql.ResultSet	executeQuery()
int	executeUpdate()
java.sql.ResultSetMetaData	getMetaData()
java.sql.ParameterMetaData	getParameterMetaData()
java.sql.Statement	getRealStatement()
void	setArray(int param, java.sql.Array array)
void	setAsciiStream(int param, java.io.InputStream inputStream, int param2)
void	setBigDecimal(int param, java.math.BigDecimal bigDecimal)
void	setBinaryStream(int param, java.io.InputStream inputStream, int param2)
void	setBlob(int param, java.sql.Blob blob)
void	setBoolean(int param, boolean param1)
void	setByte(int param, byte param1)
void	setBytes(int param, byte[] values)
void	setCharacterStream(int param, java.io.Reader reader, int param2)
void	setClob(int param, java.sql.Clob clob)
void	setDate(int param, java.sql.Date date)
void	setDate(int param, java.sql.Date date, java.util.Calendar calendar)
void	setDouble(int param, double param1)
void	setFloat(int param, float param1)
void	setInt(int param, int param1)
void	setLong(int param, long param1)
void	setNull(int param, int param1)
void	setNull(int param, int param1, java.lang.String str)
void	setObject(int param, java.lang.Object obj)
void	setObject(int param, java.lang.Object obj, int param2)
void	setObject(int param, java.lang.Object obj, int param2, int param3)
void	setRef(int param, java.sql.Ref ref)
void	setShort(int param, short param1)
void	setString(int param, java.lang.String str)
void	setTime(int param, java.sql.Time time)
void	setTime(int param, java.sql.Time time, java.util.Calendar calendar)
void	setTimestamp(int param, java.sql.Timestamp timestamp)
void	setTimestamp(int param, java.sql.Timestamp timestamp, java.util.Calendar calendar)
void	setUnicodeStream(int param, java.io.InputStream inputStream, int param2)
void	setURL(int param, java.net.URL url)

Methods inherited from class org.lateralnz.c3d.DCStatement

addBatch, cancel, clearBatch, clearWarnings, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQL, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setSQL

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout

Field Detail

realPS

protected java.sql.PreparedStatement realPS

queryUpdateRowsPS

protected java.sql.PreparedStatement queryUpdateRowsPS

queryUpdateRowsSQL

protected java.lang.String queryUpdateRowsSQL

params

protected Column[] params

Constructor Detail

DCPreparedStatement

public DCPreparedStatement(DCConnection conn,
                           java.lang.String sql,
                           int resultsetType,
                           int resultsetConcurrency,
                           int resultsetHoldability,
                           int autoGeneratedKeys,
                           int[] columnIndexes,
                           java.lang.String[] columnNames)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

addBatch

public void addBatch()
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Specified by:

clearParameters in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Statement

Overrides:

close in class DCStatement

Throws:

java.sql.SQLException

execute

public boolean execute()
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Specified by:

getMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

Specified by:

getParameterMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getRealStatement

public java.sql.Statement getRealStatement()

Overrides:

getRealStatement in class DCStatement

setArray

public void setArray(int param,
                     java.sql.Array array)
              throws java.sql.SQLException

Specified by:

setArray in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int param,
                           java.io.InputStream inputStream,
                           int param2)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBigDecimal

public void setBigDecimal(int param,
                          java.math.BigDecimal bigDecimal)
                   throws java.sql.SQLException

Specified by:

setBigDecimal in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int param,
                            java.io.InputStream inputStream,
                            int param2)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int param,
                    java.sql.Blob blob)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBoolean

public void setBoolean(int param,
                       boolean param1)
                throws java.sql.SQLException

Specified by:

setBoolean in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setByte

public void setByte(int param,
                    byte param1)
             throws java.sql.SQLException

Specified by:

setByte in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBytes

public void setBytes(int param,
                     byte[] values)
              throws java.sql.SQLException

Specified by:

setBytes in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int param,
                               java.io.Reader reader,
                               int param2)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int param,
                    java.sql.Clob clob)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int param,
                    java.sql.Date date)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int param,
                    java.sql.Date date,
                    java.util.Calendar calendar)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDouble

public void setDouble(int param,
                      double param1)
               throws java.sql.SQLException

Specified by:

setDouble in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setFloat

public void setFloat(int param,
                     float param1)
              throws java.sql.SQLException

Specified by:

setFloat in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setInt

public void setInt(int param,
                   int param1)
            throws java.sql.SQLException

Specified by:

setInt in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setLong

public void setLong(int param,
                    long param1)
             throws java.sql.SQLException

Specified by:

setLong in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int param,
                    int param1)
             throws java.sql.SQLException

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int param,
                    int param1,
                    java.lang.String str)
             throws java.sql.SQLException

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int param,
                      java.lang.Object obj)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int param,
                      java.lang.Object obj,
                      int param2)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int param,
                      java.lang.Object obj,
                      int param2,
                      int param3)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setRef

public void setRef(int param,
                   java.sql.Ref ref)
            throws java.sql.SQLException

Specified by:

setRef in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setShort

public void setShort(int param,
                     short param1)
              throws java.sql.SQLException

Specified by:

setShort in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setString

public void setString(int param,
                      java.lang.String str)
               throws java.sql.SQLException

Specified by:

setString in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int param,
                    java.sql.Time time)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int param,
                    java.sql.Time time,
                    java.util.Calendar calendar)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int param,
                         java.sql.Timestamp timestamp)
                  throws java.sql.SQLException

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int param,
                         java.sql.Timestamp timestamp,
                         java.util.Calendar calendar)
                  throws java.sql.SQLException

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setURL

public void setURL(int param,
                   java.net.URL url)
            throws java.sql.SQLException

Specified by:

setURL in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setUnicodeStream

public void setUnicodeStream(int param,
                             java.io.InputStream inputStream,
                             int param2)
                      throws java.sql.SQLException

Specified by:

setUnicodeStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException