1.生成200個指定長度的隨機碼
python小程序。import random
import string
def rand_str(num,len=7):
f = open('file.txt','w')
count = 1
for i in range(num):
restr = ''
chars = string.ascii_lowercase+ string.digits
for i in range(len):
restr += random.choice(chars)
f.write( str(count)+ ' ' + restr +' ')
count += 1
f.close()
if __name__ == '__main__':
rand_str(200,20)
知識點:
1.隨機取值:
random.choice
2.w是寫入,wb就是寫入二進制文件了。
f = open('file.txt','w')
3.int轉為str
str(count)
二、把1中生成的隨機碼存到數據庫中
#-*- coding:utf-8 -*-
'''
02
'''
import string
import random
import pymysql
#用于生成隨機字符串List的函數
def geneRandStr(num,len=7):
strList = []
for i in range(num):
restr = ''
chars = string.ascii_lowercase + string.digits
for i in range(len):
restr += random.choice(chars)
strList.append(restr)
return strList
#把字符串List存入數據庫
def storeInMysql(codeList):
try:
conn = pymysql.connect(host='127.0.0.1',user = 'root',
password = '123456',db = 'pytest')
cur = conn.cursor()
except BaseException as e:
print(e)
else:
try:
cur.execute('DROP DATABASE pytest ')
cur.execute('CREATE DATABASE IF NOT EXISTS pytest ')
cur.execute('USE pytest')
cur.execute('''CREATE TABLE IF NOT EXISTS code(
id INT NOT NULL AUTO_INCREMENT,
code VARCHAR (32) NOT NULL,
PRIMARY KEY (id)
)''')
for code in codeList:
cur.execute('INSERT INTO code(code) VALUES (%s)',(code))
cur.connection.commit()
except BaseException as e:
print(e)
finally:
cur.close()
conn.close()
if __name__ == '__main__':
storeInMysql(geneRandStr(20,10))
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态