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:Python27python.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:Python27python.exe C:/Users/tlcb/PycharmProjects/untitled/a1.py

[(10,'tlcb')] 


Process finished with exit code 0

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!