cx_oracle用户名密码变量,cx_Oracle模块学习之绑定变量

有些时候我们需要和程序交互，此时需要绑定量

下面两个例子简介在SELECT 和 DML 里面绑定变量的用法

SELECT 里面的绑定变量

[root@Ora10G py]# cat SelectBinding.py

#!/bin/env python

#coding=utf-8

#filename:execise binding in select

#Author:DBA_WaterBin

import cx_Oracle

conn=cx_Oracle.connect(\'hr/hr@orcl\')

cur=conn.cursor()

dept_id=raw_input(\'\n please input department ID you want to search:\')

dept_name=raw_input(\' please input department name you want to seaarch:\')

cur.execute(\'\'\'select * from departments

where department_id=:id and

department_name=:name

\'\'\',id=dept_id,name=dept_name

)

rows=cur.fetchall()

print \'\ninformation are as following:\'

for row in rows:

print row

cur.close()

conn.close()

DML 里面的绑定变量

[root@Ora10G py]# cat DmlBinding.py

#!/bin/env python

#coding=utf-8

#filename:execise binding in dml

#Author:DBA_WaterBin

import cx_Oracle

conn=cx_Oracle.connect(\'hr/hr@orcl\')

cur=conn.cursor()

cur.execute(\'\'\'insert into departments (department_id,department_name,manager_id,location_id)

values(:ID,:NAME,:MGR_ID,:LOC_ID)

\'\'\', {\'ID\':555,\'NAME\':\'WaterBin\',\'MGR_ID\':110,\'LOC_ID\':7788}

)

cur.close()

conn.commit()

conn.close()

By DBA_WaterBin

2013-09-09

good luck