简单学生管理系统.zip

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 本地 Source Server Type : MySQL Source Server Version : 50647 Source Host : 127.0.0.1:3306 Source Schema : test Target Server Type : MySQL Target Server Version : 50647 File Encoding : 65001 Date: 14/12/2020 18:57:03 */ drop database if exists test; create DATABASE test; use test; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for student -- ---------------------------- DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Sno` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学号', `Sname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名', `Ssex` bit(1) NULL DEFAULT NULL COMMENT '性别', `Stel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话', `Sage` int(255) NULL DEFAULT NULL COMMENT '年龄', `Sgrade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年级', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of student -- ---------------------------- INSERT INTO `student` VALUES (1, '11', '发的', b'1', '111', 23, '202001'); INSERT INTO `student` VALUES (3, '12', '22', b'0', '111', 22, '202001'); -- ---------------------------- -- Table structure for stusub -- ---------------------------- DROP TABLE IF EXISTS `stusub`; CREATE TABLE `stusub` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程号', `Sno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学号', `Achievement` decimal(18, 2) NULL DEFAULT NULL COMMENT '成绩', `Batch` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考试批次', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of stusub -- ---------------------------- INSERT INTO `stusub` VALUES (2, 'Mathematics', '11', 60.30, '20201101'); INSERT INTO `stusub` VALUES (4, 'ComputerApplication', '12', 60.90, '20200101'); -- ---------------------------- -- Table structure for subject -- ---------------------------- DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `id` int(11) NOT NULL AUTO_INCREMENT, `SubjectName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称', `SubjectCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程编码', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of subject -- ---------------------------- INSERT INTO `subject` VALUES (1, '英语', 'English'); INSERT INTO `subject` VALUES (2, '高等数学', 'Mathematics'); INSERT INTO `subject` VALUES (6, '计算机应用', 'ComputerApplication'); -- ---------------------------- -- Table structure for sys_log -- ---------------------------- DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `ID` int(20) NOT NULL AUTO_INCREMENT, `USERNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `OPERATION` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `TIME` int(11) NULL DEFAULT NULL, `METHOD` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `PARAMS` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `IP` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `CREATE_TIME` date NULL DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '阿的说法' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for userinfo -- ---------------------------- DROP TABLE IF EXISTS `userinfo`; CREATE TABLE `userinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `UserId` int(11) NULL DEFAULT NULL COMMENT '用户ID', `UserName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称', `UserPassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码', `IsAdmin` bit(1) NULL DEFAULT NULL COMMENT '是否管理员', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of userinfo -- ---------------------------- INSERT INTO `userinfo` VALUES (3, 4, '4', '4', b'0'); INSERT INTO `userinfo` VALUES (4, 44, '44', '44', b'0'); INSERT INTO `userinfo` VALUES (5, 3, '2', '2', b'0'); INSERT INTO `userinfo` VALUES (6, 1, 'admin', 'admin', b'1'); INSERT INTO `userinfo` VALUES (7, 66, '66', '34', b'0'); SET FOREIGN_KEY_CHECKS = 1;