python　链接oracle

1、python　链接oracle　代码

import cx_Oracle
class Oracle():
    con = cx_Oracle.connect('system','tester','localhost:1521/ORCL')
    cursor = con.cursor()
    def select(self,sqselect):
        sqselect="""SELECT * FROM fang"""
        self.cursor.execute(sqselect)
        row=self.cursor.fetchall()
        print row[0][0]
        self.cursor.close()
        self.con.close()

    def insert(self,sqlinsert):
        sqlinsert=""" insert into fang values(10000,'fang',30) """
        self.cursor.execute(sqlinsert)
        self.cursor.close()
        self.con.commit()
        self.con.close()

    def update(self,sqlupdate):
        sqlupdate=""" update fang set id=110 where name='fang' """
        self.cursor.execute(sqlupdate)
        self.cursor.close()
        self.con.commit()
        self.con.close()

    def createtable(self,sqlcreate):
        sqlcreate=""" create table fang(id int ,name varchar(10),age int) """
        self.cursor.execute(sqlcreate)
        self.cursor.close()
        self.con.commit()
        self.con.close()

oracle=Oracle()
print oracle.select('')

２、cx_Oracle　下载

http://cx-oracle.sourceforge.net/