Python学生信息管理系统设计与实现.zip(论文+项目源码+使用说明书)

/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50532 Source Host : localhost:3306 Source Database : student Target Server Type : MYSQL Target Server Version : 50532 File Encoding : 65001 Date: 2021-01-10 15:09:36 */ DROP TABLE IF EXISTS student_k; CREATE TABLE student_k ( id char(20) NOT NULL, name char(20) DEFAULT NULL, gender char(5) DEFAULT NULL, age char(5) DEFAULT NULL, c_grade int DEFAULT NULL, e_grade int DEFAULT NULL, m_grade int DEFAULT NULL, Total int DEFAULT NULL, ave int DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of student_k -- ---------------------------- INSERT INTO student_k VALUES ('182085211003', 'a', '女', '22','80','80','80','240','80'); INSERT INTO student_k VALUES ('182085211004', 'b', '女', '18','80','80','80','240','80'); INSERT INTO student_k VALUES ('182085211005', 'abc', '男', '23','80','80','80','240','80'); -- Table user for user_login_k -- ---------------------------- DROP TABLE IF EXISTS user_login_k; CREATE TABLE user_login_k ( username char(20) NOT NULL, password char(20) DEFAULT NULL, type int , PRIMARY KEY (username) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user_login_k -- ---------------------------- INSERT INTO user_login_k VALUES ('182085211003', '123456',1); INSERT INTO user_login_k VALUES ('182085211004', '123456',1); INSERT INTO user_login_k VALUES ('182085211005', '123456',1); INSERT INTO user_login_k VALUES ('admin', 'admin',0); -- Table user for attendance -- ---------------------------- DROP TABLE IF EXISTS attendance; CREATE TABLE attendance ( id char(20) NOT NULL, date char(20) NOT NULL, course char(100) NOT NULL, state char(20) NOT NULL, PRIMARY KEY (id,date,course) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO attendance VALUES ('182085211004', '20210403','语文','早退'); INSERT INTO attendance VALUES ('182085211004', '20210402','数学','在勤'); INSERT INTO attendance VALUES ('182085211004', '20210401','语文','在勤'); INSERT INTO attendance VALUES ('182085211003', '20210403','数学','在勤'); INSERT INTO attendance VALUES ('182085211003', '20210402','数学','迟到');