+1 for Spring JDBC: it manages all that openConnection/closeConnection noise for you, which means that your JDBC code can *also* start to be expressive.
~~ Robert. Rakesh wrote: > 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 >> >> > > > > -- ~~ Robert Fischer. Grails Training http://GroovyMag.com/training Smokejumper Consulting http://SmokejumperIT.com Enfranchised Mind Blog http://EnfranchisedMind.com/blog Check out my book, "Grails Persistence with GORM and GSQL"! http://www.smokejumperit.com/redirect.html --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
