have you looked at Spring JDBC? It has a similar interface and manages the connections for you.
I think if you go down a non-orm route and want to have lots of sql, Ibatis is quite common - not used it so can't say for sure. Spring JDBC though is very nice and have used it extensively. Rakesh On Sun, Feb 22, 2009 at 2:21 PM, Christian Hvid <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
