Python链接数据库查询

 1 import cx_Oracle
 2 #conn = cx_Oracle.connect('payment_sx/payment_sx0703@172.16.39.8/ecom')
 3 
 4 conn = cx_Oracle.connect('paymentmrl/paymentmrl0528@172.16.39.7/ecom')
 5 
 6 cur = conn.cursor()
 7     
 8 #sql = "select order_no from spm_app_prodouctorder"
 9 
10 sql = "select order_no,pay_no from spm_app_prodouctorder where pay_no is not null"
11 
12 cur.execute(sql)
13 
14 rows = cur.fetchall()
15 
16 f1 = open("C:\\Users\\YHXX\\Desktop\\order_no.txt","a")
17 
18 f2 = open("C:\\Users\\YHXX\\Desktop\\pay_no.txt","a")
19 
20 for row in rows:
21 
22     f1.writelines("%s\n" % row[0])
23 
24     f2.writelines("%s\n" % row[1])
25     
26     print(row[0],row[1])
27 
28 
29 f1.close()
30 
31 f2.close()
32 
33 cur.close()
34     
35 conn.commit()
36     
37 conn.close()

posted on 2019-09-11 16:27 阿宅gogo 阅读(92) 评论(0) 编辑收藏举报