dragonzoebai的专栏

import pymssql conn = 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 pymssql SQLSERVER = '10.19.1.50' USER = 'sa' PASSWORD = '123' DATABASE = 'GuBei_Data' g_Conn = None def openDB(): global g_Conn g_Conn = pymssql.connect(host=SQLSERVER,user=USER,passw

#_*_encoding:utf-8_*_ import pymssql import os class MSSQLHelper: def __init__(self,host,user,pwd,db): self.host=host self.user=user self.pwd=pwd self.db=db d