A股上市公司传智教育(股票代码 003032)旗下技术交流社区北京昌平校区

 找回密码
 加入黑马

QQ登录

只需一步,快速开始

# -*- coding: utf-8 -*-# Define here the models for your scraped items## See documentation in:# https://doc.scrapy.org/en/latest/topics/items.htmlimport scrapyclass MyprojectItem(scrapy.Item):    # define the fields for your item here like:    # name = scrapy.Field()    passclass LagouItem(scrapy.Item):    title = scrapy.Field()    company =scrapy.Field()    salary = scrapy.Field()    job_adv = scrapy.Field()    job_bt =scrapy.Field()    def get_insert_sql(self):        sql = "insert into lagou_test(title,company,salary,job_adv,job_bt)values(%s,%s,%s,%s,%s)"        data =(self['title'],self['company'],self['salary'],self['job_adv'],self['job_bt'])        return (sql,data)class SinaItem(scrapy.Item):    title =scrapy.Field()    def get_insert_sql(self):        sql = 'insert into sina_test (title) values (%s)'        data = (self['title'])        return (sql,data)

1 个回复

倒序浏览
奈斯,加油加油
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 加入黑马