| java.lang.Object com.internetcds.jdbc.tds.Statement com.internetcds.jdbc.tds.PreparedStatement_base com.internetcds.jdbc.tds.PreparedStatement_2_0
Method Summary | |
public void | addBatch() JDBC 2.0
Adds a set of parameters to the batch. | public boolean | execute(String sql, int autoGeneratedKeys) | public boolean | execute(String sql, int[] columnIndexes) | public boolean | execute(String sql, String[] columnNames) | public int | executeUpdate(String sql, int autoGeneratedKeys) | public int | executeUpdate(String sql, int[] columnIndexes) | public int | executeUpdate(String sql, String[] columnNames) | public Array | getArray(String str) | public BigDecimal | getBigDecimal(String str) | public Blob | getBlob(String str) | public boolean | getBoolean(String str) | public byte | getByte(String str) | public byte[] | getBytes(String str) | public Clob | getClob(String str) | public Date | getDate(String str) | public Date | getDate(String str, Calendar c) | public double | getDouble(String str) | public float | getFloat(String str) | public ResultSet | getGeneratedKeys() | public int | getInt(String str) | public long | getLong(String str) | public java.sql.ResultSetMetaData | getMetaData() JDBC 2.0
Gets the number, types and properties of a ResultSet's columns. | public boolean | getMoreResults(int current) | public Object | getObject(String str) | public Object | getObject(String str, Map m) | public java.sql.ParameterMetaData | getParameterMetaData() | public Ref | getRef(String str) | public int | getResultSetHoldability() | public short | getShort(String str) | public String | getString(String str) | public Time | getTime(String str) | public Time | getTime(String str, Calendar m) | public Timestamp | getTimestamp(String str) | public Timestamp | getTimestamp(String str, Calendar m) | public URL | getURL(int url) | public URL | getURL(String str) | public void | registerOutParameter(String str, int x) | public void | registerOutParameter(String str, int x, int y) | public void | registerOutParameter(String str1, String str2) | public void | registerOutParameter(String str1, int x, String str2) | public void | setArray(int i, java.sql.Array x) JDBC 2.0
Sets an Array parameter. | public void | setAsciiStream(String str, InputStream b, int x) | public void | setAsciiStream(int parameterIndex, InputStream x) | public void | setAsciiStream(int parameterIndex, InputStream x, long length) | public void | setBigDecimal(String str, BigDecimal b) | public void | setBinaryStream(String str, InputStream b, int x) | public void | setBinaryStream(int parameterIndex, InputStream x) | public void | setBinaryStream(int parameterIndex, InputStream x, long length) | public void | setBlob(int i, java.sql.Blob x) JDBC 2.0
Sets a BLOB parameter. | public void | setBlob(int parameterIndex, InputStream inputStream) | public void | setBlob(int parameterIndex, InputStream inputStream, long length) | public void | setBoolean(String str, boolean b) | public void | setByte(String str, byte b) | public void | setBytes(String str, byte[] b) | public void | setCharacterStream(int parameterIndex, java.io.Reader reader, int length) JDBC 2.0
Sets the designated parameter to the given Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. | public void | setCharacterStream(String str, Reader b, int x) | public void | setCharacterStream(int parameterIndex, Reader reader) | public void | setCharacterStream(int parameterIndex, Reader reader, long length) | public void | setClob(int i, java.sql.Clob x) JDBC 2.0
Sets a CLOB parameter. | public void | setClob(int parameterIndex, Reader reader) | public void | setClob(int parameterIndex, Reader reader, long length) | public void | setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) JDBC 2.0
Sets the designated parameter to a java.sql.Date value,
using the given Calendar object. | public void | setDate(String str, Date b) | public void | setDate(String str, Date b, Calendar cal) | public void | setDouble(String str, double b) | public void | setFloat(String str, float b) | public void | setInt(String str, int b) | public void | setLong(String str, long b) | public void | setNCharacterStream(int parameterIndex, Reader value) | public void | setNCharacterStream(int parameterIndex, Reader value, long length) | public void | setNClob(int parameterIndex, NClob value) | public void | setNClob(int parameterIndex, Reader reader) | public void | setNClob(int parameterIndex, Reader reader, long length) | public void | setNString(int parameterIndex, String value) | public void | setNull(int paramIndex, int sqlType, String typeName) JDBC 2.0
Sets the designated parameter to SQL NULL. | public void | setNull(String column, int url) | public void | setNull(String str, int b, String str2) | public void | setObject(String str, Object b, int x, int y) | public void | setObject(String str, Object b, int x) | public void | setObject(String str, Object b) | public void | setRef(int i, java.sql.Ref x) JDBC 2.0
Sets a REF(<structured-type>) parameter. | public void | setRowId(int parameterIndex, RowId x) | public void | setSQLXML(int parameterIndex, SQLXML xmlObject) | public void | setShort(String str, short b) | public void | setString(String str, String b) | public void | setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) JDBC 2.0
Sets the designated parameter to a java.sql.Time value,
using the given Calendar object. | public void | setTime(String str, Time b) | public void | setTime(String str, Time b, Calendar cal) | public void | setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) JDBC 2.0
Sets the designated parameter to a java.sql.Timestamp value,
using the given Calendar object. | public void | setTimestamp(String str, Timestamp b) | public void | setTimestamp(String str, Timestamp b, Calendar cal) | public void | setURL(int current, URL url) | public void | setURL(String current, URL url) |
setArray | public void setArray(int i, java.sql.Array x) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets an Array parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing an SQL array exception: SQLException - if a database access error occurs |
setBlob | public void setBlob(int i, java.sql.Blob x) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets a BLOB parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing a BLOB exception: SQLException - if a database access error occurs |
setCharacterStream | public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets the designated parameter to the given Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. JDBC will read the data from the stream
as needed, until it reaches end-of-file. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard
Java stream object or your own subclass that implements the
standard interface.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the java reader which contains the UNICODE data Parameters: length - the number of characters in the stream exception: SQLException - if a database access error occurs |
setCharacterStream | public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException(Code) | | |
setClob | public void setClob(int i, java.sql.Clob x) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets a CLOB parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing a CLOB exception: SQLException - if a database access error occurs |
setDate | public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets the designated parameter to a java.sql.Date value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL DATE,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the date
taking into account a custom timezone and locale. If no
Calendar object is specified, the driver uses the default
timezone and locale.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will useto construct the date exception: SQLException - if a database access error occurs |
setNCharacterStream | public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException(Code) | | |
setNull | public void setNull(int paramIndex, int sqlType, String typeName) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets the designated parameter to SQL NULL. This version of setNull should
be used for user-named types and REF type parameters. Examples
of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Note: To be portable, applications must give the
SQL type code and the fully-qualified SQL type name when specifying
a NULL user-defined or REF parameter. In the case of a user-named type
the name is the type name of the parameter itself. For a REF
parameter the name is the type name of the referenced type. If
a JDBC driver does not need the type code or type name information,
it may ignore it.
Although it is intended for user-named and Ref parameters,
this method may be used to set a null parameter of any JDBC type.
If the parameter does not have a user-named or REF type, the given
typeName is ignored.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: sqlType - a value from java.sql.Types Parameters: typeName - the fully-qualified name of an SQL user-named type,ignored if the parameter is not a user-named type or REF exception: SQLException - if a database access error occurs |
setRef | public void setRef(int i, java.sql.Ref x) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets a REF(<structured-type>) parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing data of an SQL REF Type exception: SQLException - if a database access error occurs |
setTime | public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets the designated parameter to a java.sql.Time value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL TIME,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the time
taking into account a custom timezone and locale. If no
Calendar object is specified, the driver uses the default
timezone and locale.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will useto construct the time exception: SQLException - if a database access error occurs |
setTimestamp | public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException(Code) | | JDBC 2.0
Sets the designated parameter to a java.sql.Timestamp value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL TIMESTAMP,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the timestamp
taking into account a custom timezone and locale. If no
Calendar object is specified, the driver uses the default
timezone and locale.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the parameter value Parameters: cal - the Calendar object the driver will useto construct the timestamp exception: SQLException - if a database access error occurs |
Methods inherited from com.internetcds.jdbc.tds.PreparedStatement_base | protected void NotImplemented() throws java.sql.SQLException(Code)(Java Doc) public void clearParameters() throws SQLException(Code)(Java Doc) public void dropAllProcedures()(Code)(Java Doc) public boolean execute() throws SQLException(Code)(Java Doc) protected boolean executeCall(String name, ParameterListItem[] formalParameterList, ParameterListItem[] actualParameterList) throws SQLException(Code)(Java Doc) public java.sql.ResultSet executeQuery() throws SQLException(Code)(Java Doc) public int executeUpdate() throws SQLException(Code)(Java Doc) public static void main(String args) throws java.lang.ClassNotFoundException, java.lang.IllegalAccessException, java.lang.InstantiationException, SQLException(Code)(Java Doc) public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc) public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException(Code)(Java Doc) public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc) public void setBoolean(int parameterIndex, boolean x) throws SQLException(Code)(Java Doc) public void setByte(int index, byte x) throws SQLException(Code)(Java Doc) public void setBytes(int parameterIndex, byte x) throws SQLException(Code)(Java Doc) public void setDate(int parameterIndex, java.sql.Date value) throws SQLException(Code)(Java Doc) public void setDouble(int parameterIndex, double value) throws SQLException(Code)(Java Doc) public void setFloat(int parameterIndex, float value) throws SQLException(Code)(Java Doc) public void setInt(int index, int value) throws SQLException(Code)(Java Doc) public void setLong(int parameterIndex, long value) throws SQLException(Code)(Java Doc) public void setNull(int index, int type) throws SQLException(Code)(Java Doc) public void setObject(int parameterIndex, Object x) throws SQLException(Code)(Java Doc) public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException(Code)(Java Doc) public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException(Code)(Java Doc) public void setShort(int index, short value) throws SQLException(Code)(Java Doc) public void setString(int index, String str) throws SQLException(Code)(Java Doc) public void setTime(int parameterIndex, java.sql.Time x) throws SQLException(Code)(Java Doc) public void setTimestamp(int index, java.sql.Timestamp value) throws SQLException(Code)(Java Doc) public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc)
|
Methods inherited from com.internetcds.jdbc.tds.Statement | public void addBatch(String sql) throws SQLException(Code)(Java Doc) public void cancel() throws SQLException(Code)(Java Doc) public void clearBatch() throws SQLException(Code)(Java Doc) public void clearWarnings() throws SQLException(Code)(Java Doc) public void close() throws SQLException(Code)(Java Doc) protected void closeResults() throws java.sql.SQLException(Code)(Java Doc) public void commit() throws java.sql.SQLException, java.io.IOException, com.internetcds.jdbc.tds.TdsUnknownPacketSubType, com.internetcds.jdbc.tds.TdsException(Code)(Java Doc) public boolean execute(String sql) throws SQLException(Code)(Java Doc) public boolean execute(String sql, int autoGeneratedKeys) throws SQLException(Code)(Java Doc) public boolean execute(String sql, int[] columnIndexes) throws SQLException(Code)(Java Doc) public boolean execute(String sql, String[] columnNames) throws SQLException(Code)(Java Doc) public int[] executeBatch() throws SQLException(Code)(Java Doc) public java.sql.ResultSet executeQuery(String sql) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, int[] columnIndexes) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, String[] columnNames) throws SQLException(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) public java.sql.Connection getConnection() throws SQLException(Code)(Java Doc) public int getFetchDirection() throws SQLException(Code)(Java Doc) public int getFetchSize() throws SQLException(Code)(Java Doc) public ResultSet getGeneratedKeys() throws SQLException(Code)(Java Doc) public int getMaxFieldSize() throws SQLException(Code)(Java Doc) public int getMaxRows() throws SQLException(Code)(Java Doc) public boolean getMoreResults() throws SQLException(Code)(Java Doc) public boolean getMoreResults(int current) throws SQLException(Code)(Java Doc) public int getQueryTimeout() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getResultSet() throws SQLException(Code)(Java Doc) public int getResultSetConcurrency() throws SQLException(Code)(Java Doc) public int getResultSetHoldability() throws SQLException(Code)(Java Doc) public int getResultSetType() throws SQLException(Code)(Java Doc) public int getUpdateCount() throws SQLException(Code)(Java Doc) public SQLWarning getWarnings() throws SQLException(Code)(Java Doc) public boolean isClosed()(Code)(Java Doc) public boolean isPoolable() throws SQLException(Code)(Java Doc) public boolean isWrapperFor(Class> iface) throws SQLException(Code)(Java Doc) public static void main(String args) throws java.lang.ClassNotFoundException, java.lang.IllegalAccessException, java.lang.InstantiationException, SQLException(Code)(Java Doc) public void rollback() throws java.sql.SQLException, java.io.IOException, com.internetcds.jdbc.tds.TdsUnknownPacketSubType, com.internetcds.jdbc.tds.TdsException(Code)(Java Doc) public void setCursorName(String name) throws SQLException(Code)(Java Doc) public void setEscapeProcessing(boolean enable) throws SQLException(Code)(Java Doc) public void setFetchDirection(int direction) throws SQLException(Code)(Java Doc) public void setFetchSize(int rows) throws SQLException(Code)(Java Doc) public void setMaxFieldSize(int max) throws SQLException(Code)(Java Doc) public void setMaxRows(int max) throws SQLException(Code)(Java Doc) public void setPoolable(boolean poolable) throws SQLException(Code)(Java Doc) public void setQueryTimeout(int seconds) throws SQLException(Code)(Java Doc) protected void startResultSet() throws SQLException(Code)(Java Doc) public T unwrap(Class<T> iface) throws SQLException(Code)(Java Doc)
|
|
|