python实现图书管理系统实现图书管理系统
本文实例为大家分享了python实现图书管理系统的具体代码，供大家参考，具体内容如下
import mysql.connector
import sys, os
import time
import datetime
from tkinter import *
from tkinter.messagebox import *
class Libop:
user = 'root'
pwd = ''
host = 'localhost'
db = 'library'
data_file = 'mysql-test.dat'
def __init__(self):
print("init")
try:
self.library=mysql.connector.connect(user=Libop.user,password=Libop.pwd,host=Libop.host,database=Libop.db)
self.cursor=self.library.cursor()
print("Connect successfully")
except mysql.connector.Error as err:
print("WTF! initial wrong")
print("Error: {}".format(err.msg))
sys.exit()
def select(self,str):
try:
self.cursor.execute(str)
return self.cursor.fetchall()
except mysql.connector.Error as err:
print("WTF! select wrong")
print("Error:{}".format(err.msg))
print(str)
showinfo("ERROR","Please input the parameter correctly")
def update(self,str):
try:
self.cursor.execute(str)
self.library.commit()
return 1
except mysql.connector.Error as err:
print("WTF! update wrong")
print("Error:{}".format(err.msg))
return 0
def delete(self,str):
try:
self.cursor.execute(str)
self.library.commit()
except mysql.connector.Error as err:
print("WTF! delete wrong")
print("Error:{}".format(err.msg))
def insert(self,str):
try:
self.cursor.execute(str)
self.library.commit()
return 1
except mysql.connector.Error as err:
print("WTF! insert wrong")
print("Error:{}".format(err.msg))
return 0
LIB = Libop()
root=Tk()
root.wm_title("Library System")
str1=str2=''
book_type=name=year=publisher=writer=price1=price2=order=''
cardid=''
def call_rent(en1,en2,brok):
st1=en1.get()
st2=en2.get()
rent(st1,st2,brok)
def call_return(en1,en2):
st1=en1.get()
st2=en2.get()
back(st1,st2)
def login():
str1=ide.get()
str2=pwde.get()
curs=LIB.select("select manage_id,pswd from managers where manage_id='{}' and pswd='{}'".format(str1,str2))
weixin_38747815
- 粉丝: 54
- 资源: 889
最新资源
- 手套手势检测7-YOLO（v5至v11）、COCO、CreateML、Paligemma、TFRecord、VOC数据集合集.rar
- CentOS bridge 工具包 bridge-utils-1.6-1.33.x86-64.rpm
- 手势检测7-YOLO（v5至v11）、COCO、CreateML、Paligemma、TFRecord、VOC数据集合集.rar
- 基于python flask实现某瓣数据可视化数据分析平台
- awewq1132323
- 手写流程图检测31-YOLO（v5至v8）、COCO、CreateML、Darknet、Paligemma、TFRecord数据集合集.rar
- frida拦截微信小程序云托管API
- 肝脏及其肿瘤分割的 CT 数据集，已经切片成jpg数据，约2w张数据和mask
- 基于Java的网上教务评教管理系统的设计与实现.doc
- 2024圣诞节海外消费市场趋势及营销策略分析报告
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
前往页