dragonzoebai的专栏

import pymssqlconn = pymssql.connect(host="10.19.1.50",user="sa",password="123",database="DBFloodPrev")cursor = conn.cursor()cursor.execute("select * from tbDepartment")rows=cursor.fetchall()pri

import pymssqlSQLSERVER = '10.19.1.50'USER = 'sa'PASSWORD = '123'DATABASE = 'GuBei_Data'g_Conn = Nonedef openDB(): global g_Conn g_Conn = pymssql.connect(host=SQLSERVER,user=USER,passw

#_*_encoding:utf-8_*_import pymssqlimport osclass MSSQLHelper: def __init__(self,host,user,pwd,db): self.host=host self.user=user self.pwd=pwd self.db=db d