{"id":101,"date":"2007-11-01T14:09:00","date_gmt":"2007-11-01T14:09:00","guid":{"rendered":"http:\/\/www.tutego.de\/blog\/javainsel\/?p=101"},"modified":"2007-11-01T14:09:00","modified_gmt":"2007-11-01T14:09:00","slug":"sql-fur-objekte-josql-sql-for-java-objects","status":"publish","type":"post","link":"https:\/\/www.tutego.de\/blog\/javainsel\/2007\/11\/sql-fur-objekte-josql-sql-for-java-objects\/","title":{"rendered":"SQL f\u00fcr Objekte: JoSQL (SQL for Java Objects)"},"content":{"rendered":"<p>JoSQL (SQL for Java Objects) unter <a title=\"http:\/\/josql.sourceforge.net\/index.html\" href=\"http:\/\/josql.sourceforge.net\/index.html\">http:\/\/josql.sourceforge.net\/index.html<\/a>&nbsp;ist eine Open-Source Biblitohek, um SQL-Anfragen an Objektgrafen zu stellen. Die Webseite gibt interessante Beispiele.<\/p>\n<pre>String query = \"SELECT * FROM   java.io.File WHERE  name LIKE '%.mp3'\";<br \/>Query q = new Query();<br \/>q.parse( query );<br \/>QueryResults results = q.execute( Arrays.asList( new File(\"C:\/Data\/Musik\/\").listFiles() ) );<br \/>System.out.println( results.getResults() );<\/pre>\n<p><\/p>\n<p>Oder f\u00fcr Ausdr\u00fccke:<\/p>\n<pre>\/*<br \/> * Use as a file filter.<br \/> *\/<br \/>String exp = \"lastModified BETWEEN toDate('10\/May\/2007') AND toDate('28\/Jun\/2007') \" +<br \/>              \"AND \" +<br \/>              \"length &gt;= 10 * 1024\" +<br \/>              \"AND \" +<br \/>              \"path LIKE '%\/subdir\/%'\";<br \/>              <br \/>ExpressionEvaluator ee = new ExpressionEvaluator (exp, File.class);<br \/><br \/>if (ee.isTrue (myfile))<br \/>{<br \/>   \/\/ Process the file.<br \/>}<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>JoSQL (SQL for Java Objects) unter http:\/\/josql.sourceforge.net\/index.html&nbsp;ist eine Open-Source Biblitohek, um SQL-Anfragen an Objektgrafen zu stellen. Die Webseite gibt interessante Beispiele. String query = &#8222;SELECT * FROM java.io.File WHERE name LIKE &#8218;%.mp3&#8242;&#8220;;Query q = new Query();q.parse( query );QueryResults results = q.execute( Arrays.asList( new File(&#8222;C:\/Data\/Musik\/&#8220;).listFiles() ) );System.out.println( results.getResults() ); Oder f\u00fcr Ausdr\u00fccke: \/* * Use as [&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":[],"class_list":["post-101","post","type-post","status-publish","format-standard","hentry","category-open-source"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/101","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=101"}],"version-history":[{"count":0,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}