Python爬虫爬取豆瓣电影

一、目标和成果
······1.目标：热门电影以及每个热门电影的详情

······2.成果

二、建名为TESTDB 的mysql数据库

DROP TABLE IF EXISTS `t_douban`;
CREATE TABLE `t_douban`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `score` float(10, 1) NULL DEFAULT NULL,
  `dao_yan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `bian_ju` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `zhu_yan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lei_xing` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci