python 数据库增删改查

import pymysql.cursors
##获取链接
def getConnect():
    conn = pymysql.connect(host="localhost",
                           user="root",
                           passwd="123",
                           database="pymysql",
                           charset="utf8")
    return conn
#关闭链接
def closeConnect(cursor,conn):
    if conn:
        cursor.close