{"repo":"landawn/abacus-jdbc","free":true,"listed":false,"github":"https://github.com/landawn/abacus-jdbc","clone":"git clone https://github.com/landawn/abacus-jdbc.git","description":"Coding with SQL/DB is just like coding with Collections","language":"Java","stars":21,"topics":["java","jdbc","sql","sqlbuilder","dao","jpa","orm"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"abacus-jdbc Work with SQL and databases as naturally as you work with Collections. abacus-jdbc is a lightweight layer on top of plain JDBC. It keeps SQL front and center — you write (or generate) real SQL — while removing the boilerplate of preparing statements, binding parameters, mapping result sets, managing transactions, and handling exceptions. There is no ORM magic to fight and no query DSL to learn before you can run your first statement. Features The library is organized around three steps you already take with JDBC — write SQL, prepare a query, execute and map the result. Each step is optional and composable; use as much or as little as you need. 1. Write or generate SQL (optional) Write SQL as a plain string, or build it type-safely with SQLBuilder / DynamicSQLBuilder. SQL can also live in an external mapper file and be referenced by id from a DAO — see the @SqlSource example below. 2. Prepare a statement / query PreparedQuery, NamedQuery, and CallableQuery wrap JDBC statements with a fluent, null-safe, auto-closing API. 3. Execute and retrieve results Execute directly from a query, or let a Dao / CrudDao / JoinEntityHelper do it for you. Results map to entities, primitives, or a Dataset via Jdbc mappers. A DAO turns your SQL into ready-to-call methods. Dozens of common operations ( insert , update , deleteById , list , count , stream , batchInsert , ...) are already defined on the built-in interfaces — no implementation required — and you add your own with @Query :","default_branch":null,"files":null,"tree":[],"storefront":"/r/landawn","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/landawn/abacus-jdbc/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}