# PracticalProject 

**Repository Path**: coderPlus-tr/practical-project

## Basic Information

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

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2020-11-09
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 需求分配
##  数据库表

```sql
create table player(
 id int primary key auto_increment,
 name varchar(100) not null,
 addr varchar(100) not null ,
 score int
)
```
## html(vue/jquery)

0. 显示选手界面 蔡华翔 
1. 评分界面 张恒
2. 显示成绩界面 林清松
3. 检查bug 程耿 
4. 检查bug 张春琳

## API
|路径|请求方式|参数|返回值|
|----|----|-----|----|
|./player-list.php|GET|无|[{"id":"1","name":"\u7a0b\u803f","score":null,"addr":"\u9a6c\u5bb6\u6c9f"},{"id":"2","name":"\u5f20\u6625\u7433","score":null,"addr":"\u6566\u714c\u804c\u4e1a\u6309\u6469\u5b66\u6821"},{"id":"3","name":"\u674e\u76f8\u708e","score":null,"addr":"\u6c5f\u82cf\u9756\u6c5f\u732a\u8089\u812f\u751f\u4ea7\u5730"}]|
|./set-score.php|GET|id(int query string),score(in query string)|{"code":4000,"message":"place input id"};{"code":4000,"message":"place input score"};{"code":4001,"message":"id not exists in db"};{"code":200,"message":"ok"}|
|./score-list.php|GET|无|[{"id":"1","name":"\u7a0b\u803f","score":"0","addr":"\u9a6c\u5bb6\u6c9f"},{"id":"2","name":"\u5f20\u6625\u7433","score":"0","addr":"\u6566\u714c\u804c\u4e1a\u6309\u6469\u5b66\u6821"},{"id":"3","name":"\u674e\u76f8\u708e","score":"0","addr":"\u6c5f\u82cf\u9756\u6c5f\u732a\u8089\u812f\u751f\u4ea7\u5730"}]|
## StudentNo And StudentName
|StudentNo|StudentName|
|-----|------|
|211806404|陶大锐|
|211806359|张春琳|
|211806311|程耿|
|211806301|蔡华翔|
|211806423|张恒|
|211806392|林清松|
|211806324|李相言|