使用的是cx_Oracle-6.1版本
封装目的:在cx_Oracle模板发生变更时,便于框架代码的维护; 方便调用oracle
# -*- coding:utf-8 -*-
import os
import cx_Oracle
from Tools.Log import Log
from Tools.Singleton import Singleton
from Tools.Config import Config
from Tools.tools import decoLOG
os.environ['NLS_LANG'] = 'AMERICAN_AMERICA.AL32UTF8'
'''
功能: Oracle类
作者: 郭可昌
作成时间: 20180213
更新内容:
更新时间:
'''
class Oracle(Singleton):
def __init__(self):
cfg = Config()
self.name = cfg.getItem("database", "NAME")
self.password = cfg.getItem("database", "PASSWORD")
self.url = cfg.getItem("database", "URL")
self.cursor = None
self.isClosed = True
# oracle connect
@decoLOG
def open(self):