{"id":1669,"date":"2013-01-06T04:06:09","date_gmt":"2013-01-06T02:06:09","guid":{"rendered":"http:\/\/www.tutego.de\/blog\/javainsel\/?p=1669"},"modified":"2013-01-06T04:06:09","modified_gmt":"2013-01-06T02:06:09","slug":"erste-libs-springen-auf-java-8-auf","status":"publish","type":"post","link":"https:\/\/www.tutego.de\/blog\/javainsel\/2013\/01\/erste-libs-springen-auf-java-8-auf\/","title":{"rendered":"Erste Libs springen auf Java 8 auf"},"content":{"rendered":"

So etwa http:\/\/www.jdbi.org\/<\/a>.<\/p>\n

\n

JDBI<\/a> is a SQL convenience library for Java.<\/p>\n<\/blockquote>\n

Beispiel von der Seite in herk\u00f6mmlicher Notation:<\/p>\n

DataSource ds = JdbcConnectionPool.create("jdbc:h2:mem:test",\n                                          "username",\n                                          "password");\nDBI dbi = new DBI(ds);\nHandle h = dbi.open();\nh.execute("create table something (id int primary key, name varchar(100))");\n\nh.execute("insert into something (id, name) values (?, ?)", 1, "Brian");\n\nString name = h.createQuery("select name from something where id = :id")\n                    .bind("id", 1)\n                    .map(StringMapper.FIRST)\n                    .first();\n                    \nassertThat(name, equalTo("Brian"));\n\nh.close();<\/code><\/pre>\n
http:\/\/skife.org\/jdbi\/2012\/12\/10\/some-jdbi3.html<\/a> schreibt nun, dass JDBI 3 Lambda-Ausdr\u00fccke nutzen wird und gibt folgendes Beispiel an:<\/p>\n
Set<Something> things = jdbi.withHandle(h -> {\n    h.execute("insert into something (id, name) values (?, ?)", 1, "Brian");\n    h.execute("insert into something (id, name) values (?, ?)", 2, "Steven");\n\n    return h.query("select id, name from something")\n            .map(rs -> new Something(rs.getInt(1), rs.getString(2)))\n            .into(new HashSet<Something>());\n});\n\nassertThat(things).isEqualTo(ImmutableSet.of(new Something(1, "Brian"),\n                                             new Something(2, "Steven")));<\/code><\/pre>\n
Das geht sicherlich noch etwas k\u00fcrzer, warten wir\u2019s ab.<\/p>\n","protected":false},"excerpt":{"rendered":"
So etwa http:\/\/www.jdbi.org\/. JDBI is a SQL convenience library for Java. Beispiel von der Seite in herk\u00f6mmlicher Notation: DataSource ds = JdbcConnectionPool.create("jdbc:h2:mem:test", "username", "password"); DBI dbi = new DBI(ds); Handle h = dbi.open(); h.execute("create table something (id int primary key, name varchar(100))"); h.execute("insert into something (id, name) values (?, ?)", 1, "Brian"); String name = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[66],"tags":[],"class_list":["post-1669","post","type-post","status-publish","format-standard","hentry","category-java-8"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/comments?post=1669"}],"version-history":[{"count":0,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1669\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/media?parent=1669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/categories?post=1669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/tags?post=1669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}