python_dbpython_db

import cx_Oracle
import os
try:
    os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.utf8'
    db = cx_Oracle.connect('数据库用户名', '数据库密码', '数据库IP地址/数据库实例')
    c = db.cursor()
    ##读取SQL文件,获得sql语句的list
    with open(u'E:\test.sql', 'r+') as f:
        sql_list = f.read().split(';')[:-1]  # sql文件最后一行加上;
        sql_list = [x.replace('n', ' ') if 'n' in x else x for x in sql_list]  # 将每段sql里的换行符改成空格
    ##执行sql语句，使用循环执行sql语句
    for sql_item  in sql_list:
        # print (sql_item)
        c.execute(sql_item)
except cx_Oracle.Error as e:
    print e
finally:
    c.close()
    db.commit()
    db.close()