# share

**Repository Path**: top_xiong/share

## Basic Information

- **Project Name**: share
- **Description**: 展示
- **Primary Language**: C++
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-05-30
- **Last Updated**: 2024-06-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# share

### 自动更新程序

通过qss QWdiget 实现的自动更新界面和http下载

![image-20240528232518431](README.assets/image-20240528232518431.png)



### 学生 GPA 管理计算程序

通过SQLite 管理和修改学生成绩,通过csv 导入导出

涉及到 教学管理员,教师,辅导员,学生本人 的不同功能

![](README.assets/image-20240629110117328.png)

```sqlite
-- 学分绩点转换视图
SELECT gr.student_id AS id,
       u1.name AS name,
       u1.class_id AS classID,
       gr.course_id AS courseID,
       cou.name AS coureName,
       cou.credits AS credit,
       gr.grade,
       ( (gr.grade - 50) / 10) AS GPA,
       gr.ranking AS rankingInClass
  FROM grades gr
       JOIN
       userInfo u1 ON (u1.account = gr.student_id),
       courses cou ON (gr.course_id = cou.id) 
 WHERE u1.isStudent = 1
 
 -- 平均绩点视图
SELECT id,
       sum(GPA * credit) / sum(credit) as avgGPA 
  FROM studentGrades st
 GROUP BY st.id
 
 -- 成绩班级排序视图
SELECT id AS id,
       row_number() OVER (PARTITION BY classID ORDER BY avgGPA DESC) AS rank
  FROM studentInfo
```