DBS-DU7

Java PostgreSQL Database CRUD Controller

Homework #7 for subject B0B36DBS on CTU in Prague

23.05.2018

Added seminar paper document for subject B6B36TS1 (Built on this homework)

Task

• Assignment:
  • ✔️Implement a simple desktop application in Java with JPA access to the database
  • ✔️ Create and annotate at least 2 entities and 1 relationship in between them
    • ✔️ Cardinality of this relationship must be @ManyToMany
  • ✔️ Allow for a complex processing of 1 of the selected entities
    • I.e. implement all the following CRUD use cases...
    • ✔️ CREATE: insertion of a new entity instance
    • ✔️ READ: browsing of a list of all entity instances
    • ✔️ UPDATE: modification of attributes of an existing entity instance
    • ✔️ DELETE: removal of an existing entity instance
  • ✔️ Allow for a complex processing of the selected relationship
    • I.e. implement all the following CRUD use cases...
    • ✔️ CREATE: insertion of a new relationship instance by choosing both the involved entity instances
    • ✔️ READ: browsing of a list of all related entity instances for a given entity instance
    • ✔️ DELETE: removal of an existing relationship instance
• Requirements:
  • ✔️Your application must have a graphical user interface (e.g. using Swing)
  • ✔️Use must connect to our server at ********** and only use your assigned database
  • It is insufficient to use just JDBC and not JPA
  • ✔️You may modify your database schema (from the third assignment) if necessary
  • ✔️Fill all the involved tables with sample realistic data (not necessarily from your application)
  • Comment your source files

Installation

• Clone project and open in Netbeans IDE
• Create PostgreSQL database and import all sql files from database schema
• Rename persistence.example.xml to persistence.xml
• Edit persistence.xml
• Launch Main.java

TO-DO

• Finish Persons in Banks tab
• Code cleanup
• Testing
• Comments