Spring Boot 2.0与WebMagic的轻松整合:低配版自动网页抓取实践(下)
最编程
2024-01-13 13:55:56
...
-- ----------------------------
-- Table structure for boot_link
-- ----------------------------
DROP TABLE IF EXISTS `boot_link`;
CREATE TABLE `boot_link` (
`id` bigint(20) NOT NULL COMMENT 'id',
`uri` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文章链接',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网站类型',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `boot_link` VALUES ('11', 'https://www.cnblogs.com/koushenhai/p/12595630.html', 'bky');
INSERT INTO `boot_link` VALUES ('12', 'https://kcloud.blog.****.net/article/details/118633942', '****');
INSERT INTO `boot_link` VALUES ('20', 'https://kcloud.blog.****.net/article/details/121491124', '****');
INSERT INTO `boot_link` VALUES ('33', 'https://kcloud.blog.****.net/article/details/82109656', '****');
INSERT INTO `boot_link` VALUES ('41', 'https://kcloud.blog.****.net/article/details/117769662', '****');
INSERT INTO `boot_link` VALUES ('49', 'https://kcloud.blog.****.net/article/details/118660073', '****');
INSERT INTO `boot_link` VALUES ('57', 'https://kcloud.blog.****.net/article/details/119720174', '****');
INSERT INTO `boot_link` VALUES ('65', 'https://kcloud.blog.****.net/article/details/123179670', '****');
INSERT INTO `boot_link` VALUES ('66', 'https://kcloud.blog.****.net/article/details/117635759', '****');
INSERT INTO `boot_link` VALUES ('74', 'https://kcloud.blog.****.net/article/details/117771583', '****');
INSERT INTO `boot_link` VALUES ('78', 'https://kcloud.blog.****.net/article/details/123039609', '****');
INSERT INTO `boot_link` VALUES ('79', 'https://kcloud.blog.****.net/article/details/82588914', '****');
INSERT INTO `boot_link` VALUES ('96', 'https://kcloud.blog.****.net/article/details/108021143', '****');
INSERT INTO `boot_link` VALUES ('118', 'https://kcloud.blog.****.net/article/details/121305244', '****');
INSERT INTO `boot_link` VALUES ('128', 'https://kcloud.blog.****.net/article/details/82110125', '****');
INSERT INTO `boot_link` VALUES ('129', 'https://kcloud.blog.****.net/article/details/123630814', '****');
INSERT INTO `boot_link` VALUES ('130', 'https://kcloud.blog.****.net/article/details/116420798', '****');
INSERT INTO `boot_link` VALUES ('131', 'https://kcloud.blog.****.net/article/details/123484520', '****');
INSERT INTO `boot_link` VALUES ('132', 'https://kcloud.blog.****.net/article/details/123013305', '****');
INSERT INTO `boot_link` VALUES ('133', 'https://kcloud.blog.****.net/article/details/123390833', '****');
INSERT INTO `boot_link` VALUES ('134', 'https://kcloud.blog.****.net/article/details/123311487', '****');
INSERT INTO `boot_link` VALUES ('135', 'https://kcloud.blog.****.net/article/details/123292276', '****');
INSERT INTO `boot_link` VALUES ('136', 'https://kcloud.blog.****.net/article/details/123123229', '****');
INSERT INTO `boot_link` VALUES ('137', 'https://kcloud.blog.****.net/article/details/116704223', '****');
INSERT INTO `boot_link` VALUES ('145', 'https://kcloud.blog.****.net/article/details/123739314', '****');
INSERT INTO `boot_link` VALUES ('146', 'https://kcloud.blog.****.net/article/details/123688809', '****');
INSERT INTO `boot_link` VALUES ('147', 'https://kcloud.blog.****.net/article/details/123673741', '****');
INSERT INTO `boot_link` VALUES ('148', 'https://kcloud.blog.****.net/article/details/123628721', '****');
INSERT INTO `boot_link` VALUES ('149', 'https://kcloud.blog.****.net/article/details/123599384', '****');
INSERT INTO `boot_link` VALUES ('150', 'https://kcloud.blog.****.net/article/details/122181814', '****');
INSERT INTO `boot_link` VALUES ('151', 'https://kcloud.blog.****.net/article/details/121557788', '****');
INSERT INTO `boot_link` VALUES ('159', 'https://kcloud.blog.****.net/article/details/116449621', '****');
INSERT INTO `boot_link` VALUES ('160', 'https://kcloud.blog.****.net/article/details/83623118', '****');
INSERT INTO `boot_link` VALUES ('161', 'https://kcloud.blog.****.net/article/details/84777724', '****');
INSERT INTO `boot_link` VALUES ('162', 'https://kcloud.blog.****.net/article/details/105587614', '****');
INSERT INTO `boot_link` VALUES ('163', 'https://kcloud.blog.****.net/article/details/83515122', '****');
INSERT INTO `boot_link` VALUES ('164', 'https://kcloud.blog.****.net/article/details/83451040', '****');
INSERT INTO `boot_link` VALUES ('165', 'https://kcloud.blog.****.net/article/details/117252826', '****');
INSERT INTO `boot_link` VALUES ('166', 'https://kcloud.blog.****.net/article/details/84826176', '****');
INSERT INTO `boot_link` VALUES ('167', 'https://kcloud.blog.****.net/article/details/120031600', '****');
INSERT INTO `boot_link` VALUES ('168', 'https://kcloud.blog.****.net/article/details/119685953', '****');
INSERT INTO `boot_link` VALUES ('169', 'https://kcloud.blog.****.net/article/details/120147123', '****');
INSERT INTO `boot_link` VALUES ('170', 'https://kcloud.blog.****.net/article/details/120245035', '****');
INSERT INTO `boot_link` VALUES ('171', 'https://kcloud.blog.****.net/article/details/120190383', '****');
INSERT INTO `boot_link` VALUES ('179', 'https://kcloud.blog.****.net/article/details/94590629', '****');
INSERT INTO `boot_link` VALUES ('187', 'https://kcloud.blog.****.net/article/details/116949872', '****');
INSERT INTO `boot_link` VALUES ('192', 'https://kcloud.blog.****.net/article/details/123789292', '****');
INSERT INTO `boot_link` VALUES ('193', 'https://kcloud.blog.****.net/article/details/123780832', '****');
INSERT INTO `boot_link` VALUES ('194', 'https://kcloud.blog.****.net/article/details/123771040', '****');
INSERT INTO `boot_link` VALUES ('195', 'https://kcloud.blog.****.net/article/details/122522290', '****');
INSERT INTO `boot_link` VALUES ('196', 'https://kcloud.blog.****.net/article/details/123833614', '****');
DROP TABLE IF EXISTS `boot_article`;
CREATE TABLE `boot_article` (
`id` bigint(20) NOT NULL COMMENT 'id',
`title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文章链接',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网站类型',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;