1 / 29

Flight Information Management System

Flight Information Management System. Chantelle Erasmus. Motivation. Learn about the client/server model with use of database How the client interacts with the server How server interacts with database. Goals. Create a client/server application with ability to:

Download Presentation

Flight Information Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Flight Information Management System Chantelle Erasmus

  2. Motivation • Learn about the client/server model with use of database • How the client interacts with the server • How server interacts with database

  3. Goals • Create a client/server application with ability to: • Display flight information to user depending on information requested • Only display information that user is authorized to view • Add/Update/Delete flight information if user has proper authorization

  4. Implementation Details • Use Java Swing for GUI • Use Java • Use Oracle database • Java Persistence API • Developed on Windows 7 • Netbeans IDE

  5. Client Design • Input is gathered from user through GUI • Has main thread for GUI and sending messages • Message sent to server requesting information • Has receive thread for receiving messages from server • Display information through GUI to user if applicable

  6. Server Design • Java Persistence API used for communication with the database • Has main thread for sending messages to client and Java Persistence API calls • Has receive thread for receiving messages from clients

  7. Database Design • Store all information about flights that may need to be accessed • Store user credentials and authorizations • Very basic; add more information in future

  8. Database Details

  9. SERVER Send() DATABASE CLIENTS JavaPersistence API Calls (Query) Receive() CLIENT SERVER • Main Thread • GUI Events • Sending messages to server • Main Thread • Sending messages to client • Java Persistence API calls Receive Thread - Receive messages from server Receive Thread - Receive messages from client

  10. EVENT_MSG(sent from client) • Client Id • Event type • Add (type 0) • Update (type 1) • Delete (type 2) • Query (type 3) • Login (type 4) • Data • If type 0-3, query to be executed • If type 4, credentials

  11. SERVER Send() DATABASE CLIENTS JavaPersistence API Calls (Query) Receive() CLIENT SERVER • Main Thread • GUI Events • Sending messages to server • Main Thread • Sending messages to client • Java Persistence API calls Receive Thread - Receive messages from server Receive Thread - Receive messages from client

  12. EVENT_MSG(sent from server) • Client Id • Event type • Add (type 0) • Update (type 1) • Delete (type 2) • Query (type 3) • Login (type 4) • Data • If type 0-2, return whole table • If type 3, result of executed query • If type 4, valid and admin privileges

  13. SERVER Send() DATABASE CLIENTS JavaPersistence API Calls (Query) Receive() CLIENT SERVER • Main Thread • GUI Events • Sending messages to server • Main Thread • Sending messages to client • Java Persistence API calls Receive Thread - Receive messages from server Receive Thread - Receive messages from client

  14. Basic User: Initial Screen

  15. Basic User: Find Gate Info.

  16. Basic User: Gate Info. Result

  17. Pilot: Login

  18. Pilot: Login Error

  19. Pilot: Initial Screen

  20. Pilot: Aircraft Type Error

  21. Pilot: Aircraft Type Info.

  22. Admin: Login

  23. Admin: Initial Screen

  24. Admin: Update Flight Info.

  25. Admin: Add Flight

  26. Admin: Add Flight Result

  27. Admin: Remove Flight

  28. Admin: Remove Flight Result

  29. Questions/Comments

More Related