Defines major database access operations in an easy usable API.
Editor: What is JDBaccess?
JDBaccess is a persistence library for the Java SE platform. It defines major database access operations in an easy usable API. The main interface classes are Transaction, Insert, Update, Delete, Select, Result, Procedure, Function, and CallResult. You select for example database rows by (see the manual for more examples):
Select select = new Select();select.setSql(select * from employee);Result result = select.execute();ArrayList list = result.getNextElements();

JDBaccess is completely written in the Java programming language and only has a small size of about 170 KB. It supports the major two database systems MySQL and Oracle with their Type 4 JDBC drivers (Oracle thin driver and Connector/J).

JDBaccess works with the Java Standard Edition (Java SE). No complex application server structure and no Java Enterprise Edition (Java EE) is needed. JDBaccess is used in a typical two-layer-architecture with a plain Java application client and a database server. But within the Java application client JDBaccess allows you to develop your application in a typical three-layer-architecture with presentation, application and persistence layer. JDBaccess is the software Between your persistence layer in the client application and the JDBC driver for your database server. JDBaccess supports the data access object and transfer object pattern.

JDBaccess applications are portable, and Independent of the underlying database. You can Focus on your object model and leave the Details of persistence to the JDBaccess implementation. JDBC is completely hidden from the programmer. A JDBaccess application for example does not care about connection and statement handling. JDBaccess can help you to remove or encapsulate vendor-specific SQL code. JDBaccess goal is to relieve the developer from 90% of common data persistence related programming tasks. you can free download JDBaccess for MySql 1.0 now.