python数据库操作
- 格式:doc
- 大小:36.50 KB
- 文档页数:3
数据库连接
# coding:gbk
'''
Created on 2010-7-15
@author: Administrator
'''
import cx_Oracle
dsn=cx_Oracle.makedsn("150.150.1.45",1521,"dx") conn=cx_Oracle.connect("test","123",dsn) print"连接oracle成功!"
try:
cur=conn.cursor()
sql="select * from portt_type"
rr=cur.execute(sql)
row=cur.fetchall()
for x in row:
print"记录",x[0],x[1]
cur.close()
except Exception,e:
print e
else:
print"一切正常"
finally:
conn.close()
print"连接关闭"
数据库操作
# coding:gbk
'''
Created on 2010-7-15
@author: Administrator
'''
import cx_Oracle
#用户名,密码,服务名
db=cx_Oracle.connect("user","pass","tns_name")
c=db.cursor();
#建表
c.execute("create table test(a int,b varchar2(100))")
#建序列
c.execute("create sequence stest")
#插入数据
c.execute("insert into test(a,b) values(stest.nextval,'Python')")
c.execute("insert into test(a,b) values(stest.nextval,'Oracle')") #检索插入的数据
sql = "select * from test"
r = c.execute(sql)
row = c.fetchone()
while row:
(a,b)=(row[0],row[1])
print a,b
row=c.fetchone()
#删除插入的数据
sql = "delete from test where a=1"
c.execute(sql)
#检索
sql = "select * from test"
r = c.execute(sql)
row = c.fetchone()
while row:
(a,b)=(row[0],row[1])
print a,b
row=c.fetchone()
#清理表和序列
c.execute("drop table test")
c.execute("drop sequence stest") mit()
db.close()