毕业设计__系友录ByJavaweb

置顶

羽凌fairy

已于 2022-04-15 20:35:09 修改

阅读量1.4k

点赞数 3

分类专栏：计算机文章标签： javaweb

于 2021-12-25 19:04:25 首次发布

本文链接：https://blog.csdn.net/qq_43760243/article/details/122146901

版权

这是一个基于JavaWeb的毕业设计，实现了登录、管理员、教师和学生的功能模块，包括信息管理、密码修改、数据导入等。管理员可以添加、修改和删除教师及学生信息，而教师和学生只能更新自己的个人信息和密码。项目在选课系统基础上进行了改进，增强了数据安全性。

摘要由CSDN通过智能技术生成

页面+数据库清单

在这里插入图片描述

数据库文件

复制文字保存成.sql文件然后在数据库管理软件里运行就行

/*
 Navicat MySQL Data Transfer

 Source Server         : bs
 Source Server Type    : MySQL
 Source Server Version : 50525
 Source Host           : localhost:3306
 Source Schema         : bs

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

 Date: 03/03/2022 23:00:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for excellent
-- ----------------------------
DROP TABLE IF EXISTS `excellent`;
CREATE TABLE `excellent`  (
  `sno` char(15) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `sname` char(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sclass` char(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `job` char(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sphone` char(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`sno`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of excellent
-- ----------------------------
INSERT INTO `excellent` VALUES ('20171103302', '曾小贤', '软工1701', '主持人', '');
INSERT INTO `excellent` VALUES ('20181103302', '陈龙', '计科对口1801', '', '');
INSERT INTO `excellent` VALUES ('20181103331', '宋泽辉', '计科对口1801', '太原理工大学', '');
INSERT INTO `excellent` VALUES ('20181103332', '王艳', '计科对口1801', '公务员/教师', '');

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login`  (
  `usertype` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `userid` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`userid`) USING BTREE,
  UNIQUE INDEX `userid`(`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of login
-- ----------------------------
INSERT INTO `login` VALUES ('管理员', '000', '000');
INSERT INTO `login` VALUES ('教师', '10000', '10000');
INSERT INTO `login` VALUES ('教师', '10001', '10001');
INSERT INTO `login` VALUES ('教师', '10002', '10002');
INSERT INTO `login` VALUES ('教师', '10003', '10003');
INSERT INTO `login` VALUES ('教师', '10004', '10004');
INSERT INTO `login` VALUES ('教师', '10005', '10005');
INSERT INTO `login` VALUES ('教师', '10006', '10006');
INSERT INTO `login` VALUES ('教师', '10007', '10007');
INSERT INTO `login` VALUES ('教师', '10008', '10008');
INSERT INTO `login` VALUES ('教师', '10009', '10009');
INSERT INTO `login` VALUES ('教师', '10010', '10010');
INSERT INTO `login` VALUES ('教师', '10011', '10011');
INSERT INTO `login` VALUES ('教师', '10012', '10012');
INSERT INTO `login` VALUES ('教师', '10013', '10013');
INSERT INTO `login` VALUES ('教师', '10014', '10014');
INSERT INTO `login` VALUES ('教师', '10015', '10015');
INSERT INTO `login` VALUES ('教师', '10016', '10016');
INSERT INTO `login` VALUES ('教师', '10017', '10017');
INSERT INTO `login` VALUES ('教师', '10018', '10018');
INSERT INTO `login` VALUES ('教师', '10019', '10019');
INSERT INTO `login` VALUES ('学生', '20161103301', '20161103301');
INSERT INTO `login` VALUES ('学生', '20171103302', '20171103302');
INSERT INTO `login` VALUES ('学生', '20181103302', '20181103302');
INSERT INTO `login` VALUES ('学生', '20181103303', '20181103303');
INSERT INTO `login` VALUES ('学生', '20181103304', '20181103304');
INSERT INTO `login` VALUES ('学生', '20181103305', '20181103305');
INSERT INTO `login` VALUES ('学生', '20181103307', '20181103307');
INSERT INTO `login` VALUES ('学生', '20181103309', '20181103309');
I