| java.lang.Object com.internetcds.jdbc.tds.Statement com.internetcds.jdbc.tds.PreparedStatement_base com.internetcds.jdbc.tds.CallableStatement_base com.internetcds.jdbc.tds.CallableStatement_2_0
Method Summary | |
public void | addBatch() | 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(int i) JDBC 2.0
Gets the value of a JDBC ARRAY parameter as an
Array object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as an Array object inthe Java programming language. | public Array | getArray(String str) | public BigDecimal | getBigDecimal(String str) | public Blob | getBlob(int i) JDBC 2.0
Gets the value of a JDBC BLOB parameter as a
Blob object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as a Blob object in theJava programming language. | public Blob | getBlob(String str) | public boolean | getBoolean(String str) | public byte | getByte(String str) | public byte[] | getBytes(String str) | public Reader | getCharacterStream(int parameterIndex) | public Reader | getCharacterStream(String parameterName) | public Clob | getClob(int i) JDBC 2.0
Gets the value of a JDBC CLOB parameter as a
Clob object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, andso on the parameter value as a Clob object in theJava programming language. | 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() | public boolean | getMoreResults(int current) | public Reader | getNCharacterStream(int parameterIndex) | public Reader | getNCharacterStream(String parameterName) | public NClob | getNClob(int parameterIndex) | public NClob | getNClob(String parameterName) | public String | getNString(int parameterIndex) | public String | getNString(String parameterName) | public Object | getObject(int i, java.util.Map map) JDBC 2.0
Returns an object representing the value of OUT parameter
i and uses map for the custom
mapping of the parameter value.
This method returns a Java object whose type corresponds to the
JDBC type that was registered for this parameter using the method
registerOutParameter . | public Object | getObject(String str) | public Object | getObject(String str, Map m) | public java.sql.ParameterMetaData | getParameterMetaData() | public Ref | getRef(int i) JDBC 2.0
Gets the value of a JDBC REF(<structured-type>)
parameter as a
Ref object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as a Ref object in theJava programming language. | public Ref | getRef(String str) | public int | getResultSetHoldability() | public RowId | getRowId(int parameterIndex) | public RowId | getRowId(String parameterName) | public SQLXML | getSQLXML(int parameterIndex) | public SQLXML | getSQLXML(String parameterName) | 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) | public void | setAsciiStream(String str, InputStream b, int x) | public void | setAsciiStream(String parameterName, InputStream x) | public void | setAsciiStream(String parameterName, InputStream x, long length) | 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(String parameterName, InputStream x) | public void | setBinaryStream(String parameterName, InputStream x, long length) | 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) | public void | setBlob(String parameterName, Blob x) | public void | setBlob(String parameterName, InputStream inputStream) | public void | setBlob(String parameterName, InputStream inputStream, long length) | 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) | public void | setCharacterStream(String str, Reader b, int x) | public void | setCharacterStream(String parameterName, Reader reader) | public void | setCharacterStream(String parameterName, Reader reader, long length) | 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) | public void | setClob(String parameterName, Clob x) | public void | setClob(String parameterName, Reader reader) | public void | setClob(String parameterName, Reader reader, long length) | 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) | 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(String parameterName, Reader value) | public void | setNCharacterStream(String parameterName, Reader value, long length) | public void | setNCharacterStream(int parameterIndex, Reader value) | public void | setNCharacterStream(int parameterIndex, Reader value, long length) | public void | setNClob(String parameterName, NClob value) | public void | setNClob(String parameterName, Reader reader) | public void | setNClob(String parameterName, Reader reader, 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(String parameterName, String value) | public void | setNString(int parameterIndex, String value) | public void | setNull(int paramIndex, int sqlType, String typeName) | 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) | public void | setRowId(String parameterName, RowId x) | public void | setRowId(int parameterIndex, RowId x) | public void | setSQLXML(String parameterName, SQLXML xmlObject) | 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) | 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) | 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) |
getArray | public Array getArray(int i) throws SQLException(Code) | | JDBC 2.0
Gets the value of a JDBC ARRAY parameter as an
Array object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as an Array object inthe Java programming language. If the value was SQL NULL, thevalue null is returned. exception: SQLException - if a database access error occurs |
getBlob | public Blob getBlob(int i) throws SQLException(Code) | | JDBC 2.0
Gets the value of a JDBC BLOB parameter as a
Blob object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as a Blob object in theJava programming language. If the value was SQL NULL, the valuenull is returned. exception: SQLException - if a database access error occurs |
getClob | public Clob getClob(int i) throws SQLException(Code) | | JDBC 2.0
Gets the value of a JDBC CLOB parameter as a
Clob object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, andso on the parameter value as a Clob object in theJava programming language. If the value was SQL NULL, thevalue null is returned. exception: SQLException - if a database access error occurs |
getObject | public Object getObject(int i, java.util.Map map) throws SQLException(Code) | | JDBC 2.0
Returns an object representing the value of OUT parameter
i and uses map for the custom
mapping of the parameter value.
This method returns a Java object whose type corresponds to the
JDBC type that was registered for this parameter using the method
registerOutParameter . By registering the target
JDBC type as java.sql.Types.OTHER , this method can
be used to read database-specific abstract data types.
Parameters: i - the first parameter is 1, the second is 2, and so on Parameters: map - the mapping from SQL type names to Java classes a java.lang.Object holding the OUT parameter value. exception: SQLException - if a database access error occurs |
getRef | public Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0
Gets the value of a JDBC REF(<structured-type>)
parameter as a
Ref object in the Java programming language.
Parameters: i - the first parameter is 1, the second is 2, and so on the parameter value as a Ref object in theJava programming language. If the value was SQL NULL, the valuenull is returned. exception: SQLException - if a database access error occurs |
setCharacterStream | public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException(Code) | | |
setNCharacterStream | public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException(Code) | | |
Fields inherited from com.internetcds.jdbc.tds.CallableStatement_base | final public static String cvsVersion(Code)(Java Doc)
|
Methods inherited from com.internetcds.jdbc.tds.CallableStatement_base | public boolean execute() throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(int parameterIndex) throws SQLException(Code)(Java Doc) public boolean getBoolean(int parameterIndex) throws SQLException(Code)(Java Doc) public byte getByte(int parameterIndex) throws SQLException(Code)(Java Doc) public byte[] getBytes(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public double getDouble(int parameterIndex) throws SQLException(Code)(Java Doc) public float getFloat(int parameterIndex) throws SQLException(Code)(Java Doc) public int getInt(int parameterIndex) throws SQLException(Code)(Java Doc) public long getLong(int parameterIndex) throws SQLException(Code)(Java Doc) public Object getObject(int parameterIndex) throws SQLException(Code)(Java Doc) public short getShort(int parameterIndex) throws SQLException(Code)(Java Doc) public String getString(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Time getTime(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Time getTime(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public java.sql.Timestamp getTimestamp(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public static void main(String args) throws java.lang.ClassNotFoundException, java.lang.IllegalAccessException, java.lang.InstantiationException(Code)(Java Doc) public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException(Code)(Java Doc) public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException(Code)(Java Doc) public void registerOutParameter(int paramIndex, int sqlType, String typeName) throws SQLException(Code)(Java Doc) public boolean wasNull() throws SQLException(Code)(Java Doc)
|
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)
|
|
|