22-05-2014, 04:59 PM
Design and Implementation of a Sport Results Management System Using an Object Oriented Approach
Design and Implementation .pdf (Size: 264.1 KB / Downloads: 13)
Abstract
This chapter describes about brief introduction and objectives of the software as well as the
scope and nature of the software are also be demonstrated.
The storing outcomes of the any kind of sports game manually is a quite difficult task. Time
could be also another issue for manual system. Also there is a risks of data loss or data
damage So keeping in mind that what could be the easiest way of storing data outcomes of
sports matches, this software product has been develop which has all the required
functionalities like adding, deleting, updating, finding and also the back up. The main
purpose of backup is to protect the data outcomes from any kind of damage or loss.
The software product named Sports Results Management System is developed in Java with JDBC
interface which helps to connect the java program with the database system. The screen layout of
the system is in simple GUI based frame. The reason for choosing GUI frame instead of DOS screen is
that it gives the more user friendly benefit to the users like user can easily edit the records; easily
change the size of the frame and so on. To develop this software, the object oriented approach of
software development methodology has been followed. This system has an easy access to the any
type of user. This system does not have any Login details so any types of user have easy access to
the system any time
Introduction
Managing the results produced from every game being played is very important for future
purposes. There has been always a risk of data loss because of lack of proper storage
technique in sports. For example in football, many games are being played every day and
different types of outcome emerge out from these matches. But these results are not being
preserved properly because of lack of appropriate data management techniques. The data
management tools are helpful to evaluate the performance of the teams
This project aims to develop a simple graphical user interface based sport results management
system (Java program linked to database through JDBC- ODBC driver) which stores, updates,
searches game results. The system also does back up to avoid the risk of data loss in future.
Sports results Management System
Sports results management system is software which has functionalities to store, edit so on
the results of the any games. Grattan (2001) describes results management system as a tool of managing sports outcomes on its own or it can be a part of sports management system along with game staffing and volunteer management, materials management, competition schedule management. However Warner (2005), describes result management system as a performance evaluation tool which analyse the results details stored in the system database table and find out the best team among them.
Java database Connectivity
Sports results management system is the software combination of program written in
programming language which is linked with the database system. So question comes, how
the Java program can be linked with the database. So from the research JDBC is the one of
the tools for java database connection. Various authors and articles have demonstrated JDBC
on their own way.
SportsResultsDAO class
This class is related to the database connection and SQL related queries. SportsResultsDAO
help to connect the java program with the database in Access using class driver and DSN
source file name. It has five methods related to database queries which are addResults (),
updateResults (), deleteResults (), searchResults () and backup ().
1. addResults (): This method has contained the query related to the addition of record in to
database tables. This method insert the records like Game No, Play Date, Home team, Away
team, final score and result of the game in to the specific database table columns. When the
message is passed with the values of the entire variable which are also the column names in
database, this method store all these data to the respective fields in the database.