python练习 0001,0002,0003

来源：互联网发布：网络平台创业计划书编辑：程序博客网时间：2024/05/17 09:46

第 0001 题：做为 Apple Store App 独立开发者，你要搞限时促销，为你的应用生成激活码（或者优惠券），使用 Python 如何生成 200 个激活码（或者优惠券）？

# -*- coding: utf-8 -*-#激活码：RHLZP-4YKRB-HKC5Cimport random,stringimport mysql.connectorimport mysqlimport rediscode = string.digits+string.ascii_letters

#随机生成,n表示生成验证码n组，生成m组码def to_code(m,n):    a = ""    for i in range(m):        for j in range(n):            b = "".join(random.sample(code,5))            if j == n-1:                a = a + b            else:                a = a + b + '-'        print(a)        a=""if __name__ == '__main__':    to_code(200,5)

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

# -*- coding: utf-8 -*-#激活码：RHLZP-4YKRB-HKC5Cimport random,stringimport mysql.connectorimport mysqlimport rediscode = string.digits+string.ascii_letters

#随机生成,n表示生成验证码n组，生成m组码def to_code(m,n):    a = ""    for i in range(m):        for j in range(n):            b = "".join(random.sample(code,5))            if j == n-1:                a = a + b            else:                a = a + b + '-'        print(a)        # to_mysql(a,i)        a=""#存入关系型数据库Mysqldef to_mysql(a,i):    conn = mysql.connector.connect(user='root', password='', database='code')    cursor = conn.cursor()    cursor.execute('show tables')    tb_list = []    for tb in cursor.fetchall():        tb_list.append(tb[0])    if 'code' not in tb_list:        cursor.execute('create table code(id VARCHAR(20) PRIMARY KEY ,code VARCHAR(200))')    cursor.execute('insert into code(id,code) values(%s,%s)',[i,a])    cursor.rowcount    conn.commit()    conn.close()if __name__ == '__main__':    to_code(200,5)

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

# -*- coding: utf-8 -*-#激活码：RHLZP-4YKRB-HKC5Cimport random,stringimport mysql.connectorimport mysqlimport rediscode = string.digits+string.ascii_letters#随机生成,n表示生成验证码n组，生成m组码def to_code(m,n):    a = ""    for i in range(m):        for j in range(n):            b = "".join(random.sample(code,5))            if j == n-1:                a = a + b            else:                a = a + b + '-'        print(a)        r.set(i, a)        a=""#存入非关系型数据库Redisr = redis.Redis(host='127.0.0.1',port=6379,db=0)if __name__ == '__main__':    to_code(200,5)

阅读全文

0 0