alptium / healthcare

MIT License
0 stars 0 forks source link

Medicine DB #20

Open vasilijajoksimovic opened 6 years ago

vasilijajoksimovic commented 6 years ago

@SavovicGoran , Make a database schema (CREATE TABLE) script.

Read tutorials regarding Java JDBC e.g. http://www.mkyong.com/tutorials/jdbc-tutorials/ see section "Quick Start" and "JDBC & Statement".

Implement saving of new data (INSERT), e.g. after you've created a medicine object (or whatever other data is in your project), then save that into the corresponding DB table.

Implement retrieving data (SELECT), so that I have a menu option to see the list of all medicines (or whatever else is in your project).

Implement deleting data (DELETE), that I can for example select which medicine to delete, and then it's deleted from the DB.

Implement editing data (UPDATE), e.g. I select a medicine and change some of the doctor's data.

[BONUS] Read about ERD & foreign keys, make relationships between the data.