JavaWeb课程设计+JavaWeb实训作业 :(Jsp+Servlet+Mysql+Tomcat+Idea)
项目类型 :JAVA WEB项目
用户类型 :3个角色(管理员+社长+学生)
主要技术 :Jsp+MySQL+Servlet
前端技术 :BootStrap模板
开发工具 :Eclipse
数据库表 :6张
需求分析:
用例描述:
整体架构:
整体E-R图:
项目结构:
高校图书管理系统系统
- 1.管理员端功能介绍
-
* 1.1登录界面
- 1.2后台首页
- 1.3管理员中心
- 1.4社团活动管理
- 1.5社团报名情况
- 1.6公告管理
- 1.6社长信息管理
- 1.7BootStrap主题颜色更换
- 2.学生端功能介绍
-
* 2.1账号注册
- 2.2社团活动报名
- 2.3社团活动报名情况
- 2.4查看公告
- 3.社长端功能介绍
-
* 3.1报名管理
- 4.数据库表
1.管理员端功能介绍
1.1登录界面
1.2后台首页
1.3管理员中心
1.4社团活动管理
修改和添加新社团
为社团设置负责人
1.5社团报名情况
1.6公告管理
1.6社长信息管理
1.7BootStrap主题颜色更换
2.学生端功能介绍
2.1账号注册
2.2社团活动报名
2.3社团活动报名情况
2.4查看公告
3.社长端功能介绍
3.1报名管理
审核学生对于社团活动的报名
4.数据库表
逆向打印模型
ET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '李清照', 'admin@qq.com', '123456');
-- ----------------------------
-- Table structure for stbm
-- ----------------------------
DROP TABLE IF EXISTS `stbm`;
CREATE TABLE `stbm` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userId` int(10) NULL DEFAULT NULL COMMENT '报名人id',
`s_id` int(10) NULL DEFAULT NULL COMMENT '社团活动id',
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态 1 报名中 2报名成功 3报名失败',
`bmrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报名日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stbm
-- ----------------------------
INSERT INTO `stbm` VALUES (2, 1, 1, '2', '2021-03-24 18:37');
INSERT INTO `stbm` VALUES (4, 1, 2, '3', '2021-03-24 18:55');
-- ----------------------------
-- Table structure for stgg
-- ----------------------------
DROP TABLE IF EXISTS `stgg`;
CREATE TABLE `stgg` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '社团内容',
`fbr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布人',
`rbrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stgg
-- ----------------------------
INSERT INTO `stgg` VALUES (1, '关于社团政治内容', '整治社团杂乱差的问题', '李清照', '2021-03-23 18:54');
INSERT INTO `stgg` VALUES (2, '关于计算机社团经费问题', '计算机社团每人团费10元', '李清照', '2021-03-24 10:22');
INSERT INTO `stgg` VALUES (3, '关于钓鱼社团活动', '社员自带鱼竿,社团提供鱼饵', '李清照', '2021-03-24 10:22');
INSERT INTO `stgg` VALUES (4, '关于电子竞技社团电脑配置升级', '社团每个电脑加上一个16g内存条', '李清照', '2021-03-24 10:23');
-- ----------------------------
-- Table structure for sthd
-- ----------------------------
DROP TABLE IF EXISTS `sthd`;
CREATE TABLE `sthd` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动名称',
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动详情',
`u_id` int(10) NULL DEFAULT NULL COMMENT '社团负责人id',
`createTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
`u_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '社团负责人名字',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sthd
-- ----------------------------
INSERT INTO `sthd` VALUES (1, '篮球社团', '篮球训练,篮球比赛等。', 1, '2021-03-23 16:55', '小明');
INSERT INTO `sthd` VALUES (2, '计算机社团活动', 'java,JavaScript,html培训。', 2, '2021-03-23 18:03', '小红');
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`stuno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
`realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出生日期',
`dj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '大几 大一大二大三',
`bj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级',
`major` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业',
`institution` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学院',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, '001', '张三', '男', '1998-03-23', '大一', '软件一班', '软件技术', '信息工程学院', 'zhangsan@qq.com', '123456', '15265123232');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '社长姓名',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '小明', 'xiaoming@qq.com', '123456');
INSERT INTO `user` VALUES (2, '小红', 'xiaohong@qq.com', '123456');
SET FOREIGN_KEY_CHECKS = 1;