Python操作mysql数据库的基本封装，使用pymsql

import pymysql


class PyMysqldbCon():
    # 获取数据库连接
    def getCon(self):
        self.host = '172.16.3.78'
        self.user = 'root'
        self.passwd = '111111'
        self.db = "test_chl"
        self.port = 3306
        self.charset = 'utf8'
        try:
            conn = pymysql.connect(host=self.host, user=self.user, passwd=self.passwd, db=self.db, port=self.port,
                                   charset=self.charset)
            return conn
        except pymysql.Error as e:
            print("pymysql Error:%s" % e)

    # 查询方法，使用con.cursor(pymysql.cursors.DictCursor),返回结果为字典
    def select(self, sql):
        try:
            con = self.getCon()
            cur = con.cursor(pymysql.cursors.DictCursor)
            count = cur.execute(sql)
            fc = cur.fetchall()
            return fc
        except pymysql.Error as e:
            print("pymysql Error:%s" % e)
        finally:
            cur.close()
            con.close()

    # 带参数的更新方法,eg:sql='insert into test values(%s)',params=(6)
    def updateByParam(self, sql, params):
        try:
            con = self.getCon()
            cur = con.cursor()
            count = cur.execute(sql, params)
            con.commit()
            return count
        except pymysql.Error as e:
            con.rollback()
            print("pymysql Error:%s" % e)
        finally:
            cur.close()
            con.close()

    # 不带参数的更新方法
    def update(self, sql):
        try:
            con = self.getCon()
            cur = con.cursor()
            count = cur.execute(sql)
            con.commit()
            return count
        except pymysql.Error as e:
            con.rollback()
            print("pymysql Error:%s" % e)
        finally:
            cur.close()
            con.close()

    def get(self, sql):
        self.sql = sql
        fc = PyMysqldbCon().select(self.sql)
        return fc

    def ins(self, sql):
        self.sql = sql
        count = PyMysqldbCon().update(self.sql)
        return count

    def insparam(self, sql, params):
        self.sql = sql
        self.params = params
        count = PyMysqldbCon().updateByParam(self.sql, self.params)
        return count

    def delop(self, sql):
        self.sql = sql
        count = PyMysqldbCon().update(sql)
        return count

    def change(self, sql):
        self.sql = sql
        count = PyMysqldbCon().update(sql)
        return count


a = PyMysqldbCon().get('select * from test;')