streamlit连接mysql数据库

Question

在python的streamlit库中如何连接MySQL数据库？

Answer 1

import matplotlib.pyplot as plt
import pymysql
import pandas as pd
import numpy as np
import seaborn as sns
import datetime
import streamlit as st
plt.rcParams['font.sans-serif']=['SimHei']
plt.rcParams['axes.unicode_minus'] = False
 
st.markdown('一, *信息表!* :sunglasses:')
#@st.cache(allow_output_mutation=True, hash_funcs={"_thread.RLock": lambda _: None})
 
#连接数据库
db = pymysql.connect(host='192.168.xx.xx',user='xxx',passwd='xxx',port=xxx,db='xxx')
 
#开启一个游标cursor
cursor=db.cursor()
 
#@st.cache(ttl=600)
#获取jifen_detail2020数据表里的所有数据
sql='select xxx,xxx,xxx,xxx,xxxfrom xxx;'
 
#执行sql中的语句
cursor.execute(sql)
st.write(cursor.description)
# 获得列名
column=[col[0] for col in cursor.description]
# 获得数据
data = cursor.fetchall()
# 获得DataFrame格式的数据
data_df=pd.DataFrame(list(data),columns=column)
st.write(data_df)