学习python-mysql:连接数据的步骤(一)

1.导入

import MySQLdb

2.定义实用类和插入语句并测试

class MysqlPipeline(object):
    def __init__(self):
        # self.conn = MySQLdb.connect('host', 'user', 'password', 'dbname', charset='utf8', user_unicode=True)
        # 下面连接的密码啥的要换成自己电脑上的登录名和密码
        self.conn = MySQLdb.connect('host', 'user', 'password', 'dbname', charset='utf8', use_unicode=True)
        self.cursor = self.conn.cursor()

    def process_item(self, item, spider):
        # title, url, create_date, url_object_id, front_image_url,
        #  front_image_path, praise_nums, comment_nums, fav_nums, tags, content
        insert_sql = """
        insert into  jobbole_article(title, url, create_date, fav_nums) 
        VALUES (%s, %s, %s, %s)
        """
        self.cursor.execute(insert_sql, (item['title'], item['url'], item['create_date'], item['fav_nums']))
        self.conn.commit()

中间犯得错

①.use_unicode=True中的use_unicode写成了user_unicode