python MySQL数据库封装

import MySQLdb

# 打开数据库连接
database = MySQLdb.connect("127.0.0.1", "username", "password", "dbname", charset='utf8' )

# 使用cursor()方法获取操作游标
cursor = database.cursor()

# 数据库操作类
class db():
    # 获取一条数据
    def fetchOne(sql, *args):
        cursor.execute(sql, *args)
        return cursor.fetchone()

    # 获取全部数据
    def fetchAll(sql, *args):
        cursor.execute(sql, *args)
        return cursor.fetchall()

    # 执行数据库
    def exec(sql, *args):
        result = cursor.execute(sql, *args)
        database.commit()
        return result

调用的地方：
 

import db
result = db.fetchOne("select * from table_name where field1='xxx")
print (result)