Ebook Apache-Empire-db tutorial
This tutorial demonstrates in eight easy steps how to work with Apache-Empire-db and perform the most common tasks of data persistence: inserting, updating and deleting records as well as performing queries with a simple and ready to run example application. For more advanced topics like complex queries, bulk operations and dynamic data model changes there is a second example application provided with the release.
The sample application used for this tutorial is provided with the Apache-Empire-db distribution and can be found in the examples/DBSample directory. If you are using the Eclipse IDE there is also an Eclipse project file that allows you to open the project straight away. In your IDE, set a breakpoint on the first line of the main method in SampleApp.java and debug the sample.
The sample works with a HSQL database that is provided with the distribution files, and allows the application to run "off the shelf". However it can easily be reconfigured to work with a Microsoft SQL-Server or Oracle database instead by altering the config.xml file.
In detail the tutorial shows the following:
- • How to declare your data model using Java classes and objects
• How to generate a DDL-Script from the data model definition and create all database objects on the server
• How to insert, update and delete individual records
• How to perform a database query including joins and constraints
• How to access the query results either sequentially row by row, as a bean list or as an XML document
Download
Ebook Apache-Empire-db tutorial
Posted in :
