The objective of this project is to create a Java application that can take user input and store it into a persistence layer.
The application will allow users to display all stored people, add, update and delete. The database will have a simple table that stores a list of people.
Review commit tree here: commit tree
The objective with the Person System is to take user input, storing the following values: - first name - last name - age
This system allows users to create, read, update and delete stored entries in a singular SQL database table.
The objective for the "Note Tracker" system is to store notes that belong to groups in a similar fashion to folder-file relationship.
This system expresses one-to-many relationships from a java-sql interaction.
This database is built around an in memory database:
URL=jdbc:h2:mem:devdb
Connection is closed when application is closed, this is why DBAs only close ResultSets and Statements.
Note groups should store the following:
- Label - should generalise the purpose of notes stored within
Notes should store the following:
- Header - To summarise the contents
- Contents - To store all information the note contains
Objective List:
- Create a UI menu system
- User must be able to create a Person Object.
- Menu must loop until User exits application.
- Person System
- Store and Retrieve Person data from database
- CREATE
- READ
- UPDATE
- DELETE
- Store and Retrieve Person data from database
- Plan Note Tracker System
- Create ERD for Note Tracker
- Implement Note Tracker System
- Add Schema for NoteTracker
- Implement POJOs
- NoteGroups Model
- Note Model
- Implement Controllers
- NoteGroups - CRUD functionality
- Notes - CRUD functionality
- Implement UI Sub-Menu for NoteTracker