import time
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
import matplotlib as mpl
from PySide2.QtWidgets import QApplication, QTableWidgetItem, QMessageBox
from PySide2.QtUiTools import QUiLoader
import sys
class Baidui_tr:
def __init__(self): # 界面导入 和事件响应
"""
--------------------------------------------------------------------
实例化界面对象,使用pyside2的QUiLoader方法获取ui界面
绑定按钮事件在指定函数 状态栏内容展示
"""
self.updat_window = QUiLoader().load('书籍修改.ui')
self.statistic_window = QUiLoader().load('类别.ui')
self.out_window = QUiLoader().load('退出.ui')
self.out_window.pushButton.clicked.connect(self.out)
self.out_window.pushButton_2.clicked.connect(self.close_out_window)
self.delet_window = QUiLoader().load('删除信息.ui')
self.delet_window.pushButton.clicked.connect(self.delete)
# self.delet_window.pushButton.clicked.connect(self.delet_window.textBrowser.clear)
self.delet_window.pushButton_2.clicked.connect(self.close_delete)
self.main_window = QUiLoader().load('个人图书管理系统.ui')
self.main_window.pushButton_7.clicked.connect(self.updat_window.show)
self.updat_window.pushButton_2.clicked.connect(self.updat_window.close)
self.updat_window.pushButton.clicked.connect(self.sure_updata)
self.table = self.main_window.tableWidget
self.statistic_window.pushButton.clicked.connect(self.main_window.textBrowser_3.clear)
self.statistic_window.pushButton.clicked.connect(self.statistic_window.tableWidget_2.clear)
self.main_window.pushButton_11.clicked.connect(self.statistic_window.show)
self.statistic_window.pushButton.clicked.connect(self.statistic_window.close)
self.main_window.pushButton_10.clicked.connect(self.out_windows)
self.main_window.pushButton_11.clicked.connect(self.statistics)
# self.main_window.pushButton_11.clicked.connect(self.main_window.textBrowser_3.clear)
self.main_window.pushButton_5.clicked.connect(self.infoss)
self.main_window.pushButton_6.clicked.connect(self.main_window.textBrowser_2.clear)
self.main_window.pushButton_8.clicked.connect(self.matplt)
self.main_window.pushButton_3.clicked.connect(self.search)
self.main_window.pushButton_4.clicked.connect(self.delete_window)
self.main_window.pushButton_9.clicked.connect(self.insert)
self.main_window.pushButton.clicked.connect(self.save_info)
self.main_window.pushButton_7.clicked.connect(self.updata_book)
# self.main_windows = QUiLoader().load('借书.ui')
# self.main_windows.pushButton.clicked.connect(self.close_borrow)
# self.main_windows.pushButton_2.clicked.connect(self.borrow_book)
# self.main_windows.pushButton_3.clicked.connect(self.returns)
self.main_window.statusbar.showMessage('作者联系方式: 3181456558')
def updata_book(self):
"""
修改书籍内容
"""
try:
book_name = self.books()
book_id = self.main_window.lineEdit_10.text()
book_user = self.main_window.lineEdit_11.text()
book_out = self.main_window.lineEdit_12.text()
price = self.main_window.lineEdit_13.text()
book_category = self.main_window.lineEdit_14.text()
delete_book_info = self.deleteinfo()
self.updat_window.textBrowser.append(str(delete_book_info))
self.updat_window.textBrowser_2.append(book_name)
self.updat_window.textBrowser_3.append(book_id
)
self.updat_window.textBrowser_4.append(book_user)
self.updat_window.textBrowser_5.append(book_out)
self.updat_window.textBrowser_6.append(price)
self.updat_window.textBrowser_7.append(book_category)
except Exception as e:
with open('日志.csv',mode='a')as f:
f.write(str(e))
f.write('\n')
def sure_updata(self):
book_name = self.books()
df = pd.read_excel("图书.xlsx")
try:
print(df['书名'])
for book in df['书名']:
if book_name == book:
idex = list(df['书名']).index(book)
df = df.drop(idex)
df.to_excel('图书.xlsx', encoding='utf8', index=False)
book_id = self.main_window.lineEdit_10.text()
book_user = self.main_window.lineEdit_11.text()
book_out = self.main_window.lineEdit_12.text()
price = self.main_window.lineEdit_13.text()
book_category = self.main_window.lineEdit_14.text()
info = {'id': int(book_id), "书名": book_name, "作者": book_user, "价格": int(price), "出版单位": book_out, "类别": str(book_category)}
df = pd.read_excel("图书.xlsx")
df = df.append(pd.Series(info), ignore_index=True)
df.to_excel('图书.xlsx', encoding='utf8', index=False)
self.messagebox = QMessageBox()
self.messagebox.information(self.messagebox, '欢迎使用', '保存成功')
except Exception as e:
with open('日志.csv', mode='a') as f:
f.write(str(e))
f.write('\n')
def matplt(self):
mpl.rcParams['font.sans-serif'] = ['SimHei']
file_price = pd.read_excel('图书.xlsx')['类别']
# file_x = pd.read_excel('图书.xlsx')['id']
np_y = np.array(file_price)
l = [i for i in range(len(file_price))]
np_x = np.array(l)
plt.subplot(122)
plt.bar(np_y, np_x, color='red', label='sigmoid')
plt.title('书籍分类')
dic = {}
for city in list(pd.read_excel('图书.xlsx')['出版单位']):
if city in dic:
dic[city] += 1
else:
dic[city] = 1
c_x = [c for c in dic.keys()]
c_s = [s for s in dic.values()]
plt.subplot(121)
plt.bar(c_x, c_s)
plt.title('出版单位')
plt.ioff()
plt.show()
def books(self):
"""
看修改的书籍是否存在
"""
books_ = pd.read_excel('图书.xlsx')
find_book = list(books_['书名'])
book = self.main_window.lineEdit_9.text()
try:
if book in find_book:
return book
else:
return '不存在书籍'
except Exception as e:
with open('日志.csv', mode='a', encoding='utf8') as f:
f.write(str(e))
f.write('\n')
def deleteinfo(self):
"""
要修改书籍的基本信息
"""
df = pd.read_excel('图书.xlsx')
try:
b = pd.read_excel('图书.xlsx')['书名']
books = list(pd.read_excel('借阅.xlsx')['书名'])
delet_book = self.books()
for i in books:
if delet_book == i:
dex = list(b).index(i)
info = df.loc[dex]
return info
else:
self.messagebox = QMessageBox()
self.messagebox.information(self.messagebox, '不存在', '书籍不存在')
except Exception as e:
with open('日志.csv', mode='a') as f:
f.write(e)
f.write('\n')
def infoss(self):
"""
-------------------------------------------------------------------
使用pandas读取excel文件,将读取的内容一一对应的放入QTableWidget控件�
没有合适的资源?快使用搜索试试~ 我知道了~
课设&大作业&毕设 python图书管理系统、ui界面、qt,期末作业、毕业设计.zip
共10个文件
ui:6个
xlsx:2个
py:1个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 60 浏览量
2024-04-17
21:11:33
上传
评论
收藏 22KB ZIP 举报
温馨提示
【资源说明】【毕业设计】 1、该资源内项目代码都是经过测试运行成功,功能正常的情况下才上传的,请放心下载使用。 2、适用人群:主要针对计算机相关专业(如计科、信息安全、数据科学与大数据技术、人工智能、通信、物联网、数学、电子信息等)的同学或企业员工下载使用,具有较高的学习借鉴价值。 3、不仅适合小白学习实战练习,也可作为大作业、课程设计、毕设项目、初期项目立项演示等,欢迎下载,互相学习,共同进步!
资源推荐
资源详情
资源评论
收起资源包目录
python图书管理系统、ui界面、qt,期末作业、毕业设计.zip (10个子文件)
bysj5575757adsfas
说明.md 142B
退出.ui 3KB
书籍修改.ui 6KB
图书.xlsx 6KB
删除信息.ui 2KB
类别.ui 16KB
借书.ui 3KB
个人图书.py 18KB
个人图书管理系统.ui 34KB
借阅.xlsx 5KB
共 10 条
- 1
资源评论
zero2100
- 粉丝: 165
- 资源: 2464
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功