{"id":417,"date":"2005-06-14T01:00:00","date_gmt":"2005-06-13T16:00:00","guid":{"rendered":"https:\/\/ecoop.net\/memo\/2005-06-14-1.html"},"modified":"2017-02-16T17:32:43","modified_gmt":"2017-02-16T08:32:43","slug":"2005-06-14-1","status":"publish","type":"post","link":"https:\/\/www.ecoop.net\/memo\/archives\/2005-06-14-1.html","title":{"rendered":"ResultSet \u3092 Map \u306b\u5909\u63db\u3059\u308b\u306b\u306f"},"content":{"rendered":"<p>ResultSet \u3092 Map \u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3068\u3057\u3066\u3001Apache Commons \u306e DbUtils \u306b\u6b21\u306e\u3088\u3046\u306a\u4fbf\u5229\u306a\u30e1\u30bd\u30c3\u30c9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>org.apache.commons.dbutils.BasicRowProcessor#toMap(ResultSet) throws SQLException<\/p>\n<p>ResultSet \u306e\u884c\u3092 Map \u3078\u5909\u63db\u3057\u307e\u3059\u3002 \u3053\u306e\u5b9f\u88c5\u3067\u306f\u3001\u5927\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u306a\u3044\u30ab\u30e9\u30e0\u540d\u3092\u30ad\u30fc\u3068\u3057\u305fMap\u3092\u8fd4\u3057\u307e\u3059\u3002 \u4f8b\u3048\u3070\u3001map.get(&#8220;COL&#8221;) \u306e\u547c\u3073\u51fa\u3057\u3068<br \/>\nmap.get(&#8220;col&#8221;) \u306e\u547c\u3073\u51fa\u3057\u3067\u306f\u3001 \u540c\u4e00\u306e\u5024\u304c\u8fd4\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/commons.apache.org\/proper\/commons-dbutils\/\" target=\"_blank\">Commons DbUtils: JDBC Utility Component<\/a><br \/>\n<a href=\"http:\/\/www.jajakarta.org\/commons\/dbutils-1.0\/ja\/withoutPrimary\/org\/apache\/commons\/dbutils\/BasicRowProcessor.html\">BasicRowProcessor javadoc<\/a><\/p>\n<p>\u307e\u305f\u306f\u3001\u81ea\u524d\u5b9f\u88c5\u3067\u3053\u306e\u3088\u3046\u306a\u65b9\u6cd5\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\npublic List resultSetToArrayList(ResultSet rs) throws SQLException{\n  ResultSetMetaData md = rs.getMetaData();\n  int columns = md.getColumnCount();\n  ArrayList list = new ArrayList(50);\n  while (rs.next()){\n     HashMap row = new HashMap(columns);\n     for(int i=1; i&amp;lt;=columns; ++i){&lt;br \/&gt;\n      row.put(md.getColumnName(i),rs.getObject(i));\n     }\n      list.add(row);\n  }\n\nreturn list;\n}\n\n<\/pre>\n<p>\u53c2\u8003\uff1a <a href=\"http:\/\/stackoverflow.com\/questions\/7507121\/efficient-way-to-handle-resultset-in-java\" target=\"_blank\">http:\/\/stackoverflow.com\/questions\/7507121\/efficient-way-to-handle-resultset-in-java<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ResultSet \u3092 Map \u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3068\u3057\u3066\u3001Apache Commons \u306e DbUtils \u306b\u6b21\u306e\u3088\u3046\u306a\u4fbf\u5229\u306a\u30e1\u30bd\u30c3\u30c9\u304c\u3042\u308a\u307e\u3059\u3002 org.apache.commons.dbutils.BasicRowPro &hellip; <a href=\"https:\/\/www.ecoop.net\/memo\/archives\/2005-06-14-1.html\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">ResultSet \u3092 Map \u306b\u5909\u63db\u3059\u308b\u306b\u306f<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[42],"class_list":["post-417","post","type-post","status-publish","format-standard","hentry","tag-java"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/comments?post=417"}],"version-history":[{"count":1,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/417\/revisions"}],"predecessor-version":[{"id":1204,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/417\/revisions\/1204"}],"wp:attachment":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/media?parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/categories?post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/tags?post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}