基于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;页面效果
