python mysql項目實戰(zhàn)及框架搭建過程

第pythonmysql項目實戰(zhàn)及框架搭建過程print(Fore.LIGHTBLUE_EX,"\n\t==================")

print(Fore.LIGHTBLUE_EX,"\n\t歡迎使用新聞管理系統(tǒng)")

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

print(Fore.LIGHTGREEN_EX,"\n\t1.登陸系統(tǒng)")

print(Fore.LIGHTGREEN_EX,"\n\t2.退出系統(tǒng)")

print(Style.RESET_ALL)

opt=input("\n\t輸入操作編號:")

ifopt=="1":

username=input("\n\t用戶名:")

password=getpass("\n\t密碼:")

result=__user_service.login(username,password)

#登陸成功

ifresult==True:

#查詢角色

role=__user_service.search_user_role(username)

whileTrue:

os.system("cls")

ifrole=="新聞編輯":

print('test')

elifrole=="管理員":

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

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

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

print(Fore.LIGHTRED_EX,"\n\texit.退出系統(tǒng)")

print(Style.RESET_ALL)

opt=input("\n\t輸入操作編號:")

ifopt=="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輸入操作編號:")

ifopt=="1":

page=1

whileTrue:

os.system("cls")

count_page=__news_service.search_unreview_count_page()

result=__news_service.search_unreview_list(page)

forindexinrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_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輸入操作編號:")

ifopt=="back":

break

elifopt=="prev"andpage1:

=1

elifopt=="next"andpagecount_page:

page+=1

elifint(opt)=1andint(opt)=10:

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

__news_service.update_unreview_news(news_id)

elifopt=="2":

page=1

whileTrue:

os.system("cls")

count_page=__news_service.search_count_page()

result=__news_service.search_list(page)

forindexinrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_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輸入操作編號:")

ifopt=="back":

break

elifopt=="prev"andpage1:

=1

elifopt=="next"andpagecount_page:

page+=1

elifint(opt)=1andint(opt)=10:

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

__news_service.delete_by_id(news_id)

elifopt=="back":

break

elifopt=="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輸入操作編號:")

ifopt=="back":

break

elifopt=="1":

os.system("cls")

username=input("\n\t用戶名:")

password=getpass("\n\t密碼:")

repassword=getpass("\n\t重復密碼:")

ifpassword!=repassword:

print("\n\t兩次密碼不一致(3秒自動返回)")

time.sleep(3)

continue

email=input("\n\t郵箱:")

result=__role_service.search_list()

forindexinrange(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)

elifopt=="2":

page=1

whileTrue:

os.system("cls")

count_page=__user_service.search_count_page()

result=__user_service.search_list(page)

forindexinrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,

"\n\t%d\t%s\t%s"%(index+1,one[1],one[2]))

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輸入操作編號:")

ifopt=="back":

break

elifopt=="prev"andpage1:

=1

elifopt=="next"andpagecount_page:

page+=1

elifint(opt)=1andint(opt)=10:

os.system("cls")

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

username=input("\n\t新用戶名:")

password=getpass("\n\t新密碼:")

repassword=getpass("\n\t再次輸入密碼:")

ifpassword!=repassword:

print(Fore.LIGHTRED_EX,"\n\t兩次密碼不一致(3秒自動返回)")

print(Style.RESET_ALL)

time.sleep(3)

break

email=input("\n\t新郵箱:")

result=__role_service.search_list()

forindexinrange(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]

opt=input("\n\t是否保存(Y/N)")

ifopt=="Y"oropt=="y":

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

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

time.sleep(3)

elifopt=="3":

page=1

whileTrue:

os.system("cls")

count_page=__user_service.search_count_page()

result=__user_service.search_list(page)

forindexinrange(len(result)):

one=result[index]

print(Fore.LIGHTBLUE_EX,

"\n\t%d\t%s\t%s"%(index+1,one[1],one[2]))

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