每天一个python小程序

def getrand():
        while True:
                a=random.randint(48,122)
                if a<=57 or (a>=65 and a<=90) or (a>=97 and a<=122):
                        break
        return a
if __name__=='__main__':
        import random
        import pymysql
        array=[]
        for k in range (200):
                rand=''
                for i in range(6):
                        rand=rand+chr(getrand())
                array.append(rand)
        conn=pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='',db='mysql')
        cur=conn.cursor()
        cur.execute('create table if not exists juan (ma varchar(20))')
        cur.executemany("insert into juan values(%s)",array)
        cur.close()
        conn.commit()
        conn.close()