基于Springboot和Mysql实现的大学生招聘网站系统

基于Springboot和Mysql实现的大学生招聘网站系统  项目功能：

基于Springboot和Mysql实现的大学生招聘网站系统 ,主要功能包括职位搜索、登陆、注册、岗位申请、简历编辑等功能

技术

使用springboot mybatis  数据库为mysql。部分表结构

DROP TABLE IF EXISTS `company`;
CREATE TABLE `company`  (
  `company_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司id',
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司名',
  `company_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司logo',
  `company_stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司阶段',
  `company_emp_count` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司员工规模',
  `company_industury` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司所属行业',
  `company_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司简介',
  `company_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司网址',
  `company_addr_province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司地址省份',
  `company_addr_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司地址城市',
  `company_addr_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司地址区域',
  `company_adrr_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司详细地址',
  `status` int(1) NULL DEFAULT NULL,
  `other1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `other2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`company_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES (1, '阿里巴巴', 'https://tse2-mm.cn.bing.net/th/id/OIP.014ThoYOUyHCTbS4KdCtlwHaHa?w=202&h=192&c=7&o=5&pid=1.7', '上市公司', '500-1500', '互联网', '阿里巴巴网络技术有限公司', NULL, '浙江', '杭州', '', NULL, NULL, NULL, NULL);
INSERT INTO `company` VALUES (2, '五菱宏光', 'https://tse4-mm.cn.bing.net/th/id/OIP.-6bf27SMKuTAtuOpD3rf6gAAAA?w=183&h=184&c=7&o=5&pid=1.7', '上市', '1500-3000', '汽车制造', '中国五菱', '', '河南', '郑州', '', NULL, NULL, NULL, NULL);
INSERT INTO `company` VALUES (3, '腾讯科技', 'https://tse3-mm.cn.bing.net/th/id/OIP.bX8UxxGgvFeHlJBoiMoi1QHaHR?w=170&h=166&c=7&o=5&pid=1.7', '上市公司', '1000-2000', '互联网科技', '深圳市腾讯计算机系统有限公司', NULL, '广东', '深圳', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for company_admin
-- ----------------------------
DROP TABLE IF EXISTS `company_admin`;
CREATE TABLE `company_admin`  (
  `company_admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司管理员id',
  `company_id` int(11) NULL DEFAULT NULL COMMENT '公司id',
  `company_admin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司管理员账户名',
  `company_admin_telno` bigint(18) NULL DEFAULT NULL COMMENT '公司管理员账户手机',
  `company_admin_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司管理员账户邮箱',
  `company_admin_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司管理员账户密码',
  `company_admin_create_time` datetime NULL DEFAULT NULL COMMENT '公司管理员账户创建时间',
  `status` int(1) NULL DEFAULT NULL,
  `other1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `other2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`company_admin_id`) USING BTREE,
  INDEX `fk_company_admin`(`company_id`) USING BTREE,
  ConSTRAINT `fk_company_admin` FOREIGN KEY (`company_id`) REFERENCES `company` (`company_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of company_admin
-- ----------------------------
INSERT INTO `company_admin` VALUES (1, 1, '赵先生', 15666666666, '942151916@qq.com', '666666', '2020-03-09 09:53:25', 0, NULL, NULL);
INSERT INTO `company_admin` VALUES (2, 2, '李先生', 18888888888, '868688686@qq.com', '888888', '2020-03-09 09:54:09', 0, NULL, NULL);
INSERT INTO `company_admin` VALUES (3, 3, '楚先生', 13224242442, '123456789@qq.com', '999999', '2020-03-02 09:54:54', 0, NULL, NULL);

-- ----------------------------
-- Table structure for company_receive_resume_record
-- ----------------------------
DROP TABLE IF EXISTS `company_receive_resume_record`;
CREATE TABLE `company_receive_resume_record`  (
  `company_receive_resume_record_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司收到简历记录id',
  `company_id` int(11) NOT NULL COMMENT '公司id',
  `resume_id` int(11) NULL DEFAULT NULL COMMENT '简历id',
  `receive_time` datetime NULL DEFAULT NULL COMMENT '公司收到简历时间',
  `company_admin_id` int(11) NULL DEFAULT NULL COMMENT '公司管理员id',
  `status` int(1) NULL DEFAULT NULL,
  `other1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `other2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`company_receive_resume_record_id`) USING BTREE,
  INDEX `fk_receive_record_company`(`company_id`) USING BTREE,
  INDEX `fk_receive_record_resume`(`resume_id`) USING BTREE,
  INDEX `fk_receive_record_admin`(`company_admin_id`) USING BTREE,
  ConSTRAINT `fk_receive_record_admin` FOREIGN KEY (`company_admin_id`) REFERENCES `company_admin` (`company_admin_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ConSTRAINT `fk_receive_record_company` FOREIGN KEY (`company_id`) REFERENCES `company` (`company_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ConSTRAINT `fk_receive_record_resume` FOREIGN KEY (`resume_id`) REFERENCES `resume` (`resume_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

页面效果