如何在数据库中使用cx_oracle

#fetchone

导入cx_Oracle

ora = cx_Oracle.connect('scott/tiger@192.168.56.152:1521/orcl')

cursor = ora.cursor()

cursor.execute('从 emp 中选择 *')

while 1:

res = curve.fetchone( )

如果 res == None:

中断

print(res)

cursor.close()

ora.close()

# fetchmany

#使用dsn解析成tns字符串并连接数据库

tnsname = cx_Oracle.makedsn('192.168. 56.151','1521','orcl')

ora = cx_Oracle.connect('system','oracle',tnsname)

cursor.execute('select * from dba_objects')

resCount=0

while 1:

res =cursor.fetchmany(10)

if res == []:

break

resCount += 10

cursor.close()

ora.close ()

#使用绑定变量

导入cx_Oracle

ora = cx_Oracle.connect('scott/tiger@192.168.56.152:1521/orcl')

cursor = ora.cursor()< /p>

#使用位置对应参数

cursor.execute('select * from t1 where DEPTNO = :1',(10,))

print(cursor.fetchall())

# 使用字典传入参数

param={'dno':20}

cursor.execute('select * from t1 where DEPTNO = :dno',param)

print(cursor.fetchall())< /p>

cursor.execute('select * from t1 where DEPTNO = :dno or DNAME=:dn',dno=40,dn='ACCOUNTING')

print(cursor.fetchall( ))

cursor.close()

ora.close()

导入cx_Oracle

#使用tnsnames文件别名链接

# ora = cx_Oracle.connect( 'scott/tiger@orcl')

#使用字符串传递输入参数链接

# ora = cx_Oracle.connect('scott /tiger@192.168.56.152:1521/orcl')

# 使用字符串分别传入用户名和密码

# ora = cx_Oracle.connect('scott','tiger','192.168.56.152:1521/orcl')

# 使用dsn解析成tns字符串并连接数据库

tnsname = cx_Oracle.makedsn('192.168.56.152','1521','orcl')

#使用sysdba或其他角色链接

p>

# ora = cx_Oracle.connect('sys','oracle','192.168.56.152:1521/orcl',mode=cx_Oracle.SYSDBA)

cursor = ora.cursor()

cursor.prepare('update t1 set LOC=:loc where DEPTNO=:dno')

cursor.execute(None, {'loc':'BEIJING','dno':50}) #使用prepare函数，可以直接传入execute中的参数，无需传入sql语句。注意：这里第一个参数必须为None

ora.commit()

Cursor.execute('select * from t1')

while 1:

res =cursor.fetchone()

if res == None:

p>

break

print(res)

cursor.close( )

ora.close()

导入cx_Oracle

#使用 tnsnames文件别名链接

# ora = cx_Oracle.connect('scott/tiger@orcl ')

#使用字符串并传递在参数链接中

# ora = cx_Oracle.connect('scott/tiger@192.168 .56.152:1521/orcl')

# 使用字符串传入用户名、密码等

# ora = cx_Oracle. connect('scott','tiger','192.168.56.152:1521/orcl')

# 使用dsn解析成tns字符串并连接数据库

tnsname = cx_Oracle.makedsn('192.168.56.152','1521','orcl')

ora = cx_Oracle.connect('scott','tiger',tnsname )

#使用sysdba或其他角色链接

# ora = cx_Oracle.connect('sys','oracle','192.168 .56.152 :1521/orcl',mode=cx_Oracle.SYSDBA)

cursor = ora.cursor()

#执行多条语句

list1 = [(60,'工程师','悉尼'),(70,'潜水员','南非')]

cursor.prepare('插入t1 value(:1,:2,:3)')

cursor.executemany(None,list1) #使用prepare函数，可以直接传入t执行时只传入参数，不传入sql语句。注意：这里第一个参数必须为None

ora.commit()

Cursor.execute('select * from t1')

while 1:

res =cursor.fetchone()

if res == None: / 关闭()

ora.close()

#调用函数

cursor.callfunc(name, returnType,parameters=[],keywordParameters={})

#cx_Oracle.STRING