研究生预调剂管理系统的设计与实现(论文+源码)_jsp_226

类似学校里面的调剂系统，首先要有学生的注册和登录功能，学生在登录之后有个表单能够填写考试的有关信息。
老师不用注册，账号直接存放在数据库里，登录之后的界面是类似一个表格，能看到学生的所有信息，再根据不同的单科成绩和总成绩进行筛选，并对选中的学生发送邮件通知，并且把这些选中的学生的信息导出成表格。
学生要填写的信息有：外语成绩，政治成绩，业务课1成绩，业务课2成绩，毕业院校，毕业专业，报考院校，报考专业，邮箱。
 

数据库脚本如下：

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50638
 Source Host           : localhost:3306
 Source Schema         : dispensing

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

 Date: 17/03/2020 23:38:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for email
-- ----------------------------
DROP TABLE IF EXISTS `email`;
CREATE TABLE `email`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sendserver` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sendport` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `emailpsd` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of email
-- ----------------------------
INSERT INTO `email` VALUES (1, '15624181999@163.com', 'smtp.163.com', '25', 'gzq123456');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `post` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `isadmin` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `major` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `classes` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `wcollege` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `wmajor` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `score1` decimal(18, 2) NULL DEFAULT NULL,
  `score2` decimal(18, 2) NULL DEFAULT NULL,
  `score3` decimal(18, 2) NULL DEFAULT NULL,
  `score4` decimal(18, 2) NULL DEFAULT NULL,
  `sumscore` decimal(18, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, NULL, 'admin', '123', '超管', '444', '123', NULL, NULL, '2222', '0', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00);
INSERT INTO `user` VALUES (41, NULL, '2', '2', '2', '2020-03-10', '2', '男', '2', '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (43, '123', 'stu', '123', '1123', '2020-03-01', '123', '男', NULL, '547850771@qq.com', '2', '已发送', '123', '123', NULL, '123', '123', 50.00, 60.00, 70.00, 80.00, 260.00);
INSERT INTO `user` VALUES (44, '11111', 'stu1', '123', 'ceshi', '2020-04-06', '111', '男', NULL, '547850771@qq.com', '2', '已发送', 'ceshi', 'ceshi', NULL, 'ceshi', 'ceshi', 70.00, 68.00, 69.00, 70.00, 277.00);
INSERT INTO `user` VALUES (45, NULL, 'tea', '123', 'laoshi', '2020-03-02', '123', '男', '123', '123', '1', '未发送', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (46, '0000001', 'student', '123', '测试学生', '2020-03-01', '1234', '女', NULL, '547850771@qq.com', '2', '已发送', '测试学校', '测试专业', NULL, '财经', '123', 100.00, 80.00, 60.00, 64.00, 304.00);
INSERT INTO `user` VALUES (47, '00012312', 'stu2', '123', 'ceshi lindao123', '2020-03-01', '123', '男', NULL, '547850771@qq.com', '2', '未发送', '123', '1', NULL, '1', '1', NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;