def fetchall(sql, args=None):
mySqlHelper = MySQLHelper()
# 打开数据库连接
conn = mySqlHelper.connetMySQL(host, user, pwd, dbname)
#print conn
# 使用cursor()方法获取操作游标
cursor = mySqlHelper.getCursor()
#print cursor
# 使用execute方法执行SQL语句
#cursor.execute("use " + dbname)
cursor.execute(sql, args)
accountList = []
res = cursor.fetchall()
#print res
for row in res:
#print row[0]
account = Account()
account.setId(row[0])
account.setName(row[1])
account.setPassword(row[2])
account.setCreatetime(row[3])
accountList.append(account)
for account in accountList:
print account.toString()
# 关闭数据库连接
cursor.close()
conn.close()
def fetchall(sql, args=None):
#下面连个字典都可行
#conn_dict=dict(host=host,user=user,passwd=pwd,db=dbname,port=3306,charset="utf8")
conn_dict = dict(host=host, user=user, passwd=pwd, db=dbname)
mySqlHelper = MySQLHelper()
# 打开数据库连接
conn = mySqlHelper.connetMySQLArgsByDict(conn_dict)
#print conn
# 使用cursor()方法获取操作游标
cursor = mySqlHelper.getCursor()
#print cursor
# 使用execute方法执行SQL语句
#cursor.execute("use " + dbname)
cursor.execute(sql, args)
accountList = []
res = cursor.fetchall()
#print res
for row in res:
#print row[0]
account = Account()
account.setId(row[0])
account.setName(row[1])
account.setPassword(row[2])
account.setCreatetime(row[3])
accountList.append(account)
for account in accountList:
print account.toString()
# 关闭数据库连接
cursor.close()
conn.close()
def fetchone(sql):
mySqlHelper = MySQLHelper()
# 打开数据库连接
conn = mySqlHelper.connetMySQL(host, user, pwd, dbname)
#print conn
# 使用cursor()方法获取操作游标
cursor = mySqlHelper.getCursor()
#print cursor
# 使用execute方法执行SQL语句
#cursor.execute("use " + dbname)
cursor.execute(select_sql)
# 使用 fetchone() 方法获取一条数据
rs = cursor.fetchone()
print "=========rs=========="
print rs
print "=========item=========="
for item in rs:
print item
# 关闭数据库连接
cursor.close()
conn.close()
def update(sql, args=None):
mySqlHelper = MySQLHelper()
# 打开数据库连接
conn = mySqlHelper.connetMySQL(host, user, pwd, dbname)
#print conn
# 使用cursor()方法获取操作游标
cursor = mySqlHelper.getCursor()
#print cursor
# 使用execute方法执行SQL语句
#cursor.execute("use " + dbname)
cursor.execute(sql, args)
#提交事务
conn.commit()
# 关闭数据库连接
cursor.close()
conn.close()
def __init__(self):
self.mySqlHelper = MySQLHelper()
self.connect()
class AccountManagerImpl:
def __init__(self):
self.mySqlHelper = MySQLHelper()
self.connect()
def __str__(self):
return "This is AccountManagerImpl class"
def __del__(self): # 回收，脚本执行的最后执行
print "Del……" # 显示执行顺序
self.disConnet()
def connect(self):
'''
打开数据库连接
:return:
'''
# 下面连个字典都可行
# conn_dict=dict(host=host,user=user,passwd=pwd,db=dbname,port=3306,charset="utf8")
conn_dict = dict(host=host, user=user, passwd=pwd, db=dbname)
# 打开数据库连接（改成使用字典进行连接参数传递）
return self.mySqlHelper.connetMySQLArgsByDict(conn_dict)
def disConnet(self):
'''
断开数据库连接
:return:
'''
self.mySqlHelper.closeCursor()
self.mySqlHelper.closeConnet()
print "Close connetction success."
def addAccount(self,sql, args=None):
'''
新增账号
:param sql: SQL语句
:param args: 字典/列表类型参数，根据SQL参数化时构造场景而定。SQL语句参数化场景需要传值，其他场景不传，默认使用None
:return: 新增成功返回True，否则报异常
'''
try:
# 使用execute方法执行SQL语句
self.mySqlHelper.execute(sql,args)
self.mySqlHelper.commit()
return True
except Exception as e:
print str(e)
raise "Add account fail."
def queryAccounts(self,sql, args=None):
'''
查询账号信息列表
:param sql: SQL语句
:param args: 字典/列表类型参数，根据SQL参数化时构造场景而定。SQL语句参数化场景需要传值，其他场景不传，默认使用None
:return: 返回账号信息列表
'''
try:
rs = self.mySqlHelper.query(sql,args)
accountList = []
for row in rs:
# print row[0]
account = Account()
account.setId(row[0])
account.setName(row[1])
account.setPassword(row[2])
account.setCreatetime(row[3])
accountList.append(account)
for account in accountList:
print account.toString()
return accountList
except Exception as e:
print str(e)
raise "Query account fail."
def updateAccount(self,sql, args=None):
'''
修改账号信息
:param sql: SQL语句
:param args: 字典/列表类型参数，根据SQL参数化时构造场景而定。SQL语句参数化场景需要传值，其他场景不传，默认使用None
:return: 新增成功返回True，否则报异常
'''
try:
# 使用execute方法执行SQL语句
self.mySqlHelper.execute(sql,args)
self.mySqlHelper.commit()
return True
except Exception as e:
print str(e)
raise "Update account fail."
def deleteAccount(self,sql, args=None):
'''
删除账号信息
:param sql: SQL语句
:param args: 字典/列表类型参数，根据SQL参数化时构造场景而定。SQL语句参数化场景需要传值，其他场景不传，默认使用None
:return: 新增成功返回True，否则报异常
'''
try:
# 使用execute方法执行SQL语句
self.mySqlHelper.execute(sql,args)
self.mySqlHelper.commit()
return True
except Exception as e:
print str(e)
raise "Delete account fail."