Java项目：基于SSM框架实现的大学生就业信息平台【ssm+B/S架构+源码+数据库】

/* SQLyog Ultimate v11.3 (64 bit) MySQL - 5.7.32-log : Database - daxueshengjiuyepingtai ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`daxueshengjiuyepingtai` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `daxueshengjiuyepingtai`; /*Table structure for table `config` */ DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*Data for the table `config` */ insert into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/daxueshengjiuyepingtai/upload/1612608992655.jpg'),(2,'picture2','http://localhost:8080/daxueshengjiuyepingtai/upload/1612608998686.jpg'),(3,'picture3','http://localhost:8080/daxueshengjiuyepingtai/upload/1612609009615.jpg'),(6,'homepage',NULL); /*Table structure for table `discussqiyexinxi` */ DROP TABLE IF EXISTS `discussqiyexinxi`; CREATE TABLE `discussqiyexinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617266825607 DEFAULT CHARSET=utf8 COMMENT='企业信息评论表'; /*Data for the table `discussqiyexinxi` */ insert into `discussqiyexinxi`(`id`,`addtime`,`refid`,`userid`,`content`,`reply`) values (131,'2021-04-01 18:52:20',1,1,'评论内容1','回复内容1'),(132,'2021-04-01 18:52:20',2,2,'评论内容2','回复内容2'),(133,'2021-04-01 18:52:20',3,3,'评论内容3','回复内容3'),(134,'2021-04-01 18:52:20',4,4,'评论内容4','回复内容4'),(135,'2021-04-01 18:52:20',5,5,'评论内容5','回复内容5'),(136,'2021-04-01 18:52:20',6,6,'评论内容6','回复内容6'),(1617266825606,'2021-04-01 16:47:05',1617266622066,1617266681745,'123123',NULL); /*Table structure for table `discusszhaopinxinxi` */ DROP TABLE IF EXISTS `discusszhaopinxinxi`; CREATE TABLE `discusszhaopinxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='招聘信息评论表'; /*Data for the table `discusszhaopinxinxi` */ insert into `discusszhaopinxinxi`(`id`,`addtime`,`refid`,`userid`,`content`,`reply`) values (141,'2021-04-01 18:52:20',1,1,'评论内容1','回复内容1'),(142,'2021-04-01 18:52:20',2,2,'评论内容2','回复内容2'),(143,'2021-04-01 18:52:20',3,3,'评论内容3','回复内容3'),(144,'2021-04-01 18:52:20',4,4,'评论内容4','回复内容4'),(145,'2021-04-01 18:52:20',5,5,'评论内容5','回复内容5'),(146,'2021-04-01 18:52:20',6,6,'评论内容6','回复内容6'); /*Table structure for table `discusszhaopinzixun` */ DROP TABLE IF EXISTS `discusszhaopinzixun`; CREATE TABLE `discusszhaopinzixun` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='招聘资讯评论表'; /*Data for the table `discusszhaopinzixun` */ insert into `discusszhaopinzixun`(`id`,`addtime`,`refid`,`userid`,`content`,`reply`) values (121,'2021-04-01 18:52:20',1,1,'评论内容1','回复内容1'),(122,'2021-04-01 18:52:20',2,2,'评论内容2','回复内容2'),(123,'2021-04-01 18:52:20',3,3,'评论内容3','回复内容3'),(124,'2021-04-01 18:52:20',4,4,'评论内容4','回复内容4'),(125,'2021-04-01 18:52:20',5,5,'评论内容5','回复内容5'),(126,'2021-04-01 18:52:20',6,6,'评论内容6','回复内容6'); /*Table structure for table `forum` */ DROP TABLE IF EXISTS `forum`; CREATE TABLE `forum` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) DEFAULT NULL COMMENT '帖子标题', `content` longtext NOT NULL COMMENT '帖子内容', `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(200) DEFAULT NULL COMMENT '用户名', `isdone` varchar(200) DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617266874961 DEFAULT CHARSET=utf8 COMMENT='论坛信息'; /*Data for the table `forum` */ insert into `forum`(`id`,`addtime`,`title`,`content`,`parentid`,`userid`,`username`,`isdone`) values (101,'2021-03-18 17:31:37','帖子标题1','帖子内容1',1,1,'用户名1','开放'),(102,'2021-03-18 17:31:37','帖子标题2','帖子内容2',2,2,'用户名2','开放'),(103,'2021-03-18 17:31:37','帖子标题3','帖子内容3',3,3,'用户名3','开放'),(104,'2021-03-18 17:31:37','帖子标题4','帖子内容4',4,4,'用户名4','开放'),(105,'2021-03-18 17:31:37','帖子标题5','帖子内容5',5,5,'用户名5','开放'),(106,'2021-03-18 17:31:37','帖子标题6','帖子内容6',6,6,'用户名6','开放'),(1617266866935,'2021-04-01 16:47:46','aaaa','<p>请输入内容weqwe</p>',0,1617266681745,'333','开放'),(1617266874960,'2021-04-01 16:47:54',NULL,'请输入评asweqweasd论',1617266866935,1617266681745,'333',NULL); /*Table structure for table `gerenjianli` */ DROP TABLE IF EXISTS `gerenjianli`; CREATE TABLE `gerenjianli` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱', `jiaoyujingli` varchar(200) DEFAULT NULL COMMENT '教育经历', `gongzuojingli` longtext COMMENT '工作经历', `gongzuoyeji` longtext COMMENT '工作业绩', `jineng` varchar(200) DEFAULT NULL COMMENT '技能', `ziwojieshao` varchar(200) DEFAULT NULL COMMENT '自我介绍', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617266727902 DEFAULT CHARSET=utf8 COMMENT='个人简历'; /*Data for the table `gerenjianli` */ insert into `gerenjianli`(`id`,`addtime`,`yonghuming`,`xingming`,`zhaopian`,`shouji`,`youxiang`,`jiaoyujingli`,`gongzuojingli`,`gongzuoyeji`,`jineng`,`ziwojieshao`) values (51,'2021-04-01 18:52:20','用户名1','姓名1','http://localhost:8080/daxueshengjiuyepingtai/upload/gerenjianli_zhaopian1.jpg','手机1','邮箱1','教育经历1','工作经历1','工作业绩1','技能1','自我介绍1'),(52,'2021-04-01 18:52:20','用户名2','姓名2','http://localhost:8080/daxueshengjiuyepingtai/upload/gerenjianli_zhaopian2.jp