python小脚本之 数据导入 [复制链接] python小脚本之 数据导入 [复制链接] xieaotian 电梯直达 1# 发表于 6 天前 | 只看该作者 有测试数据需要入库, 逗号分隔的 csv格式 ,不想大动干戈用java来操作 写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() 复制代码 xieaotian 电梯直达 1# 发表于 6 天前 | 只看该作者 有测试数据需要入库, 逗号分隔的 csv格式 ,不想大动干戈用java来操作 写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() 复制代码