IDEA+Java+SSM+Jsp+Mysql实现Web商品信息

2022-04-17 本文已影响0人水坚石青

一、系统介绍

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;

二、系统展示

1.系统注册