import pymssql
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() 免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
