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;

Project Samples

Project Activity

See All Activity >

License

Public Domain

Follow SqlWrapper

SqlWrapper Web Site

Other Useful Business Software
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of SqlWrapper!

Additional Project Details

Languages

English

Intended Audience

System Administrators, Developers, Quality Engineers

User Interface

Other toolkit

Programming Language

Java

Database Environment

Project is a database abstraction layer (API), JDBC, SQLite, SQL-based

Related Categories

Java Front-Ends, Java Object Oriented Software, Java Code Generators

Registered

2010-03-29