python爬取豆瓣TOP250并保存到Mysql中

最新推荐文章于 2023-04-26 23:56:53 发布

irons mo

最新推荐文章于 2023-04-26 23:56:53 发布

阅读量1.4k

点赞数

分类专栏： Python 数据库文章标签： Python 爬虫 Mysql

本文链接：https://blog.youkuaiyun.com/jyc1020/article/details/102536356

版权

代码

#!/usr/bin/env python 
# -*- coding:utf-8 -*-
import pymysql
import requests
from bs4 import BeautifulSoup
import lxml

def createDB():
    # 创建数据库
    print("创建数据库doubantop250...")
    try:
        conn = pymysql.connect(host="localhost",
                               port=3306,
                               user="用户名",
                               password="密码",
                               charset="utf8")
        cur = conn.cursor()
        createSql = "create database if not exists doubanTop250 default charset utf8"
        cur.execute(createSql)
        conn.commit()
        print("创建成功")
    except pymysql.Error as e:
        print("pymysql Error: ", e.args[0], e.args[1])
    finally: