`
elan1986
  • 浏览: 164598 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

python oracle

阅读更多
#coding:utf-8
import cx_Oracle as oracle
import os
fp = open('E:\\PyWk\\nodepad_py\\db\\db.txt')
a = fp.readlines()
fp.close()
a = [x.replace('\n', '') for x in a]
db = oracle.connect('******', '******', '******:1521/***')
cr = db.cursor()
t = []
for i in a:
	temp = 'select count(1) from ac01 where aac002=\'' + i +'\''
	cr.execute(temp)
	rs = cr.fetchall()
	print rs
	t += rs
cr.close()
db.close()
#print '***********'
#print t
#print '*****1*****'
t1 = [str(x[0]) + '\n' for x in t]
#print t1 
fp = open('E:\\PyWk\\nodepad_py\\db\\rs.txt', 'w')
fp.writelines(t1)
fp.close()
	

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics