# server默認(rèn)為127.0.0.1，如果打開了TCP動(dòng)態(tài)端口的需要加上端口號(hào)，如'127.0.0.1:1433'
# user默認(rèn)為sa
# password為自己設(shè)置的密碼
# database為數(shù)據(jù)庫名字
server = '127.0.0.1'
user = "sa"
password = "123456"
database = "pubs"
conn = pymssql.connect(server, user, password, database)
# 可簡(jiǎn)化為conn = pymssql.connect(host='localhost', user='sa', password='123456', database='pubs')
cursor = conn.cursor()
cursor.execute('SELECT * FROM titles')
print( cursor.fetchall() ) 
# 如果用pandas讀取數(shù)據(jù)庫
import pymssql
import pandas as pd
conn = pymssql.connect('IP地址','賬號(hào)','密碼','數(shù)據(jù)庫')
sql_1 = "SELECT Id,creat_time from 表名"
#利用pandas直接獲取數(shù)據(jù)"
data = pd.read_sql(sql_1, conn)
conn.close()
print(data)

#coding=utf-8 
# sqlserver的連接
import pymssql
class MSSQL:
 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,"沒有設(shè)置數(shù)據(jù)庫信息")
  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,"連接數(shù)據(jù)庫失敗")
  else:
return cur
 def ExecQuery(self,sql):
  """
  執(zhí)行查詢語句
  返回的是一個(gè)包含tuple的list，list的元素是記錄行，tuple的元素是每行記錄的字段
  """
  cur = self.__GetConnect()
  cur.execute(sql)
  resList = cur.fetchall()
  #查詢完畢后必須關(guān)閉連接
  self.conn.close()
  return resList
 def ExecNonQuery(self,sql):
  """
  執(zhí)行非查詢語句
  調(diào)用示例：
cur = self.__GetConnect()
cur.execute(sql)
self.conn.commit()
self.conn.close()
  """
  cur = self.__GetConnect()
  cur.execute(sql)
  self.conn.commit()
  self.conn.close()
def main():
	# host默認(rèn)為127.0.0.1，如果打開了TCP動(dòng)態(tài)端口的需要加上端口號(hào)，如'127.0.0.1:1433'
 # user默認(rèn)為sa
 # pwd為自己設(shè)置的密碼
 # db為數(shù)據(jù)庫名字
 ms = MSSQL(host='127.0.0.1',user="sa",pwd="123456",db="pubs")
 resList = ms.ExecQuery("SELECT * FROM titles")
 print(resList)
if __name__ == '__main__':
 main()