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)