python新闻管理系统_python项目——新闻管理系统

fromcolorama import Fore,Stylefromgetpass import getpass #获取用输入密码fromservice.user_service import UserServicefromservice.news_service import NewsServicefromservice.role_service import RoleService

import os #为了清空控制台内容

import sys

import time

__user_service=UserService()

__news_service=NewsService()

__role_service=RoleService()whileTrue:

os.system("cls")

print(Fore.LIGHTBLUE_EX,"\n\t+++++++++++++++++++")

print(Fore.LIGHTBLUE_EX,"\n\t欢迎使用新闻管理系统")

print(Fore.LIGHTBLUE_EX,"\n\t+++++++++++++++++++")

print(Fore.LIGHTGREEN_EX,"\n\t1)登陆系统")

print(Fore.LIGHTGREEN_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)whileTrue:

os.system("cls")if role == "新闻编辑":

print("test")

elif role== "管理员":

print(Fore.LIGHTGREEN_EX,"\n\t1)新闻管理")

print(Fore.LIGHTGREEN_EX,"\n\t2)用户管理")

print(Fore.LIGHTRED_EX,"\n\tback)退出登陆")

print(Fore.LIGHTRED_EX,"\n\texit)退出系统")

print(Style.RESET_ALL)

opt= input("\n\t输入你的操作编号:")if opt == "1":whileTrue:

os.system("cls")

print(Fore.LIGHTGREEN_EX,"\n\t1)审批新闻")

print(Fore.LIGHTGREEN_EX,"\n\t2)删除新闻")

print(Fore.LIGHTRED_EX,"\n\tback)返回")

print(Style.RESET_ALL)

opt= input("\n\t输入你的操作编号:")if opt == "1":

page= 1

whileTrue:

os.system("cls")

count_page=__news_service.search_unreview_count_page()

result=__news_service.search_unreview_list(page)for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}\t{1}\t{2}\t{3}".format(index+1,one[1],one[2],one[3]))

print(Fore.LIGHTBLUE_EX,"\n\t-------------------")

print(Fore.LIGHTBLUE_EX,"\n\t{0}/{1}".format(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":breakelif opt== "prev" and page > 1:

page-=1elif opt== "next" and page

page+=1elifint(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

whileTrue:

os.system("cls")

count_page=__news_service.search_count_page()

result=__news_service.search_list(page)for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}\t{1}\t{2}\t{3}".format(index + 1, one[1], one[2], one[3]))

print(Fore.LIGHTBLUE_EX,"\n\t-------------------")

print(Fore.LIGHTBLUE_EX,"\n\t{0}/{1}".format(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":breakelif opt== "prev" and page > 1:

page-= 1elif opt== "next" and page

page+= 1elifint(opt) >= 1 and int(opt) <= 10:

news_id= result[int(opt) - 1][0]

__news_service.delete_by_id(news_id)

elif opt== "back":breakelif opt== "2":whileTrue:

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":breakelif opt== "1":

os.system("cls")

username= input("\n\t你要添加的用户名字")

password= getpass("\n\t输入新用户密码")

repassword= getpass("\n\t再次输入新用户密码")if password !=repassword:

print(Fore.LIGHTRED_EX,"\n\t两次密码不一致（3秒自动返回）")

time.sleep(3)continueemail= input("\n\t新用户邮箱：")

result=__role_service.search_list()for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}.{1}".format(index+1,one[1]))

print(Style.RESET_ALL)

opt= input("\n\t新用户的角色编号：")

role_id= result[int(opt)-1][0]

__user_service.insert_user(username,password,email,role_id)

print("\n\t保存成功（3秒自动返回）")

time.sleep(3)

elif opt== "2":

page= 1

whileTrue:

os.system("cls")

count_page=__user_service.search_count_page()

result=__user_service.search_list(page)for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}\t{1}\t{2}".format(index + 1, one[1], one[2]))

print(Fore.LIGHTBLUE_EX,"\n\t-------------------")

print(Fore.LIGHTBLUE_EX,"\n\t{0}/{1}".format(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":breakelif opt== "prev" and page > 1:

page-= 1elif opt== "next" and page

page+= 1elifint(opt) >= 1 and int(opt) <= 10:

os.system("cls")

user_id= result[int(opt)-1][0]

username= input("\n\t你要修改成的用户名字")

password= getpass("\n\t输入新密码")

repassword= getpass("\n\t再次输入新密码")if password !=repassword:

print(Fore.LIGHTRED_EX,"\n\t两次密码不一致（3秒自动返回）")

time.sleep(3)

print(Style.RESET_ALL)breakemail= input("\n\t新用户邮箱：")

result=__role_service.search_list()for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}.{1}".format(index + 1, one[1]))

print(Style.RESET_ALL)

opt= input("\n\t新用户的角色编号：")

role_id= result[int(opt) - 1][0]

opt= input("\n\t是否保存（Y/N）")if opt.upper() == "Y":

__user_service.update(user_id,username,password,email,role_id)

print("\n\t保存成功（3秒自动返回）")

time.sleep(3)

elif opt== "3":

page= 1

whileTrue:

os.system("cls")

count_page=__user_service.search_count_page()

result=__user_service.search_list(page)for index inrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,"\n\t{0}\t{1}\t{2}".format(index + 1, one[1], one[2]))

print(Fore.LIGHTBLUE_EX,"\n\t-------------------")

print(Fore.LIGHTBLUE_EX,"\n\t{0}/{1}".format(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":breakelif opt== "prev" and page > 1:

page-= 1elif opt== "next" and page

page+= 1elifint(opt) >= 1 and int(opt) <= 10:

os.system("cls")

user_id= result[int(opt) - 1][0]

__user_service.delete_by_id(user_id)

print("\n\t删除成功（3秒自动返回）")

time.sleep(3)

elif opt== "back":breakelif opt== "exit":

sys.exit(0)else:

print("\n\t登陆失败,3秒自动返回")

time.sleep(3)

elif opt== "2":

sys.exit(0)#0代表安全退出，等数据释放等