public class ApptrievePreparedStatement extends ApptrieveStatement implements java.sql.PreparedStatement
Note: The Host Integrator server does not support precompiled SQL. ApptrievePreparedStatement call ApptrieveStatement methods for execute queries.
PreparedStatement
Modifier and Type | Method and Description |
---|---|
void |
addBatch()
This method is not supported by the Host Integrator driver.
|
void |
clearParameters()
Clears all values set the the PreparedStatement object's
IN parameters.
|
void |
closeOnCompletion() |
boolean |
execute()
Executes the SQL statement contained in the PreparedStatement
object.
|
java.sql.ResultSet |
executeQuery()
Executes a prepared SQL query statement and returns the
results in a ResultSet object.
|
int |
executeUpdate()
Executes a prepared SQL update statement and returns the
number of rows updated.
|
java.sql.ResultSetMetaData |
getMetaData()
This method is not supported by the Host Integrator driver.
|
java.sql.ParameterMetaData |
getParameterMetaData()
This method is not supported by the Host Integrator driver.
|
boolean |
isCloseOnCompletion() |
void |
setArray(int parameterIndex,
java.sql.Array x)
This method is not supported by the Host Integrator driver.
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x) |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream fin,
int length)
Sets the parameter in position parameterIndex to the
input stream object fin, from which length bytes will be read and
sent to the Host Integrator server.
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
long length) |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal n)
Sets parameter number parameterIndex to the BigDecimal n.
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x) |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream fin,
int length)
Sets parameter number parameterIndex to the input stream
object fin, from which length bytes will be read and sent to
the Host Integrator server.
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
long length) |
void |
setBlob(int parameterIndex,
java.sql.Blob x)
This method is not supported by the Host Integrator driver.
|
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream) |
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream,
long length) |
void |
setBoolean(int parameterIndex,
boolean x)
Sets parameter number parameterIndex to the string value of boolean x.
|
void |
setByte(int parameterIndex,
byte x)
Sets parameter number parameterIndex to the byte x.
|
void |
setBytes(int parameterIndex,
byte[] x)
Sets parameter number parameterIndex to the array of bytes x[].
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader) |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
This method is not supported by the Host Integrator driver.
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
long length) |
void |
setClob(int parameterIndex,
java.sql.Clob x)
This method is not supported by the Host Integrator driver.
|
void |
setClob(int parameterIndex,
java.io.Reader reader) |
void |
setClob(int parameterIndex,
java.io.Reader reader,
long length) |
void |
setDate(int parameterIndex,
java.sql.Date x)
Sets parameter number parameterIndex to the Date x.
|
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
This method is not supported by the Host Integrator driver.
|
void |
setDouble(int parameterIndex,
double x)
Sets parameter number parameterIndex to the double x.
|
void |
setEscapeProcessing(boolean enable)
ApptrievePreparedStatement does not support escape processing.
|
void |
setFloat(int parameterIndex,
float x)
Sets parameter number parameterIndex to the float x.
|
void |
setInt(int parameterIndex,
int x)
Sets parameter number parameterIndex to the int x.
|
void |
setLong(int parameterIndex,
long x)
Sets parameter number parameterIndex to the long x.
|
void |
setNCharacterStream(int parameterIndex,
java.io.Reader value) |
void |
setNCharacterStream(int parameterIndex,
java.io.Reader value,
long length) |
void |
setNClob(int parameterIndex,
java.sql.NClob value) |
void |
setNClob(int parameterIndex,
java.io.Reader reader) |
void |
setNClob(int parameterIndex,
java.io.Reader reader,
long length) |
void |
setNString(int parameterIndex,
java.lang.String value) |
void |
setNull(int parameterIndex,
int jdbcType)
This method is not supported by the Host Integrator driver.
|
void |
setNull(int parameterIndex,
int jdbcType,
java.lang.String typeName)
This method is not supported by the Host Integrator driver.
|
void |
setObject(int parameterIndex,
java.lang.Object x)
Sets parameter number parameterIndex to the Object x.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType)
This method is not supported by the Host Integrator driver.
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
This method is not supported by the Host Integrator driver.
|
void |
setRef(int parameterIndex,
java.sql.Ref x)
This method is not supported by the Host Integrator driver.
|
void |
setRowId(int parameterIndex,
java.sql.RowId x) |
void |
setShort(int parameterIndex,
short x)
Sets parameter number parameterIndex to the short x.
|
void |
setSQLXML(int parameterIndex,
java.sql.SQLXML xmlObject) |
void |
setString(int parameterIndex,
java.lang.String x)
Sets parameter number parameterIndex to the String x.
|
void |
setTime(int parameterIndex,
java.sql.Time x)
Sets parameter number parameterIndex to the Time x.
|
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
This method is not supported by the Host Integrator driver.
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
Sets parameter number parameterIndex to the Timestamp x.
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
This method is not supported by the Host Integrator driver.
|
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream fin,
int length)
Deprecated.
- use setCharacterStream
|
void |
setURL(int parameterIndex,
java.net.URL x)
Deprecated.
- use setCharacterStream
|
java.lang.String |
toString()
Returns the original SQL String.
|
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getConnectionTimeout, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isWrapperFor, setConnectionTimeout, setCursorName, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
addBatch, cancel, clearBatch, clearWarnings, close, 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, isClosed, isPoolable, setCursorName, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
public void addBatch() throws java.sql.SQLException
addBatch
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.addBatch()
public void clearParameters() throws java.sql.SQLException
clearParameters
in interface java.sql.PreparedStatement
java.sql.SQLException
PreparedStatement.clearParameters()
public boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
java.sql.SQLException
PreparedStatement.execute()
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
executeQuery
in interface java.sql.PreparedStatement
java.sql.SQLException
PreparedStatement.executeQuery()
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
java.sql.SQLException
PreparedStatement.executeUpdate()
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.getMetaData()
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
getParameterMetaData
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.getParameterMetaData()
public void setArray(int parameterIndex, java.sql.Array x) throws java.sql.SQLException
setArray
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setArray(int, Array)
public void setAsciiStream(int parameterIndex, java.io.InputStream fin, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterfin
- java.io.InputStream - the input stream object to uselength
- - the number of bytes to read from the input streamjava.sql.SQLException
PreparedStatement.setAsciiStream(int, java.io.InputStream, int)
public void setBigDecimal(int parameterIndex, java.math.BigDecimal n) throws java.sql.SQLException
setBigDecimal
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parametern
- BigDecimal - the input valuejava.sql.SQLException
PreparedStatement.setBigDecimal(int, java.math.BigDecimal)
public void setBinaryStream(int parameterIndex, java.io.InputStream fin, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterfin
- InputStream - the input streamlength
- int - the number of bytes to readjava.sql.SQLException
PreparedStatement.setBinaryStream(int, java.io.InputStream, int)
public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setBlob(int, Blob)
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- boolean - the input value. Sets the parameter to the string
value obtained from Boolean.toString(x)
.java.sql.SQLException
PreparedStatement.setBoolean(int, boolean)
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
setByte
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- byte - the input valuejava.sql.SQLException
PreparedStatement.setByte(int, byte)
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- byte[] - the input valuesjava.sql.SQLException
PreparedStatement.setBytes(int, byte[])
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setCharacterStream(int, Reader, int)
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setClob(int, Clob)
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- Date - the input valuejava.sql.SQLException
PreparedStatement.setDate(int, java.sql.Date)
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setDate(int, java.sql.Date, Calendar)
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
setDouble
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- double - the input valuejava.sql.SQLException
PreparedStatement.setDouble(int, double)
public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
setEscapeProcessing
in interface java.sql.Statement
setEscapeProcessing
in class ApptrieveStatement
java.sql.SQLException
- - always thrown.Statement.setEscapeProcessing(boolean)
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
setFloat
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- float - the input valuejava.sql.SQLException
PreparedStatement.setFloat(int, float)
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
setInt
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- int - the input valuejava.sql.SQLException
PreparedStatement.setInt(int, int)
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
setLong
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- long - the input valuejava.sql.SQLException
PreparedStatement.setLong(int, long)
public void setNull(int parameterIndex, int jdbcType) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrownPreparedStatement.setNull(int, int)
public void setNull(int parameterIndex, int jdbcType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrownPreparedStatement.setNull(int, int, String)
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- Object - the input objectjava.sql.SQLException
PreparedStatement.setObject(int, java.lang.Object, int)
public void setObject(int parameterIndex, java.lang.Object x, int targetJdbcType) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setObject(int, Object, int)
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setObject(int, Object, int, int)
public void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
setRef
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setRef(int, Ref)
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
setShort
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- short - the input valuejava.sql.SQLException
PreparedStatement.setShort(int, short)
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- java.lang.String - the input valuejava.sql.SQLException
PreparedStatement.setString(int, java.lang.String)
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- Time - the input valuejava.sql.SQLException
PreparedStatement.setTime(int, java.sql.Time)
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setTime(int, Time, Calendar)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterx
- Timestamp - the input valuejava.sql.SQLException
PreparedStatement.setTimestamp(int, java.sql.Timestamp)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setTimestamp(int, Timestamp, Calendar)
public void setUnicodeStream(int parameterIndex, java.io.InputStream fin, int length) throws java.sql.SQLException
setUnicodeStream
in interface java.sql.PreparedStatement
parameterIndex
- int - the position of the input parameterfin
- java.io.InputStream - the input valuelength
- int - the number of bytes to read from finjava.sql.SQLException
PreparedStatement.setUnicodeStream(int, java.io.InputStream, int)
public void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
setURL
in interface java.sql.PreparedStatement
java.sql.SQLException
- - always thrown.PreparedStatement.setURL(int , URL)
public java.lang.String toString()
toString
in class java.lang.Object
public void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNString(int parameterIndex, java.lang.String value) throws java.sql.SQLException
setNString
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNCharacterStream(int parameterIndex, java.io.Reader value, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNClob(int parameterIndex, java.sql.NClob value) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
java.sql.SQLException
public void setNClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.PreparedStatement
java.sql.SQLException
public boolean isCloseOnCompletion() throws java.sql.SQLException
isCloseOnCompletion
in interface java.sql.Statement
isCloseOnCompletion
in class ApptrieveStatement
java.sql.SQLException
public void closeOnCompletion() throws java.sql.SQLException
closeOnCompletion
in interface java.sql.Statement
closeOnCompletion
in class ApptrieveStatement
java.sql.SQLException