python+SQL sever+thinter学生宿舍管理系统

一、系统介绍

系统主要功能学生信息管理、管理员信息管理、核酸信息管理等。

二、功能展示

1.主页

2.用户登陆

3.学生信息

三、数据库

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : studentinfo

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 23/11/2022 16:47:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_login_k
-- ----------------------------
DROP TABLE IF EXISTS `admin_login_k`;
CREATE TABLE `admin_login_k`  (
  `admin_id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `admin_pass` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin_login_k
-- ----------------------------
INSERT INTO `admin_login_k` VALUES ('admin', 'admin');

-- ----------------------------
-- Table structure for stu_login_k
-- ----------------------------
DROP TABLE IF EXISTS `stu_login_k`;
CREATE TABLE `stu_login_k`  (
  `stu_id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `stu_pass` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`stu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stu_login_k
-- ----------------------------
INSERT INTO `stu_login_k` VALUES ('182085211000', '123456');

-- ----------------------------
-- Table structure for student_k
-- ----------------------------
DROP TABLE IF EXISTS `student_k`;
CREATE TABLE `student_k`  (
  `id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gender` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student_k
-- ----------------------------
INSERT INTO `student_k` VALUES ('182085211000', 'a', '女', '22');
INSERT INTO `student_k` VALUES ('182085211004', 'b', '女', '18');
INSERT INTO `student_k` VALUES ('182085211005', 'abc', '男', '23');
INSERT INTO `student_k` VALUES ('182085211006', 'abc', '女', '24');
INSERT INTO `student_k` VALUES ('182085211008', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211009', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211010', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211011', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('1820852110111', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211012', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211013', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211014', 'Tom2', '男', '23');
INSERT INTO `student_k` VALUES ('182085211015', 'Tom1', '男', '23');
INSERT INTO `student_k` VALUES ('182085211016', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211017', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211018', 'Tom', '男', '20');
INSERT INTO `student_k` VALUES ('182085211019', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211020', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211021', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('1820852110211', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211022', 'Tom1', '男', '23');
INSERT INTO `student_k` VALUES ('182085211023', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211024', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211034', 'Tom', '男', '23');

-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course`  (
  `SNO` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `COURSE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREDIT` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `GRADE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_course
-- ----------------------------
INSERT INTO `t_course` VALUES ('08300205', '程序设计', '4', '88');
INSERT INTO `t_course` VALUES ('08300205', '数据库', '2.5', '90');
INSERT INTO `t_course` VALUES ('08300205', '力学', '5', '92');
INSERT INTO `t_course` VALUES ('08080929', '数据库', '2.5', '85');
INSERT INTO `t_course` VALUES ('09350124', '数据库', '2.5', '92');
INSERT INTO `t_course` VALUES ('09620233', '数据库', '2.5', '80');
INSERT INTO `t_course` VALUES ('09300218', '数据库', '2.5', '78');
INSERT INTO `t_course` VALUES ('09010122', '数据库', '2.5', '87');
INSERT INTO `t_course` VALUES ('08080929', '程序设计', '4', '86');
INSERT INTO `t_course` VALUES ('09010122', '程序设计', '4', '80');
INSERT INTO `t_course` VALUES ('08300516', '程序设计', '4', '76');

-- ----------------------------
-- Table structure for t_st
-- ----------------------------
DROP TABLE IF EXISTS `t_st`;
CREATE TABLE `t_st`  (
  `SNO` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SNAME` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SSEX` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AGE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DEPT` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SNO`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_st
-- ----------------------------
INSERT INTO `t_st` VALUES ('08080929', '刘超世', '男', '19', '计算机应用技术');
INSERT INTO `t_st` VALUES ('08300205', '李媛媛', '女', '19', '软件工程');
INSERT INTO `t_st` VALUES ('09300218', '王海超', '男', '19', '软件工程');
INSERT INTO `t_st` VALUES ('09350124', '王彤', '女', '19', '通信原理');
INSERT INTO `t_st` VALUES ('09620233', '陈晓丽', '女', '21', '通信工程');

SET FOREIGN_KEY_CHECKS = 1;


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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140

四、其它

1.其他系统实现

Java+Swing实现学生选课管理系统
Java+Swing实现学校教务管理系统
Java+Swing+sqlserver学生成绩管理系统
Java+Swing用户信息管理系统
Java+Swing实现的五子棋游戏
基于JavaSwing 银行管理系统
Java+Swing+mysql仿QQ聊天工具
Java+Swing 聊天室
Java+Swing+dat文件存储实现学生选课管理系统
Java+Swing可视化图像处理软件
Java+Swing学生信息管理系统
Java+Swing图书管理系统
Java+Swing图书管理系统2.0
基于java+swing+mysql图书管理系统3.0
大作业-基于java+swing+mysql北方传统民居信息管理系统

五、 获取源码

点击下载
python+SQL sever+thinter学生宿舍管理系统