mysql---- 用户权限管理

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

模块导入模块

 1 #!/usr/bin/env python3
 2 #-*- coding:utf-8 -*-
 3 '''
 4 Administrator 
 5 2018/11/14 
 6 '''
 7 
 8 #第一种调用方法
 9 # commons.add()
10 
11 #第二种调用方法   利用反射调用
12 # func_name='add'
13 #
14 # func=getattr(commons,func_name)
15 # func()
16 
17 permisson_list=[
18     {'caption':"添加用户","func":"add","module":"user_info"},
19     {'caption':"删除用户","func":"delete","module":"user_info"},
20     {'caption':"查看用户","func":"modify","module":"user_info"},
21 ]
22 
23 for index, item in enumerate(permisson_list,1) :
24     print(index,item['caption'])
25 '''
26 1 添加用户
27 2 删除用户
28 3 查看用户
29 '''
30 
31 choic=input('请按数字输入要选择的菜单》》').strip()
32 choic=int(choic)
33 permisson=permisson_list[choic-1]
34 func_name=permisson['func']
35 #1导入模块
36 # from src import commons
37 # func=getattr(commons,func_name)
38 # func()
39 #2   动态导入模块
40 module='src.commons'
41 func_name1='add'
42 
43 import importlib
44 m=importlib.import_module(module)
45 print(m)
46 func2=getattr(m,func_name1)
47 func2()

 1 #!/usr/bin/env python3
 2 #-*- coding:utf-8 -*-
 3 '''
 4 Administrator 
 5 2018/11/14 
 6 '''
 7 permisson_list=[
 8     {'caption':"添加用户","func":"add","module":"src.commons"},
 9     {'caption':"删除用户","func":"delete","module":"src.commons"},
10     {'caption':"查看用户","func":"modify","module":"src.commons"},
11 ]
12 for index, item in enumerate(permisson_list,1) :
13     print(index,item['caption'])
14 '''
15 1 添加用户
16 2 删除用户
17 3 查看用户
18 '''
19 choic=input('请按数字输入要选择的菜单》》').strip()
20 choic=int(choic)
21 permisson=permisson_list[choic-1]
22 func_name=permisson['func']
23 module=permisson['module']
24 import importlib
25 m=importlib.import_module(module)
26 print(m)
27 func2=getattr(m,func_name)
28 func2()

 1 #!/usr/bin/env python3
 2 #-*- coding:utf-8 -*-
 3 '''
 4 Administrator 
 5 2018/11/14 
 6 '''
 7 import pymysql
 8 import os,sys
 9 BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
10 sys.path.append(BASE_DIR)
11 from conf import setting
12 
13 # conn=pymysql.connect(setting.DB_ADDRESS)
14 
15 
16 class UserInfoRepository:
17     def __init__(self,conn):
18         self.conn=conn
19         self.db=pymysql.connect(**self.conn)
20         self.cursor = self.db.cursor()
21 
22     def get_all(self):
23         sql='select * from user_info'
24         self.cursor.execute(sql)
25         data=self.cursor.fetchall()
26 
27         return data
28 
29     def close(self):
30         self.cursor.close()
31         self.conn.close()
32 
33 if __name__=="__main__":
34     obj = UserInfoRepository(setting.DB_ADDRESS)
35 
36     obj.get_all()