Fork me on GitHub
This has nothing to do with the "Dragon Ball";
I just happen to be a fan of this comic.

Welcome to SqlMan!

A easy, small, straight forward Java CRUD Helper.

SqlMan is a lightweight wrapper over JDBC. It is NOT an ORM but follows a SQL-first approach. It allows you to use pure SQL with IF/forEach and pass Map parameters for queries or executions. The results you receive are either 'isOk' indicators and 'Map' or Java Bean object(s). SqlMan enables fast CRUD database operations with ZERO dependencies, except for the JDK.



Similar libraries:Spring JDBC Template, Apache Commons DbUtils, Jdbi3.



Built for direct database work

Design Philosophy

A focused toolkit for teams who want SQL to stay visible, predictable, and fast.

Small/Restraint

Simple philosophy, easy to understand the whole package quickly. Minimal introduction of third-party dependencies.

Carefully Designed API

Elegant API invocation, reuse of common concepts, consistent usage, and reduced learning curve.

Fast

Minimal object creation, efficient database operations. No magic behind the scenes, straightforward execution

Open

100% Open Source with full documentation, commments, unit tests. Community-driven development.

Why SqlMan

Some of the advantages of using SqlMan are:

  • Familiar way for you:
    • sql().input('SELECT * FROM table WHERE id=?', 1).query()
    • Multiple lines of SQL written in XML
    • @Insert, @Update, @Delete, @Query annotations
    • Automatically populate JavaBean properties from ResultSets.
  • Core philosophy centers around SQL. Enhanced SQL logic, supporting dynamic SQL (IF/ForEach).
  • Built-in common CRUD/Paging functionality.
  • Offers a rich set of extension features.
Open source

Source Code

Under GNU GENERAL PUBLIC LICENSE v3.0.