python3读取sqlserver数据库数据

最新推荐文章于 2021-02-09 06:45:41 发布

李家小少爷

最新推荐文章于 2021-02-09 06:45:41 发布

阅读量5.5k

点赞数

分类专栏： python 文章标签： python sqlserver pandas

本文链接：https://blog.csdn.net/qq_36114862/article/details/80411140

版权

python 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

#!/usr/bin/env python
# encoding: utf-8
"""
@author: Frank
@file: sqlserver.py
@time: 2017/5/22
"""
import pyodbc
import pandas as pd
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=2001:da8:700e:e00:d129:18c:5345:5a44;DATABASE=zc_nxjc_znc_znf_dcs02;UID=sa;PWD=123456')
#cur = conn.cursor()
#cur.execute("select top 3 * from dbo.DCSContrast")
#resList = cur.fetchall()#fetchall()是接收全部的返回结果行
#if not cur:
# raise (NameError,"数据库连接失败")
#df = pd.DataFrame(resList)
df = pd.read_sql("select * from dbo.DCSContrast",con=conn)
df1=pd.read_sql("select * from History_ProcessVariable01",con=conn)
conn.close()
print(df1)