首页 > 数据库技术 > 详细

python操作mysql数据库常用操作

时间:2021-08-30 00:16:09      阅读:20      评论:0      收藏:0      [点我收藏+]

pip install PyMySQL

import pymysql


class MysqlHandler:

    def __init__(self, db_config):
        self.connection = pymysql.connect(**db_config)
        # self.connection.autocommit(True)
        self.cursor = self.connection.cursor()

    def query_all(self, sql):
        self.cursor.execute(sql)
        return self.cursor.fetchall()

    def query_one(self, sql):
        self.cursor.execute(sql)
        return self.cursor.fetchone()

    def query_many(self, sql, num):
        self.cursor.execute(sql)
        return self.cursor.fetchmany(num)

    def update_db(self, sql):

        try:
            self.cursor.execute(sql)
            self.connection.commit()
        except:
            self.connection.rollback()

    def __del__(self):
        """
        MysqlHandler 实例对象被释放时调用此方法,用于关闭 cursor 和 connection 连接
        """
        print("close!!!")
        self.cursor.close()
        self.connection.close()


if __name__ == "__main__":
    db = {
        "user": "root",
        "password": "123456",
        "host": "47.112.214.205",
        "port": 3306,
        "db": "BaseTestPlatform",
        "charset": "utf8mb4",
        "cursorclass": pymysql.cursors.DictCursor
    }

    my_db = MysqlHandler(db)

    r1 = my_db.query_all("select * from polls_question;")

    for i in r1:
        print(i)

    r2 = my_db.query_many("select * from polls_question;", 2)

    for i in r2:
        print(i)

    r3 = my_db.query_one("select * from polls_question where id=3;")

    print(r3)

    my_db.update_db("update polls_question set question_text=‘333‘ where id=3;")

python操作mysql数据库常用操作

原文:https://www.cnblogs.com/jianjiacangcang/p/15201052.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!