|
With the enhancements coming in JDBC 4.0 (whenever that's due) I can imagine a rise in JDBC usage for simple data access. Read up on how annotations can be used for simple Table-To-JavaBean mapping.
Another hidden gem that I have enjoyed playing with but never heard of anyone else using is the Apache DBUtils project. This is a nice and easy SqlQuery-To-JavaBean mapping technique. It is easier to use than you might think on first reading the manual. The manual starts by explaining the couple of interfaces that need to be implemented etc, but by the end you will realise that in fact there is surprisingly little to it, and with the pre-rolled implementations there is no need to implement any of it's APIs - just use the classes provided.
I'm not saying these would replace a full blown ORM tool, but for projects with light sql needs, they might offer a quick and easy way of using (more-or-less) directly JDBC without too much boilerplate coding.
Now that I think about it, why is there so little obvious use of the standard RowSet classes? Another light way of using JDBC. |