Transcript Presentation

Soccer Record Net
Present by :
Lai, Yue Hang (Ugami)
Purpose





This program is doing the management of soccer
records in a well developed database
After the owner (Admin user) can use their recent data
to upload to the server easily and immediately
Provide a user-friendly interface for normal user and
admin user
Easy to manage
The normal user can use different search method to get
their desired data, statistic, etc..
Overview

For Admin User:

The database mainly separated to four parts
Player database
 Team database
 Competition database
 Match database


Give user a easy way to update the databases
Overview

Easy input of data


If user input a single match detail, the databases in Match,
Player, and History data will be updated
Easy update of the data for admin user

Clear and easy interface for user to search records that
want to be updated
Feature

Admin User
Add new competition/team/player/match details
 Edit competition/team/player/match details
 edit competition, team, player history
 edit the match status/data (Sub, Score, general data)
 Edit the team member, transfer player
 Add/edit a match report

Feature

Normal User
Search for statistic in different
competition/team/player …
 Get competition, team, player history
 Get the match status/data
 Search the best fit player



Search for player in different position, with height,
number of Match Played
Give user a flexible way to find the leaders with
different attributes
Technology






Java
JSP/Servlets
Apache Tomcat
MySQL
JSTL
Server System
Function

Admin User

Player database
Add new Player
 Edit Player Detail
 Manage the Transfer of Player
 Edit Player History


Relate Table:

PlayerProfile, PlayerHisory, PlayerPosition,
PositionPriority
Function

Admin User

Team database
Add new Team
 Edit Team Detail
 Edit Team History
 Edit Team’s Squad


Relate Table:

TeamProfile, TeamHisory, PlayerHistory
Function

Admin User

Competition database
Add new Competition
 Edit Competition Detail
 Edit Competition History


Relate Table:

Competition, CompetitionHisory, TopScorerTable
Function

Admin User

Match database
Add New Match
 Edit Match Detail
 Add Match Report
 Edit Match Report


Relate Table:

MatchDetail, InGameDetail, SubDetail, ScoreDetail,
PenaltyDetail, MatchReport, PlayerHistory
Function

Normal User

History
Competition
 Player History
 Team History
 Match History


Relate Table:

MatchDetail, InGameDetail, SubDetail, ScoreDetail,
MatchReport, PlayerHistory, TeamHistory, PlayerProfile,
TeamProfile, Competition, CompetitionHistory
Function

Normal User

Statistic

Competition Statistic






Division Statistic
Table of League
Top Scorer
Player Discipline
Fair Play
Team Statistic



Team‘s leaders
Result
Squad
Function

Normal User

Search for best player
Giving user a easy way to get a group of player out with
user specify condition
 Using the profile and history of player to search


Special Search

Giving user a way to find the leaders of different stats in
different league and in different period of time
Live Demo

http://cs.calstatela.edu:8080/cs491stu02/Login.
jsp