基于jsp的学生成绩管理系统设计源程序代码及数据库

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80027 Source Host : localhost:3306 Source Schema : test Target Server Type : MySQL Target Server Version : 80027 File Encoding : 65001 Date: 27/11/2021 17:54:37 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `shenfen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES (1, 'admin', 'admin', 'guanliyuan'); -- ---------------------------- -- Table structure for banji -- ---------------------------- DROP TABLE IF EXISTS `banji`; CREATE TABLE `banji` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `nianji` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `banzhuren` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `renshu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`name`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of banji -- ---------------------------- INSERT INTO `banji` VALUES (1, '物联网五班', '2018级', '1', '61'); -- ---------------------------- -- Table structure for chengji -- ---------------------------- DROP TABLE IF EXISTS `chengji`; CREATE TABLE `chengji` ( `id` int(0) NOT NULL AUTO_INCREMENT, `xuesheng` int(0) NULL DEFAULT NULL, `kemu` int(0) NULL DEFAULT NULL, `shijian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fenshu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of chengji -- ---------------------------- INSERT INTO `chengji` VALUES (1, 1, 1, '2021-12-1', '96'); INSERT INTO `chengji` VALUES (2, 2, 1, '2021-12-1', '99'); INSERT INTO `chengji` VALUES (3, 3, 1, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (4, 4, 1, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (5, 5, 1, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (6, 6, 1, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (7, 7, 1, '2021-12-1', '97'); INSERT INTO `chengji` VALUES (8, 8, 1, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (9, 9, 1, '2021-12-1', '91'); INSERT INTO `chengji` VALUES (10, 10, 1, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (11, 11, 1, '2021-12-1', '91'); INSERT INTO `chengji` VALUES (12, 12, 1, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (13, 13, 1, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (14, 14, 1, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (15, 15, 1, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (16, 16, 2, '2021-12-1', '89'); INSERT INTO `chengji` VALUES (17, 17, 2, '2021-12-1', '90'); INSERT INTO `chengji` VALUES (18, 18, 2, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (19, 19, 2, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (20, 20, 2, '2021-12-1', '98'); INSERT INTO `chengji` VALUES (21, 21, 2, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (22, 22, 2, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (23, 23, 2, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (24, 24, 2, '2021-12-1', '91'); INSERT INTO `chengji` VALUES (25, 25, 2, '2021-12-1', '90'); INSERT INTO `chengji` VALUES (26, 26, 2, '2021-12-1', '88'); INSERT INTO `chengji` VALUES (27, 27, 2, '2021-12-1', '96'); INSERT INTO `chengji` VALUES (28, 28, 2, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (29, 29, 2, '2021-12-1', '88'); INSERT INTO `chengji` VALUES (30, 30, 2, '2021-12-1', '87'); INSERT INTO `chengji` VALUES (31, 31, 3, '2021-12-1', '89'); INSERT INTO `chengji` VALUES (32, 32, 3, '2021-12-1', '89'); INSERT INTO `chengji` VALUES (33, 33, 3, '2021-12-1', '90'); INSERT INTO `chengji` VALUES (34, 34, 3, '2021-12-1', '98'); INSERT INTO `chengji` VALUES (35, 35, 3, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (36, 36, 3, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (37, 37, 3, '2021-12-1', '90'); INSERT INTO `chengji` VALUES (38, 38, 3, '2021-12-1', '98'); INSERT INTO `chengji` VALUES (39, 39, 3, '2021-12-1', '96'); INSERT INTO `chengji` VALUES (40, 40, 3, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (41, 41, 3, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (42, 42, 3, '2021-12-1', '89'); INSERT INTO `chengji` VALUES (43, 43, 3, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (44, 44, 3, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (45, 45, 3, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (46, 46, 4, '2021-12-1', '98'); INSERT INTO `chengji` VALUES (47, 47, 4, '2021-12-1', '89'); INSERT INTO `chengji` VALUES (48, 48, 4, '2021-12-1', '90'); INSERT INTO `chengji` VALUES (49, 49, 4, '2021-12-1', '98'); INSERT INTO `chengji` VALUES (50, 50, 4, '2021-12-1', '97'); INSERT INTO `chengji` VALUES (51, 51, 4, '2021-12-1', '91'); INSERT INTO `chengji` VALUES (52, 52, 4, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (53, 53, 4, '2021-12-1', '93'); INSERT INTO `chengji` VALUES (54, 54, 4, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (55, 55, 4, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (56, 56, 4, '2021-12-1', '94'); INSERT INTO `chengji` VALUES (57, 57, 4, '2021-12-1', '87'); INSERT INTO `chengji` VALUES (58, 58, 4, '2021-12-1', '95'); INSERT INTO `chengji` VALUES (59, 59, 4, '2021-12-1', '92'); INSERT INTO `chengji` VALUES (60, 60, 4, '2021-12-1', '91'); INSERT INTO `chengji` VALUES (61, 61, 4, '2021-12-1', '91'); -- ---------------------------- -- Table structure for jiaoshi -- ---------------------------- DROP TABLE IF EXISTS `jiaoshi`; CREATE TABLE `jiaoshi` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `jiaoshihao` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `zhenname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `shenfen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`name`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE, UNIQUE INDEX `NewIndex1`(`jiaoshihao`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of jiaoshi -- ---------------------------- INSERT INTO `jiaoshi` VALUES (4, 'dufangfang', '555', 't5', '11', '女', 'laoshi'); INSERT INTO `jiaoshi` VALUES (1, 'sunhongwei', '111', 't1', '22', '男', 'laoshi'); INSERT INTO `jiaoshi` VALUES (2, 'wangyingtao', '222', 't2', '33', '女', 'laoshi'); INSERT INTO `jiaoshi` VALUES (3, 'yangqiang', '333', 't3', '44', '男', 'laoshi'); -- ---------------------------- -- Table structure for kecheng -- ---------------------------- DROP TABLE IF EXISTS `kecheng`; CREATE TABLE `kecheng` ( `id