1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 | import threading import datetime import pymssql import time from faker import Faker def insert_db(): for i in range ( 100 ): for j in range ( 100 ): print (j) time1 = datetime.datetime.now() fake = Faker(locale = 'zh_CN' ) name = fake.name() ssn = fake.ssn() card_number = fake.credit_card_number() phone_number = fake.phone_number() print (datetime.datetime.now() - time1) print (name, ssn, card_number, phone_number) conn = pymssql.connect(host = 'ip' , user = 'sa' , password = 'password' , database = 'db' , charset = 'UTF-8' ) cur = conn.cursor() sql = 'This is the sql' print (sql) cur.execute(sql) conn.commit() cur.close() conn.close() exitFlag = 0 class myThread(threading.Thread): def __init__( self , threadID, name, counter): threading.Thread.__init__( self ) self .threadID = threadID self .name = name self .counter = counter def run( self ): print ( "开始线程:" + self .name) print_time( self .name, self .counter, 5 ) insert_db() print ( "退出线程:" + self .name) def print_time(threadName, delay, counter): while counter: if exitFlag: threadName.exit() time.sleep(delay) print ( "%s: %s" % (threadName, time.ctime(time.time()))) counter - = 1 for i in range ( 50 ): # 创建新线程 locals ()[ 'thread' + str (i)] = myThread(i, "Thread-%s" % i, i) for i in range ( 50 ): # 开启新线程 locals ()[ 'thread' + str (i)].start() for i in range ( 50 ): locals ()[ 'thread' + str (i)].join() print ( "退出主线程" ) |
locals()['thread' + str(i)] 这个方法可以生成thread1,thread2,thread3...这些参数
Faker 是python造数常用的一个库
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 25岁的心里话
· 闲置电脑爆改个人服务器(超详细) #公网映射 #Vmware虚拟网络编辑器
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 零经验选手,Compose 一天开发一款小游戏!
· 一起来玩mcp_server_sqlite,让AI帮你做增删改查!!