import pymysql
import logging
import sys
# 加入日志
#获取logger实例
logger = logging.getLogger("baseSpider")
# 指定输出格式
formatter = logging.Formatter(‘%(asctime)s\
%(levelname)-8s:%(message)s‘)
# 文件日志
file_handler = logging.FileHandler("baseSpider.log")
file_handler.setFormatter(formatter)
# 控制台日志
console_handler = logging.StreamHandler(sys.stdout)
console_handler.setFormatter(formatter)
# 为logge添加具体的日志处理器
logger.addHandler(file_handler)
logger.addHandler(console_handler)
logger.setLevel(logging.INFO)
class DBHelper:
# 构造函数
def __init__(self, host=‘127.0.0.1‘, user=‘root‘,
pwd=‘123456‘, db=‘testdb‘):
self.host = host
self.user = user
self.pwd = pwd
self.db = db
<