3.python 连接封装的数据库

?

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

from oracletest1 import MyOracle import xlwt import datetime name='xxx' password='xxx' tnsname='xxx' #连接数据库 myo = MyOracle(name,password,tnsname) #建立指针 cur = myo.mycursor() #查询数据 sql="select * from xxx where flag='0'" #返回查询的表头和数据 tabtopname,row = myo.myquery(sql,cur) #创建EXCLE f = xlwt.Workbook() sheet1 = f.add_sheet("op") k=0 j=0 kk=0 print("写入头部信息") #写入头部信息 for topname in tabtopname:     sheet1.write(0,j,topname[0])     j+=1 #写入数据内容 print("写入数据内容") for g in row:     kk+=1     for h in g:         if(h == "None"):             h = ""               elif(isinstance(h,datetime.datetime)):             h = "to_date('" + str(h) + "','YYYY-MM-DD HH24:MI:SS')"         sheet1.write(kk,k,h)         k+=1     k=0 #保存数据 print("保存数据") f.save("op.xls") #关闭游标连接 myo.mycurclose(cur) myo.myconnclose()   #时间格式转换 """ print(row[0]) b=row[0] print(b[17]) c=b[17] if(isinstance(c,datetime.datetime)):     temp = "to_date('" + str(c) + "','YYYY-MM-DD HH24:MI:SS')"     print(temp)    """