要求

将 0001 题生成的 200 个激活码（或者优惠券）保存到 MySQL 关系型数据库中。

代码

import string
import random
import pymysql
db=pymysql.connect(host="localhost",
                   user="root",
                   password="Yuyy0800",
                   db="big_database",
                   charset="utf8")

def getKeys():
    list=[]
    str=string.ascii_uppercase
    for i in range(200):
        key = ""
        for j in range(16):
            key+=random.choice(str)
            if (j+1)%4==0 and j !=15:
                key+="-"
        if not key in list:
            list.append(key)
            print(key)
        else:
            i-=1
    return list
def main():
    list=getKeys()
    try:
        with db.cursor() as cursor:
            for i in range(200):
                sql="insert into pythoneveryday0002keys (keyName) values  ('"+\
                    list[i]+"');"
                print("执行sql："+sql)
                cursor.execute(sql)
            cursor.connection.commit()
    finally:
        db.close()

main()