Python之旅 3·数据爬虫常见问题

import pymysql
# 建立数据库连接
def getDBConnection():
    print(‘***************getDBConnection start‘)
    host = ‘127.0.0.1‘
    port = 3306
    user = ‘root‘
    password = ‘123‘
    db = ‘music‘
    charset = ‘utf8‘

    DBConnection = pymysql.connect(host=host, port=port, user=user, password=password, db=db, charset=charset)
    return DBConnection

# 保存音乐信息到数据库中
def saveMusicToDB(m_id, m_name, m_link, m_type, m_singer, m_album, m_click, m_collect):
    print(‘**********************saveMusicToDB start‘)
    DBConnection = getDBConnection()
    print(‘dbconnection=‘ + str(DBConnection))
    # 创建 游标
    cursor = DBConnection.cursor()
    sql = ‘insert into orgmusic(m_id,m_name,m_link,m_type,m_singer,m_album,m_click,m_collect) values(%s,%s,%s,%s,%s,%s,%s,%s)‘
    cursor.execute(sql, (m_id, m_name, m_link, m_type, m_singer, m_album, m_click, m_collect))

import urllib.request
from bs4 import BeautifulSoup
import pymysql
import datetime
import random
import gzip