当当1000图书书籍存储到mysql中

最新推荐文章于 2024-10-13 14:19:13 发布

jackieclzheng

最新推荐文章于 2024-10-13 14:19:13 发布

阅读量732

点赞数 1

分类专栏： python爬虫文章标签：当当指定书目基本信息爬取存储爬虫信息到mysql python与mysql的连接

本文链接：https://blog.csdn.net/jackieclzheng/article/details/90760180

版权

'''
1-当当网指定书籍信息检索指定个数，
2-结果存储到mysql的dangdang_books中
'''
from dangdang_book_2 import getvaluespages,getvalues,download
import pymysql # 引入MySQL的第三方模块
from book import Book


# 存储指定条目书到数据库
def savevalues_mysql(books):
    # 1- 新建连接
    connect = pymysql.Connection(host = "localhost",
                       user = "root",
                       password = "mysql",
                       port = 3306,
                       database = "dangdang_db",
                       charset = "utf8"
                       )

    # 2- 执行者  执行谁  怎么执行
    cursor = connect.cursor()
    insert = """insert into dangdang_books 
    (书名,作者,价格,出版社) 
    values (%s,%s,%s,%s) """
    # 执行书籍的添加，但是books本书-执行len(books)次
    for book in books:
        rows = cursor.execute(insert,[book.bname,book.bauthor,book.bprice,book.bpublisher])