python ODBC 操作数据库

 
import pyodbc
def init_db():
  try:
      conn = pyodbc.connect('DRIVER=SQL Server Native Client 10.0;SERVER=10.10.10.166;DATABASE=diaodu;UID=sa;PWD=sjtu123456')
      #conn = pyodbc.connect( 'DRIVER=SQL Server Native Client 10.0;SERVER=DESKTOP-D4405JU;DATABASE=test;UID=kds;PWD=kds123456')
      return conn
  except:
      print ("Error:数据库连接错误")
      return None

def select_demo(conn, sql):
  try:
      cursor = conn.cursor()
      cursor.execute(sql)
      return cursor.fetchall()
  except:
      print ("Error:数据库选择错误")
      return None
sql = 'select [Day_seven] from [diaodu].[dbo].[Seven_day_predict]'

#sql = 'select * from [diaodu].[dbo].[Seven_day_predict]'

conn = init_db()
data = select_demo(conn,sql)
print(data)
len(data)