# dy-mcp-server

**Repository Path**: zhoukebin/dy-mcp-server

## Basic Information

- **Project Name**: dy-mcp-server
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-03-28
- **Last Updated**: 2026-04-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Student Grade Management System

## Project Overview
A Spring Boot 3.2 project using JDK 17, MyBatis-Plus, and MySQL for managing student grades.

## Tech Stack
- **JDK**: 17
- **Spring Boot**: 3.2.0
- **MyBatis-Plus**: 3.5.5
- **MySQL**: 8.0
- **Druid**: 1.2.20

## Project Structure
```
src/main/java/com/example/student/
├── controller/
│   └── StudentController.java      # REST API endpoints
├── service/
│   ├── StudentService.java         # Service interface
│   └── impl/
│       └── StudentServiceImpl.java # Service implementation
├── mapper/
│   └── StudentMapper.java          # MyBatis-Plus mapper
├── entity/
│   └── Student.java                # Database entity
├── dto/
│   └── StudentGradeDTO.java       # Data transfer object
└── StudentGradeApplication.java   # Main application
```

## API Endpoints

### 1. Query by Student ID
```
GET /api/student/grade/studentId/{studentId}
```
Returns single student grade info with average and rank.

### 2. Query by Name
```
GET /api/student/grade/name/{name}
```
Returns list of students matching the name.

### 3. Query by Student ID and Name
```
GET /api/student/grade?studentId=xxx&name=xxx
```
Returns students matching both criteria.

## Response Format
```json
{
  "code": 200,
  "message": "查询成功",
  "data": {
    "studentId": "2024001",
    "name": "张三",
    "className": "计算机科学与技术1班",
    "grades": {
      "数学": 95,
      "语文": 88,
      "英语": 92,
      "物理": 90,
      "化学": 87
    },
    "average": 90.4,
    "rank": 5
  }
}
```

## Setup Instructions

### 1. Initialize Database
```bash
mysql -u root -p < src/main/resources/sql/init.sql
```

### 2. Update Configuration
Edit `src/main/resources/application.yml` with your MySQL credentials:
```yaml
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/student_db
    username: your_username
    password: your_password
```

### 3. Build and Run
```bash
mvn clean install
mvn spring-boot:run
```

### 4. Access API
```
http://localhost:8080/api/student/grade/studentId/2024001
```

## Default Sample Data
| Student ID | Name | Class | Average | Rank |
|------------|------|-------|---------|------|
| 2024001 | 张三 | 计算机科学与技术1班 | 90.4 | 5 |
| 2024002 | 李四 | 计算机科学与技术1班 | 80.8 | 15 |
| 2024003 | 王五 | 计算机科学与技术2班 | 90.0 | 6 |
| 2024004 | 赵六 | 软件工程1班 | 86.0 | 10 |
| 2024005 | 钱七 | 软件工程1班 | 96.0 | 1 |
| 2024006 | 孙八 | 网络工程1班 | 73.6 | 25 |
| 2024007 | 周九 | 网络工程1班 | 88.0 | 8 |
| 2024008 | 吴十 | 数据科学1班 | 92.4 | 2 |