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]'
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)
data = select_demo(conn,sql)
print(data)
len(data)