本文介绍了一个使用Python和pyodbc库连接SQL Server并批量插入数据到指定表的示例代码。通过定义一个函数实现循环插入不同数据，并展示了如何使用datetime模块获取当前时间。
#encoding=utf-8
import pyodbc
import random,datetime
conn = pyodbc.connect(r'DRIVER={SQL Server Native Client 10.0};SERVER=IP,1433;DATABASE=test;UID=sa;PWD=******')
def insert(n,str):
while(1):
cursor = conn.cursor()
randonstr=random.randint(1000, 10000)
print randonstr
tem = '%d' %randonstr
str1=str+datetime.datetime.now().strftime('%Y%m%d%H%M%S')
str1=str1+tem
print str1
cursor.execute("insert into student(id,name) values('%d','%s')"%(n,str1))
n=n+1
cursor.close()
conn.commit()
str=u'字符串'
insert(3,str)
import pyodbc
import random,datetime
conn = pyodbc.connect(r'DRIVER={SQL Server Native Client 10.0};SERVER=IP,1433;DATABASE=test;UID=sa;PWD=******')
def insert(n,str):
while(1):
cursor = conn.cursor()
randonstr=random.randint(1000, 10000)
print randonstr
tem = '%d' %randonstr
str1=str+datetime.datetime.now().strftime('%Y%m%d%H%M%S')
str1=str1+tem
print str1
cursor.execute("insert into student(id,name) values('%d','%s')"%(n,str1))
n=n+1
cursor.close()
conn.commit()
str=u'字符串'
insert(3,str)
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
