def cxOracleolbTrasferDict(dbsearchresult):
readstr = ""
for i in dbsearchresult.read():
readstr = readstr + i
responsedict = eval(readstr)
return responsedict
DB的封装
#-*- coding: utf-8 -*-
import configparser
import pymysql as mdb
import os
import cx_Oracle as ora
import sys
"""
单例模式获取数据连接
"""
def singleton (cls, *args, **kwargs):
instances = {}
def get_instance(*args, **kwargs):
if args not in instances:
instances[args] = cls(*args, **kwargs)
return instances[args]
return get_instance
"""
数据库操作
"""
def dao(db,sql):
cur = Conn(db)
# print(cur)
if sql.lower().startswith("select"):
return cur.query(sql)
else:
return cur.modify(sql)
@singleton
class Conn(object):
sql = []
db