メインページ | パッケージ | クラス階層 | 構成 | ファイル一覧 | 構成メンバ | 関連ページ | 検索 

クラス org.objectweb.cjdbc.driver.CallableStatement

org.objectweb.cjdbc.driver.CallableStatementに対する継承グラフ

Inheritance graph
[凡例]
org.objectweb.cjdbc.driver.CallableStatementのコラボレーション図

Collaboration graph
[凡例]
すべてのメンバ一覧

説明

This class is used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. The only syntax accepted by this implementation is as follows:

  {call <procedure-name>[<arg1>,<arg2>, ...]}

The other standard form

  {?= call <procedure-name>[<arg1>,<arg2>, ...]}

is *NOT* supported.

Parameters are referred to sequentially, by number, with the first parameter being 1. IN parameter values are set using the set methods inherited from PreparedStatement.

OUT parameters are *NOT* supported.

A CallableStatement can return one DriverResultSet object or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from Statement.

参照:
Connection.prepareCall

DriverResultSet

作者:
Emmanuel Cecchet
バージョン:
1.0

CallableStatement.java の 79 行で定義されています。

Public メソッド

 CallableStatement (Connection connection, String sql) throws SQLException
void registerOutParameter (int parameterIndex, int sqlType) throws SQLException
void registerOutParameter (int parameterIndex, int sqlType, int scale) throws SQLException
boolean wasNull () throws SQLException
String getString (int parameterIndex) throws SQLException
boolean getBoolean (int parameterIndex) throws SQLException
byte getByte (int parameterIndex) throws SQLException
short getShort (int parameterIndex) throws SQLException
int getInt (int parameterIndex) throws SQLException
long getLong (int parameterIndex) throws SQLException
float getFloat (int parameterIndex) throws SQLException
double getDouble (int parameterIndex) throws SQLException
BigDecimal getBigDecimal (int parameterIndex, int scale) throws SQLException
byte[] getBytes (int parameterIndex) throws SQLException
Date getDate (int parameterIndex) throws SQLException
Time getTime (int parameterIndex) throws SQLException
Timestamp getTimestamp (int parameterIndex) throws SQLException
Object getObject (int parameterIndex) throws SQLException
BigDecimal getBigDecimal (int parameterIndex) throws SQLException
Object getObject (int i, Map map) throws SQLException
Ref getRef (int i) throws SQLException
Blob getBlob (int i) throws SQLException
Clob getClob (int i) throws SQLException
Array getArray (int i) throws SQLException
Date getDate (int parameterIndex, Calendar cal) throws SQLException
Time getTime (int parameterIndex, Calendar cal) throws SQLException
Timestamp getTimestamp (int parameterIndex, Calendar cal) throws SQLException
void registerOutParameter (int paramIndex, int sqlType, String typeName) throws SQLException
void registerOutParameter (String parameterName, int sqlType) throws SQLException
void registerOutParameter (String parameterName, int sqlType, int scale) throws SQLException
void registerOutParameter (String parameterName, int sqlType, String typeName) throws SQLException
URL getURL (int parameterIndex) throws SQLException
void setURL (String parameterName, URL val) throws SQLException
void setNull (String parameterName, int sqlType) throws SQLException
void setBoolean (String parameterName, boolean x) throws SQLException
void setByte (String parameterName, byte x) throws SQLException
void setShort (String parameterName, short x) throws SQLException
void setInt (String parameterName, int x) throws SQLException
void setLong (String parameterName, long x) throws SQLException
void setFloat (String parameterName, float x) throws SQLException
void setDouble (String parameterName, double x) throws SQLException
void setBigDecimal (String parameterName, BigDecimal x) throws SQLException
void setString (String parameterName, String x) throws SQLException
void setBytes (String parameterName, byte[] x) throws SQLException
void setDate (String parameterName, Date x) throws SQLException
void setTime (String parameterName, Time x) throws SQLException
void setTimestamp (String parameterName, Timestamp x) throws SQLException
void setAsciiStream (String parameterName, InputStream x, int length) throws SQLException
void setBinaryStream (String parameterName, InputStream x, int length) throws SQLException
void setObject (String parameterName, Object x, int targetSqlType, int scale) throws SQLException
void setObject (String parameterName, Object x, int targetSqlType) throws SQLException
void setObject (String parameterName, Object x) throws SQLException
void setCharacterStream (String parameterName, Reader reader, int length) throws SQLException
void setDate (String parameterName, Date x, Calendar cal) throws SQLException
void setTime (String parameterName, Time x, Calendar cal) throws SQLException
void setTimestamp (String parameterName, Timestamp x, Calendar cal) throws SQLException
void setNull (String parameterName, int sqlType, String typeName) throws SQLException
String getString (String parameterName) throws SQLException
boolean getBoolean (String parameterName) throws SQLException
byte getByte (String parameterName) throws SQLException
short getShort (String parameterName) throws SQLException
int getInt (String parameterName) throws SQLException
long getLong (String parameterName) throws SQLException
float getFloat (String parameterName) throws SQLException
double getDouble (String parameterName) throws SQLException
byte[] getBytes (String parameterName) throws SQLException
Date getDate (String parameterName) throws SQLException
Time getTime (String parameterName) throws SQLException
Timestamp getTimestamp (String parameterName) throws SQLException
Object getObject (String parameterName) throws SQLException
BigDecimal getBigDecimal (String parameterName) throws SQLException
Object getObject (String parameterName, Map map) throws SQLException
Ref getRef (String parameterName) throws SQLException
Blob getBlob (String parameterName) throws SQLException
Clob getClob (String parameterName) throws SQLException
Array getArray (String parameterName) throws SQLException
Date getDate (String parameterName, Calendar cal) throws SQLException
Time getTime (String parameterName, Calendar cal) throws SQLException
Timestamp getTimestamp (String parameterName, Calendar cal) throws SQLException
URL getURL (String parameterName) throws SQLException

コンストラクタとデストラクタ

org.objectweb.cjdbc.driver.CallableStatement.CallableStatement (  Connection  connection,
String  sql
)  throws SQLException
 

CallableStatements syntax is {call procedure_name[(?, ?, ...)]}. Note that {? = call ...} is not supported by this implementation.

引数:
connection the instanatiating connection
sql the SQL statement with ? for IN markers
例外:
SQLException if something bad occurs
CallableStatement.java の 91 行で定義されています。
00093   {
00094     super(connection, sql);
00095     if (!this.sql.toLowerCase().startsWith("{call "))
00096       throw new SQLException("Syntax error: callable statements expected syntax is {call procedure_name[(?, ?, ...)]}");
00097   }

メソッド

Array org.objectweb.cjdbc.driver.CallableStatement.getArray (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC ARRAY parameter as an Arrayobject in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value as an Array object in Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1590 行で定義されています。
01591   {
01592     throw new NotImplementedException("getArray");
01593   }

Array org.objectweb.cjdbc.driver.CallableStatement.getArray (  int  i  )  throws SQLException
 

Retrieves the value of the designated JDBC ARRAY parameter as an Arrayobject in the Java programming language.

引数:
i the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value as an Array object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.2
CallableStatement.java の 502 行で定義されています。
00503   {
00504     throw new NotImplementedException("getArray");
00505   }

BigDecimal org.objectweb.cjdbc.driver.CallableStatement.getBigDecimal (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

引数:
parameterName the name of the parameter
戻り値:
the parameter value in full precision. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setBigDecimal
から:
1.4
CallableStatement.java の 1504 行で定義されています。
01505   {
01506     throw new NotImplementedException("getBigDecimal");
01507   }

BigDecimal org.objectweb.cjdbc.driver.CallableStatement.getBigDecimal (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value in full precision. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setBigDecimal
から:
1.2
CallableStatement.java の 416 行で定義されています。
00417   {
00418     throw new NotImplementedException("");
00419   }

BigDecimal org.objectweb.cjdbc.driver.CallableStatement.getBigDecimal (  int  parameterIndex,
int  scale
)  throws SQLException
 

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
scale the number of digits to the right of the decimal point
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
非推奨:
use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
参照:
setBigDecimal
CallableStatement.java の 310 行で定義されています。
00312   {
00313     throw new NotImplementedException("getBigDecimal");
00314   }

Blob org.objectweb.cjdbc.driver.CallableStatement.getBlob (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC BLOB parameter as a Blobobject in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1558 行で定義されています。
01559   {
01560     throw new NotImplementedException("getBlob");
01561   }

Blob org.objectweb.cjdbc.driver.CallableStatement.getBlob (  int  i  )  throws SQLException
 

Retrieves the value of the designated JDBC BLOB parameter as a Blobobject in the Java programming language.

引数:
i the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.2
CallableStatement.java の 470 行で定義されています。
00471   {
00472     throw new NotImplementedException("getBlob");
00473   }

boolean org.objectweb.cjdbc.driver.CallableStatement.getBoolean (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is false.
例外:
SQLException if a database access error occurs
参照:
setBoolean
から:
1.4
CallableStatement.java の 1304 行で定義されています。
01305   {
01306     throw new NotImplementedException("getBoolean");
01307   }

boolean org.objectweb.cjdbc.driver.CallableStatement.getBoolean (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is false.
例外:
SQLException if a database access error occurs
参照:
setBoolean
CallableStatement.java の 202 行で定義されています。
00203   {
00204     throw new NotImplementedException("getBoolean");
00205   }

byte org.objectweb.cjdbc.driver.CallableStatement.getByte (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setByte
から:
1.4
CallableStatement.java の 1320 行で定義されています。
01321   {
01322     throw new NotImplementedException("getByte");
01323   }

byte org.objectweb.cjdbc.driver.CallableStatement.getByte (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setByte
CallableStatement.java の 217 行で定義されています。
00218   {
00219     throw new NotImplementedException("getByte");
00220   }

byte [] org.objectweb.cjdbc.driver.CallableStatement.getBytes (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setBytes
から:
1.4
CallableStatement.java の 1417 行で定義されています。
01418   {
01419     throw new NotImplementedException("getBytes");
01420   }

byte [] org.objectweb.cjdbc.driver.CallableStatement.getBytes (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setBytes
CallableStatement.java の 327 行で定義されています。
00328   {
00329     throw new NotImplementedException("getBytes");
00330   }

Clob org.objectweb.cjdbc.driver.CallableStatement.getClob (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1574 行で定義されています。
01575   {
01576     throw new NotImplementedException("getClob");
01577   }

Clob org.objectweb.cjdbc.driver.CallableStatement.getClob (  int  i  )  throws SQLException
 

Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language.

引数:
i the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.2
CallableStatement.java の 486 行で定義されています。
00487   {
00488     throw new NotImplementedException("getClob");
00489   }

Date org.objectweb.cjdbc.driver.CallableStatement.getDate (  String  parameterName,
Calendar  cal
)  throws SQLException
 

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. With 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.

引数:
parameterName the name of the parameter
cal the Calendar object the driver will use to construct the date
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setDate
から:
1.4
CallableStatement.java の 1611 行で定義されています。
01612   {
01613     throw new NotImplementedException("getDate");
01614   }

Date org.objectweb.cjdbc.driver.CallableStatement.getDate (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setDate
から:
1.4
CallableStatement.java の 1433 行で定義されています。
01434   {
01435     throw new NotImplementedException("getDate");
01436   }

Date org.objectweb.cjdbc.driver.CallableStatement.getDate (  int  parameterIndex,
Calendar  cal
)  throws SQLException
 

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. With 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.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
cal the Calendar object the driver will use to construct the date
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setDate
から:
1.2
CallableStatement.java の 524 行で定義されています。
00525   {
00526     throw new NotImplementedException("getDate");
00527   }

Date org.objectweb.cjdbc.driver.CallableStatement.getDate (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setDate
CallableStatement.java の 342 行で定義されています。
00343   {
00344     throw new NotImplementedException("getDate");
00345   }

double org.objectweb.cjdbc.driver.CallableStatement.getDouble (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setDouble
から:
1.4
CallableStatement.java の 1400 行で定義されています。
01401   {
01402     throw new NotImplementedException("getDouble");
01403   }

double org.objectweb.cjdbc.driver.CallableStatement.getDouble (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setDouble
CallableStatement.java の 292 行で定義されています。
00293   {
00294     throw new NotImplementedException("getDouble");
00295   }

float org.objectweb.cjdbc.driver.CallableStatement.getFloat (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setFloat
から:
1.4
CallableStatement.java の 1384 行で定義されています。
01385   {
01386     throw new NotImplementedException("getFloat");
01387   }

float org.objectweb.cjdbc.driver.CallableStatement.getFloat (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setFloat
CallableStatement.java の 277 行で定義されています。
00278   {
00279     throw new NotImplementedException("getFloat");
00280   }

int org.objectweb.cjdbc.driver.CallableStatement.getInt (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setInt
から:
1.4
CallableStatement.java の 1352 行で定義されています。
01353   {
01354     throw new NotImplementedException("getInt");
01355   }

int org.objectweb.cjdbc.driver.CallableStatement.getInt (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setInt
CallableStatement.java の 247 行で定義されています。
00248   {
00249     throw new NotImplementedException("getInt");
00250   }

long org.objectweb.cjdbc.driver.CallableStatement.getLong (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setLong
から:
1.4
CallableStatement.java の 1368 行で定義されています。
01369   {
01370     throw new NotImplementedException("getLong");
01371   }

long org.objectweb.cjdbc.driver.CallableStatement.getLong (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setLong
CallableStatement.java の 262 行で定義されています。
00263   {
00264     throw new NotImplementedException("getLong");
00265   }

Object org.objectweb.cjdbc.driver.CallableStatement.getObject (  String  parameterName,
Map  map
)  throws SQLException
 

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.

引数:
parameterName the name of the parameter
map the mapping from SQL type names to Java classes
戻り値:
a java.lang.Object holding the OUT parameter value
例外:
SQLException if a database access error occurs
参照:
setObject
から:
1.4
CallableStatement.java の 1526 行で定義されています。
01527   {
01528     throw new NotImplementedException("getObject");
01529   }

Object org.objectweb.cjdbc.driver.CallableStatement.getObject (  String  parameterName  )  throws SQLException
 

Retrieves the value of a parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null.

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.

引数:
parameterName the name of the parameter
戻り値:
A java.lang.Object holding the OUT parameter value.
例外:
SQLException if a database access error occurs
参照:
java.sql.Types

setObject

から:
1.4
CallableStatement.java の 1487 行で定義されています。
01488   {
01489     throw new NotImplementedException("getObject");
01490   }

Object org.objectweb.cjdbc.driver.CallableStatement.getObject (  int  i,
Map  map
)  throws SQLException
 

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.

引数:
i the first parameter is 1, the second is 2, and so on
map the mapping from SQL type names to Java classes
戻り値:
a java.lang.Object holding the OUT parameter value
例外:
SQLException if a database access error occurs
参照:
setObject
から:
1.2
CallableStatement.java の 438 行で定義されています。
00439   {
00440     throw new NotImplementedException("getObject");
00441   }

Object org.objectweb.cjdbc.driver.CallableStatement.getObject (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null.

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.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
A java.lang.Object holding the OUT parameter value
例外:
SQLException if a database access error occurs
参照:
java.sql.Types

setObject

CallableStatement.java の 397 行で定義されています。
00398   {
00399     throw new NotImplementedException("getObject");
00400   }

Ref org.objectweb.cjdbc.driver.CallableStatement.getRef (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value as a Ref object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1542 行で定義されています。
01543   {
01544     throw new NotImplementedException("getRef");
01545   }

Ref org.objectweb.cjdbc.driver.CallableStatement.getRef (  int  i  )  throws SQLException
 

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

引数:
i the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value as a Ref object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs
から:
1.2
CallableStatement.java の 454 行で定義されています。
00455   {
00456     throw new NotImplementedException("getRef");
00457   }

short org.objectweb.cjdbc.driver.CallableStatement.getShort (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setShort
から:
1.4
CallableStatement.java の 1336 行で定義されています。
01337   {
01338     throw new NotImplementedException("getShort");
01339   }

short org.objectweb.cjdbc.driver.CallableStatement.getShort (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is 0.
例外:
SQLException if a database access error occurs
参照:
setShort
CallableStatement.java の 232 行で定義されています。
00233   {
00234     throw new NotImplementedException("getShort");
00235   }

String org.objectweb.cjdbc.driver.CallableStatement.getString (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC CHAR,VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setString
から:
1.4
CallableStatement.java の 1288 行で定義されています。
01289   {
01290     throw new NotImplementedException("getString");
01291   }

String org.objectweb.cjdbc.driver.CallableStatement.getString (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC CHAR,VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setString
CallableStatement.java の 187 行で定義されています。
00188   {
00189     throw new NotImplementedException("getString");
00190   }

Time org.objectweb.cjdbc.driver.CallableStatement.getTime (  String  parameterName,
Calendar  cal
)  throws SQLException
 

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. With 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.

引数:
parameterName the name of the parameter
cal the Calendar object the driver will use to construct the time
戻り値:
the parameter value; if the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTime
から:
1.4
CallableStatement.java の 1632 行で定義されています。
01633   {
01634     throw new NotImplementedException("getTime");
01635   }

Time org.objectweb.cjdbc.driver.CallableStatement.getTime (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTime
から:
1.4
CallableStatement.java の 1449 行で定義されています。
01450   {
01451     throw new NotImplementedException("getTime");
01452   }

Time org.objectweb.cjdbc.driver.CallableStatement.getTime (  int  parameterIndex,
Calendar  cal
)  throws SQLException
 

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. With 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.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
cal the Calendar object the driver will use to construct the time
戻り値:
the parameter value; if the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTime
から:
1.2
CallableStatement.java の 546 行で定義されています。
00547   {
00548     throw new NotImplementedException("getTime");
00549   }

Time org.objectweb.cjdbc.driver.CallableStatement.getTime (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTime
CallableStatement.java の 357 行で定義されています。
00358   {
00359     throw new NotImplementedException("getTime");
00360   }

Timestamp org.objectweb.cjdbc.driver.CallableStatement.getTimestamp (  String  parameterName,
Calendar  cal
)  throws SQLException
 

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. With 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.

引数:
parameterName the name of the parameter
cal the Calendar object the driver will use to construct the timestamp
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTimestamp
から:
1.4
CallableStatement.java の 1654 行で定義されています。
01656   {
01657     throw new NotImplementedException("getTimestamp");
01658   }

Timestamp org.objectweb.cjdbc.driver.CallableStatement.getTimestamp (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

引数:
parameterName the name of the parameter
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTimestamp
から:
1.4
CallableStatement.java の 1465 行で定義されています。
01466   {
01467     throw new NotImplementedException("getTimestamp");
01468   }

Timestamp org.objectweb.cjdbc.driver.CallableStatement.getTimestamp (  int  parameterIndex,
Calendar  cal
)  throws SQLException
 

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. With 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.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
cal the Calendar object the driver will use to construct the timestamp
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTimestamp
から:
1.2
CallableStatement.java の 569 行で定義されています。
00571   {
00572     throw new NotImplementedException("getTimestamp");
00573   }

Timestamp org.objectweb.cjdbc.driver.CallableStatement.getTimestamp (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
戻り値:
the parameter value. If the value is SQL NULL, the result is null.
例外:
SQLException if a database access error occurs
参照:
setTimestamp
CallableStatement.java の 372 行で定義されています。
00373   {
00374     throw new NotImplementedException("getTimestamp");
00375   }

URL org.objectweb.cjdbc.driver.CallableStatement.getURL (  String  parameterName  )  throws SQLException
 

Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.

引数:
parameterName the name of the parameter
戻り値:
the parameter value as a java.net.URL object in the Java programming language. If the value was SQL NULL, the value null is returned.
例外:
SQLException if a database access error occurs, or if there is a problem with the URL
参照:
setURL
から:
1.4
CallableStatement.java の 1673 行で定義されています。
01674   {
01675     throw new NotImplementedException("getURL");
01676   }

URL org.objectweb.cjdbc.driver.CallableStatement.getURL (  int  parameterIndex  )  throws SQLException
 

Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.

引数:
parameterIndex the first parameter is 1, the second is 2,...
戻り値:
a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
例外:
SQLException if a database access error occurs, or if the URL being returned is not a valid URL on the Java platform
参照:
setURL
から:
1.4
CallableStatement.java の 738 行で定義されています。
00739   {
00740     throw new NotImplementedException("getURL");
00741   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  String  parameterName,
int  sqlType,
String  typeName
)  throws SQLException
 

Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.

Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters.

Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.

Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.

引数:
parameterName the name of the parameter
sqlType a value from java.sql.Types
typeName the fully-qualified name of an SQL structured type
例外:
SQLException if a database access error occurs
参照:
java.sql.Types
から:
1.4
CallableStatement.java の 717 行で定義されています。
00722   {
00723     throw new NotImplementedException("registerOutParameter");
00724   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  String  parameterName,
int  sqlType,
int  scale
)  throws SQLException
 

Registers the parameter named parameterName to be of JDBC type sqlType. This method must be called before a stored procedure is executed.

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.

引数:
parameterName the name of the parameter
sqlType 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.
例外:
SQLException if a database access error occurs
から:
1.4
参照:
java.sql.Types
CallableStatement.java の 675 行で定義されています。
00680   {
00681     throw new NotImplementedException("registerOutParameter");
00682   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  String  parameterName,
int  sqlType
)  throws SQLException
 

Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject retrieves the value.

引数:
parameterName the name of the parameter
sqlType 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.
例外:
SQLException if a database access error occurs
から:
1.4
参照:
java.sql.Types
CallableStatement.java の 647 行で定義されています。
00649   {
00650     throw new NotImplementedException("registerOutParameter");
00651   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  int  paramIndex,
int  sqlType,
String  typeName
)  throws SQLException
 

Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-defined or REF output parameter. Examples of user-defined types include: STRUCT,DISTINCT,JAVA_OBJECT, and named array types.

Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-defined parameter, the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-defined and REF parameters.

Although it is intended for user-defined and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the typeName parameter is ignored.

Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.

引数:
paramIndex the first parameter is 1, the second is 2,...
sqlType a value from java.sql.Types
typeName the fully-qualified name of an SQL structured type
例外:
SQLException if a database access error occurs
参照:
java.sql.Types
から:
1.2
CallableStatement.java の 611 行で定義されています。
00616   {
00617     throw new NotImplementedException("registerOutParameter");
00618   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  int  parameterIndex,
int  sqlType,
int  scale
)  throws SQLException
 

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType. This method must be called before a stored procedure is executed.

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
sqlType 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.
例外:
SQLException if a database access error occurs
参照:
java.sql.Types
CallableStatement.java の 150 行で定義されています。
00152   {
00153     throw new NotImplementedException("registerOutParameter(int parameterIndex, int sqlType, int scale)");
00154   }

void org.objectweb.cjdbc.driver.CallableStatement.registerOutParameter (  int  parameterIndex,
int  sqlType
)  throws SQLException
 

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject retrieves the value.

引数:
parameterIndex the first parameter is 1, the second is 2, and so on
sqlType 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.
例外:
SQLException if a database access error occurs
参照:
java.sql.Types
CallableStatement.java の 123 行で定義されています。
00125   {
00126     throw new NotImplementedException("registerOutParameter(int parameterIndex, int sqlType)");
00127   }

void org.objectweb.cjdbc.driver.CallableStatement.setAsciiStream (  String  parameterName,
InputStream  x,
int  length
)  throws SQLException
 

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII 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.

引数:
parameterName the name of the parameter
x the Java input stream that contains the ASCII parameter value
length the number of bytes in the stream
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1006 行で定義されています。
01008   {
01009     throw new NotImplementedException("setAsciiStream");
01010   }

void org.objectweb.cjdbc.driver.CallableStatement.setBigDecimal (  String  parameterName,
BigDecimal  x
)  throws SQLException
 

Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getBigDecimal
から:
1.4
CallableStatement.java の 899 行で定義されています。
00901   {
00902     throw new NotImplementedException("setBigDecimal");
00903   }

void org.objectweb.cjdbc.driver.CallableStatement.setBinaryStream (  String  parameterName,
InputStream  x,
int  length
)  throws SQLException
 

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

引数:
parameterName the name of the parameter
x the java input stream which contains the binary parameter value
length the number of bytes in the stream
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1029 行で定義されています。
01031   {
01032     throw new NotImplementedException("setBinaryStream");
01033   }

void org.objectweb.cjdbc.driver.CallableStatement.setBoolean (  String  parameterName,
boolean  x
)  throws SQLException
 

Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getBoolean
から:
1.4
CallableStatement.java の 787 行で定義されています。
00788   {
00789     throw new NotImplementedException("setBoolean");
00790   }

void org.objectweb.cjdbc.driver.CallableStatement.setByte (  String  parameterName,
byte  x
)  throws SQLException
 

Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getByte
から:
1.4
CallableStatement.java の 803 行で定義されています。
00804   {
00805     throw new NotImplementedException("setByte");
00806   }

void org.objectweb.cjdbc.driver.CallableStatement.setBytes (  String  parameterName,
byte[]  x
)  throws SQLException
 

Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY or LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values) when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getBytes
から:
1.4
CallableStatement.java の 934 行で定義されています。
00935   {
00936     throw new NotImplementedException("setBytes");
00937   }

void org.objectweb.cjdbc.driver.CallableStatement.setCharacterStream (  String  parameterName,
Reader  reader,
int  length
)  throws SQLException
 

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 object. The data will be read from the stream as needed until end-of-file is reached. 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.

引数:
parameterName the name of the parameter
reader the java.io.Reader object that contains the UNICODE data used as the designated parameter
length the number of characters in the stream
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1159 行で定義されています。
01164   {
01165     throw new NotImplementedException("");
01166   }

void org.objectweb.cjdbc.driver.CallableStatement.setDate (  String  parameterName,
Date  x,
Calendar  cal
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, 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. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

引数:
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the date
例外:
SQLException if a database access error occurs
参照:
getDate
から:
1.4
CallableStatement.java の 1186 行で定義されています。
01188   {
01189     throw new NotImplementedException("setDate");
01190   }

void org.objectweb.cjdbc.driver.CallableStatement.setDate (  String  parameterName,
Date  x
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Date value. The driver converts this to an SQL DATE value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getDate
から:
1.4
CallableStatement.java の 950 行で定義されています。
00951   {
00952     throw new NotImplementedException("setDate");
00953   }

void org.objectweb.cjdbc.driver.CallableStatement.setDouble (  String  parameterName,
double  x
)  throws SQLException
 

Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getDouble
から:
1.4
CallableStatement.java の 883 行で定義されています。
00884   {
00885     throw new NotImplementedException("setDouble");
00886   }

void org.objectweb.cjdbc.driver.CallableStatement.setFloat (  String  parameterName,
float  x
)  throws SQLException
 

Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getFloat
から:
1.4
CallableStatement.java の 867 行で定義されています。
00868   {
00869     throw new NotImplementedException("setFloat");
00870   }

void org.objectweb.cjdbc.driver.CallableStatement.setInt (  String  parameterName,
int  x
)  throws SQLException
 

Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getInt
から:
1.4
CallableStatement.java の 835 行で定義されています。
00836   {
00837     throw new NotImplementedException("setInt");
00838   }

void org.objectweb.cjdbc.driver.CallableStatement.setLong (  String  parameterName,
long  x
)  throws SQLException
 

Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getLong
から:
1.4
CallableStatement.java の 851 行で定義されています。
00852   {
00853     throw new NotImplementedException("setLong");
00854   }

void org.objectweb.cjdbc.driver.CallableStatement.setNull (  String  parameterName,
int  sqlType,
String  typeName
)  throws SQLException
 

Sets the designated parameter to SQL NULL. This version of the method setNull should be used for user-defined types and REF type parameters. Examples of user-defined 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-defined 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-defined 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-defined or REF type, the given typeName is ignored.

引数:
parameterName the name of the parameter
sqlType a value from java.sql.Types
typeName the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 1265 行で定義されています。
01267   {
01268     throw new NotImplementedException("setNull");
01269   }

void org.objectweb.cjdbc.driver.CallableStatement.setNull (  String  parameterName,
int  sqlType
)  throws SQLException
 

Sets the designated parameter to SQL NULL.

Note: you must specify the parameter's SQL type.

引数:
parameterName the name of the parameter
sqlType the SQL type code defined in java.sql.Types
例外:
SQLException if a database access error occurs
から:
1.4
CallableStatement.java の 771 行で定義されています。
00772   {
00773     throw new NotImplementedException("setNull");
00774   }

void org.objectweb.cjdbc.driver.CallableStatement.setObject (  String  parameterName,
Object  x
)  throws SQLException
 

Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types.

The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.

Note that this method may be used to pass datatabase-specific abstract data types, by using a driver-specific Java type.

If the object is of a class implementing the interface SQLData, the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref,Blob,Clob, Struct, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.

引数:
parameterName the name of the parameter
x the object containing the input parameter value
例外:
SQLException if a database access error occurs or if the given Object parameter is ambiguous
参照:
getObject
から:
1.4
CallableStatement.java の 1134 行で定義されています。
01135   {
01136     throw new NotImplementedException("setObject");
01137   }

void org.objectweb.cjdbc.driver.CallableStatement.setObject (  String  parameterName,
Object  x,
int  targetSqlType
)  throws SQLException
 

Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.

引数:
parameterName the name of the parameter
x the object containing the input parameter value
targetSqlType the SQL type (as defined in java.sql.Types) to be sent to the database
例外:
SQLException if a database access error occurs
参照:
getObject
から:
1.4
CallableStatement.java の 1093 行で定義されています。
01095   {
01096     throw new NotImplementedException("setObject");
01097   }

void org.objectweb.cjdbc.driver.CallableStatement.setObject (  String  parameterName,
Object  x,
int  targetSqlType,
int  scale
)  throws SQLException
 

Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used.

The given Java object will be converted to the given targetSqlType before being sent to the database.

If the object has a custom mapping (is of a class implementing the interface SQLData), the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob,Clob,Struct, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

Note that this method may be used to pass datatabase-specific abstract data types.

引数:
parameterName the name of the parameter
x the object containing the input parameter value
targetSqlType the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
scale for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored.
例外:
SQLException if a database access error occurs
参照:
java.sql.Types

getObject

から:
1.4
CallableStatement.java の 1070 行で定義されています。
01076   {
01077     throw new NotImplementedException("setObject");
01078   }

void org.objectweb.cjdbc.driver.CallableStatement.setShort (  String  parameterName,
short  x
)  throws SQLException
 

Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getShort
から:
1.4
CallableStatement.java の 819 行で定義されています。
00820   {
00821     throw new NotImplementedException("setShort");
00822   }

void org.objectweb.cjdbc.driver.CallableStatement.setString (  String  parameterName,
String  x
)  throws SQLException
 

Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getString
から:
1.4
CallableStatement.java の 917 行で定義されています。
00918   {
00919     throw new NotImplementedException("setString");
00920   }

void org.objectweb.cjdbc.driver.CallableStatement.setTime (  String  parameterName,
Time  x,
Calendar  cal
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIME value, 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. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

引数:
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the time
例外:
SQLException if a database access error occurs
参照:
getTime
から:
1.4
CallableStatement.java の 1210 行で定義されています。
01212   {
01213     throw new NotImplementedException("setTime");
01214   }

void org.objectweb.cjdbc.driver.CallableStatement.setTime (  String  parameterName,
Time  x
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getTime
から:
1.4
CallableStatement.java の 966 行で定義されています。
00967   {
00968     throw new NotImplementedException("setTime");
00969   }

void org.objectweb.cjdbc.driver.CallableStatement.setTimestamp (  String  parameterName,
Timestamp  x,
Calendar  cal
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIMESTAMP value, 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. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

引数:
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the timestamp
例外:
SQLException if a database access error occurs
参照:
getTimestamp
から:
1.4
CallableStatement.java の 1234 行で定義されています。
01236   {
01237     throw new NotImplementedException("setTimestamp");
01238   }

void org.objectweb.cjdbc.driver.CallableStatement.setTimestamp (  String  parameterName,
Timestamp  x
)  throws SQLException
 

Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.

引数:
parameterName the name of the parameter
x the parameter value
例外:
SQLException if a database access error occurs
参照:
getTimestamp
から:
1.4
CallableStatement.java の 982 行で定義されています。
00984   {
00985     throw new NotImplementedException("setTimestamp");
00986   }

void org.objectweb.cjdbc.driver.CallableStatement.setURL (  String  parameterName,
URL  val
)  throws SQLException
 

Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database.

引数:
parameterName the name of the parameter
val the parameter value
例外:
SQLException if a database access error occurs, or if a URL is malformed
参照:
getURL
から:
1.4
CallableStatement.java の 755 行で定義されています。
00756   {
00757     throw new NotImplementedException("setURL");
00758   }

boolean org.objectweb.cjdbc.driver.CallableStatement.wasNull (   )  throws SQLException
 

Retrieves whether the last OUT parameter read had the value of SQL NULL. Note that this method should be called only after calling a getter method; otherwise, there is no value to use in determining whether it is null or not.

戻り値:
true if the last parameter read was SQL NULL; false otherwise
例外:
SQLException if a database access error occurs
CallableStatement.java の 166 行で定義されています。
00167   {
00168     throw new NotImplementedException("wasNull");
00169   }

このクラスの説明は次のファイルから生成されました:
CJDBCversion1.0.1に対してWed Aug 18 09:20:31 2004に生成されました。 doxygen 1.3.8