Paython打卡Day19——数据库连接

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())