python工具类-sql操作封装

#!/usr/bin/python
# coding=utf-8


# 链接mysql数据库
# 需要安装mysqlclient


import MySQLdb




class SqlUtil():
    conn = None


    # 初始化链接,带默认参数
    def __init__(self, datahost, datausername, datapassword, database):
        # 只有链接不为空的时候才创建对象
        if (self.conn == None):
            self.conn = MySQLdb.connect(datahost, datausername, datapassword, database, charset="utf8")


    # 返回connect
    def getDBConnect(self):
        return self.conn


    def selectAll(self, sql):
        cursor = self.conn.cursor();
        cursor.execute(sql)
        ret = cursor.fetchall()
        return ret


    def selectOne(self, sql):
        cursor = self.conn.cursor();
        cursor.execute(sql)
        ret = cursor.fetchOne()
        cursor.close()
        return ret


    def insert(self, sql):
        cursor = self.conn.cursor();
        cursor.execute(sql)
        self.conn.commit()  # 提交数据
        cursor.close()


    def update(self, sql):
        cursor = self.conn.cursor();
        cursor.execute(sql)
        self.conn.commit()  # 提交数据
        cursor.close()


    def __del__(self):
        self.conn.close()


# if __name__=="__main__":
# conn=dbConnection().getDBConnect()
# # 使用cursor()方法获取操作游标
# cursor = conn.cursor();
# sql = "select * from learn_course"
# # 使用execute()方法执行sql
# cursor.execute(sql)
# # 使用fetchone()方法获取一条数据
# data = cursor.fetchone()
# print(data)

-------------------------------------最后---------------------------------

 更多软件测试相关内容请关注“软件测试道与术”公众号或扫描下方二维码