mysql---- 用户权限管理

设计一个数据库用户权限管理系统

 模块导入模块

#!/usr/bin/env python3
#-*- coding:utf-8 -*-
'''
Administrator 
2018/11/14 
'''

#第一种调用方法
# commons.add()

#第二种调用方法   利用反射调用
# func_name='add'
#
# func=getattr(commons,func_name)
# func()

permisson_list=[
    {'caption':"添加用户","func":"add","module":"user_info"},
    {'caption':"删除用户","func":"delete","module":"user_info"},
    {'caption':"查看用户","func":"modify","module":"user_info"},
]

for index, item in enumerate(permisson_list,1) :
    print(index,item['caption'])
'''
1 添加用户
2 删除用户
3 查看用户
'''

choic=input('请按数字输入要选择的菜单》》').strip()
choic=int(choic)
permisson=permisson_list[choic-1]
func_name=permisson['func']
#1导入模块
# from src import commons
# func=getattr(commons,func_name)
# func()
#2   动态导入模块
module='src.commons'
func_name1='add'

import importlib
m=importlib.import_module(module)
print(m)
func2=getattr(m,func_name1)
func2()

---

---

---

#!/usr/bin/env python3
#-*- coding:utf-8 -*-
'''
Administrator 
2018/11/14 
'''
permisson_list=[
    {'caption':"添加用户","func":"add","module":"src.commons"},
    {'caption':"删除用户","func":"delete","module":"src.commons"},
    {'caption':"查看用户","func":"modify","module":"src.commons"},
]
for index, item in enumerate(permisson_list,1) :
    print(index,item['caption'])
'''
1 添加用户
2 删除用户
3 查看用户
'''
choic=input('请按数字输入要选择的菜单》》').strip()
choic=int(choic)
permisson=permisson_list[choic-1]
func_name=permisson['func']
module=permisson['module']
import importlib
m=importlib.import_module(module)
print(m)
func2=getattr(m,func_name)
func2()

---

#!/usr/bin/env python3
#-*- coding:utf-8 -*-
'''
Administrator 
2018/11/14 
'''
import pymysql
import os,sys
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
sys.path.append(BASE_DIR)
from conf import setting

# conn=pymysql.connect(setting.DB_ADDRESS)


class UserInfoRepository:
    def __init__(self,conn):
        self.conn=conn
        self.db=pymysql.connect(**self.conn)
        self.cursor = self.db.cursor()

    def get_all(self):
        sql='select * from user_info'
        self.cursor.execute(sql)
        data=self.cursor.fetchall()

        return data

    def close(self):
        self.cursor.close()
        self.conn.close()

if __name__=="__main__":
    obj = UserInfoRepository(setting.DB_ADDRESS)

    obj.get_all()