JDBI Alternatives, Similar

1 Star 0
Loading...

JDBI

Explanation
JDBI is a SQL convenience library for Java. It attempts to expose relational database access in idiommatic Java, using collections, beans, and so on, while maintaining the same level of detail as JDBC. It exposes two different style APIs, a fluent style and a sql object style.The DBI type is analogous to a JDBC DataSource, and will usually be const... read more
Categories
Reviews (5.00)
Reviews (0 / 0)
Licence
Free
Platforms
Windows Mac Linux

All JDBI Alternatives

Free

Hibernate

Hibernate an open source Java persistence framework project. Perform powerful object relational mapping and query databases using HQL and SQL.

Show Details
1 Star 0
Loading...
Free

Ebean ORM

ORM for Java / Kotlin

Show Details
1 Star 0
Loading...

JDBI About

JDBI is a SQL convenience library for Java. It attempts to expose relational database access in idiommatic Java, using collections, beans, and so on, while maintaining the same level of detail as JDBC. It exposes two different style APIs, a fluent style and a sql object style.

The DBI type is analogous to a JDBC DataSource, and will usually be constructed by passing in a JDBC DataSource. There are alternate constructors which take JDBC URL and credentials, and other means. From the DBI instance you obtain Handle instances. A Handle represents a single connection to the database. Handles rely on an underlying JDBC connection object. More Info »

With a handle you may create and execute statements, queries, calls, batches, or prepared batches. In the above example we execute a statement to define a table, execute another statement, this time with two positional arguments to insert a value, and finally construct a query, bind a value to a named argument in the query, map the results to a a String, and take the first result which comes back.

The named argument facility on statements and queries is provided by JDBI – it parses out the SQL and uses positional parameters when actually constructing the prepared statements. The above example uses the default colon-demarcated parser, but an alternative hash delimited parser is included as well for use with databases which use colons in their grammars, such as PostgreSQL.

Reviews & Comments

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
Tags
0
Would love your thoughts, please comment.x
()
x