文件操作-结合oracle数据库

import cx_Oracleimport os
from openpyxl import load_workbook

os.environ[‘NLS_LANG‘] = ‘SIMPLIFIED CHINESE_CHINA.UTF8‘



def updateOracle(sql):
    os.environ[‘NLS_LANG‘] = ‘SIMPLIFIED CHINESE_CHINA.UTF8‘  # 读取数据中文全是问号的问题
    conn = cx_Oracle.connect(‘loan_c/[email?protected]:1521/testdb‘)
    cursor = conn.cursor()
    cursor.execute(sql)
    conn.commit()
    cursor.close()
    conn.close()


def selectOracle(sql):
    os.environ[‘NLS_LANG‘] = ‘SIMPLIFIED CHINESE_CHINA.UTF8‘  # 读取数据中文全是问号的问题
    conn = cx_Oracle.connect(‘loan_c/[email?protected]:1521/testdb‘)
    cursor = conn.cursor()
    cursor.execute(sql)
    s = cursor.fetchone()[0]
    cursor.close()
    conn.close()
    return s




#----------------------------------------------------执行-------------------------------------------
wb = load_workbook("renhanggaoduan.xlsx")
ws = wb.active



#更新datetime.date格式到oralce数据库

updateOracle("update lb_t_customter_info set birthday=to_date(‘%s‘,‘yyyy-mm-dd‘) where id =(select r.fk_cust_id from lb_t_into_customer_ref r where r.fk_into_app_id = ‘120154630763‘)"%((ws["D242"].value).date()))

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!