File: class/Extras/Code/Dbase/dbapi.py

File: class/Extras/Code/Dbase/dbapi.py

########################################
# example of portable database API usage
########################################
from dcoracle import Connect
connobj = Connect("user/password@system")
cursobj = connobj.cursor()
value1,value2 ='developer', 40
query = 'SELECT name, shoesize FROM empl WHERE job = ? AND age = ?'
cursobj.execute(query, (value1, value2))
results = cursobj.fetchall()
for (name, size) in results:
 print name, size



AltStyle によって変換されたページ (->オリジナル) /