Google


ResultSet

SQLʸ¤ò¼Â¹Ô¤·¤¿¸¡º÷·ë²Ì¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤¿¤á¤Î¥ª¥Ö¥¸¥§¥¯¥È

¥¯¥é¥¹¥á¥½¥Ã¥É:

¥á¥½¥Ã¥É:

initialize(statement)

Statement#executeQuery¤Ê¤É¤«¤é¸Æ¤Ð¤ì¤ë(¤Î¤ÇRDBC¥æ¡¼¥¶¡¼¤¬¸Æ¤ÖɬÍפϤʤ¤)¡£ statement¤ÏͳÍ褹¤ëStatement¥ª¥Ö¥¸¥§¥¯¥È¡£

next

¸¡º÷¤µ¤ì¤¿¥Ç¡¼¥¿¥»¥Ã¥È¤Î¡Ö¼¡¤Î¹Ô¡×¤Ø°Ü¤ë¡£ ¼¡¤Î¹Ô¤Î¥Ç¡¼¥¿¤¬Í­¤ì¤Ð(¼èÆÀ¤ËÀ®¸ù¤¹¤ì¤Ð)true¤ò¡¢ ̵¤±¤ì¤Ðfalse¤ò¡¢ÊÖ¤¹¡£

getData(col=nil)
data(col=nil)

¥Ç¡¼¥¿¤Îº£¤Î¹Ô¤ÎÃÍ(Ê£¿ô¤Ê¤é¤Ð¤½¤ì¤é¤ÎArray)¤òÊÖ¤¹¡£ JDBC¤Ë¤Ï¥Ç¡¼¥¿¤Îtype¤´¤È¤Ë¿§¡¹¤ÊgetXXX¥á¥½¥Ã¥É¤¬¤¢¤ë¤¬¡¢ Ruby¤Ç¤Ï1¼ïÎà¤Ç½½Ê¬¤Ç¤¢¤ë¡£
col¤¬¡¢

  • String¤Ê¤é¤Ð¡¢Database¤Ç¤½¤Î̾¤¬ÉÕ¤±¤é¤ì¤Æ¤¤¤ë¥«¥é¥à¤Î
  • integer¤Ê¤é¤Ð¡¢¤½¤ÎÈÖ¹æ(0¤«¤é¿ô¤¨¤ë)¤Î¥«¥é¥à¤Î
  • Array¤Ê¤é¤Ð¡¢¤½¤ÎÍ×Áǰì¸Ä¤Å¤Ä¤Ë¤Ä¤¤¤ÆºÆµ¢Åª¤ËŬÍѤµ¤ì¤ë¥«¥é¥à¤Î
  • nil¤Ê¤é¤Ð¡¢Database¥¹¥­¡¼¥Þ¤ËÄêµÁ¤µ¤ì¤Æ¤¤¤ëÄ̤ê¤Ë1¹ÔÁ´¥«¥é¥à¤Î
¥Ç¡¼¥¿¤òÊÖ¤¹¡£¤³¤ì¤é¤Ë³ºÅö¤·¤Ê¤±¤ì¤ÐÎã³°¤ò½Ð¤¹¡£ Ê£¿ô¤Î¥«¥é¥à¤¬ÁªÂò¤µ¤ì¤¿¾ì¹ç¤ÏÊÖ¤¹¥Ç¡¼¥¿¤¿¤Á¤ò Array¤ÇÊñ¤ó¤ÇÊÖ¤¹¡£

metadata

ResultSetMetaData¤Î¥¤¥ó¥¹¥¿¥ó¥¹¤òÊÖ¤¹¡£

close

¤³¤ÎResultSet¤È¡¢¤½¤ì¤ËͳÍ褹¤ëRDBC¥ª¥Ö¥¸¥§¥¯¥È¤ò¡¢ÊĤ¸¤ë¡£