先立ã?£ã?¦SELECTæ–‡ã?Œå®Ÿè¡Œã?•れã?Ÿæ™‚ã?«ä¾‹å¤–ã?Œç™ºç”Ÿã?™ã‚‹ã?¨ã€?ResultSetã‚’é–‹ã??ã?“ã?¨ã?Œã?§ã??ã?¾ã?›ã‚“。ResultSetã?Œé–‹ã?„ã?Ÿå¾Œã?§ã?‚れã?°ã€?å?Œæ§˜ã?®ã‚¨ãƒ©ãƒ¼ã?Œç™ºç”Ÿã?—ã?¦ã‚‚ã€?ResultSetã?Œé–‰ã?˜ã‚‰ã‚Œã‚‹ã?“ã?¨ã?¯ã?‚りã?¾ã?›ã‚“。
例ã?ˆã?°ã€?java.sql.Statementã‚„java.sql.PreparedStatementã?®executeQueryメソッドã?«ã?¦ã€?零除算エラーã?Œç™ºç”Ÿã?—ã?Ÿå ´å?ˆã€?例外ã?ŒæŒ™ã?Œã?£ã?¦çµ?果セットã?¯è¿”りã?¾ã?›ã‚“。一方ã?§å?Œæ§˜ã?®ã‚¨ãƒ©ãƒ¼ã?ŒResultSetオブジェクトã?®nextメソッドã?§ç™ºç”Ÿã?—ã?¦ã‚‚çµ?果セットã?Œé–‰ã?˜ã?¦ã?—ã?¾ã?†ã?“ã?¨ã?¯ã?‚りã?¾ã?›ã‚“。
最åˆ?ã?®è¡Œã?Œå?–り出ã?•れるå‰?ã?«ã‚·ã‚¹ãƒ†ãƒ ã?Œéƒ¨åˆ†çš„ã?«å•?å?ˆã?›ã‚’実行ã?—ã?Ÿå ´å?ˆã€?ResultSetã?Œä½œæˆ?ã?•れるã?¨ã??ã?«ã‚¨ãƒ©ãƒ¼ã?Œç™ºç”Ÿã?™ã‚‹ã?“ã?¨ã?Œã?‚りã?¾ã?™ã€‚ ã?“ã?®ã‚¨ãƒ©ãƒ¼ã?¯ä¸€ã?¤ä»¥ä¸Šã?®è¡¨ã‚’使ã?†å•?å?ˆã?›ã‚„ã€?集約ã€?GROUP BYã€?ORDER BYã€?DISTINCTã€?INTERSECTã€?EXCEPTã€?UNIONを使ã?†å•?å?ˆã?›ã?«ã?¦ç™ºç”Ÿã?™ã‚‹ã?“ã?¨ã?Œã?‚りã?¾ã?™ã€‚
Statementã‚’é–‰ã?˜ã‚‹ã?¨ã€?ã??ã?®æ–‡ã?§é–‹ã?„ã?Ÿå…¨ã?¦ã?®ResultSetオブジェクトも閉ã?˜ã?¾ã?™ã€‚
ResultSetã?®ã‚«ãƒ¼ã‚½ãƒ«ã?«ã?¯ã€?æ–‡ã?Œå®Ÿè¡Œã?•れるå‰?ã?«ã‚«ãƒ¼ã‚½ãƒ«å??を与ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?Ÿã? ã?—一旦実行ã?•れã?Ÿå¾Œã?§ã?¯ã€?カーソルã?®å??å‰?を変更ã?™ã‚‹ã?“ã?¨ã?¯ã?§ã??ã?¾ã?›ã‚“。