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.

- Current version: v1.0

Blog

New code, new project, new site

2024-12-05 by Frank Cheung

I can't remember how many iterations this project has gone through. It's been at least eight years since I first attempted to encapsulate JDBC API, and throughout this time, I've been obsessed with achieving a better implementation to improve development efficiency. Gradually, I've developed an overall approach and have implemented it in code, but something always feels off; the components just don't seem to be as user-friendly as they should be. This led me to realize that the issue lies with the API style. Having pinpointed the problem, I plan to refactor once again, aiming to make it more usable, clearer, and more intuitive. Honestly, designing the right style requires inspiration...