Welcome to SqlMan's Docs Center

This is a Java helper library for data manipulation of RDBMS (Databases), from low-level SQL operations to advanced low-code rapid development integration. First of all, it encapsulates common JDBC operations while retaining the original SQL statement input (SQL can be stored in XML or Java annotations); Secondly, it provides convenient CRUD (Create, Read, Update, Delete) operations for Java entities, eliminating the need to write SQL; Finally, it offers a rapid development platform that integrates the features of the former two, allowing the generation of API interfaces with just SQL statements, making it more user-friendly.

Some of the advantages of using SqlMan are:

• Familiar way for you:
  • sql().input('SELECT * FROM table WHERE id=?', 1).query() -- Highly compatible with Spring JdbcTemplate/Apache DBUtils.
  • Multiple lines of SQL written in XML -- Highly compatible with MyBatis Mapper.
  • @Insert、@Update、@Delete、@Query annotations -- Highly compatible with JPA.
  • Automatically populate JavaBean properties from ResultSets. You don't need to manually copy column values into bean instances by calling setter methods. Each row of the ResultSet can be represented by one fully populated bean instance. Besides, Map type is optional.
• Core philosophy centers around SQL. Enhanced SQL logic, supporting dynamic SQL (IF/ForEach).
• Built-in common CRUD//Paging functionality, allowing simple systems to write 0% SQL, and saving 50% of the workload in complex projects.
• Offers a rich set of extension features, with 80% of the functionality being customizable and expandable.

SqlMan is designed to be:

• Small - Almost obsessively simple philosophy. You should be able to understand the whole package in a short amount of time.
• Transparent - SqlMan doesn't do any magic behind the scenes. You give it a query, it executes it and cleans up for you.
• Fast - You don't need to create a million temporary objects to work with SqlMan.

SqlMan is NOT:

• An Object/Relational bridge - there are plenty of good O/R tools already. SqlMan is for developers looking to use JDBC without all the mundane pieces.
• Does not provide a functional-style chained call, as the author believes that readability is poor and debugging is inconvenient.

• A heavyweight framework of any kind - the goal here is to be a straightforward and easy to use JDBC helper library.

Source Code

Under GNU GENERAL PUBLIC LICENSE v3.0.

• Github: https://github.com/lightweight-component/SqlMan
• Gitcode: https://gitcode.com/lightweight-component/SqlMan, for Chinese users faster access.

Links

Website | Documents | JavaDoc