pyqt4 如何连接sql server数据库
pyqt4 如何连接sql server数据库怎么没办法连上呢 老是失败 这有一个使用ODBC连接sqlserver的类，可以参考
class ODBC:
def __init__(self, server, uid, pwd, db, DRIVER='{SQL Server}'):
self.server = server
self.uid = uid
self.pwd = pwd
self.db = db
self.DRIVER = DRIVER
def GetConnect(self):
if not self.db:
raise (NameError, '没有设置数据库信息')
self.conn = pyodbc.connect (SERVER=self.server, UID=self.uid, PWD=self.pwd, DATABASE=self.db,
DRIVER=self.DRIVER)
cur = self.conn.cursor ()
if not cur:
raise (NameError, '连接数据库失败')
else:
return cur
def ExecQuery(self, sql):
cur = self.GetConnect ()
cur.execute (sql)
resList = cur.fetchall ()
self.conn.close ()
return resList
def ExecNonQuery(self, sql):
cur = self.GetConnect ()
cur.execute (sql)
self.conn.commit ()
self.conn.close ()
def main():
ms = ODBC(server='.', uid=‘数据库用户名’, pwd=‘密码’, db=‘库名’)
ms.GetConnect()
页:
[1]