|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.sas.rio.MVAStatement | +--com.sas.rio.MVAPreparedStatement
Fields inherited from class com.sas.rio.MVAStatement |
bookmarkLength,
bookmarkLengthHolder,
direction,
sasDataSet,
sasDataSetHolder,
sasLibref,
status,
statusHolder |
Constructor Summary | |
MVAPreparedStatement()
Constructs a MVAPreparedStatement object. |
|
MVAPreparedStatement(MVAConnection inconnection,
java.lang.String sql)
Constructs a MVAPreparedStatement object. |
Method Summary | |
void |
addBatch()
JDBC 2.0 Adds a set of parameters to the batch. |
void |
clearParameters()
Clears all the parameters. |
boolean |
execute()
Executes a query. |
java.sql.ResultSet |
executeQuery()
Executes a prepared SQL query and returns the ResultSet. |
int |
executeUpdate()
Executes an SQL INSERT, UPDATE or DELETE statement. |
java.sql.ResultSetMetaData |
getMetaData()
JDBC 2.0 Gets the number, types and properties of a ResultSet's columns as a ResultSetMetaData object. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String x)
JDBC 2.0 TODO: need method definition from latest java.sql source. |
void |
setArray(int parameterIndex,
java.sql.Array x)
JDBC 2.0 Sets a parameter to an Array object. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets a parameter to a Java java.io.InputStream. |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
Sets a parameter to a Java BigDecimal value. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets a parameter to a Java java.io.InputStream. |
void |
setBlob(int parameterIndex,
java.sql.Blob x)
JDBC 2.0 Sets a parameter to a BLOB object. |
void |
setBoolean(int parameterIndex,
boolean x)
Sets a parameter to a Java Boolean value. |
void |
setByte(int parameterIndex,
byte x)
Sets a parameter to a Java byte value. |
void |
setBytes(int parameterIndex,
byte[] x)
Sets a parameter to a Java byte array value. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
JDBC 2.0 Sets a parameter to java.io.Reader object. |
void |
setClob(int parameterIndex,
java.sql.Clob x)
JDBC 2.0 Sets a parameter to a CLOB object. |
void |
setDate(int parameterIndex,
java.sql.Date x)
Sets a parameter to a Java java.sql.Date value. |
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
JDBC 2.0 Sets a parameter to a java.sql.Date value. |
void |
setDouble(int parameterIndex,
double x)
Sets a parameter to a Java double value. |
void |
setFloat(int parameterIndex,
float x)
Sets a parameter to a Java float value. |
void |
setInt(int parameterIndex,
int x)
Sets a parameter to a Java int value. |
void |
setLong(int parameterIndex,
long x)
Sets a parameter to a Java long value. |
void |
setNull(int parameterIndex,
int sqlType)
Sets a parameter to SQL NULL. |
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String x)
JDBC 2.0 Sets a parameter to SQL NULL. |
void |
setObject(int parameterIndex,
java.lang.Object x)
Sets a parameter to the default type. |
void |
setObject(int parameterIndex,
java.lang.Object x,
int sqlType)
Sets a parameter to the input type. |
void |
setObject(int parameterIndex,
java.lang.Object x,
int sqlType,
int scale)
Sets a parameter to the input type. |
void |
setRef(int parameterIndex,
java.sql.Ref x)
JDBC 2.0 Sets a parameter to a REF(<structured-type>) object. |
void |
setShort(int parameterIndex,
short x)
Sets a parameter to a Java short value. |
void |
setString(int parameterIndex,
java.lang.String x)
Sets a parameter to a Java string value. |
void |
setTime(int parameterIndex,
java.sql.Time x)
Sets a parameter to a Java java.sql.Time value. |
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
JDBC 2.0 Sets a parameter to a java.sql.Time value. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
Sets a parameter to a Java java.sql.Timestamp value. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
JDBC 2.0 Sets a parameter to a java.sql.Timestamp value. |
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
Deprecated. |
Methods inherited from class com.sas.rio.MVAStatement |
addBatch,
cancel,
clearBatch,
clearWarnings,
close,
createTable,
deleteTable,
deleteTable,
execute,
executeBatch,
executeQuery,
executeUpdate,
getConnection,
getFetchDirection,
getFetchSize,
getMaxFieldSize,
getMaxRows,
getMoreResults,
getQueryTimeout,
getResultSet,
getResultSetConcurrency,
getResultSetType,
getTable,
getTable,
getUpdateCount,
getWarnings,
setCursorName,
setEscapeProcessing,
setFetchDirection,
setFetchSize,
setMaxFieldSize,
setMaxRows,
setQueryTimeout |
Methods inherited from class java.lang.Object |
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Constructor Detail |
public MVAPreparedStatement()
none
- used only by MVACallableStatementpublic MVAPreparedStatement(MVAConnection inconnection, java.lang.String sql)
inconnection
- MVAConnection objectsql
- input sql statementMethod Detail |
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.sqlType
- An SQL type code that is defined by java.sql.Types.public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- An int value.public void setLong(int parameterIndex, long x) throws java.sql.SQLException
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- float value.public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- double value.public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- String value.public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- java.sql.Date value.public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- java.sql.Time value.public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- java.sql.Timestamp value.public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void clearParameters() throws java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x, int sqlType, int scale) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- An input object.sqlType
- The target SQL type for the object.scale
- This parameter is ignored. SAS software does not support Decimal or Numeric data
types.public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second parameter is 2, and so on.x
- An input object.public void setObject(int parameterIndex, java.lang.Object x, int sqlType) throws java.sql.SQLException
parameterIndex
- The first parameter is 1, the second is 2, and so on.x
- An input object.sqlType
- The target SQL type for the object.public boolean execute() throws java.sql.SQLException
MVAStatement.execute(java.lang.String)
public void addBatch() throws java.sql.SQLException
MVAStatement.addBatch(java.lang.String)
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- The java reader object which contains the UNICODE data.length
- The number of characters in the stream.public void setRef(int parameterIndex, java.sql.Ref x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- An object representing data of an SQL REF Type .public void setBlob(int parameterIndex, java.sql.Blob x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- An object representing a BLOB.public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- An object representing a CLOB.public void setArray(int parameterIndex, java.sql.Array x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- An object representing an SQL array.public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- The parameter value, a java.sql.Date object.cal
- A Calendar object. Ignored if cal is NULL.public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- The parameter value, a java.sql.Time object.cal
- A Calendar object. Ignored if cal is NULL.public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second is 2, and so on.x
- The parameter value, a java.sql.Timestamp value.cal
- A Calendar object. Ignored if cal is NULL.public void setNull(int parameterIndex, int sqlType, java.lang.String x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second parameter is 2, and so on.sqlType
- An SQL type code that is defined by java.sql.Types.x
- An input String.public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String x) throws java.sql.SQLException
parameterIndex
- The parameter index. The first parameter is 1, the second parameter is 2, and so on.sqlType
- An SQL type code that is defined by java.sql.Types.x
- An input String.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |