1 # _*_ coding:utf-8 _*_ 2 import requests 3 from bs4 import BeautifulSoup 4 import re 5 import pymysql 6  7 def create(): 8     db = pymysql.connect("localhost", "root", "111111", "aoyang")  # 连接数据库 9     cursor = db.cursor()10     cursor.execute("DROP TABLE IF EXISTS aoy")#查询是否有相同的表，如果有删除，重新建表11     sql = """CREATE TABLE `aoy` (12 `id`  int(10) NOT NULL AUTO_INCREMENT ,13 `name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,14 `Price`  decimal(10,2) NULL DEFAULT NULL ,15 `spec`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,16 `Manufactor`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,17 PRIMARY KEY (`id`)18 )"""19     cursor.execute(sql)20     db.close()21 22 def insert(value):23     db = pymysql.connect("127.0.0.1", "root", "111111", "aoyang")24     cursor = db.cursor()25     sql = "INSERT INTO aoy(name,Price,spec,Manufactor) VALUES (%s, %s, %s, %s)"26     try:27         cursor.execute(sql, value)28         db.commit()29         print('插入数据成功')30     except:31         db.rollback()32         print("插入数据失败")33     #cursor.execute(sql, value)34     #db.commit()35     db.close()36 37 38 def aa():39     ddd = '哈'40     i = [ddd, '22.22', 'kkk','方法']41     q = ['sdasdas', '22.22', 'kkk','问']42 43     insert(q)44 45     insert(i)46 create()47 aa()