添加用户后报错
还请老
elif opt == "2":
while True:
os.system("cls")
print(Fore.LIGHTGREEN_EX, "\n\t1.添加用户")
print(Fore.LIGHTGREEN_EX, "\n\t2.修改用户")
print(Fore.LIGHTGREEN_EX, "\n\t3.删除用户")
print(Fore.LIGHTRED_EX, "\n\tback.返回上一层")
print(Style.RESET_ALL)
opt = input("\n\t输入操作编号:")
if opt == "back":
break
elif opt == "1":
os.system("cls")
username = input("\n\t用户名:")
password = getpass("\n\t密码:")
repassword = getpass("\n\t重复密码:")
if password != repassword:
print("\n\t两次密码不一致(3秒自动返回)")
time.sleep(3)
continue
email = input("\n\t邮箱:")
result = __role_service.search_list()
for index in range(len(result)):
one = result[index]
print(Fore.LIGHTBLUE_EX, "\n\t%d.%s" % (index + 1, one[1]))
print(Style.RESET_ALL)
opt = input("\n\t角色编号:")
role_id = result[int(opt) - 1][0]
__user_service.insert(username, password, email, role_id)
print("\n\t保存成功(3秒自动返回)")
time.sleep(3)
elif opt=="back":
break
elif opt=="exit":
sys.exit(0)
else:
print("\n\t登录失败(3秒自动返回)")
time.sleep(3)
elif opt=="2":
sys.exit(0)师指导下
16
收起
正在回答 回答被采纳积分+1
3回答
-
慕村8230135 #1
#!/usr/bin/python # -*- coding: UTF-8 -*- from colorama import Fore,Style #字体颜色\重置字体颜色 from getpass import getpass #遮挡用户密码 from service.user_service import UserService from service.news_service import NewsService from service.role_service import RoleService import os import sys import time __user_service=UserService() __news_service=NewsService() __role_service=RoleService while True: os.system("cls") print(Fore.LIGHTBLUE_EX,"\n\t========") print(Fore.LIGHTBLUE_EX,"\n\t欢迎使用新闻系统") print(Fore.LIGHTBLUE_EX,"\n\t========") print(Fore.LIGHTRED_EX,"\n\t1.登录系统") print(Fore.LIGHTRED_EX,"\n\t2.退出系统") print(Style.RESET_ALL)#重置字体颜色 opt=input("\n\t输入操作编号:") if opt=="1": username=input("\n\t用户名:") password=getpass("\n\t密码:") result=__user_service.login(username,password) #登录成功 if result==True: #查询角色 role=__user_service.search_user_role(username) while True: os.system("cls") if role=="新闻编辑": print("test") elif role=="管理员": print(Fore.LIGHTBLACK_EX,"\n\t1.新闻管理") print(Fore.LIGHTBLACK_EX,"\n\t2.用户管理") print(Fore.LIGHTBLACK_EX,"\n\tback.退出登录") print(Fore.LIGHTBLACK_EX,"\n\texit.退出系统") print(Style.RESET_ALL) # 重置字体颜色 opt = input("\n\t输入操作编号:") if opt == "1": while True: os.system("cls") print(Fore.LIGHTBLACK_EX, "\n\t1.审批新闻") print(Fore.LIGHTBLACK_EX, "\n\t2.删除新闻") print(Fore.LIGHTBLACK_EX, "\n\tback.返回上一层") print(Style.RESET_ALL) # 重置字体颜色 opt = input("\n\t输入操作编号:") if opt == "1": page = 1 while True: os.system("cls") count_page = __news_service.search_unreview_count_page() result = __news_service.search_unreview_list(page) for index in range(len(result)): one = result[index] print(Fore.LIGHTCYAN_EX, "\n\t%d\t%s\t%s\t%s" % (index + 1, one[1], one[2], one[3])) print(Fore.LIGHTBLUE_EX, "\n\t-----------------------------") print(Fore.LIGHTBLUE_EX, "\n\t%d/%d" % (page, count_page)) print(Fore.LIGHTBLUE_EX, "\n\t----------------------------") print(Fore.LIGHTRED_EX, "\n\tback.返回上一层") print(Fore.LIGHTRED_EX, "\n\tprev.上一页") print(Fore.LIGHTRED_EX, "\n\tnext.下一页") print(Style.RESET_ALL) # 重置字体颜色 opt = input("\n\t输入操作编号:") if opt=="back": break elif opt=="prev" and page>1: page-=1 elif opt=="next" and page<count_page: page+=1 elif int(opt)>=1 and int(opt)<=10: news_id=result[int(opt)-1][0] __news_service.update_unreview_news(news_id) elif opt == "2": page = 1 while True: os.system("cls") count_page = __news_service.search_count_page() result = __news_service.search_list(page) for index in range(len(result)): one = result[index] print(Fore.LIGHTCYAN_EX, "\n\t%d\t%s\t%s\t%s" % (index + 1, one[1], one[2], one[3])) print(Fore.LIGHTBLUE_EX, "\n\t-----------------------------") print(Fore.LIGHTBLUE_EX, "\n\t%d/%d" % (page, count_page)) print(Fore.LIGHTBLUE_EX, "\n\t----------------------------") print(Fore.LIGHTRED_EX, "\n\tback.返回上一层") print(Fore.LIGHTRED_EX, "\n\tprev.上一页") print(Fore.LIGHTRED_EX, "\n\tnext.下一页") print(Style.RESET_ALL) # 重置字体颜色 opt = input("\n\t输入操作编号:") if opt=="back": break elif opt=="prev" and page>1: page-=1 elif opt=="next" and page<count_page: page+=1 elif int(opt)>=1 and int(opt)<=10: news_id=result[int(opt)-1][0] __news_service.delete_by_id(news_id) elif opt == "2": while True: os.system("cls") print(Fore.LIGHTGREEN_EX, "\n\t1.添加用户") print(Fore.LIGHTGREEN_EX, "\n\t2.修改用户") print(Fore.LIGHTGREEN_EX, "\n\t3.删除用户") print(Fore.LIGHTRED_EX, "\n\tback.返回上一层") print(Style.RESET_ALL) opt = input("\n\t输入操作编号:") if opt == "back": break elif opt == "1": os.system("cls") username = input("\n\t用户名:") password = getpass("\n\t密码:") repassword = getpass("\n\t重复密码:") if password != repassword: print("\n\t两次密码不一致(3秒自动返回)") time.sleep(3) continue email = input("\n\t邮箱:") result = __role_service.search_list() for index in range(len(result)): one = result[index] print(Fore.LIGHTBLUE_EX, "\n\t%d.%s" % (index + 1, one[1])) print(Style.RESET_ALL) opt = input("\n\t角色编号:") role_id = result[int(opt) - 1][0] __user_service.insert(username, password, email, role_id) print("\n\t保存成功(3秒自动返回)") time.sleep(3) elif opt=="back": break elif opt=="exit": sys.exit(0) else: print("\n\t登录失败(3秒自动返回)") time.sleep(3) elif opt=="2": sys.exit(0)2021-10-28 20:59:49
慕村8230135
2021-10-28 18:18:08
from db.mysql_db import pool class RoleDao: #查询角色列表 def search_list(self): try: con = pool.get_connection() # 获取数据库链接 cursor = con.cursor() # 创建游标 sql = "select id,role from t_role" cursor.execute(sql) result = cursor.fetchall() return result except Exception as e: print(e) finally: if "con" in dir(): con.close()
-
好帮手慕凡 #1
同学，你好！
RoleService类对象实例化时未加括号，导致没有实例对象而报错，如下图：RoleService类实例化时要加( )
祝学习愉快~
2021-10-29 11:25:54
Python全能工程师
- 参与学习 人
- 提交作业 16233 份
- 解答问题 4470 个
全新版本覆盖5大热门就业方向：Web全栈、爬虫、数据分析、软件测试、人工智能，零基础进击Python全能型工程师，从大厂挑人到我挑大厂，诱人薪资在前方！
了解课程
恭喜解决一个难题，获得1积分~
来为老师/同学的回答评分吧
0 星