python连接mysql/Oracle及读取数据库内容

    import pymysql
    import pandas as pd 
    import numpy as np
    conn =pymysql.connect(host='192.168.X.X',port=3306,user = 'root',passwd='XXXXX',db='XXX',charset='utf8') 
    #db：库名；charset='utf8'可解决导入中文乱码问题；
    sqlcmd="select * from XXXX limit 100"
    a=pd.read_sql(sqlcmd,conn)
    #直接读取是dataframe格式，np.array()即可转换为数组格式；
    b=np.array(a)
    print(b[0],'\n',b[1,3])#输出换行

Oracle:

import cx_Oracle
import pandas as pd
dsn=cx_Oracle.makedsn("192.XXX.XX.XX",33XX,"XXXX")#ip，端口，库名
conn=cx_Oracle.connect("username","password",dsn)
sqlcmd="select * from XXXX limit 100"
a=pd.read_sql(sqlcmd,conn)

b=pd.read_csv('D:/XXX.csv',encoding='gb2312')#encoding可解决读取本地文件的中文编码显示问题；