当前位置:Gxlcms > mysql > python读sqlserver库Grid显示窗体程序

python读sqlserver库Grid显示窗体程序

时间:2021-07-01 10:21:17 帮助过:16人阅读

欢迎进入Windows社区论坛,与300万技术人员互动交流 >>进入 # Author: scott # # Created: 04/02/2012 #------------------------------------------------------------------------------- import pymssql import sys import decimal reload(sys) sys.setde

欢迎进入Windows社区论坛,与300万技术人员互动交流 >>进入

  # Author: scott

  #

  # Created: 04/02/2012

  #-------------------------------------------------------------------------------

  import pymssql

  import sys

  import decimal

  reload(sys)

  sys.setdefaultencoding( "utf8" )

  class MSSQL:

  """

  对pymssql的简单封装

  pymssql库,该库到这里下载:http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql

  使用该库时,需要在Sql Server Configuration Manager里面将TCP/IP协议开启

  用法:

  """

  def __init__(self,host,user,pwd,db):

  self.host = host

  self.user = user

  self.pwd = pwd

  self.db = db

  def __GetConnect(self):

  """

  得到连接信息

  返回: conn.cursor()

  """

  if not self.db:

  raise(NameError,"没有设置数据库信息")

  self.conn = pymssql.connect(host=self.host,user=self.user,password=self.pwd,database=self.db,charset="utf8")

  cur = self.conn.cursor()

  if not cur:

  raise(NameError,"连接数据库失败")

  else:

  return cur

  def ExecQuery(self,sql):

  """

  执行查询语句

  返回的是一个包含tuple的list,list的元素是记录行,tuple的元素是每行记录的字段

  调用示例:

  ms = MSSQL(host="localhost",user="sa",pwd="123456",db="PythonWeiboStatistics")

  resList = ms.ExecQuery("SELECT id,NickName FROM WeiBoUser")

  for (id,NickName) in resList:

  print str(id),NickName

  """

  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()

  """

  cur = self.__GetConnect()

  cur.execute(sql)

  self.conn.commit()

  self.conn.close()

[1] [2] [3]

人气教程排行