StudentApp/StudentSystem.sql at main · Ganxy03/StudentApp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
-- MySQL dump 10.13  Distrib 8.0.32, for Win64 (x86_64)
--
-- Host: 124.221.138.245    Database: train_student
-- ------------------------------------------------------
-- Server version	5.7.40-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `grade`
--

DROP TABLE IF EXISTS `grade`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `学号` varchar(45) DEFAULT NULL,
  `名字` varchar(45) DEFAULT NULL,
  `性别` varchar(45) DEFAULT NULL,
  `班级` varchar(45) DEFAULT NULL,
  `修读课程` int(11) DEFAULT NULL,
  `未通过课程` int(11) DEFAULT NULL,
  `修读学分` decimal(15,2) DEFAULT NULL,
  `获得学分` decimal(15,2) DEFAULT NULL,
  `绩点` decimal(15,2) DEFAULT NULL,
  `学分绩点` decimal(15,2) DEFAULT NULL,
  `平均学分绩点` decimal(15,2) DEFAULT NULL,
  `加权平均成绩` decimal(15,2) DEFAULT NULL,
  `平均成绩` decimal(15,2) DEFAULT NULL,
  `总成绩` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grade`
--

LOCK TABLES `grade` WRITE;
/*!40000 ALTER TABLE `grade` DISABLE KEYS */;
INSERT INTO `grade` VALUES (2,'202280310302','陈凯乐','女','22级计算机应用技术-3',15,0,41.50,41.50,60.50,171.75,4.14,91.37,90.29,1354.30),(4,'202280310307','王欣宇','女','22级计算机应用技术-3',15,0,41.50,41.50,57.90,160.15,3.86,88.61,88.58,1328.70),(6,'202280310313','朱博杭','男','22级计算机应用技术-3',15,0,41.50,41.50,57.40,160.25,3.86,88.58,88.17,1322.60),(7,'202280310310','彭清玄','女','22级计算机应用技术-3',15,0,41.50,41.50,57.20,159.25,3.84,88.25,88.01,1320.20),(8,'202280310304','李泽菁','女','22级计算机应用技术-3',15,0,41.50,41.50,56.80,154.85,3.73,87.22,87.76,1316.40),(10,'202280310317','单宇鹏','男','22级计算机应用技术-3',15,0,41.50,41.50,56.30,153.70,3.70,86.92,87.40,1311.00),(11,'202208540343','罗顺利','男','22级计算机应用技术-3',15,0,41.50,41.50,55.50,155.20,3.74,87.43,86.97,1304.50),(12,'202280310326','李润发','男','22级计算机应用技术-3',15,0,41.50,41.50,55.10,148.30,3.57,85.66,86.67,1300.10),(13,'202230860150','张家举','男','22级计算机应用技术-3',15,0,41.50,41.50,55.10,151.30,3.65,86.36,86.59,1298.90),(14,'202280319998','黄家祥','男','22级计算机应用技术-3',15,0,41.50,41.50,54.70,149.55,3.60,86.04,86.44,1296.60),(15,'202280310308','张亚楠','女','22级计算机应用技术-3',15,0,41.50,41.50,54.30,148.10,3.57,85.64,86.13,1291.90),(16,'202280310305','龚晨曦','女','22级计算机应用技术-3',15,0,41.50,41.50,54.40,147.70,3.56,85.33,86.01,1290.20),(17,'202280310345','王文涛','男','22级计算机应用技术-3',15,0,41.50,41.50,53.50,141.50,3.41,84.04,85.57,1283.60),(18,'202280310335','刘浩宇','男','22级计算机应用技术-3',15,0,41.50,41.50,53.00,140.80,3.39,83.84,85.23,1278.40),(19,'2022803120350','高猛猛','男','22级计算机应用技术-3',15,0,41.50,41.50,52.80,140.45,3.38,83.80,85.13,1277.00),(20,'202280310341','卢家列','男','22级计算机应用技术-3',15,0,41.50,41.50,52.90,140.55,3.39,83.73,85.12,1276.80),(21,'202280310329','王子浩','男','22级计算机应用技术-3',15,1,41.50,37.00,52.60,137.40,3.31,83.24,85.10,1276.50),(22,'202280310309','陈慧瑗','女','22级计算机应用技术-3',15,0,41.50,41.50,52.40,143.85,3.47,84.53,84.79,1271.80),(23,'202240860128','许彪峰','男','22级计算机应用技术-3',15,0,41.50,41.50,52.30,145.45,3.50,84.90,84.75,1271.30),(24,'202280310346','金家辉','男','22级计算机应用技术-3',15,0,41.50,41.50,52.10,137.85,3.32,83.23,84.71,1270.60),(25,'202280310320','纵浩','男','22级计算机应用技术-3',15,0,41.50,41.50,52.20,138.10,3.33,83.15,84.65,1269.80),(26,'202280310325','王小庆','男','22级计算机应用技术-3',15,0,41.50,41.50,51.40,138.55,3.34,83.40,84.27,1264.00),(27,'202280310316','朱引航','男','22级计算机应用技术-3',15,0,41.50,41.50,51.30,138.90,3.35,83.48,84.18,1262.70),(28,'202280310318','李家辉','男','22级计算机应用技术-3',15,0,41.50,41.50,51.30,136.05,3.28,82.77,84.17,1262.60),(29,'202280310336','程家宝','男','22级计算机应用技术-3',15,1,41.50,37.00,50.50,131.20,3.16,81.83,83.75,1256.30),(30,'202280310343','魏鹏','男','22级计算机应用技术-3',15,0,41.50,41.50,49.60,131.25,3.16,81.43,82.89,1243.40),(31,'202280310347','张建琳','男','22级计算机应用技术-3',15,0,41.50,41.50,49.40,129.30,3.12,81.07,82.83,1242.50),(32,'202280310340','余志强','男','22级计算机应用技术-3',15,0,41.50,41.50,49.50,130.90,3.15,81.35,82.81,1242.20),(33,'202280310338','童浩','男','22级计算机应用技术-3',15,1,41.50,37.00,49.60,128.65,3.10,80.64,82.78,1241.70),(34,'202280310334','陶仁辉','男','22级计算机应用技术-3',15,0,41.50,41.50,49.30,126.30,3.04,80.31,82.75,1241.20),(35,'202280310348','韩聪','男','22级计算机应用技术-3',15,0,41.50,41.50,48.90,129.95,3.13,81.27,82.56,1238.40),(36,'202280310349','魏永强','男','22级计算机应用技术-3',15,0,41.50,41.50,48.60,128.60,3.10,80.94,82.29,1234.40),(37,'202280310344','朱军杰','男','22级计算机应用技术-3',15,0,41.50,41.50,48.60,125.10,3.01,80.04,82.28,1234.20),(38,'202280310324','李杰','男','22级计算机应用技术-3',15,1,41.50,37.00,47.80,124.40,3.00,79.90,81.76,1226.40),(39,'202280310327','朱锴','男','22级计算机应用技术-3',15,0,41.50,41.50,47.80,126.15,3.04,80.16,81.61,1224.10),(40,'202280310303','陈雪晴','女','22级计算机应用技术-3',15,0,41.50,41.50,47.20,119.90,2.89,78.79,81.34,1220.10),(41,'202280380151','黄耀东','男','22级计算机应用技术-3',15,1,41.50,37.00,46.20,117.35,2.83,79.03,81.26,1218.90),(42,'202280310332','王争鸣','男','22级计算机应用技术-3',15,0,41.50,41.50,46.80,126.05,3.04,80.44,81.23,1218.50),(43,'202280310342','林家骏','男','22级计算机应用技术-3',15,1,41.50,37.00,46.00,114.20,2.75,78.28,81.10,1216.50),(44,'202280310339','杨浩','男','22级计算机应用技术-3',15,1,41.50,37.00,45.90,115.75,2.79,78.33,80.85,1212.70),(45,'202280310322','刘孟强','男','22级计算机应用技术-3',15,0,41.50,41.50,46.30,124.65,3.00,79.98,80.80,1212.00),(46,'202280310306','吴雨馨','女','22级计算机应用技术-3',15,0,41.50,41.50,46.30,121.15,2.92,79.03,80.73,1210.90),(47,'202280310315','蒋豪进','男','22级计算机应用技术-3',15,1,41.50,37.00,45.50,119.35,2.88,79.35,80.69,1210.30),(48,'202280310333','宋坤华','男','22级计算机应用技术-3',15,0,41.50,41.50,46.00,120.25,2.90,78.98,80.67,1210.00),(49,'202280310321','吴德豪','男','22级计算机应用技术-3',15,0,41.50,41.50,46.00,118.40,2.85,78.50,80.58,1208.70),(50,'202280310330','李肖辉','男','22级计算机应用技术-3',15,1,41.50,37.00,45.70,116.55,2.81,77.87,80.33,1205.00),(51,'202280310337','吴俊隆','男','22级计算机应用技术-3',15,2,41.50,33.00,46.20,114.35,2.76,76.91,80.28,1204.20),(52,'202280310323','韦彭','男','22级计算机应用技术-3',15,1,41.50,37.50,46.80,120.70,2.91,77.78,80.25,1203.70),(53,'202280310331','黄坤龙','男','22级计算机应用技术-3',15,0,41.50,41.50,45.30,116.40,2.80,77.94,80.07,1201.00),(54,'202280320115','王勇','男','22级计算机应用技术-3',15,1,41.50,37.00,44.40,111.30,2.68,76.80,79.53,1192.90),(55,'2022803120899','王若霖','男','22级计算机应用技术-3',15,0,41.50,41.50,43.80,111.10,2.68,76.65,79.05,1185.80),(56,'202280310319','石宇','男','22级计算机应用技术-3',15,1,41.50,37.00,39.80,94.85,2.29,73.67,77.03,1155.40),(57,'202280310314','张小果','男','22及计应3',8,5,2.00,2.00,1.00,2.00,0.00,123.00,200.00,1220.00);
/*!40000 ALTER TABLE `grade` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `pwd` varchar(45) DEFAULT NULL,
  `time` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Ganxy','123456',NULL),(2,'gxy','123456',NULL),(3,'ganxy','123456',NULL),(4,'ganxy233','123456',NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-01-01 17:09:55