python通用数据库连接_python连接数据库的几种方式！

# -*- coding: utf-8 -*-

"""

-------------------------------------------------

File Name： Database.py

Author : LiSen

Date： 2018/6/26 15:51:

-------------------------------------------------

"""

'''

database

两个库：1、MySQLdb:只能python2版本用

2、PyMySQL:python2.3通用

Oracle：cx_Oracle

'''

import MySQLdb

import pymysql

import cx_Oracle

instance = {}

def singleton_mode(cls):

def incall(*args,**kwargs):

if cls not in instance:

instance[cls] = cls(*args,**kwargs)

return instance[cls]

return incall

@singleton_mode

class Mysql(object):

def __init__(self, host, user, password, db, port, charset):

self.connect = MySQLdb.Connect(

host&#