class UserService: __user_dao = UserDao() def login(self, username, password): result = self.__user_dao.login(username=username, password=password) return result def search_user_role(self, username): role = self.__user_dao.search_user_role(username=username) return role def insert(self, username, password, email, role_id): self.__user_dao.insert(username=username, password=password, email=email, role_id=role_id) def search_count_page(self): count_page = self.__user_dao.search_count_page() return count_page def search_user_list(self, page): result = self.__user_dao.search_user_list(page=page) return result def update_user(self, user_id, username, password, email, role_id): self.__user_dao.update_user(user_id=user_id, username=username, password=password, email=email, role_id=role_id) def delete_user(self, user_id): self.__user_dao.delete_user(user_id=user_id)
class UserService: __user_dao = UserDao() # 验证用户登录 def login(self, username, password): return self.__user_dao.login(username, password) # 查询用户角色 def search_user_role(self, username): return self.__user_dao.search_user_role(username) # 添加用户 def insert(self, username, password, email, role_id): self.__user_dao.insert(username, password, email, role_id) # 查询用户总页数 def search_count_page(self): return self.__user_dao.search_count_page() # 查询用户分页记录 def search_list(self, page): return self.__user_dao.search_list(page) # 修改用户信息 def update(self, id, username, password, email, role_id): self.__user_dao.update(id, username, password, email, role_id) # 删除用户 def delete_by_id(self, id): self.__user_dao.delete_by_id(id) # 查询用户ID def search_userid(self, username): return self.__user_dao.search_userid(username)
class BusinessObject: """Simple class for mock demo""" def __init__(self, name=''): print('BusinessObject.__init__') self.name = name self.user_dao = UserDao() def get_user(self, user_id): try: user = self.user_dao.query_user(user_id) print('BusinessObject.get_user: user_dao.query_user returned ' 'user ' + user.last_name if user else None) if user is None: raise ValueError('{} is not a valid user ID'.format(user_id)) return user except sqlite3.Error as e: raise BusinessError('Problem fetching user with ID {}: {}' .format(user_id, str(e))) def __str__(self): return "{self.name}".format(self=self)
class UserService(): __user_dao = UserDao() def login(self, username, password): result = self.__user_dao.login(username, password) return result def search_user_role(self, username): role = self.__user_dao.search_user_role(username) return role def add_user(self, username, password, email, role_id): self.__user_dao.add_user(username, password, email, role_id) def search_count_page(self): count_page = self.__user_dao.search_count_page() return count_page def search_user_list(self, page): result = self.__user_dao.search_user_list(page) return result def update_user(self, id, username, password, email, role_id): self.__user_dao.update_user(id, username, password, email, role_id) def delete_by_id(self, id): self.__user_dao.delete_by_id(id)
def search_user_role(username): """ get the urser's role :param username: the user's username :return: the user's role if not found, return None """ return UserDao.search_user_role(username)
class User_service: __user_dao = UserDao() def login(self, username, password): return self.__user_dao.login(username, password) def get_user_role(self, username): return self.__user_dao.get_user_role(username)
def login(username, password): """ find wether the user exist in the database :param username: username :param password: password :return: True if the user and password are all corrected, False, if one of them is not correct """ return UserDao.login(username, password)
class UserService(object): """ 用户服务类 """ __user_dao = UserDao() def login(self, username, password): """ 验证用户登录 """ result = self.__user_dao.login(username, password) return result def search_user_role(self, username): """ 验证用户角色 """ role = self.__user_dao.search_user_role(username) return role def insert(self, username, password, email, role_id): """ 添加记录 """ self.__user_dao.insert(username, password, email, role_id) def search_count_page(self): """ 查询用户总页数 """ count_page = self.__user_dao.search_count_page() return count_page def search_list(self, page): """ 查询用户分页记录 """ result = self.__user_dao.search_list(page) return result def update(self, id, username, password, email, role_id): """ 修改用户信息 """ self.__user_dao.update(id, username, password, email, role_id) def delete_by_id(self, id): """ 删除用户 """ self.__user_dao.delete_by_id(id) def search_userid(self, username): """ 查询用户ID """ userid = self.__user_dao.search_userid(username) return userid
class UserService: __user_dao = UserDao() # 验证用户登录 def login(self, username, password): result = self.__user_dao.login(username, password) return result # 查询用户角色 def search_user_role(self, username): role = self.__user_dao.seach_user_role(username) return role # 添加记录 def insert(self, username, password, email, role_id): self.__user_dao.insert(username, password, email, role_id) # 查询用户总页数 def search_userlist_page(self): count_page = self.__user_dao.search_userlist_page() return count_page # 查询用户的分页 def search_list(self, page): result = self.__user_dao.search_list(page) return result # 修改用户信息 def update(self, id, username, password, email, role_id): self.__user_dao.update(id, username, password, email, role_id) # 删除用户信息 def delete_by_id(self, id): self.__user_dao.delete_by_id(id) # 查询用户ID def search_userid(self, username): userid = self.__user_dao.search_userid(username) return userid
class UserSercicr(object): __user_dao = UserDao() # 验证用户登录 def login(self, username, password): result = self.__user_dao.login(username, password) return result # 查询用户角色 def search_user_role(self, username): role = self.__user_dao.search_user_role(username) return role # 查询单个用户信息 def search_username(self, username): count = self.__user_dao.search_username(username) return count # 添加用户 def insert(self, username, password, email, rold_id): self.__user_dao.insert(username, password, email, rold_id) # 查询用户总页数 def search_count_page(self): count_page = self.__user_dao.search_count_page() return count_page # 查询用户分页记录 def search_list(self, page): result = self.__user_dao.search_list(page) return result # 修改用户信息 def update(self, id, username, password, email, role_id): self.__user_dao.update(id, username, password, email, role_id) # 删除用户 def delete_by_id(self, id): self.__user_dao.delete_by_id(id)
class UserService: __user_dao = UserDao() # 验证用户登录 def login(self, username, password): result = self.__user_dao.login(username, password) return result # 验证用户身份 def sear_user_role(self, username): role = self.__user_dao.search_user_role(username) return role # 添加用户 def insert_user(self, username, password, email, role_id): self.__user_dao.insert_user(username, password, email, role_id) # 验证用户名 def search_username(self): username = self.__user_dao.search_username() return username # 查看用户表的总页数 def search_user_page_count(self): page_count = self.__user_dao.search_user_page_count() return page_count # 分页查询用户 def search_user(self, page): result = self.__user_dao.search_user(page) return result # 修改用户信息 def update_user_by_username(self, username, password, email, role_id, old_username): self.__user_dao.update_user_by_username(username, password, email, role_id, old_username)
class BusinessObject: """Simple class for mock demo""" def __init__(self, name=''): print('BusinessObject.__init__') self.name = name self.user_dao = UserDao() def get_user(self, user_id): try: user = self.user_dao.query_user(user_id) print('BusinessObject.get_user: user_dao.query_user returned ' 'user ' + user.last_name if user else None) if user is None: raise ValueError('{} is not a valid user ID'.format(user_id)) return user except sqlite3.Error as e: raise BusinessError('Problem fetching user with ID {}: {}'.format( user_id, str(e))) def __str__(self): return "{self.name}".format(self=self)
def __init__(self, name=''): print('BusinessObject.__init__') self.name = name self.user_dao = UserDao()
from db.user_dao import UserDao print(UserDao.login("admin", "123456")) r = UserDao.search_user_role("admin") print(r)