alptium / airlines

Alptium Airlines
MIT License
0 stars 0 forks source link

Client DB #14

Open vasilijajoksimovic opened 6 years ago

vasilijajoksimovic commented 6 years ago

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