大佬教程收集整理的这篇文章主要介绍了cx_Oracle 查询 传参，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。
#Coding=utf-8
import threading
import time
import cx_Oracle
from pprint import pprint
import csv
table_name = "dbtest.csv"
f = open(table_name + ".csv","w")
conn = cx_Oracle.connect('tlcbuser/tlcbuser@20.5.101.31/tlyy')
cursor = conn.cursor()
def query01():
aa=10
# cursor.execute("SELECT * FROM TEST100 WHERE ID = %s",[aa])
cursor.prepare("""SELECT * FROM TEST100 WHERE ID=:ID""")
cursor.execute(None,{'ID':aa})
row = cursor.fetchall()
return row
a=query01()
print a
#Coding=utf-8
import threading
import time
import cx_Oracle
from pprint import pprint
import csv
table_name = "dbtest.csv"
f = open(table_name + ".csv",{'ID':aa})
row = cursor.fetchall()
return row
a=query01()
print a
C:\Python27\python.exe C:/Users/tlcb/PycharmProjects/unTitled/a1.py
[(10,'10boobook10','10aaaaaaaaaaaa10','10bbbbbbbbbbbbbbbbb10'),(10,'10sssssssss10','tlcb','tlcb')]
Process finished with exit code 0
#Coding=utf-8
import threading
import time
import cx_Oracle
from pprint import pprint
import csv
table_name = "dbtest.csv"
f = open(table_name + ".csv","w")
conn = cx_Oracle.connect('tlcbuser/tlcbuser@20.5.101.31/tlyy')
cursor = conn.cursor()
def query01():
aa=10
bb='tlcb'
# cursor.execute("SELECT * FROM TEST100 WHERE ID = %s",[aa])
cursor.prepare("""SELECT * FROM TEST100 WHERE ID=:cc and A2=:dd""")
cursor.execute(None,{'cc':aa,'dd':bb})
row = cursor.fetchall()
return row
a=query01()
print a
C:\Python27\python.exe C:/Users/tlcb/PycharmProjects/unTitled/a1.py
[(10,'tlcb')]
Process finished with exit code 0
以上是大佬教程为你收集整理的cx_Oracle 查询 传参全部内容，希望文章能够帮你解决cx_Oracle 查询 传参所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。