摘要: 需安装的包 pymysql pandas sqlalchemy import pymysql import pandas as pd from sqlalchemy import create_engine def GetQueryByDF(self,sql): list_conn = self.G 阅读全文
posted @ 2020-02-08 18:00 bigdog 阅读(826) 评论(0) 推荐(0) 编辑
摘要: 1.Oracle 需安装的包 cx_Oracle pandas def GetQueryByDF(self,sql): conn = cx_Oracle.connect("orcl/orcl@localhost:1521/ORCL") # 连接数据库 cur = conn.cursor() cur. 阅读全文
posted @ 2020-02-08 17:55 bigdog 阅读(853) 评论(0) 推荐(0) 编辑