读崔庆才之小白进阶之Scrapy第一篇遇到的问题

第一个问题：No module named 'win32api'错误

解决方法：直接在命令行：pip install pypiwin32。

第二个问题：No module named 'mysql'错误

解决方法：

  因为在python3里mysql-python不再兼容，我们这里改用pymysql。

so我们pip install pymysql

之前在博主的事情sql.py的代码为：

import mysql.connector
from dingdian import settings

MYSQL_HOSTS = settings.MYSQL_HOSTS
MYSQL_USER = settings.MYSQL_USER
MYSQL_PASSWORD = settings.MYSQL_PASSWORD
MYSQL_PORT = settings.MYSQL_PORT
MYSQL_DB = settings.MYSQL_DB

cnx = mysql.connector.connect(user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOSTS, database=MYSQL_DB)
cur = cnx.cursor(buffered=True)

下面为改正后的的代码

import pymysql                     #这里修改了
from dingdian import settings

MYSQL_HOSTS = settings.MYSQL_HOSTS
MYSQL_USER = settings.MYSQL_USER
MYSQL_PASSWORD = settings.MYSQL_PASSWORD
MYSQL_PORT = settings.MYSQL_PORT
MYSQL_DB = settings.MYSQL_DB

cnx = pymysql.connect(user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOSTS, database=MYSQL_DB)
cur = cnx.cursor()                      #这里修改了

修改后的源码下载：https://github.com/aaaazhi/dingdian

小白进阶scrapy第一篇链接：https://cuiqingcai.com/3472.html/1

pymysql数据库的连接用法：http://www.runoob.com/python3/python3-mysql.html