python封装mysql

最新推荐文章于 2023-11-30 18:11:09 发布

Bmynd

最新推荐文章于 2023-11-30 18:11:09 发布

阅读量303

点赞数 1

CC 4.0 BY-SA版权

分类专栏：杂文章标签： python mysql

本文链接：https://blog.youkuaiyun.com/qq_44740963/article/details/97493808

杂专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一个使用Python和pymysql模块进行数据库操作的示例，包括连接数据库、执行查询、获取单条或多条记录、执行插入、更新和删除操作的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import pymysql

class DBHelper():
    def __init__(self,host, user, passwd, dbName):
        self.host = host
        self.user = user
        self.passwd = passwd
        self.dbName = dbName
    def connet(self):
        #连接到数据库
        self.db = pymysql.connect(self.host,self.user,self.passwd,self.dbName)
        #创建游标
        self.cursor = self.db.cursor()
        
    def close(self):
        self.cursor.close()
        self.db.close()
    
    #查询一条数据
    def get_one(self, sql):
        res = None
        try:
            self.connet()
            self.cursor.execute(sql)
            res = self.cursor.fetchone()
            self.close()
        except:
            print("查询失败")
        return res
    
    #得到所有的数据
    def get_all(self, sql):
        res = ()
        try:
            self.connet()
            self.cursor.execute(sql)
            res = self.cursor.fetchall()
            self.close()
        except:
            print("查询失败")
        return res


    #插入
    def insert(self, sql):
        return self.__edit(sql)
    
    #更新
    def update(self, sql):
        return self.__edit(sql)
    
    #删除
    def delete(self, sql):
        return self.__edit(sql)

    def __edit(self,sql):
        count = 0
        try:
            self.connet()
            count = self.cursor.execute(sql)
            self.db.commit()
            self.close()
        except:
            print("事物提交失败")
            self.db.rollback()
        return count
if __name__ == '__main__':
    dbh = DbHelper(host='localhost',username='root',password='123456',database='stu')
    #查询当前用户
    #res = dbh.get_one('select user()')
    #res = dbh.insert_data("insert into student values(0,'谭松韵',29,0,99)")
    #res = dbh.get_all('select * from student')
    #res = dbh.update_data("update student set name='周杰伦' where id=4")
    res = dbh.delete_data("delete from student where id>60")
    print(res)