python 对MySQL的封装

最新推荐文章于 2024-06-20 22:30:37 发布

go_flush

最新推荐文章于 2024-06-20 22:30:37 发布

阅读量2.5k

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/weixin_44224529/article/details/101082945

版权

数据库专栏收录该内容

10 篇文章 0 订阅

订阅专栏

python 对MySQL的封装

from pymysql import *


class MysqlHelp(object):
    """mysql常用方法的封装"""
    mysql_params = {
        "host": "localhost",
        "port": 3306,
        "database": "school",
        "user": "root",
        "password": "******",
        "charset": "utf8"
    }
    conn = Connection(**mysql_params)  # 获取连接对象
    cr_obj = conn.cursor()  # 获取cursor对象

    @classmethod
    def get(cls, field, table_name, num):
        cls.cr_obj.execute("select %s from %s" % (field, table_name))
        if num == 1:
            return cls.cr_obj.fetchone()  # 获取一数据
        else:
            return cls.cr_obj.fetchall()  # 获取所有的数据

    @classmethod
    def insert(cls, table_name, field_name, field_value):
        st = ""
        for i in field_name:
            if i == field_name[-1]:
                st += "".join(i+")")
            elif i == field_name[0]:
                st+= "".join("("+i+",")
            else:
                st += "".join(i + ",")
        field_name=st
        sql = "insert into {}{} values{}".format(table_name, field_name, field_value)
        print(sql)
        ret = cls.cr_obj.execute("insert into {}{} values{}".format(table_name, field_name, field_value))
        print(ret)

    @classmethod
    def update(cls, table_name, field):
        field_name = field["field_name"]
        field_value = field["field_value"]
        c_field = field["c_field"]
        v_field = field["f_field"]

        field_value="'"+ field_value+"'"
        ret = cls.cr_obj.execute(
            "update {} set {}={} where {}={}".format(table_name, field_name, field_value, c_field, v_field))
        print(ret)

    @classmethod
    def delete(cls, table_name, field_name, field_value):
        field_value = "'"+field_value+"'"
        ret = cls.cr_obj.execute("delete from %s where %s = %s" % (table_name, field_name, field_value))
        print(ret)

    @classmethod
    def close(cls):
        cls.conn.commit()
        cls.cr_obj.close()
        cls.conn.close()


if __name__ == '__main__':
    # ret = MysqlHelp.get("*", "students", 4)
    # print(ret)
    # ret1 = MysqlHelp.insert("students",("name","age","high"),("老王","10","190"))
    #
    # ret1 = MysqlHelp.update("students",{"field_name":"high","field_value":"178","c_field":"id","f_field":15})
    # print(ret1)
    ret2 = MysqlHelp.delete("students","name","老王")

    MysqlHelp.close()