# 学生评测系统

**Repository Path**: orianayin/student-evaluation-system

## Basic Information

- **Project Name**: 学生评测系统
- **Description**: 学生评测系统
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2023-07-03
- **Last Updated**: 2023-07-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 学生评测项目

**note:本地运行前调整application.yaml, inputInfoRunner中的数据库配置信息和文件上传的路径信息**

**运行系统后先登录Admin1管理员账号（用户名：01，密码：01），然后选择user excel文件导入用户信息，studentinfo excel文件导入学生信息，因为存在外键约束，请先导入用户信息再导入学生信息**

**远程部署请根据以下的信息建立数据库**

## 数据库信息

数据库名称：assessment_system
用户名：root
密码：xky1234567

### SQL语句

```SQL
# 建立数据库

create database assessment_system;

use assessment_system;

# 建立学生信息表、用户表、菜单表

CREATE TABLE assessment_system.`user` (
	id varchar(100) NOT null primary key,
	password varchar(100) NOT NULL,
	`type` enum('stu','stuwork','teacher') NOT NULL,
	name varchar(100) NOT NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.studentinfo (
	student_id varchar(100) NOT null primary key,
	name varchar(100) NOT NULL,
	volunteer_hour int NOT NULL,
	gpa double NOT null,
	foreign key(student_id) references `user`(id)
	on update cascade on delete cascade
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.`menu` (
	id int NOT null primary key auto_increment,
	`type` enum('stu','stuwork','teacher') NOT NULL,
	name varchar(100) NOT null,
	`path` varchar(100) not null,
	icon varchar(100) not null
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

# 在用户表中插入超级管理员、菜单表中插入菜单项

insert into `user` (id, password, `type`, name)
values ('01','01','stuwork','Admin1');

insert into `menu` (`type`, name, `path`, icon)
values ('stu', '成绩确认', '/stu/gpa', 'el-icon-success'),
('stu', '志愿时长确认', '/stu/volunteer', 'el-icon-success'),
('stu', '科研情况填写', '/stu/research', 'el-icon-edit'),
('stu', '骨干服务填写', '/stu/service', 'el-icon-edit'),
('stu', '社会实践填写', '/stu/practice', 'el-icon-edit'),
('stuwork', 'Excel导入用户信息', '/stu_work/excel_import_Users', 'el-icon-upload'),
('stuwork', 'Excel导入学生信息', '/stu_work/excel_import_StudentInfo', 'el-icon-upload'),
('stuwork', '查看当前评分', '/stu_work/all_score', 'el-icon-s-data'),
('stuwork', '查看当前状态', '/stu_work/all_status', 'el-icon-s-data'),
('teacher', '确认学生绩点', '/teacher/grade_audit', 'el-icon-success'),
('teacher', '确认学生志愿时长', '/teacher/volunteer_audit', 'el-icon-success'),
('teacher', '学术科研评分', '/teacher/research_confirm', 'el-icon-document-checked'),
('teacher', '社会实践评分', '/teacher/practice_confirm', 'el-icon-document-checked'),
('teacher', '骨干服务评分', '/teacher/service_confirm', 'el-icon-document-checked');

# 建立科研情况、骨干服务、社会实践三张大表

CREATE TABLE assessment_system.research (
	research_id int NOT null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	`date` varchar(100) NOT NULL,
	prize varchar(100) NOT NULL,
	place varchar(100) NOT NULL,
        foreign key(student_id) references studentinfo(student_id)
	on update cascade on delete cascade
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.service (
	service_id int not null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	`date` varchar(100) NOT NULL,
	job_name varchar(100) NOT NULL,
	job_content varchar(100) NOT NULL,
	`level` varchar(100) NOT NULL,
        foreign key(student_id) references studentinfo(student_id)
	on update cascade on delete cascade
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;

CREATE TABLE assessment_system.practice (
	practice_id int not null primary key auto_increment,
	student_id varchar(100) NOT NULL,
	organization varchar(100) NOT NULL,
	location varchar(100) NOT NULL,
	duration int NOT NULL,
	member_number int NOT NULL,
	job_content varchar(100) NOT NULL,
	online enum('yes','no') NOT NULL,
	prize_or_not enum('yes','no') NOT NULL,
	prize varchar(100) NULL,
        foreign key(student_id) references studentinfo(student_id)
	on update cascade on delete cascade
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4;
```