java.sql.CallableStatement
java.sql.CallableStatement是SQL语句接口,主要用于执行存储过程,本节将介绍对此接口的支持情况。
该接口中的方法都不是线程安全的。
返回值类型 |
方法名 |
---|---|
Object |
getObject(int) |
Object |
getObject(String) |
boolean |
getBoolean(String) |
boolean |
getBoolean(int) |
byte |
getByte(String) |
byte |
getByte(int) |
short |
getShort(String) |
short |
getShort(int) |
int |
getInt(String) |
int |
getInt(int) |
long |
getLong(String) |
long |
getLong(int) |
float |
getFloat(int) |
float |
getFloat(String) |
double |
getDouble(int) |
double |
getDouble(String) |
byte[] |
getBytes(int) |
byte[] |
getBytes(String) |
String |
getString(String) |
String |
getString(int) |
Time |
getTime(int) |
Time |
getTime(String) |
Time |
getTime(int, Calendar) |
Time |
getTime(String, Calendar) |
Timestamp |
getTimestamp(String, Calendar) |
Timestamp |
getTimestamp(int) |
Timestamp |
getTimestamp(int, Calendar) |
Timestamp |
getTimestamp(String) |
Date |
getDate(String, Calendar) |
Date |
getDate(String) |
Date |
getDate(int, Calendar) |
Date |
getDate(int) |
BigDecimal |
getBigDecimal(String) |
BigDecimal |
getBigDecimal(int) |
Blob |
getBlob(int) |
Blob |
getBlob(String) |
Reader |
getCharacterStream(String) |
Reader |
getCharacterStream(int) |
Clob |
getClob(String) |
Clob |
getClob(int) |
boolean |
wasNull() |
void |
registerOutParameter(int, int) |
void |
setTimestamp(int, Timestamp, Calendar) |
void |
setTimestamp(int, Timestamp) |
boolean |
execute() |
void |
setBoolean(int, boolean) |
void |
setByte(int, byte) |
void |
setDouble(int, double) |
void |
setFloat(int, float) |
void |
setInt(int, int) |
void |
setLong(int, long) |
void |
setShort(int, short) |
void |
setTime(int, Time, Calendar) |
void |
setTime(int, Time) |
void |
addBatch() |
void |
clearParameters() |
ResultSet |
executeQuery() |
int |
executeUpdate() |
ResultSetMetaData |
getMetaData() |
void |
setBigDecimal(int, BigDecimal) |
void |
setBinaryStream(int, InputStream) |
void |
setBinaryStream(int, InputStream, int) |
void |
setBinaryStream(int, InputStream, long) |
void |
setBlob(int, InputStream) |
void |
setBlob(int, InputStream, long) |
void |
setBlob(int, Blob) |
void |
setBytes(int, byte[]) |
void |
setCharacterStream(int, Reader, long) |
void |
setCharacterStream(int, Reader, int) |
void |
setCharacterStream(int, Reader) |
void |
setClob(int, Reader) |
void |
setClob(int, Reader, long) |
void |
setClob(int, Clob) |
void |
setDate(int, Date) |
void |
setDate(int, Date, Calendar) |
void |
setNull(int, int) |
void |
setObject(int, Object) |
void |
setObject(int, Object, int) |
void |
setObject(int, Object, int, int) |
void |
setString(int, String) |
boolean |
execute(String, int) |
boolean |
execute(String) |
boolean |
isClosed() |
Connection |
getConnection() |
ResultSet |
executeQuery(String) |
int |
executeUpdate(String, int) |
int |
executeUpdate(String) |
void |
cancel() |
void |
clearBatch() |
void |
clearWarnings() |
int[] |
executeBatch() |
int |
getFetchSize() |
ResultSet |
getGeneratedKeys() |
int |
getMaxRows() |
boolean |
getMoreResults(int) |
boolean |
getMoreResults() |
int |
getQueryTimeout() |
ResultSet |
getResultSet() |
int |
getUpdateCount() |
SQLWarning |
getWarnings() |
void |
setFetchSize(int) |
void |
setMaxRows(int) |
void |
setQueryTimeout(int) |
int |
getFetchDirection() |
int |
getResultSetConcurrency() |
int |
getResultSetHoldability() |
int |
getResultSetType() |
void |
setFetchDirection(int) |