用wxpython實現的簡單圖書管理系統，可以實現增加圖書，刪除圖書，修改圖書，查看圖書。后臺數據庫為mysql數據庫，采用的pymysql連接數據庫。系統界面如下：

代碼如下：

1.書本類代碼

#author = liuwei date = 2017-06-02from datetime import *      #導入日期模塊__metaclass__ = typeclass Book: '''一個書本信息類，包括書本名字，作者名字和書本簡單信息''' def __init__(self, bookName = "", author = "", content = ""): self.bookName = bookName     #書本名字 self.author = author      #作者名字 self.content = content     #書本信息 self.add_date = date.today()     #書本添加日期 def setBookName(self, name): self.bookName = name def getBookName(self): return self.bookName def setAuthor(self, author): self.author = author def getAuthor(self): return self.author def setContent(self, content): self.content = content def getContent(self): return self.content def getAddDate(self): return self.add_dateif __name__ == "__main__": mybook = Book() print(mybook.date)

2.數據庫操作類代碼

#author = liuwei date = 2017-06-02#數據庫幫助類import pymysqlfrom book import *__metaclass__ = typeclass DBHelper: def getCon(self): '''獲取操作數據庫的curcor即游標，首先的建立連接，需要服務器地址，端口號，用戶名，密碼和數據庫名''' #為了能用中文，得加上編碼方式 conn = pymysql.connect(host = "localhost", port = 3306, user = "root", password = "201392260", db = "library", charset = "utf8") return conn def insertBook(self, book): '''向數據庫中book表插入書本信息，book為Book類對象，包含書本基本信息''' sql = "insert into book(name, author, content, add_date) values(%s, %s, %s, %s)" conn = self.getCon(); if conn ==None:  return cursor = conn.cursor() cursor.execute(sql, (book.getBookName(), book.getAuthor(), book.getContent(), book.getAddDate())) conn.commit() cursor.close() conn.close() new_id = cursor.lastrowid print("新插入鍵值id為:", new_id) return new_id def getAllBook(self): '''返回數據庫中，book表中所有的書本信息''' sql = "select *from book" conn = self.getCon() if conn == None:  return cursor = conn.cursor() rownum = cursor.execute(sql)  #執行并返回找到的行數 #獲取查詢結果 rows = cursor.fetchall() list = [] for item in rows:  bitem = (item[0], item[1], str(item[4]))  list.append(bitem) conn.commit() cursor.close() conn.close() return list def getBookById(self, bookid): '''根據書本id值來尋找書本信息''' sql = "select book.name, book.author, book.content from book where id=%s" conn = self.getCon() if conn == None:  return cursor = conn.cursor() cursor.execute(sql, (bookid, ))   #參數以元組形式給出 row = cursor.fetchone()    #取到第一個結果 conn.commit() cursor.close() conn.close() return row      #返回該書本信息 def saveUpdate(self, bookid, book): '''用book對象來修改id為bookid的書本信息''' sql = "update book set book.name=%s, book.author=%s, book.content=%s where book.id=%s" conn = self.getCon() if conn == None:  return cursor = conn.cursor() cursor.execute(sql, (book.getBookName(), book.getAuthor(), book.getContent(), bookid)) conn.commit() cursor.close() conn.close() def deleteBook(self, bookid): '''根據書本id來刪除書籍''' sql = "delete from book where book.id = %s" conn = self.getCon() if conn == None:  return cursor = conn.cursor() cursor.execute(sql, (bookid, )) conn.commit() cursor.close() conn.close()if __name__ == '__main__': db = DBHelper() #book = Book("秦腔", "賈凹平", "講的是大西北夏家和白家的事情，由引生口述。") #db.insertBook(book) list = db.getAllBook() for item in list: print(item)