|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Agent hosts PreparedStatement interface.
Method Summary | |
void |
addBatch()
Adds a set of parameters to the list of commands to be sent as a batch. |
void |
clearParameters()
Clears the value of all parameters. |
void |
enableResultSetsAndUpdateCounts()
Enables both Result Sets and Update Counts to be received after an execute call. |
void |
enableResultSetsOnly()
Enables only Result Sets to be received after an execute call. |
void |
enableUpdateCountsOnly()
Enables only Update Counts to be received after an execute call. |
boolean |
execute()
Executes the prepared SQL statement. |
ResultSetAgent |
executeQuery()
Executes the prepared SQL query and returns a ResultSetAgent that contains the generated result set. |
int |
executeUpdate()
Executes the prepared SQL statement and returns the number of rows that were affected. |
java.lang.String |
getPreparedStmt()
Returns the Prepared Statement. |
PreparedStatementResultSet[] |
getRSAgentList()
Gets the PreparedStatementResultSet list. |
java.lang.String[] |
getRSAgentSigs()
Gets ResultSetAgent signatures. |
int |
getUpdateCount()
Returns the record count of the last executed statement. |
boolean |
matchResultSetSignature(int ord)
Matches a particular Result Set's Column signature with the current one and points the current Result Set Agent to it. |
boolean |
resultsAvailable()
Determines whether results (Update Counts and/or Result Sets) are available after an execute. |
void |
setArray(int index,
java.sql.Array a)
Sets the Array value of the indexed parameter. |
void |
setAsciiStream(int index,
java.io.InputStream is,
int length)
Sets the character value of the indexed parameter with an input stream and specified length. |
void |
setBigDecimal(int index,
java.math.BigDecimal dec)
Sets the decimal value of indexed parameter. |
void |
setBinaryStream(int index,
java.io.InputStream is,
int length)
Sets the binary value of the indexed parameter with an input stream and specified length. |
void |
setBlob(int index,
java.sql.Blob blob)
Sets the Blob value of the indexed parameter. |
void |
setBoolean(int index,
boolean b)
Sets the boolean value of indexed parameter. |
void |
setByte(int index,
byte byt)
Sets the byte value of indexed parameter. |
void |
setBytes(int index,
byte[] bytes)
Sets the byte array value of the indexed parameter. |
void |
setCharacterStream(int index,
java.io.Reader rd,
int length)
Sets the character value of the indexed parameter with a reader stream and specified length. |
void |
setClob(int index,
java.sql.Clob clob)
Sets the Clob value of the indexed parameter. |
void |
setDate(int index,
java.sql.Date date)
Sets the date value of indexed parameter. |
void |
setDate(int index,
java.sql.Date date,
java.util.Calendar cal)
Sets the date value of indexed parameter including the time zone from the calendar. |
void |
setDouble(int index,
double d)
Sets the double value of indexed parameter. |
void |
setFloat(int index,
float f)
Sets the float value of indexed parameter. |
void |
setInt(int index,
int i)
Sets the integer value of indexed parameter. |
void |
setLong(int index,
long l)
Sets the long value of indexed parameter. |
void |
setNull(int index,
int type)
Nullifies value of the indexed parameter. |
void |
setNull(int index,
int type,
java.lang.String tname)
Nullifies value of indexed parameter. |
void |
setObject(int index,
java.lang.Object ob)
Sets value of indexed parameter with an object. |
void |
setObject(int index,
java.lang.Object ob,
int iType)
Sets value of indexed parameter with data type conversion. |
void |
setObject(int index,
java.lang.Object ob,
int iType,
int iScale)
Sets value of indexed parameter with data type conversion and specified scale. |
void |
setRef(int index,
java.sql.Ref ref)
Sets the Ref value of the indexed parameter. |
void |
setRSAgentList(PreparedStatementResultSet[] rsAgentList)
Sets PreparedStatementResultSet list and holds the list of result sets returned from the prepared statement. |
void |
setRSAgentSigs(java.lang.String[] rsAgentSigs)
Sets ResultSetAgent signatures. |
void |
setShort(int index,
short si)
Sets the short value of indexed parameter. |
void |
setString(int index,
java.lang.String s)
Sets the string value of the indexed parameter. |
void |
setTime(int index,
java.sql.Time t)
Sets the time value of indexed parameter. |
void |
setTime(int index,
java.sql.Time t,
java.util.Calendar cal)
Sets the time value of indexed parameter with time zone from calendar. |
void |
setTimestamp(int index,
java.sql.Timestamp ts)
Sets the timestamp value of the indexed parameter. |
void |
setTimestamp(int index,
java.sql.Timestamp ts,
java.util.Calendar cal)
Sets the timestamp value of the indexed parameter including the time zone from the calendar. |
Methods inherited from interface com.stc.connector.appconn.db.StatementAgent |
cancel, clearBatch, clearWarnings, executeBatch, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getWarnings, isClosed, queryName, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, stmtInvoke |
Method Detail |
public void addBatch() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void clearParameters() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void enableResultSetsAndUpdateCounts()
void
- None.
public void enableResultSetsOnly()
void
- None.
public void enableUpdateCountsOnly()
void
- None.
public boolean execute() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public ResultSetAgent executeQuery() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public int executeUpdate() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public java.lang.String getPreparedStmt() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public PreparedStatementResultSet[] getRSAgentList()
public java.lang.String[] getRSAgentSigs()
public int getUpdateCount() throws java.sql.SQLException
getUpdateCount
in interface StatementAgent
java.sql.SQLException
- when SQL problems occur.public boolean matchResultSetSignature(int ord) throws java.sql.SQLException
ord
- the ordinal position of the particular Result Set.java.sql.SQLException
- when SQL problems occur. when SQL problems occur.public boolean resultsAvailable() throws java.sql.SQLException
true
if Update Counts and/or Result Sets are available.java.sql.SQLException
- when SQL problems occur. when SQL problems occur.public void setArray(int index, java.sql.Array a) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.a
- an Array parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setAsciiStream(int index, java.io.InputStream is, int length) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.is
- an ASCII stream parameter value.length
- the number of bytes to be read from the stream.void
- None.java.sql.SQLException
- when SQL problems occur.public void setBigDecimal(int index, java.math.BigDecimal dec) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.dec
- a BigDecimal parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setBinaryStream(int index, java.io.InputStream is, int length) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.is
- an Binary stream parameter value.length
- the number of bytes to be read from the stream.void
- None.java.sql.SQLException
- when SQL problems occur.public void setBlob(int index, java.sql.Blob blob) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.blob
- a Blob parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setBoolean(int index, boolean b) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.b
- a boolean parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setByte(int index, byte byt) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.byt
- a byte parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setBytes(int index, byte[] bytes) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.bytes
- a byte array parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setCharacterStream(int index, java.io.Reader rd, int length) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.rd
- a Reader parameter value.length
- the number of characters to be read from the stream.void
- None.java.sql.SQLException
- when SQL problems occur.public void setClob(int index, java.sql.Clob clob) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.clob
- a Clob parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setDate(int index, java.sql.Date date) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.date
- a Date parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setDate(int index, java.sql.Date date, java.util.Calendar cal) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.date
- a Date parameter value.cal
- the Calendar object used to construct the Date objectvoid
- None.java.sql.SQLException
- when SQL problems occur.public void setDouble(int index, double d) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.d
- a double parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setFloat(int index, float f) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.f
- a float parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setInt(int index, int i) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.i
- an integer parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setLong(int index, long l) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.l
- a long parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setNull(int index, int type) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.type
- the JDBC type code defined by java.sql.Types.void
- None.java.sql.SQLException
- when SQL problems occur.public void setNull(int index, int type, java.lang.String tname) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.type
- the JDBC type code defined by java.sql.Types.tname
- the fully qualified name of the parameter being set.void
- None.java.sql.SQLException
- when SQL problems occur.public void setObject(int index, java.lang.Object ob) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ob
- a Java object that holds the parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setObject(int index, java.lang.Object ob, int iType) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ob
- a Java object that holds the parameter value.iType
- the JDBC type code defined by java.sql.Types.void
- None.java.sql.SQLException
- when SQL problems occur.public void setObject(int index, java.lang.Object ob, int iType, int iScale) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ob
- a Java object that holds the parameter value.iType
- the JDBC type code defined by java.sql.Types.iScale
- the desired number of digits to the right of the decimal point.void
- None.java.sql.SQLException
- when SQL problems occur.public void setRef(int index, java.sql.Ref ref) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ref
- a Ref parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setRSAgentList(PreparedStatementResultSet[] rsAgentList)
rsAgentList
- an array of PreparedStatementResultSet instances.
void
- None.public void setRSAgentSigs(java.lang.String[] rsAgentSigs)
rsAgentSigs
- an array of signatures in string.
void
- None.public void setShort(int index, short si) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.si
- a short parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setString(int index, java.lang.String s) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.s
- a String parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setTime(int index, java.sql.Time t) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.t
- a Time parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setTime(int index, java.sql.Time t, java.util.Calendar cal) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.t
- a Time parameter value.cal
- the Calendar object used to construct the Time object.void
- None.java.sql.SQLException
- when SQL problems occur.public void setTimestamp(int index, java.sql.Timestamp ts) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ts
- a Timestamp parameter value.void
- None.java.sql.SQLException
- when SQL problems occur.public void setTimestamp(int index, java.sql.Timestamp ts, java.util.Calendar cal) throws java.sql.SQLException
index
- the position of the parameter. It starts from 1.ts
- a Timestamp parameter value.cal
- the Calendar object used to construct the Time object.void
- None.java.sql.SQLException
- when SQL problems occur.
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Copyright 2004 by SeeBeyond Technology Corporation. All Rights Reserved.