SQL Zone is brought to you in partnership with:

Yegor has posted 1 posts at DZone. View Full User Profile

Jcabi fluent wrapper of JDBC

05.20.2012
| 1245 views |
  • submit to reddit
Location: 
California

There are a number of open source JDBC wrappers, including Olli, JDBI, and Spring JdbcTemplate. All of them are more complex than such a wrapper should be for simple applications, when you need to do a few primitive manipulations with the database. This is what JdbcSession offers (from jcabi-jdbc): 

String name = new JdbcSession(source)
  .sql("SELECT name FROM user WHERE id = ?")
  .select(new SingleHandler<String>(String.class));    .set(12345)

That's all you need to fetch one value from the database, using SQL. The module is available in Maven Central with these coordinates:

<dependency>
  <groupId>com.jcabi</groupId>
  <artifactId>jcabi-jdbc</artifactId>
  <version>0.1.8</version>
</dependency> 

Source code is hosted at github: https://github.com/yegor256/jcabi 

0
Average: 5 (1 vote)
Published at DZone with permission of its author, Yegor Bugayenko.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)