Python 结缘Oracle、MySQL

Oracle http://cx-oracle.sourceforge.net/html/index.html
模块名称：cx_Oracle

 

#!/usr/bin/python

import cx_Oracle

connstr='scott/tiger'
conn = cx_Oracle.connect(connstr)
curs = conn.cursor()
curs.execute('select * from emp')
print curs.description
for row in curs:
print row
conn.close()

MySQL http://mysql-python.sourceforge.net/MySQLdb.html
模块名称：MySQLdb

#!/usr/bin/python

import MySQLdb

conn = MySQLdb.connect (host = "localhost",user = "testuser",passwd = "testpass",db = "test")
cursor = conn.cursor ()
cursor.execute ("SELECT VERSION()")
row = cursor.fetchone ()
print "server version:", row[0]
cursor.close ()
conn.close ()