python学习：python代码连接数据库

#导入pymysql
import pymysql
#与数据库建立连接
conn = pymysql.connect(user="用户", password="密码", host="127.0.0.1", database="数据库名", port=3306,charset="编码方式（utf8）")
#建立游标
cursor = conn.cursor()
#要执行的sql语句
sql = "select title,pubtime from news where pubtime >= '2021-11-26 00:00:00' and pubtime <= '2021-11-26 23:59:59'"
#执行
cursor.execute(sql)
#执行的结果存放到data_list
data_list = cursor.fetchall()
print(data_list)
#关闭游标
cursor.close()
#关闭连接
conn.close()