cx_oracle使用参数,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 &#