{"id":1425,"date":"2012-07-04T19:14:15","date_gmt":"2012-07-04T17:14:15","guid":{"rendered":"http:\/\/www.tutego.de\/blog\/javainsel\/?p=1425"},"modified":"2012-07-05T09:25:48","modified_gmt":"2012-07-05T07:25:48","slug":"putziger-kleiner-or-mapper-ormlite","status":"publish","type":"post","link":"https:\/\/www.tutego.de\/blog\/javainsel\/2012\/07\/putziger-kleiner-or-mapper-ormlite\/","title":{"rendered":"Putziger kleiner OR-Mapper: ORMLite, f&uuml;r JDBC und auch f&uuml;r Android"},"content":{"rendered":"<pre class=\"csharpcode\">package tutego;\n\nimport java.sql.SQLException;\nimport com.j256.ormlite.dao.*;\nimport com.j256.ormlite.db.HsqldbDatabaseType;\nimport com.j256.ormlite.field.DatabaseField;\nimport com.j256.ormlite.jdbc.JdbcConnectionSource;\nimport com.j256.ormlite.support.ConnectionSource;\nimport com.j256.ormlite.table.*;\n\n@DatabaseTable\n<span class=\"kwrd\">class<\/span> Contact\n{\n  @DatabaseField( generatedId = <span class=\"kwrd\">true<\/span> )\n  Long id;\n\n  @DatabaseField\n  String name;\n\n  <span class=\"rem\">\/\/ Setter\/Getter sparen<\/span>\n}\n\n<span class=\"kwrd\">public<\/span> <span class=\"kwrd\">class<\/span> ORMLiteDemo\n{\n  <span class=\"kwrd\">public<\/span> <span class=\"kwrd\">static<\/span> <span class=\"kwrd\">void<\/span> main( String[] args )\n  {\n    System.setProperty( <span class=\"str\">&quot;tutegoHsqldbDatabasePath&quot;<\/span>, <span class=\"str\">&quot;TutegoDB&quot;<\/span> );\n    String url = <span class=\"str\">&quot;jdbc:hsqldb:file:${tutegoHsqldbDatabasePath};shutdown=true&quot;<\/span>;\n    ConnectionSource connectionSource;\n    <span class=\"kwrd\">try<\/span> {\n      connectionSource = <span class=\"kwrd\">new<\/span> JdbcConnectionSource( url, <span class=\"str\">&quot;sa&quot;<\/span>, <span class=\"str\">&quot;&quot;<\/span>, <span class=\"kwrd\">new<\/span> HsqldbDatabaseType() );\n      Dao&lt;Contact, String&gt; dao = DaoManager.createDao( connectionSource, Contact.<span class=\"kwrd\">class<\/span> );\n<span class=\"rem\">\/\/      TableUtils.createTable( connectionSource, Contact.class );<\/span>\n\n      Contact c1 = <span class=\"kwrd\">new<\/span> Contact();\n      c1.name = <span class=\"str\">&quot;Chris&quot;<\/span>;\n      dao.create( c1 );\n      Contact c2 = <span class=\"kwrd\">new<\/span> Contact();\n      c2.name = <span class=\"str\">&quot;Juvy&quot;<\/span>;\n      dao.create( c2 );\n\n      Contact c3 = dao.queryForId( <span class=\"str\">&quot;1&quot;<\/span> );\n      System.<span class=\"kwrd\">out<\/span>.println( c3.name );\n      connectionSource.close();\n    }\n    <span class=\"kwrd\">catch<\/span> ( SQLException e ) {\n      e.printStackTrace();\n    }\n  }\n}<\/pre>\n<style type=\"text\/css\">\n.csharpcode, .csharpcode pre\n{\n\tfont-size: small;\n\tcolor: black;\n\tfont-family: consolas, \"Courier New\", courier, monospace;\n\tbackground-color: #ffffff;\n\t\/*white-space: pre;*\/\n}\n.csharpcode pre { margin: 0em; }\n.csharpcode .rem { color: #008000; }\n.csharpcode .kwrd { color: #0000ff; }\n.csharpcode .str { color: #006080; }\n.csharpcode .op { color: #0000c0; }\n.csharpcode .preproc { color: #cc6633; }\n.csharpcode .asp { background-color: #ffff00; }\n.csharpcode .html { color: #800000; }\n.csharpcode .attr { color: #ff0000; }\n.csharpcode .alt \n{\n\tbackground-color: #f4f4f4;\n\twidth: 100%;\n\tmargin: 0em;\n}\n.csharpcode .lnum { color: #606060; }<\/style>\n<p>1. Klassen annotieren mit den ORMLite-Annotationen oder mit JPA-Annotationen<\/p>\n<p>2. Sind die Tabellen nicht da, muss man TableUtils.createTable( connectionSource, Contact.class ); aufrufen, dann erzeugt ORMLite die Tabellen.<\/p>\n<p>3. Der Rest ist einfach, siehe Beispiel \ud83d\ude42<\/p>\n<p>Mehr unter <a href=\"http:\/\/ormlite.com\/\">http:\/\/ormlite.com\/<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>package tutego; import java.sql.SQLException; import com.j256.ormlite.dao.*; import com.j256.ormlite.db.HsqldbDatabaseType; import com.j256.ormlite.field.DatabaseField; import com.j256.ormlite.jdbc.JdbcConnectionSource; import com.j256.ormlite.support.ConnectionSource; import com.j256.ormlite.table.*; @DatabaseTable class Contact { @DatabaseField( generatedId = true ) Long id; @DatabaseField String name; \/\/ Setter\/Getter sparen } public class ORMLiteDemo { public static void main( String[] args ) { System.setProperty( &quot;tutegoHsqldbDatabasePath&quot;, &quot;TutegoDB&quot; ); String url = &quot;jdbc:hsqldb:file:${tutegoHsqldbDatabasePath};shutdown=true&quot;; ConnectionSource [&hellip;]<\/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":[4],"tags":[69,70],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-open-source","tag-hsqldb","tag-ormlite"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1425","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=1425"}],"version-history":[{"count":3,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1425\/revisions"}],"predecessor-version":[{"id":1428,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1425\/revisions\/1428"}],"wp:attachment":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/categories?post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/tags?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}