有几个表写几个DAO,每个DAO里有CRUD四项操作 account_dao 放在 com.dao包里
"""账号表DAO"""
# coding=utf-8
from com.dao.base_dao import BaseDao
import pymysql
# 创建账号表DAO类,执行CRUD四种方法
class AccountDao(BaseDao):
def __init__(self):
super().__init__()
# 查询账号是否存在
def r_id(self, userid):
account = None
try:
with self.conn.cursor() as cur:
sql = 'select userid, password from account where userid = %s'
aft = cur.execute(sql, userid)
if aft > 0:
row = cur.fetchone()
if row is not None:
account = {'userid': row[0], 'password': row[1]}
else:
print('无此账号')
except pymysql.DatabaseError as e:
print('查询失败!', e)
finally:
self.close()