37,720
社区成员
发帖
与我相关
我的任务
分享
import time
import random
import pymssql
def getone(sql,*args):
try:
conn = pymssql.connect(host='127.0.0.1', user='sa', password='123456', database='fpjl')
except:
print("连接错误")
cur = conn.cursor()
cur.execute(sql,(args))
conn.commit()
conn.close()
fpdm='00000000144011620878'
qshm='00033005'
jshm='00045000'
tablename='js_fpmxzb'+time.strftime('%Y%m',time.localtime())
date=time.strftime('%Y-%m-%d',time.localtime())
sqlstr= ''' insert into {}( ID,JQBH,KPRQ,KPLX,FPHM,KPZJE,SKM,YFPHM,FPDM,FKR,KPYMC,XMS,CZR,CZSJ,jxzt,kpxm,ywlshm) values('{}','0000007010498297','{}','41',%s,'0.00','000000','00000000','{}',
'个人','文冲','0','wlkp','{}','0','','' ) '''.format(tablename,time.strftime('%Y%m',time.localtime())+str(random.randint(0,99999)),date,fpdm,date)
fphm=int(qshm)
while fphm<=int(jshm):
getone(sqlstr,('0000000'+str(fphm))[-8:])
fphm=fphm+1
def getone(sql,*args):
try:
conn = pymssql.connect(host='127.0.0.1', user='sa', password='123456', database='fpjl')
cur = conn.cursor()
cur.execute(sql,(args))
conn.commit()
conn.close()
except Exception as ex:
print("连接错误,",ex.value)
问题很明显,一旦报错,后面的conn就是没申明。
试试看是不是try的问题。
链接一次,insert一条——这种方法很不好