# SAMS **Repository Path**: lichuanwei0916/SAMS ## Basic Information - **Project Name**: SAMS - **Description**: 为弘扬全民健身运动，便于学校开展运动会，某高校拟委托开发一个运动会信息管理系统。 - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 4 - **Created**: 2023-04-26 - **Last Updated**: 2026-02-25 ## Categories & Tags **Categories**: Uncategorized **Tags**: 运动会管理系统, Java, javaWEB, 高校 ## README Based on the provided code map, I can see this is a comprehensive Sports Achievement Management System (SAMS). Let me create a detailed README.md for this project. # SAMS - 体育成就管理系统 (Sports Achievement Management System) [English](#english) | [中文](#中文) --- ## English ### Project Overview SAMS (Sports Achievement Management System) is a comprehensive web-based application for managing sports competitions, athlete registrations, scores, and results. The system supports multiple user roles including athletes, athlete leaders, referees, and head referees. ### Technology Stack - **Backend**: Java Servlet, JSP - **Database**: MySQL - **Frontend**: HTML, CSS, JavaScript (layui, wangEditor) - **Libraries**: Jackson JSON, Commons FileUpload ### System Architecture ``` SAMS/ ├── src/ │ ├── Main.java # Application entry point │ ├── controller/servlets/ # Servlet controllers │ ├── dao/ # Data Access Objects │ └── modle/ # Model classes ├── web/ │ ├── WEB-INF/ # Web configuration │ ├── jsp/ # JSP pages │ ├── javascript/ # JavaScript files │ ├── css/ # Stylesheets │ ├── lib/ # Third-party libraries │ └── img/ # Images ├── lib/ # JAR dependencies └── sams.sql # Database schema ``` ### User Roles 1. **Athlete (运动员)** - View schedules, register for events, check scores 2. **Athlete Leader (领队)** - Manage team registrations, approve records 3. **Referee (裁判)** - Input competition scores 4. **Head Referee (裁判长)** - Manage competitions, items, schedules, referees ### Key Features #### For Athletes - View competition schedules - Register for available events - Search signup items - Query personal grades/scores - Appeal grades #### For Athlete Leaders - Examine registration records - Approve or reject athlete registrations - Query team grades #### For Referees - View assigned competitions - Input athlete scores #### For Head Referees - Add/Edit/Delete competition items - Create competition schedules - Arrange referees for competitions - Release announcements - Review items ### Database The system uses MySQL database. Import the `sams.sql` file to create the database schema. ### Installation & Deployment 1. **Prerequisites** - Java JDK 8+ - Apache Tomcat 8+ - MySQL 5.7+ 2. **Database Setup** ```sql mysql -u root -p < sams.sql ``` 3. **Deploy to Tomcat** - Build the project as WAR file - Deploy to Tomcat's webapps directory - Configure database connection in `JDBCUtil.java` 4. **Access** - Open browser: `http://localhost:8080/SAMS/` ### Project Structure Details #### Servlets (Controller Layer) - `LoginServlet` - User authentication - `AddCompetitionInformationServlet` - Add competition info - `AddItemInformationServlet` - Add sport items - `SearchAthleteCompetitionInformationServlet` - Search athlete competitions - `InputAthleteScoresServlet` - Input scores - And more... #### DAO (Data Access Layer) - `AthleteInformationDao` - Athlete data operations - `CompetitionDao` - Competition management - `ItemInformationDao` - Item management - `SignUpRecordDao` - Registration records - And more... #### Models - `Athlete` - Athlete information - `CompetitionInformation` - Competition details - `ItemInformation` - Sport item details - `AthleteSignUpRecord` - Registration records - And more... ### License This project is for educational purposes. --- ## 中文 ### 项目简介 SAMS（体育成就管理系统）是一个基于Web的综合性体育赛事管理系统，用于管理体育比赛、运动员报名、成绩录入和查询。系统支持多种用户角色，包括运动员、领队、裁判和裁判长。 ### 技术栈 - **后端**: Java Servlet, JSP - **数据库**: MySQL - **前端**: HTML, CSS, JavaScript (layui, wangEditor) - **依赖库**: Jackson JSON, Commons FileUpload ### 系统架构 ``` SAMS/ ├── src/ │ ├── Main.java # 程序入口 │ ├── controller/servlets/ # Servlet控制器 │ ├── dao/ # 数据访问层 │ └── modle/ # 模型类 ├── web/ │ ├── WEB-INF/ # Web配置 │ ├── jsp/ # JSP页面 │ ├── javascript/ # JavaScript文件 │ ├── css/ # 样式表 │ ├── lib/ # 第三方库 │ └── img/ # 图片资源 ├── lib/ # JAR依赖包 └── sams.sql # 数据库脚本 ``` ### 用户角色 1. **运动员** - 查看赛程、报名比赛、查询成绩 2. **领队** - 管理团队报名、审核报名记录 3. **裁判** - 录入比赛成绩 4. **裁判长** - 管理比赛、项目、赛程、裁判安排 ### 主要功能 #### 运动员功能 - 查看比赛赛程 - 报名参赛项目 - 查询报名项目 - 查询个人成绩 - 成绩申诉 #### 领队功能 - 审核报名记录 - 批准/拒绝运动员报名 - 查询团队成绩 #### 裁判功能 - 查看执裁比赛 - 录入运动员成绩 #### 裁判长功能 - 添加/编辑/删除比赛项目 - 创建比赛赛程 - 安排裁判 - 发布公告 - 审核项目 ### 数据库配置 系统使用MySQL数据库。导入 `sams.sql` 文件创建数据库结构。 ### 安装部署 1. **环境要求** - Java JDK 8+ - Apache Tomcat 8+ - MySQL 5.7+ 2. **数据库设置** ```sql mysql -u root -p < sams.sql ``` 3. **部署到Tomcat** - 将项目打包为WAR文件 - 部署到Tomcat的webapps目录 - 在 `JDBCUtil.java` 中配置数据库连接 4. **访问系统** - 浏览器打开: `http://localhost:8080/SAMS/` ### 核心模块说明 #### Servlet控制器 - `LoginServlet` - 用户登录认证 - `AddCompetitionInformationServlet` - 添加比赛信息 - `AddItemInformationServlet` - 添加项目信息 - `SearchAthleteCompetitionInformationServlet` - 查询运动员比赛信息 - `InputAthleteScoresServlet` - 录入成绩 - 等多个Servlet处理不同业务... #### 数据访问层(DAO) - `AthleteInformationDao` - 运动员数据操作 - `CompetitionDao` - 比赛管理 - `ItemInformationDao` - 项目管理 - `SignUpRecordDao` - 报名记录管理 - 等多个DAO类... #### 实体模型 - `Athlete` - 运动员信息 - `CompetitionInformation` - 比赛信息 - `ItemInformation` - 项目信息 - `AthleteSignUpRecord` - 报名记录 - 等多个模型类... ### 许可证 本项目仅供学习交流使用。