pymysql封装

# -*- coding: utf-8 -*-

"""
@Time    : 2021/12/14 17:20
@Author  : 阿涛@
"""
import pymysql


class MysqlUtil(object):
    conn = pymysql.Connect(
        user="root",
        password="123456",
        host="192.168.31.72",
        port=3306,
        database="irc"
    )

    curses = conn.cursor()
    # 查询
    curses.execute("select * from t_21")
    # print(curses.fetchone())
    print(curses.fetchall())

    # 增删改
    # curses.execute("insert into t_21(name) value('华子明01')")
    # conn.commit()

    curses.close()
    conn.close()


if __name__ == '__main__':
    mysql_util = MysqlUtil("irc")
    print(mysql_util.query("select * from t_21 where name='zhangsan'"))
    mysql_util.close()