# 在项目目录下的items中定义类型，并插入数据，目的在于不用判断不同的item对象，传递过来的item是什么类型，就可以执行对应类型中save函数
# 一级页面图片数据信息
class ImgItem(scrapy.Item):
#获取的图片链接
src = scrapy.Field()
url = scrapy.Field()
title = scrapy.Field()
article_nums = scrapy.Field()
look_nums = scrapy.Field()
referer = scrapy.Field()
def save(self, cursor):
sql = "INSERT INTO section(title, article_nums, look_nums, url, src)VALUES('{}',{},{},'{}','{}')".format(self['title'], self['article_nums'], self['look_nums'], self['url'], self['src'][0])
cursor.execute(sql)
# 详情页面数据
class ArticleItem(scrapy.Item):
a_type = scrapy.Field()
title = scrapy.Field()
description = scrapy.Field()
create_time = scrapy.Field()
look_nums = scrapy.Field()
href = scrapy.Field()
referer = scra
