search

alptium / airlines

Alptium Airlines
MIT License
0 stars 0 forks source link

Reservation DB #13

Open vasilijajoksimovic opened 6 years ago

vasilijajoksimovic commented 6 years ago

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 reservation 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 reservations (or whatever else is in your project). Implement deleting data (DELETE), that I can for example select which reservation to delete, and then it's deleted from the DB. Implement editing data (UPDATE), e.g. I select a doctor and change some of the data. [BONUS] Read about ERD & foreign keys, make relationships between the data.

vasilijajoksimovic commented 6 years ago

@lespabrandzulic82 See the task above :)

lespabrandzulic82 commented 6 years ago

Sorry, one question - do we have database or should we all create database on our localhost and create tables there - I am not sure about this part, how should we do it? Thanks. @vasilijajoksimovic

vasilijajoksimovic commented 6 years ago

@lespabrandzulic82 I'm not sure about that but I think we should create our databases.

lespabrandzulic82 commented 6 years ago

so, it means , each of us should create a database on our computer and work on it ? @vasilijajoksimovic

vasilijajoksimovic commented 6 years ago

@lespabrandzulic82 I think we should do that but I could ask Valantina.

lespabrandzulic82 commented 6 years ago

yes, maybe that is the best :) thanks. @vasilijajoksimovic

vasilijajoksimovic commented 6 years ago

@lespabrandzulic82 I wait an answer from Valentina. You've probably seen, I used the reservation class to create new constructor and used it on my reservation page and erased my reservation class.