DB アクセス機能使用ガイド 最終更新日：2007/04/06
目次
1. 機能概要......................................................................................................................................................................................................4
2. 設定編 ..........................................................................................................................................................................................................5
2.1. 事前準備 ............................................................................................................................................................................................5
2.2. WACs設定ファイル記述仕様.........................................................................................................................................................5
2.3. 定義ファイル仕様 .............................................................................................................................................................................8
2.3.1. DB接続定義 : dbspec.properties .........................................................................................................................................8
2.3.2. SQL定義 : sql.properties ........................................................................................................................................................8
3. プログラミング編.......................................................................................................................................................................................14
3.1. 目的別API概要 ...............................................................................................................................................................................14
3.1.1. 照会処理.................................................................................................................................................................................14
3.1.2. 更新処理.................................................................................................................................................................................15
3.2. API詳細 ............................................................................................................................................................................................16
3.2.1. パラメーターの設定 ..............................................................................................................................................................16
3.2.2. 動的パラメーター照会機能.................................................................................................................................................21
3.2.3. コネクター・オブジェクトの取得...........................................................................................................................................23
3.2.4. コネクター・オブジェクトの設定の変更..............................................................................................................................23
3.2.5. SQLの発行.............................................................................................................................................................................24
3.2.6. 照会結果の取得 ...................................................................................................................................................................25
3.2.7. 発生する例外.........................................................................................................................................................................29
3.2.8. トランザクションのコミット・ロールバック............................................................................................................................30
3.2.9. コネクターのクローズ............................................................................................................................................................30
3.2.10. その他の機能....................................................................................................................................................................30
4. エラー・メッセージ一覧 ............................................................................................................................................................................34
5. Appendix ....................................................................................................................................................................................................39
5.1. SQL情報ログ出力機能について ................................................................................................................................................39
5.2. SQLインジェクション対策について..............................................................................................................................................39
5.3. 自己初期化機能について ............................................................................................................................................................40
5.4. 機能拡張について..........................................................................................................................................................................43
5.4.1. 機能拡張のルール ...............................................................................................................................................................43
5.4.2. 拡張可能クラス......................................................................................................................................................................44
5.4.3. DefaultDBConnectorの拡張例...........................................................................................................................................44
5.4.4. DefaultDBParamの拡張例..................................................................................................................................................45
5.4.5. DefaultDBResultの拡張例 ..................................................................................................................................................45
5.5. 旧バージョンとの違い....................................................................................................................................................................45
5.5.1. 定義ファイル上の注意点.....................................................................................................................................................45
5.5.2. コーディング上の注意点......................................................................................................................................................46
(c) Copyright IBM Japan, Ltd. 2000, 2007. All rights reserved. Page 3 of 48
评论0