Point Of Sale system Java Application with JDBC and full source code.ZIP

Point Of Sale system Java Application with JDBC and full source code

The Task
You will need to develop a JavaFX Application which connects to a Database and makes use of the JDBC API.

The Scenario
See the ERD diagram given in Figure 1. You are asked to create a Point Of Sale system. The application should be JavaFX based. For the database, you can use your choice of RDBMS (e.g. Java DB, MySQL etc.).

The application should have the following functionalities:
- Create the six tables shown on the diagram.
- Simulate a point of sale (A transaction header is a sale. A transaction item is an item in a sale). The flow of a sale is as follows:

  • Employee enters his id and start transaction

  • The employee adds a Product ID. The system will pick the product price according to the effective date.

  • The employee will add the quantity.

  • The system will calculate the subtotal.

  • The system will loop until employee exits (may or may not start a new transaction.

  • Calculate total

  • Transaction header and items are created (you should identify what fields go into this, e.g. customer details, product details, price etc.).

  • Record the transaction. When creating sale you can use SQL Transaction, commit and rollback.

Powered by