PRAPRO2ENG.rst

Programming Laboratory

PROJECT

Project from the topics : JSON + XML + HIBERNATE

Create a program that will read and save a specific data model from/to file to/from database.

Each person has to think about what type of data he wants to store in the final application (information about people, movies, cars, footballers, computers, etc.). You should model this data by defining the tables, fields and the relationships between them.

20% points: The data must contain at least 5 tables, two OneToOne relationships and two OneToMany (or ManyToMany) relationships.

20% points: Exemplary data requests should be created for the data (preferably useful in the target project). You have to define at least 5 queries, each query should be a separate method in the code. One of the queries should be paginated.

15% points: Please use the date type field in the project - preferably ZonedDateTime or JodaTime (as this may cause a problem).

25% points: The target design should read and write modeled data from and into XML and JSON type files (both types!) And write / read them from the database.

20% points: It must also use a database not stored in memory, eg. PostgreQSL, MyQSL, ORACLE etc.

You do not need to create any menu for the project, execution can be done by defining the appropriate tests method (in test classes!) For scenarios: reading data from XML / JSON file and writing to the database, reading data from the database and writing to XML / JSON files. You must create the appropriate XML / JSON files for the above mentioned tests.

Attention! Read and write should properly execute in case of providing partial data (some empty fields) and fail if providing incorrect data.

Deadline for completion and presentation: 09.XII.2018. No postpone is possible.