Python 连接 Oracle

'''
Created on 2011-8-30

@author: keeny
'''
import cx_Oracle

def getCursor():
    
    dsn_tns = cx_Oracle.makedsn('192.168.0.113', 1521, 'orcl')
    print dsn_tns
    con = cx_Oracle.connect("ad","ad",dsn_tns)
    return con

def queryData(con):
    cursor = con.cursor()
    cursor.execute("select * from tbl_ad")
    print cursor.fetchall()
    con.commit()
    close("self",cursor, con)

def close(self,cursor,con):
    cursor.close()
    con.close()
    print "closed"
if __name__ == '__main__':
    
    con = getCursor()
    queryData(con)