Hi Java people. I have been toying with simplier ways of doing embedded SQL in Java.
And would like your comments on this one? http://code.google.com/p/chalkmine/ It allows you to write code like this: openConnection(); try { int count = queryScalar(Integer.class, "select count(*) from people"); System.out.println("There are "+count+" people in the bin."); } finally { closeConnection(); } or openConnection(); try { List<Person> people = queryList(Person.class, "select name, time_in_the_bin from people"); for (Person p : people) System.out.println(p.getName()+" has been "+p.getTimeInTheBin() +" hours in the bin."); } finally { closeConnection(); } (Provided that Person has a constructor matching the types of name, time_in_the_bin. Probably Person(String, int).) Where the methods openConnection, queryScalar, queryList, closeConnection are statically imported. openConnection() figures out the name of the calling class, looks up a configuration, opens a connection and puts in a ThreadLocal container. queryScalar(Class, String, ...) performs a query with a single row result that is "cast" to the given class. queryList(Class, String, ...) performs a query and returns the result as a list of the given class. I would like to turn it into a full-fledged open source project. But since it is incredibly hard for a new open source project to gain traction I would like to figure out whether it is interesting enough first. -- Christian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/javaposse?hl=en -~----------~----~----~----~------~----~------~--~---
