您好,登錄后才能下訂單哦!
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進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。