map_detailed_design

map_detailed_design - CS102 Detailed Design Report Project...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
CS102 – Detailed Design Report Project Name : Due Date : The Traveller IQ Challenge 05 July 2010 Group ID : Section No : D 4 Instructors : Cengiz Çelik Volkan Yazıcı Group Members : Aybüke Duman Çağın Lenk Melih Çavuşculu Murat Gökhan Çabuker Zulal Aydın
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
1. Database Design 1.1 Score Table This table is necessary to save & show high scores. New high scores will be added to this table. Scoreid is key field of this table and it is also used to create new Score object by giving id parameter. Username field is necessary to save owner of the high scores. Score field is necessary to save score amount of the user. This table is also called the order of score descended. Figure 1 Score Table 1.2 Cities Table This table is storing the core of the game information. The cities that will be requested during the game, their coordinates on the map and their information texts are also available in this table. Figure 2 City Table
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2. Simple UML Design of Classes Figure 3 UML Design (x : “has a” relationship, - - indicates “uses” relationship)
Background image of page 4
3. Detailed Information about Classes Controller and view parts of the program are the same and named as Map class. Map class maintains visual effects and input / output control of the software. Score and RequestedCity classes are the data classes and they are maintains the background information flow with the mySql database. Connect class is also required for database connection and all the data classes are connect through static connect class which is implemented in the main class “Map”. Connect class properties + Connection: con Constructors + Connect (String url, String username, String password): // Opens a connection from MySQL database with the given parameters. Methods + update(String queryString) : void // executes given queryString in MySql database + executeQuery(String sql) : ResultSet // executes the given sql statement and returns resultset from database + closeConnection() : void // closes the database connection
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

map_detailed_design - CS102 Detailed Design Report Project...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online