Abstracts developers from SQL syntax, with methods that return Strings to pass on to JDBC, thus allowing compile-time checking for, many, otherwise run-time bugs. e.g. stmt.executeQuery(SqlWrapper.selectId(ordersTable, customerColumn, "John Smith")
Features
- Transparently wraps Java DB (Apache Derby) SQLite, and PostgresSQL syntax, making the code easily portable between the two;
- Simple static and instance methods with intutive signatures that return SQL Strings;
- Provides Table and Column objects to pass as parameters to create, insert, select, selectId, last, first, etc .. methods enabling the convenient use of variables to refer to them throughout the code;
- Developer-friendly: developed as a component of STCAL and MemorizEasy;
- Test code provides usage examples, in addition to the open-source projects using it;
- Transparently adds to Java DB and PostgreSQL databases the SQLite convenient concept of an AUTOINCREMENT ROWID;
- Available with Maven;
License
Public DomainFollow SqlWrapper
Other Useful Business Software
Next-Gen Encryption for Post-Quantum Security | CLEAR by Quantum Knight
CLEAR by Quantum Knight is a FIPS-140-3 validated encryption SDK engineered for enterprises requiring top-tier security. Offering robust post-quantum cryptography, CLEAR secures files, streaming media, databases, and networks with ease across over 30 modern platforms. Its compact design, smaller than a single smartphone image, ensures maximum efficiency and low energy consumption.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SqlWrapper!