Motivation

About FluentJdbc

FluentJdbc is a java library for convenient native SQL querying. Blends well with Java 8 / functional code, supports functionality many jdbc wrappers prevent / abstract away, and is lightweight (~80K, no dependencies).

FluentJdbc's key features:

• functional, fluent API
• execution of select/insert/update/delete/alter/... statements as one-liners
• parameter mapping (named, positional, supports java.time, enums, Optional, Collections, plugins for custom types)
• access to generated keys of insert/update queries
• transactions
• big data (scalable, streaming style batch and select)
• automatic result to pojo mapping
• database inspection
• query listening (for eg logging, auditing, performance measurement)

<dependency>
    <groupId>org.codejargon</groupId>
    <artifactId>fluentjdbc</artifactId>
    <version>1.3.4</version>
</dependency>

Get started guide
Javadoc