学生信息填报系统使用手册

服务器环境搭建

JAVA

Java JDK1.8及以上

MySQL

 MySQL5.7及以上

数据导入

详情翻到最后的附页

部署和运行

部署

1、jar 包方式

将jar 放在服务器指定的项目目录下即可

软件附件 jar 包

2、源码方式

使用IDE（Intellij IDEA）导入源码
刷新Maven 仓库（为保证依赖的正确导入）
使用Maven 清理
编译（使用Maven）
打包（使用Maven）

运行

Linux 服务器

打开终端进入到jar包存放路径，运行以下命令：

nohup java -jar infosystam-0.0.1-SNAPSHOT.jar > infosystem.log &

Windows 服务器

打开CMD进入到jar包存放路径，运行以下命令：

java -jar infosystam-0.0.1-SNAPSHOT.jar > infosystem.log &

附页（SQL，内置了部分数据）

打开数据库管理程序

运行以下代码：

-- ---------------------------------
-- 信息填报系统数据库结构及部分测试数据
-- ---------------------------------
-- 管理员测试账号：0, 123456
-- 管理员测试密码：123456
-- ---------------------------------
-- 教师测试账号：20200615, 20200616, 20200614, 
-- 教师测试密码：123456
-- ---------------------------------
-- 学生测试账号：21211214125, ...
-- 学生测试密码：123456
-- ---------------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cclass
-- ----------------------------
DROP TABLE IF EXISTS `cclass`;
CREATE TABLE `cclass`  (
  `cid` int(11) NOT NULL AUTO_INCREMENT COMMENT '班级ID',
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级名称',
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学院名称',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`cid`, `cname`) USING BTREE,
  INDEX `cid`(`cid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 315 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of cclass
-- ----------------------------
INSERT INTO `cclass` VALUES (196, '18社体本1', '体育学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (269, '19化工本3', '化学工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (270, '15采矿本', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (271, '16采矿本', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (272, '16水利本', '土木建筑工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (273, '17采矿本', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (274, '18采矿本1', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (275, '18采矿本2', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (290, '17土木本1', '土木建筑工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (291, '17土木本3', '土木建筑工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (293, '19测绘本', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (294, '15地质本', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (299, '19地质本1', '矿业工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (312, '18工管本1', '土木建筑工程学院', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (313, '19思政本1', '马克思主义教学部', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');
INSERT INTO `cclass` VALUES (314, '19思政本2', '马克思主义教学部', 0, '2020-06-15 01:37:08', '2020-06-14 01:21:30');

-- ----------------------------
-- Table structure for fields
-- ----------------------------
DROP TABLE IF EXISTS `fields`;
CREATE TABLE `fields`  (
  `field_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '字段ID',
  `tno` int(11) NOT NULL COMMENT '管理员ID',
  `field_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名称',
  `field_key` varchar(46) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段JS代码',
  `field_context` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单HTML代码',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`field_id`, `field_key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for report
-- ----------------------------
DROP TABLE IF EXISTS `report`;
CREATE TABLE `report`  (
  `report_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '填报ID',
  `sno` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `report_content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '填报内容',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`report_id`) USING BTREE,
  INDEX `sno`(`sno`) USING BTREE,
  INDEX `task_id`(`task_id`) USING BTREE,
  CONSTRAINT `report_ibfk_1` FOREIGN KEY (`sno`) REFERENCES `student` (`sno`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `report_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`task_id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of report
-- ----------------------------


-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `sid` int(11) NOT NULL AUTO_INCREMENT COMMENT '#',
  `sno` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学生学号',
  `spassword` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学生姓名',
  `cid` int(11) NOT NULL COMMENT '班级ID',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`sid`, `sno`) USING BTREE,
  INDEX `sno`(`sno`, `spassword`, `sname`, `cid`) USING BTREE,
  INDEX `cid`(`cid`) USING BTREE,
  INDEX `sno_2`(`sno`) USING BTREE,
  CONSTRAINT `student_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `cclass` (`cid`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 152 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (53, '1805032020', '123456', '测试', 1, 0, '2020-06-15 17:56:48', '2020-06-15 17:56:48');
INSERT INTO `student` VALUES (55, '21211214125', '123456', '肖南梦', 3, 0, '2020-06-15 17:56:45', '2020-06-15 17:56:45');
INSERT INTO `student` VALUES (56, '21211215103', '12345678', '邢维帅', 4, 0, '2020-06-15 16:12:51', '2020-06-15 16:12:52');
INSERT INTO `student` VALUES (57, '21211215105', '123456', '陈坤', 5, 0, '2020-06-15 15:06:37', '2020-06-15 15:06:37');
INSERT INTO `student` VALUES (58, '21211215118', '123456', '金如意', 6, 0, '2020-06-16 15:06:37', '2020-06-16 15:06:37');
INSERT INTO `student` VALUES (100, '21211216128', '123456', '赵磊', 48, 0, '2020-07-28 15:06:37', '2020-07-28 15:06:37');
INSERT INTO `student` VALUES (101, '21211216129', '123456', '明亚军', 49, 0, '2020-07-29 15:06:37', '2020-07-29 15:06:37');
INSERT INTO `student` VALUES (102, '21211216130', '123456', '王昌艳', 50, 0, '2020-07-30 15:06:37', '2020-07-30 15:06:37');

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task`  (
  `task_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '填报任务ID',
  `tno` int(15) NOT NULL COMMENT '填报任务教师工号',
  `task_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '填报任务名称',
  `task_range` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '填报任务范围',
  `task_template` int(11) NOT NULL COMMENT '填报任务模板',
  `task_start` datetime(0) NOT NULL COMMENT '填报任务开始时间',
  `task_end` datetime(0) NOT NULL COMMENT '填报任务结束时间',
  `task_state` tinyint(3) NOT NULL DEFAULT 1 COMMENT '任务状态（1正在进行填报任务，2填报任务暂停中，3填报任务已完成）',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`task_id`) USING BTREE,
  UNIQUE INDEX `task_id`(`task_id`) USING BTREE,
  INDEX `task_name`(`task_name`) USING BTREE,
  INDEX `tno`(`tno`) USING BTREE,
  INDEX `task_template`(`task_template`) USING BTREE,
  CONSTRAINT `task_ibfk_1` FOREIGN KEY (`tno`) REFERENCES `teacher` (`tno`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `task_ibfk_2` FOREIGN KEY (`task_template`) REFERENCES `template` (`template_id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of task
-- ----------------------------


-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `tid` int(11) NOT NULL AUTO_INCREMENT COMMENT '#',
  `tno` int(15) NOT NULL COMMENT '教师工号',
  `roles` tinyint(2) NOT NULL DEFAULT 0 COMMENT '权限（0普通教师，1管理员）',
  `tpassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `tname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '教师姓名',
  `tphone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '教师手机号',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`tid`, `tno`) USING BTREE,
  INDEX `tno`(`tno`, `tpassword`, `tname`) USING BTREE,
  INDEX `tno_2`(`tno`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (0, 0, 1, '123456', '系统管理员', '00000000000', 0, '2020-06-11 01:21:30', '2020-06-18 13:24:39');
INSERT INTO `teacher` VALUES (1, 20200615, 0, '123456', '教师', '15785211234', 0, '2020-06-14 01:21:30', '2020-06-15 00:37:04');
INSERT INTO `teacher` VALUES (2, 20200616, 0, '123456', '测试教师', '187856182021', 0, '2020-06-15 00:39:53', '2020-06-15 00:39:53');
INSERT INTO `teacher` VALUES (3, 20200614, 0, '123456', '徐胜男', '15445687895', 0, '2020-06-15 13:22:19', '2020-06-15 13:22:19');
INSERT INTO `teacher` VALUES (4, 123456, 1, '123456', '测试管理员', '1008611', 0, '2020-06-15 16:57:48', '2020-06-15 16:57:57');

-- ----------------------------
-- Table structure for template
-- ----------------------------
DROP TABLE IF EXISTS `template`;
CREATE TABLE `template`  (
  `template_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '模板ID',
  `tno` int(11) NOT NULL COMMENT '教师ID',
  `template_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称',
  `template_fields` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '填报字段',
  `template_context` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板HTML',
  `deleted` tinyint(2) NOT NULL DEFAULT 0 COMMENT '逻辑删除（0：未删除，1：删除）',
  `gmt_create` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  PRIMARY KEY (`template_id`) USING BTREE,
  UNIQUE INDEX `template_name`(`template_name`) USING BTREE,
  INDEX `tno`(`tno`) USING BTREE,
  CONSTRAINT `template_ibfk_1` FOREIGN KEY (`tno`) REFERENCES `teacher` (`tno`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of template
-- ----------------------------


SET FOREIGN_KEY_CHECKS = 1;

参与贡献

Fork 本仓库
新建 Feat_xxx 分支
提交代码
新建 Pull Request

我有酒 / 信息填报系统（JAVA版）

学生信息填报系统使用手册

服务器环境搭建

JAVA

MySQL

数据导入

部署和运行

部署

1、jar 包方式

2、源码方式

运行

Linux 服务器

Windows 服务器

参与贡献

简介

发行版

贡献者

近期动态

我有酒 / 信息填报系统（JAVA版） .gitee-modal { width: 500px !important; }

学生信息填报系统使用手册

服务器环境搭建

JAVA

MySQL

数据导入

部署和运行

部署

1、jar 包方式

2、源码方式

运行

Linux 服务器

Windows 服务器

参与贡献

简介

发行版

贡献者

近期动态

搜索帮助

我有酒 / 信息填报系统（JAVA版）