public class JbaseJDBCCallableStatement extends JBaseJDBCPreparedStatement implements java.sql.CallableStatement
JBaseJDBCGlobals.TYPES
parameters
batchRequestsList
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
AM, CHAR_AM, CHAR_SM, CHAR_VM, SHORT_AM, SHORT_CHAR_AM, SHORT_CHAR_SM, SHORT_CHAR_VM, SHORT_SM, SHORT_VM, SM, VM
Constructor and Description |
---|
JbaseJDBCCallableStatement(JBaseJDBCSocketConnection connection,
java.lang.String sql) |
Modifier and Type | Method and Description |
---|---|
boolean |
execute() |
int |
executeUpdate()
Executes the SQL statement in this PreparedStatement object,
which must be an SQL INSERT, UPDATE or DELETE statement;
or an SQL statement that returns nothing, such as a DDL statement.
|
java.sql.Array |
getArray(int arg0) |
java.sql.Array |
getArray(java.lang.String arg0) |
java.math.BigDecimal |
getBigDecimal(int i) |
java.math.BigDecimal |
getBigDecimal(int arg0,
int arg1) |
java.math.BigDecimal |
getBigDecimal(java.lang.String arg0) |
java.sql.Blob |
getBlob(int arg0) |
java.sql.Blob |
getBlob(java.lang.String arg0) |
boolean |
getBoolean(int arg0) |
boolean |
getBoolean(java.lang.String arg0) |
byte |
getByte(int arg0) |
byte |
getByte(java.lang.String arg0) |
byte[] |
getBytes(int arg0) |
byte[] |
getBytes(java.lang.String arg0) |
java.sql.Clob |
getClob(int arg0) |
java.sql.Clob |
getClob(java.lang.String arg0) |
java.sql.Date |
getDate(int arg0) |
java.sql.Date |
getDate(int arg0,
java.util.Calendar arg1) |
java.sql.Date |
getDate(java.lang.String arg0) |
java.sql.Date |
getDate(java.lang.String arg0,
java.util.Calendar arg1) |
double |
getDouble(int i) |
double |
getDouble(java.lang.String arg0) |
float |
getFloat(int i) |
float |
getFloat(java.lang.String arg0) |
int |
getInt(int i) |
int |
getInt(java.lang.String arg0) |
long |
getLong(int i) |
long |
getLong(java.lang.String arg0) |
java.lang.Object |
getObject(int arg0) |
java.lang.Object |
getObject(int arg0,
java.util.Map arg1) |
java.lang.Object |
getObject(java.lang.String arg0) |
java.lang.Object |
getObject(java.lang.String arg0,
java.util.Map arg1) |
java.sql.Ref |
getRef(int arg0) |
java.sql.Ref |
getRef(java.lang.String arg0) |
short |
getShort(int i) |
short |
getShort(java.lang.String arg0) |
java.lang.String |
getString(int arg0) |
java.lang.String |
getString(java.lang.String arg0) |
java.sql.Time |
getTime(int arg0) |
java.sql.Time |
getTime(int arg0,
java.util.Calendar arg1) |
java.sql.Time |
getTime(java.lang.String arg0) |
java.sql.Time |
getTime(java.lang.String arg0,
java.util.Calendar arg1) |
java.sql.Timestamp |
getTimestamp(int arg0) |
java.sql.Timestamp |
getTimestamp(int arg0,
java.util.Calendar arg1) |
java.sql.Timestamp |
getTimestamp(java.lang.String arg0) |
java.sql.Timestamp |
getTimestamp(java.lang.String arg0,
java.util.Calendar arg1) |
java.net.URL |
getURL(int arg0) |
java.net.URL |
getURL(java.lang.String arg0) |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
|
void |
registerOutParameter(int arg0,
int arg1,
java.lang.String arg2) |
void |
registerOutParameter(java.lang.String arg0,
int arg1) |
void |
registerOutParameter(java.lang.String arg0,
int arg1,
int arg2) |
void |
registerOutParameter(java.lang.String arg0,
int arg1,
java.lang.String arg2) |
void |
setAsciiStream(java.lang.String arg0,
java.io.InputStream arg1,
int arg2) |
void |
setBigDecimal(java.lang.String arg0,
java.math.BigDecimal arg1) |
void |
setBinaryStream(java.lang.String arg0,
java.io.InputStream arg1,
int arg2) |
void |
setBoolean(java.lang.String arg0,
boolean arg1) |
void |
setByte(java.lang.String arg0,
byte arg1) |
void |
setBytes(java.lang.String arg0,
byte[] arg1) |
void |
setCharacterStream(java.lang.String arg0,
java.io.Reader arg1,
int arg2) |
void |
setDate(java.lang.String arg0,
java.sql.Date arg1) |
void |
setDate(java.lang.String arg0,
java.sql.Date arg1,
java.util.Calendar arg2) |
void |
setDouble(java.lang.String arg0,
double arg1) |
void |
setFloat(java.lang.String arg0,
float arg1) |
void |
setInt(java.lang.String arg0,
int arg1) |
void |
setLong(java.lang.String arg0,
long arg1) |
void |
setNull(java.lang.String arg0,
int arg1) |
void |
setNull(java.lang.String arg0,
int arg1,
java.lang.String arg2) |
void |
setObject(java.lang.String arg0,
java.lang.Object arg1) |
void |
setObject(java.lang.String arg0,
java.lang.Object arg1,
int arg2) |
void |
setObject(java.lang.String arg0,
java.lang.Object arg1,
int arg2,
int arg3) |
void |
setShort(java.lang.String arg0,
short arg1) |
void |
setString(java.lang.String arg0,
java.lang.String arg1) |
void |
setTime(java.lang.String arg0,
java.sql.Time arg1) |
void |
setTime(java.lang.String arg0,
java.sql.Time arg1,
java.util.Calendar arg2) |
void |
setTimestamp(java.lang.String arg0,
java.sql.Timestamp arg1) |
void |
setTimestamp(java.lang.String arg0,
java.sql.Timestamp arg1,
java.util.Calendar arg2) |
void |
setURL(java.lang.String arg0,
java.net.URL arg1) |
boolean |
wasNull() |
addBatch, clearParameters, close, countParameters, CRT, execute, execute, execute, executeQuery, getMetaData, getParameterMetaData, getResultSet, main, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, freeId, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setId, setMaxFieldSize, setMaxRows, setQueryTimeout
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getCharacterStream, getCharacterStream, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRowId, setSQLXML
addBatch, clearParameters, executeLargeUpdate, executeQuery, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
public JbaseJDBCCallableStatement(JBaseJDBCSocketConnection connection, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
execute
in class JBaseJDBCPreparedStatement
java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
executeUpdate
in class JBaseJDBCPreparedStatement
java.sql.SQLException
- if a database access error occurs or the SQL statement returns a ResultSet objectpublic void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- - the first parameter is 1, the second is 2, and so onsqlType
- - the JDBC type code defined by java.sql.Types. If the parameter is of
JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts
a scale value should be used.java.sql.SQLException
- - if a database access error occursTypes
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- - the first parameter is 1, the second is 2, and so onsqlType
- - the SQL type code defined by java.sql.Types.scale
- - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.java.sql.SQLException
- - if a database access error occursTypes
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(int arg0) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(int arg0) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(int arg0) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(int i) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(int i) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(int i) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(int i) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(int i) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int arg0, int arg1) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(int arg0) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int arg0) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int arg0) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int arg0) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(int arg0) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int i) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(int arg0, java.util.Map arg1) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(int arg0) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(int arg0) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(int arg0) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(int arg0) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int arg0, java.util.Calendar arg1) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int arg0, int arg1, java.lang.String arg2) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String arg0, int arg1) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String arg0, int arg1, int arg2) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String arg0, int arg1, java.lang.String arg2) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(int arg0) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setURL(java.lang.String arg0, java.net.URL arg1) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String arg0, int arg1) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBoolean(java.lang.String arg0, boolean arg1) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public void setByte(java.lang.String arg0, byte arg1) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
public void setShort(java.lang.String arg0, short arg1) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
public void setInt(java.lang.String arg0, int arg1) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
public void setLong(java.lang.String arg0, long arg1) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
public void setFloat(java.lang.String arg0, float arg1) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDouble(java.lang.String arg0, double arg1) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBigDecimal(java.lang.String arg0, java.math.BigDecimal arg1) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public void setString(java.lang.String arg0, java.lang.String arg1) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBytes(java.lang.String arg0, byte[] arg1) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String arg0, java.sql.Date arg1) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String arg0, java.sql.Time arg1) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String arg0, java.sql.Timestamp arg1) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String arg0, java.io.InputStream arg1, int arg2) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String arg0, java.lang.Object arg1, int arg2, int arg3) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String arg0, java.lang.Object arg1, int arg2) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String arg0, java.lang.Object arg1) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String arg0, java.io.Reader arg1, int arg2) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String arg0, java.sql.Date arg1, java.util.Calendar arg2) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String arg0, java.sql.Time arg1, java.util.Calendar arg2) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String arg0, java.sql.Timestamp arg1, java.util.Calendar arg2) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String arg0, int arg1, java.lang.String arg2) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(java.lang.String arg0) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(java.lang.String arg0) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(java.lang.String arg0) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(java.lang.String arg0) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(java.lang.String arg0) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(java.lang.String arg0) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(java.lang.String arg0) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(java.lang.String arg0) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(java.lang.String arg0) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String arg0) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String arg0) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String arg0) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String arg0) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String arg0) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String arg0, java.util.Map arg1) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String arg0) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String arg0) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String arg0) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(java.lang.String arg0) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String arg0, java.util.Calendar arg1) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(java.lang.String arg0) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException