php和python如何连接数据库,学习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