Skip to content

Database "CRUD" Functionalities for the Time Scheduler App.

Notifications You must be signed in to change notification settings

HatimDa/OnTime-CRUD

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 

Repository files navigation

CRUD Operations for the Time Scheduler App


Setup and Requirements:

  1. IDE : Inteliji

  2. JDK Version Used on the Project (v15) , it's a must to use this version otherwise you will receive problem with mysql connector

  3. 👇🏽 Hibernate Library + MySQL Connector

(https://drive.google.com/drive/folders/1mak3fOojSJhwfHLNnfRCnFtx_nUON9Ky?usp=sharing)


Architecture:

  • The decision behind using Hibernate Framework because it will save us a lot of time and lines of code for mapping our DB to the Java Code it will minimise the amount of sql code we should write to insert or retrieve an object from the db.

Hibernate - Java Architecture

  • Hibernate provides the Object-to-Relational Mapping (ORM) We tell hibernate how our Java Class or Object maps to the Data inside the Database, we gonna map our Class into a given Database Table. We can setup this mapping via a config file like XML or Java Annotations but i used the java annotation for the mapping

DB Mapping

  • All Tables should be mapped to the Database to perform the CRUD Functionalities - (EER Diagram)

EER Diagram for the Time Scheduler


  • All the CRUD functionalities are on the package "com.ontime.crudoperations"
  • The Mapping on the other hand is on "com.ontime.dbmapping" only for the User table ,the others are on the way.

Mapping

About

Database "CRUD" Functionalities for the Time Scheduler App.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages