基于Python的招聘網(wǎng)站爬蟲及可視化的實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Python
框架：flask
Python版本：python3.7.7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
DROP TABLE IF EXISTS `a6woc_zhaopinxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `a6woc_zhaopinxinxi` (
? `id` bigint(20) NOT NULL DEFAULT '0' COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `chengshien` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '城市英文名',
? `fabuhao` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '發(fā)布號(hào)',
? `zhiwei` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '職位',
? `xueli` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '學(xué)歷',
? `jingyan` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '經(jīng)驗(yàn)',
? `xinzi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '薪資',
? `gongsi` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '公司',
? `gongzuodidian` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '工作地點(diǎn)',
? `gongsileixing` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '公司類型',
? `detail` longtext CHARACTER SET utf8 COMMENT '職位描述',
? `fuli` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '福利'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `aboutus`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aboutus` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `subtitle` varchar(200) DEFAULT NULL COMMENT '副標(biāo)題',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? `picture1` longtext COMMENT '圖片1',
? `picture2` longtext COMMENT '圖片2',
? `picture3` longtext COMMENT '圖片3',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='關(guān)于我們';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aboutus`
--
LOCK TABLES `aboutus` WRITE;
/*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
INSERT INTO `aboutus` VALUES (1,'2023-02-08 03:51:23','關(guān)于我們','ABOUT US','不管你想要怎樣的生活，你都要去努力爭(zhēng)取，不多嘗試一些事情怎么知道自己適合什么、不適合什么呢?\n你說(shuō)你喜歡讀書，讓我給你列書單，你還問(wèn)我哪里有那么多時(shí)間看書;你說(shuō)自己夢(mèng)想的職業(yè)是廣告文案，問(wèn)我如何成為一個(gè)文案，應(yīng)該具備哪些素質(zhì);你說(shuō)你計(jì)劃晨跑，但總是因?yàn)閷W(xué)習(xí)、工作辛苦或者身體不舒服第二天起不了床;你說(shuō)你一直夢(mèng)想一個(gè)人去長(zhǎng)途旅行，但是沒(méi)錢，父母覺(jué)得危險(xiǎn)。其實(shí)，我已經(jīng)厭倦了你這樣說(shuō)說(shuō)而已的把戲，我覺(jué)得就算我告訴你如何去做，你也不會(huì)照做，因?yàn)槟愀臼裁炊疾蛔觥?#39;,'upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg');
/*!40000 ALTER TABLE `aboutus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `name` varchar(100) NOT NULL COMMENT '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusszhaopinxinxi`
--
DROP TABLE IF EXISTS `discusszhaopinxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusszhaopinxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `avatarurl` longtext COMMENT '頭像',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='zhaopinxinxi評(píng)論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusszhaopinxinxi`
--
LOCK TABLES `discusszhaopinxinxi` WRITE;
/*!40000 ALTER TABLE `discusszhaopinxinxi` DISABLE KEYS */;
/*!40000 ALTER TABLE `discusszhaopinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡(jiǎn)介',
? `picture` longtext NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='公告資訊';
/*!40101 SET character_set_client = @saved_cs_client */;
