oracle_ cursor.executemany

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

def replace_into1(table_name, table_data):     table_data = Hr_Kpi.reset_index(drop=True)<br>　　 table_data=table_data.where(table_data.notnull(),'')     columns = [x for x in list(table_data.columns)]     cursor=conn.cursor()     x_colnames = [k for k in columns ]     list1=[ ]     for j in range(1,len(columns)+1):         list1.append(":"+str(j))     #     # 拼接值 #     sql_values = "','".join(x_value)     #     # 拼接列名     sql_colnames = ",".join(x_colnames)     sql_list1= ",".join(list1)     #     # 生成插入sql     insert_sql = 'insert into %s (%s) values(%s)' % (table_name, sql_colnames, sql_list1 )     print(insert_sql)     args= list(map(tuple,table_data.astype("str").values))     cursor.prepare(insert_sql)     cursor.executemany(None, args)     conn.commit() # replace_into1('test',Hr_Kpi)