Assignment two -> Task one
 

Task one: Library enterprise application

Introduction

A library is a collection of information, sources, resources, books, and services, and the structure in which it is housed: it is organized for use and maintained by a public body, an institution, or a private individual. In the more traditional sense, a library is a collection of books. The term can mean the collection, the building that houses such a collection, or both (http://en.wikipedia.org/wiki/Library).

Requirements

A library needs an information GUI client that helps find out the information (title, language, year and subject belonging to a given book description id.

The library provides a books.sql file containing the create table and the insert statements and a ERD document containing the ERD diagram of the database. (The database tables are extracted from web.cecs.pdx.edu/~lmd/cs386/LibraryDB.sql)

The architecture of the system has to be multi-tier; the clients use a GUI application, the application is running on a glassfish application server and the database on a MySQL server.

 

Goal state

Next interface illustrates the goal of this task:

application client Library enterprise applciation

In this example an id of 164 is given. When the user clicks on the button "Find all" the information of this book is shown.

 

Solution

The complete tutorial is provided by a tutorial. Please, perform this tutorial.
© Marco Marcellis 2009