jsp ssm 学生选课系统 在线选课 高校选课管理 项目源码 web java【项目源码+数据库脚本+项目说明+软件工具】毕设

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50639 Source Host : localhost:3306 Source Schema : schoolsystem Target Server Type : MySQL Target Server Version : 50639 File Encoding : 65001 Date: 26/03/2023 22:42:28 */ drop database if exists schoolsystem; create database schoolsystem charset utf8; use schoolsystem; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_num` varchar(255) DEFAULT NULL, `admin_name` varchar(255) DEFAULT NULL, `admin_password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of admin -- ---------------------------- BEGIN; INSERT INTO `admin` VALUES (1, 'admin', '管理员', 'admin'); COMMIT; -- ---------------------------- -- Table structure for clazz -- ---------------------------- DROP TABLE IF EXISTS `clazz`; CREATE TABLE `clazz` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clazz_name` varchar(255) DEFAULT NULL, `clazz_major_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of clazz -- ---------------------------- BEGIN; INSERT INTO `clazz` VALUES (1, '计算机科学与技术2班', 3); INSERT INTO `clazz` VALUES (2, '物联网1班', 3); INSERT INTO `clazz` VALUES (3, '日语141', 6); INSERT INTO `clazz` VALUES (4, '热动141', 4); INSERT INTO `clazz` VALUES (5, '热动142', 4); INSERT INTO `clazz` VALUES (6, '软件工程2班', 3); INSERT INTO `clazz` VALUES (7, '计算机科学与技术1班', 3); INSERT INTO `clazz` VALUES (8, '环艺141', 5); INSERT INTO `clazz` VALUES (9, '能动142', 4); INSERT INTO `clazz` VALUES (10, '物联网2班', 3); INSERT INTO `clazz` VALUES (11, '日语142', 6); INSERT INTO `clazz` VALUES (12, '软件工程1班', 3); INSERT INTO `clazz` VALUES (13, '信计143', 3); INSERT INTO `clazz` VALUES (14, '能动141', 4); COMMIT; -- ---------------------------- -- Table structure for course -- ---------------------------- DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `id` int(11) NOT NULL AUTO_INCREMENT, `course_name` varchar(255) DEFAULT NULL, `course_teacherid` int(11) DEFAULT NULL, `course_weekday` int(255) DEFAULT NULL COMMENT '1-7', `course_time` int(11) DEFAULT NULL COMMENT '1-5', `course_place` varchar(255) DEFAULT NULL, `course_type` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of course -- ---------------------------- BEGIN; INSERT INTO `course` VALUES (1, '高等数学', 2, 1, 2, '333', 1); INSERT INTO `course` VALUES (2, '大学物理', 1, 1, 1, '301', 1); INSERT INTO `course` VALUES (3, 'Spring框架技术', 1, 2, 5, '301', 2); INSERT INTO `course` VALUES (4, '毛泽东思想概论', 1, 1, 5, '301', 1); INSERT INTO `course` VALUES (5, '大学英语', 1, 3, 3, '301', 1); INSERT INTO `course` VALUES (6, '日语进阶', 1, 2, 1, '301', 1); INSERT INTO `course` VALUES (7, 'MyBatis技术', 1, 4, 1, '301', 1); INSERT INTO `course` VALUES (8, 'MySQL数据库技术', 1, 4, 2, '301', 1); INSERT INTO `course` VALUES (9, '计算机基础', 1, 5, 2, '301', 1); INSERT INTO `course` VALUES (10, 'JSP开发技术', 1, 4, 3, '301', 1); INSERT INTO `course` VALUES (11, 'Java程序设计', 1, 5, 5, '301', 2); INSERT INTO `course` VALUES (12, 'JavaWeb网站开发技术', 1, 2, 3, '301', 1); COMMIT; -- ---------------------------- -- Table structure for course_student -- ---------------------------- DROP TABLE IF EXISTS `course_student`; CREATE TABLE `course_student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cs_course_id` int(11) DEFAULT NULL, `cs_student_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of course_student -- ---------------------------- BEGIN; INSERT INTO `course_student` VALUES (7, 11, 2); INSERT INTO `course_student` VALUES (10, 3, 1); INSERT INTO `course_student` VALUES (12, 11, 1); COMMIT; -- ---------------------------- -- Table structure for evaluate -- ---------------------------- DROP TABLE IF EXISTS `evaluate`; CREATE TABLE `evaluate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `evaluate_teacherid` int(11) DEFAULT NULL, `evaluate_studentid` int(11) DEFAULT NULL, `evaluate_score` varchar(255) DEFAULT NULL, `evaluate_comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of evaluate -- ---------------------------- BEGIN; INSERT INTO `evaluate` VALUES (1, 1, 1, '4', '哈哈哈'); INSERT INTO `evaluate` VALUES (2, 2, 1, '5', '老师很好，上课很生动！'); COMMIT; -- ---------------------------- -- Table structure for major -- ---------------------------- DROP TABLE IF EXISTS `major`; CREATE TABLE `major` ( `id` int(11) NOT NULL AUTO_INCREMENT, `major_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of major -- ---------------------------- BEGIN; INSERT INTO `major` VALUES (1, '会计与应用会计'); INSERT INTO `major` VALUES (2, '数学与应用数学'); INSERT INTO `major` VALUES (3, '信息与计算科学'); INSERT INTO `major` VALUES (4, '能源与动力科学'); INSERT INTO `major` VALUES (5, '环境艺术与设计'); INSERT INTO `major` VALUES (6, '实用日语'); COMMIT; -- ---------------------------- -- Table structure for major_course -- ---------------------------- DROP TABLE IF EXISTS `major_course`; CREATE TABLE `major_course` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mc_major_id` int(11) DEFAULT NULL, `mc_course_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of major_course -- ---------------------------- BEGIN; INSERT INTO `major_course` VALUES (1, 2, 1); INSERT INTO `major_course` VALUES (2, 2, 2); INSERT INTO `major_course` VALUES (4, 2, 4); INSERT INTO `major_course` VALUES (5, 2, 5); INSERT INTO `major_course` VALUES (6, 2, 9); INSERT INTO `major_course` VALUES (7, 2, 10); INSERT INTO `major_course` VALUES (9, 2, 12); INSERT INTO `major_course` VALUES (10, 3, 1); INSERT INTO `major_course` VALUES (11, 3, 2); INSERT INTO `major_course` VALUES (13, 3, 4); INSERT INTO `major_course` VALUES (14, 3, 5); INSERT INTO `major_course` VALUES (15, 3, 9); INSERT INTO `major_course` VALUES (16, 3, 10); INSERT INTO `major_course` VALUES (18, 3, 12); INSERT INTO `major_course` VALUES (19, 4, 1); INSERT INTO `major_course` VALUES (20, 4, 2); INSERT INTO `major_course` VALUES (22, 4, 4); INSERT INTO `major_course` VALUES (23, 4, 5); INSERT INTO `major_course` VALUES (24, 4, 8); INSERT INTO `major_course` VALUES (25, 4, 9); INSERT INTO `major_course` VALUES (29, 5, 4); INSERT INTO `major_course` VALUES (30, 5, 5); INSERT INTO `major_course` VALUES (31, 5, 7); INSERT INTO `major_course` VALUES (32, 5, 9); INSERT INTO `major_course` VALUES (36, 6, 4); INSERT INTO `major_course` VALUES (37, 6, 5); INSERT INTO `major_course` VALUES (38, 6, 6); INSERT INTO `major_course` VALUES (39, 6, 9); COMMIT; -- ---------------------------- -- Table structure for paper -- ---------------------------- DROP TABLE IF EXISTS `paper`; CREATE TABLE `paper` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paper_file` varchar(255) DEFAULT NULL, `paper_s