python控件与数据库的关联,python 操作数据库

coding: utf-8

功能说明：

对数据的操纵进行补充

日期 20190527

import pymssql

import pymysql

import time

from SQL import SQL

from Server_Info import DB_Info

class Operate_DB(object):

"""docstring for Operate_DB"""

def init(self, DB_Info):

if DB_Info[‘Type‘]==‘pymssql‘:

self.conn=pymssql.connect(host=DB_Info[‘HostName‘],database=DB_Info[‘Database‘],user=DB_Info[‘User‘],password=DB_Info[‘Password‘])

elif DB_Info[‘Type‘]==‘pymysql‘:

self.conn=pymysql.connect(host=DB_Info[‘HostName‘],database=DB_Info[‘Database‘],user=DB_Info[‘User‘],password=DB_Info[‘Password‘])

else:

print(‘error‘)

def O_DB(self,SQL,Action,*args):

if Action==‘serach‘:

# self.conn.cursor.execute(SQL)

yield self.conn.cursor.fetchall()

elif Action == ‘Insert‘:

self.conn.cursor().execute(SQL)

else:

print(error)

def close_DB(self):

self.conn.commit()

self.conn.close()