(源码)基于SSM框架的人才招聘网站.zip

/* SQLyog Ultimate v11.3 (64 bit) MySQL - 5.7.32-log : Database - jspm4f21r ********************************************************************* */ /*!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*/`jspm4f21r` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `jspm4f21r`; /*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/jspm4f21r/upload/1612608992655.jpg'),(2,'picture2','http://localhost:8080/jspm4f21r/upload/1612608998686.jpg'),(3,'picture3','http://localhost:8080/jspm4f21r/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=137 DEFAULT CHARSET=utf8 COMMENT='企业信息评论表'; /*Data for the table `discussqiyexinxi` */ insert into `discussqiyexinxi`(`id`,`addtime`,`refid`,`userid`,`content`,`reply`) values (131,'2021-02-06 18:52:20',1,1,'评论内容1','回复内容1'),(132,'2021-02-06 18:52:20',2,2,'评论内容2','回复内容2'),(133,'2021-02-06 18:52:20',3,3,'评论内容3','回复内容3'),(134,'2021-02-06 18:52:20',4,4,'评论内容4','回复内容4'),(135,'2021-02-06 18:52:20',5,5,'评论内容5','回复内容5'),(136,'2021-02-06 18:52:20',6,6,'评论内容6','回复内容6'); /*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-02-06 18:52:20',1,1,'评论内容1','回复内容1'),(142,'2021-02-06 18:52:20',2,2,'评论内容2','回复内容2'),(143,'2021-02-06 18:52:20',3,3,'评论内容3','回复内容3'),(144,'2021-02-06 18:52:20',4,4,'评论内容4','回复内容4'),(145,'2021-02-06 18:52:20',5,5,'评论内容5','回复内容5'),(146,'2021-02-06 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-02-06 18:52:20',1,1,'评论内容1','回复内容1'),(122,'2021-02-06 18:52:20',2,2,'评论内容2','回复内容2'),(123,'2021-02-06 18:52:20',3,3,'评论内容3','回复内容3'),(124,'2021-02-06 18:52:20',4,4,'评论内容4','回复内容4'),(125,'2021-02-06 18:52:20',5,5,'评论内容5','回复内容5'),(126,'2021-02-06 18:52:20',6,6,'评论内容6','回复内容6'); /*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=57 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-02-06 18:52:20','用户1','姓名1','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian1.jpg','手机1','邮箱1','教育经历1','工作经历1','工作业绩1','技能1','自我介绍1'),(52,'2021-02-06 18:52:20','用户2','姓名2','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian2.jpg','手机2','邮箱2','教育经历2','工作经历2','工作业绩2','技能2','自我介绍2'),(53,'2021-02-06 18:52:20','用户3','姓名3','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian3.jpg','手机3','邮箱3','教育经历3','工作经历3','工作业绩3','技能3','自我介绍3'),(54,'2021-02-06 18:52:20','用户4','姓名4','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian4.jpg','手机4','邮箱4','教育经历4','工作经历4','工作业绩4','技能4','自我介绍4'),(55,'2021-02-06 18:52:20','用户5','姓名5','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian5.jpg','手机5','邮箱5','教育经历5','工作经历5','工作业绩5','技能5','自我介绍5'),(56,'2021-02-06 18:52:20','用户6','姓名6','http://localhost:8080/jspm4f21r/upload/gerenjianli_zhaopian6.jpg','手机6','邮箱6','教育经历6','工作经历6','工作业绩6','技能6','自我介绍6'); /*Table structure for table `qiye` */ DROP TABLE IF EXISTS `qiye`; CREATE TABLE `qiye` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `qiyezhanghao` varchar(200) NOT NULL COMMENT '企业账号', `mima` varchar(200) NOT NULL COMMENT '密码', `qiyemingcheng` varchar(200) DEFAULT NULL COMMENT '企业名称', `touxiang` varchar(200) DEFAULT NULL COMMENT '头像', `lianxiren` varchar(200) DEFAULT NULL COMMENT '联系人', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', `qiyeyouxiang` varchar(200) DEFAULT NULL COMMENT '企业邮箱', `qiyedizhi` varchar(200) DEFAULT NULL COMMENT '企业地址', PRIMARY KEY (`id`), UNIQUE KEY `qiyezhanghao` (`qiyezhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAUL