scrapy数据库写入（可用于多个类型的item对象或单个item对象）

# 在项目目录下的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