Javaã?®ãƒ—ãƒã‚°ãƒ©ãƒ ã?§ã?¯ã€?INOUT引数ã?«å¯¾ã?—ã?¦å¼•æ•°ã?®åž‹ã‚’è¦?ç´ ã?¨ã?™ã‚‹é…?列ã?Œå¯¾å¿œã?—ã?¾ã?™ã€‚(メソッドã?¯é…?列を引数ã?¨ã?—ã?¦ã?¨ã‚‰ã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。) ã?“ã?®å¯¾å¿œé–¢ä¿‚ã?¯SQL標準ã?®æŽ¨å¥¨ã?«æ²¿ã?£ã?Ÿã‚‚ã?®ã?§ã?™ã€‚
CallableStatement call = conn.prepareCall(
"{CALL doubleMyInt(?)}");
// 値を代入�る��引数を登録�る事��
// inout引数��良�やり方��。
call.registerOutParameter(1, Types.INTEGER);
call.setInt(1,10);
call.execute();
int retval = call.getInt(1);
public static void doubleMyInt(int[] i) {
i[0] *=2;
/* Derbyã?¯é…?列ã?®æœ€åˆ?ã?®è¦?ç´ ã‚’è¿”ã?—ã?¾ã?™ã€‚*/
}
JDBC�型 | メソッド�引数��列型 | 値�返り値�型 |
---|---|---|
BIGINT | long[] | long |
BINARY | byte[][] | byte[] |
BIT | boolean[] | boolean |
DATE | java.sql.Date[] | java.sql.Date |
DOUBLE | double[] | double |
FLOAT | double[] | double |
INTEGER | int[] | int |
LONGVARBINARY | byte[][] | byte[] |
REAL | float[] | float |
SMALLINT | short[] | short |
TIME | java.sql.Time[] | java.sql.Time |
TIMESTAMP | java.sql.Timestamp[] | java.sql.Timestamp |
VARBINARY | byte[][] | byte[] |
OTHER | yourType[] | yourType |
JAVA_OBJECT (Java2/JDBC 2.0�環境���有効) | yourType[] | yourType |
呼ã?³å‡ºã?—å‰?ã?«å‡ºåŠ›ã?®å¼•数を登録ã?—ã?¦ã??ã? ã?•ã?„。INOUTã?®å¼•æ•°ã?§ã?¯ã€?値を代入ã?™ã‚‹å‰?ã?«å‡ºåŠ›ã?®å¼•数を登録ã?™ã‚‹ã?®ã?Œè‰¯ã?„やり方ã?§ã?™ã€‚