IDEA+Java+Jsp+Mysql实现Web毕业设计选题系统，先收藏了

18.学生-主页面

19.学生-个人中心-修改资料

20.学生-个人中心-我的选题

21.学生-开始选题-选题列表

22.学生-开始选题-选题明细

三、部分代码

StudentManager

TeacherManager

TopicManager

DB

Login.jsp

index.jsp

news.jsp

四、其他

1.更多系统

Java+JSP系统系列实现

Java+Servlet系统系列实现

Java+SSM系统系列实现

Java+SSH系统系列实现

Java+Springboot系统系列实现

2.源码下载

3.运行项目

4.备注

5.支持博主

---

一、系统介绍

======

1.开发环境

---

开发工具：IDEA2018

JDK版本：Jdk1.8

Mysql版本：8.0.13

2.技术选型

---

Java+Jsp+Mysql

3.系统功能

---

1.管理员登录系统，管理学生信息，管理教师信息，管理课题信息，系统维护功能；

2.教师登录系统，修改个人信息，添加课题，查看课题；

3.学生登录系统，修改个人信息，查看选题，选择课题；

4.数据库文件

---

/*

Navicat Premium Data Transfer

Source Server : MYSQL

Source Server Type : MySQL

Source Server Version : 80013

Source Host : localhost:3306

Source Schema : jsp_select_topic

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 12/04/2022 09:04:43

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for msg

---

DROP TABLE IF EXISTS msg;

CREATE TABLE msg (

title varchar(100) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,

text varchar(1000) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,

PRIMARY KEY (title) USING BTREE

) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

---

– Records of msg

---

INSERT INTO msg VALUES (‘毕业设计选题系统初步完成’, ‘整个系统流程大致为：老师发布课题，管理员审核\r\n\r\n课题，学生选题，学生完成设计’);

INSERT INTO msg VALUES (‘学生相关功能’, ‘请各位学生登录系统，给自己选择一个课题！’);

---

– Table structure for student_info

---

DROP TABLE IF EXISTS student_info;

CREATE TABLE student_info (

sno varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

sname varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

ssex varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

sclass varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

stel varchar(11) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

semail varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

sgroup varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

spassword varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT ‘6-10位字符’,

PRIMARY KEY (sno) USING BTREE

) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

---

– Records of student_info

---

INSERT INTO student_info VALUES (‘1001’, ‘张三’, ‘男’, ‘4’, ‘15523457667’, ‘336688@qq.com’, ‘2’, ‘123456’);

INSERT INTO student_info VALUES (‘1002’, ‘李四’, ‘男’, ‘2’, ‘14456789876’, ‘6699334@qq.com’, ‘2’, ‘123456’);

INSERT INTO student_info VALUES (‘1003’, ‘王五’, ‘男’, ‘3’, ‘14456789876’, ‘6699334@qq.com’, ‘3’, ‘123456’);

INSERT INTO student_info VALUES (‘1004’, ‘赵六’, ‘男’, ‘3’, ‘14456789876’, ‘6699334@qq.com’, ‘3’, ‘admin’);

---

– Table structure for teacher_info

---

DROP TABLE IF EXISTS teacher_info;

CREATE TABLE teacher_info (

tno varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

tname varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

tsex varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

tdept varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

tdegree varchar(8) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

ttitle varchar(4) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

tright bit(1) NOT NULL,

ttel varchar(11) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

temail varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

tgroup varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

tpassword varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

PRIMARY KEY (tno) USING BTREE

) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

---

– Records of teacher_info

---

INSERT INTO teacher_info VALUES (‘101’, ‘admin’, ‘男’, ‘计算机科学与技术系’, ‘硕士’, ‘教授’, b’0’, ‘15315614829’, ‘12345678@qq.com’, ‘4’, ‘admin’);

INSERT INTO teacher_info VALUES (‘102’, ‘王老师’, ‘男’, ‘计算机科学与技术系’, ‘硕士’, ‘教授’, b’1’, ‘15315614829’, ‘1234567844@qq.com’, ‘4’, ‘123456’);

INSERT INTO teacher_info VALUES (‘103’, ‘李老师’, ‘男’, ‘计算机科学与技术系’, ‘硕士’, ‘助教’, b’1’, ‘13456789876’, ‘1234567844@qq.com’, ‘4’, ‘admin’);

---

– Table structure for topic_info

---

DROP TABLE IF EXISTS topic_info;

CREATE TABLE topic_info (

hno varchar(5) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hname varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

htype varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hkind varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hsource varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hstatus varchar(5) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hcontent varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

hresult varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

direction varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

tno varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,

sno varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,

PRIMARY KEY (hno) USING BTREE,

INDEX FK_topicinfo(sno) USING BTREE,

INDEX FK_topicinfo1(tno) USING BTREE,

CONSTRAINT FK_topicinfo FOREIGN KEY (sno) REFERENCES student_info (sno) ON DELETE RESTRICT ON UPDATE RESTRICT,

CONSTRAINT FK_topicinfo1 FOREIGN KEY (tno) REFERENCES teacher_info (tno) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

---

– Records of topic_info

---

INSERT INTO topic_info VALUES (‘10001’, ‘计算机技术体系研究’, ‘毕业设计’, ‘理论研究’, ‘结合科研’, ‘true’, ‘计算机技术体系研究’, ‘SCI发表相应论文’, ‘无’, ‘102’, ‘1001’);

INSERT INTO topic_info VALUES (‘10002’, ‘软件工程体系研究’, ‘毕业设计’, ‘软件研究’, ‘结合科研’, ‘true’, ‘软件工程体系研究’, ‘SCI发表论文’, ‘无’, ‘102’, ‘1002’);

SET FOREIGN_KEY_CHECKS = 1;

5.工程截图

---

二、系统展示

======

1.登录系统

---

2.管理员-主页面

---

3.管理员-学生管理-查看所有

---

4.管理员-学生管理-添加学生

---

5.管理员-教师管理-查看所有

---

6.管理员-教师管理-添加教师

---

7.管理员-课程管理-课程查询

---

8.管理员-课程管理-课程审核

---

9.管理员-系统维护-添加公告

---

10.管理员-系统维护-查看公告

---

11.管理员-系统维护-教师功能开关

---

12.管理员-系统维护-学生功能开关

---