一条条插数据
import cx_Oracle
import numpy as np
conn = cx_Oracle.connect('user/passwd@host/instance')
c = conn.cursor()
x = np.arange(9).reshape((3,3)) # ndarray
z=x.tolist() # ndarray to list
b=[[v] for v in z]
for i in range(10):
c.execute('insert into sales_table (X1,X2) values(:1,:2)',(b[i][0],b[i][1]))
conn.commit()
c.close()
conn.close()
批量插入数据
sql_ins='insert into sales_table (x1,x2) values (:1,:2)'
# 注意(:1,:2)和(:2,:1)一样, :1 是b的第一列,b的列数要和变量数一致
# pg库写法:
# sql_ins='insert into sales_table (x1,x2) values (%s,%s)'
c.executemany(sql_ins,b)
c.execute('commit')
conn.commit()
c.close()
conn.close()