Paython打卡Day19——数据库连接

import pymysql # 获取数据库连接 def get_connect(): return pymysql.connect(host='101.200.82.237',port = 3306,db = 'content_center',user = 'root',password = 'abc.123') # 关闭数据库连接 def close(cursor, connect): cursor.close() connect.close() # 查询 def get_query(): connect = get_connect() cursor = connect.cursor() sql = "SELECT * FROM share" cursor.execute(sql) result = cursor.fetchall() close(cursor, connect) return result if __name__ == "__main__": print(get_query())