友善交流技术...
python 链接oracle
上一篇 /
下一篇 2012-03-29 11:31:34
/ 个人分类:python
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('')
2、cx_Oracle 下载
http://cx-oracle.sourceforge.net/
收藏
举报
TAG: