返回顶部

收藏

Python 数据导入

更多
import cx_Oracle   

dns_tns=cx_Oracle.makedsn("192.168.0.288",1521,"skynet")   
print dns_tns   
con = cx_Oracle.connect('alibaba', 'zhimakamen', dns_tns)   
cur=con.cursor()   

for index,line in enumerate(file("f2.csv")):   
  sql="""insert into iq_data_B011F8286A1B2000A   
    (field1,field2,field3,field4) values ("""  
  for fields in (line.split(",")):   
    sql=sql+"'"+fields+"'," 
  cur.execute(sql[:-1]+")")   

con.commit()   
con.close()
#该片段来自于http://outofmemory.cn

标签:python,数据库

收藏

0人收藏

支持

0

反对

0

发表评论