项目前台和后台界面模板都是自己编写，前台采用Bootstrap框架UI,后台EasyUI框架UI,没有采用Django自动生成的那个后台管理，因为那个后台实在是太丑了，丑得惨不忍睹！整个项目主要负责图书信息的添加，修改，多个条件组合查询，删除。虽然系统功能不是很复杂，不过这是一个很好的学习案例，包括了常用字段的设计，比如字符串，浮点型，整型，日期型，图片型，富文本字符串型，文件型和下拉框外键关联型，囊括了所有商业项目设计需要的字段类型，通杀所有商业系统设计原理！当然也是学习的不二选择，好东西值得分享，强烈推荐.后台登录用户名密码均为a。
系统实体对象：
图书类型：图书类别，类别名称，可借阅天数
图书：图书条形码，图书名称，图书所在类别，图书价格，库存，出版日期，出版社，图书图片，图书简介，图书文件。
程序运行截图
核心代码
"""Django settings for PythonProject project.Generated by 'django-admin startproject' using Django 2.2.5.For more information on this file, see/en/2.2/topics/settings/For the full list of settings and their values, see/en/2.2/ref/settings/"""import osimport sys# Build paths inside the project like this: os.path.join(BASE_DIR, ...)BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))#sys.path.insert(0, os.path.join(BASE_DIR, 'apps'))# Quick-start development settings - unsuitable for production# See /en/2.2/howto/deployment/checklist/# SECURITY WARNING: keep the secret key used in production secret!SECRET_KEY = 'fav!(r-3=i+bya!meg=vw*zcn-$4g3vhav!!)mw=f!b)7+7it2'# SECURITY WARNING: don't run with debug turned on in production!DEBUG = TrueALLOWED_HOSTS = []# Application definitionINSTALLED_APPS = ['django.contrib.admin','django.contrib.auth','django.contrib.contenttypes','django.contrib.sessions','django.contrib.messages','django.contrib.staticfiles','apps.Index', #首页模块'apps.BookType', #图书分类模块'apps.Book', #图书信息模块'tinymce', #富文本编辑器]MIDDLEWARE = ['django.middleware.security.SecurityMiddleware','django.contrib.sessions.middleware.SessionMiddleware','monMiddleware','django.middleware.csrf.CsrfViewMiddleware','django.contrib.auth.middleware.AuthenticationMiddleware','django.contrib.messages.middleware.MessageMiddleware','django.middleware.clickjacking.XFrameOptionsMiddleware',]ROOT_URLCONF = 'PythonProject.urls'TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates','DIRS': [os.path.join(BASE_DIR, 'templates')],'APP_DIRS': True,'OPTIONS': {'context_processors': ['django.template.context_processors.debug','django.template.context_processors.request','django.contrib.auth.context_processors.auth','django.contrib.messages.context_processors.messages',],},},]WSGI_APPLICATION = 'PythonProject.wsgi.application'# Database# /en/2.2/ref/settings/#databasesDATABASES = {'default': {'ENGINE': 'django.db.backends.mysql','NAME': 'db_book','USER': 'root','PASSWORD': 'sxing86','HOST': '127.0.0.1','PORT': 3306,}}# Password validation# /en/2.2/ref/settings/#auth-password-validatorsAUTH_PASSWORD_VALIDATORS = [{'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',},{'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',},{'NAME': 'django.contrib.monPasswordValidator',},{'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',},]# Internationalization# /en/2.2/topics/i18n/LANGUAGE_CODE = 'zh-hans'TIME_ZONE = 'Asia/Shanghai'USE_I18N = TrueUSE_L10N = TrueUSE_TZ = True# Static files (CSS, JavaScript, Images)# /en/2.2/howto/static-files/STATIC_URL = '/static/'STATICFILES_DIRS = [ os.path.join(BASE_DIR, 'static') ]MEDIA_ROOT = os.path.join(BASE_DIR, 'media').replace("\\", "/")MEDIA_URL = '/media/'# 配置session存储SESSION_ENGINE = "django.contrib.sessions.backends.cache"SESSION_CACHE_ALIAS = "default"#富文本编辑器配置TINYMCE_DEFAULT_CONFIG = {'theme': 'simple','width': '100%','height': '300px',}
BookType/views.py
from django.views.generic import Viewfrom django.shortcuts import renderfrom apps.BookType.models import BookTypefrom django.core.paginator import Paginatorfrom django.http import JsonResponseclass FrontAddView(View):def get(self,request):passdef post(self,request):passclass ListAllView(View):def get(self,request):bookTypes = BookType.objects.all()bookTypeList = []for bookType in bookTypes:bookTypeObj = {'bookTypeId': bookType.bookTypeId,'bookTypeName': bookType.bookTypeName,}bookTypeList.append(bookTypeObj)return JsonResponse(bookTypeList,safe=False)class FrontListView(View):def get(self,request):pageSize = 5currentPage = request.GET.get("currentPage")bookTypes = BookType.objects.all()paginator = Paginator(bookTypes, pageSize)totalPage = paginator.num_pagesrecordNumber = paginator.count# 获取第page页的内容try:currentPage = int(currentPage)except Exception as e:currentPage = 1if currentPage > totalPage:currentPage = totalPage# 获取第page页的Page实例对象bookTypes_page = paginator.page(currentPage)startIndex = (currentPage - 1) * pageSize #计算起始序号startPage = currentPage - 5endPage = currentPage + 5if startPage < 1:startPage=1if endPage > totalPage:endPage = totalPage;pageList = list(range(startPage,endPage+1))context = {'bookTypes_page': bookTypes_page,'currentPage': currentPage,'totalPage': totalPage,'recordNumber': recordNumber,'startIndex': startIndex,'pageList': pageList,}print(pageList)# 使用模板return render(request, 'BookType/bookType_frontquery_result.html', context)def post(self,request):pass
Book/views.py
from django.views.generic import Viewfrom apps.BaseView import BaseViewfrom django.shortcuts import renderfrom django.core.paginator import Paginatorfrom apps.Book.models import Bookfrom apps.BookType.models import BookTypefrom django.http import JsonResponsefrom django.http import FileResponsefrom apps.BaseView import ImageFormatExceptionfrom django.conf import settingsimport pandas as pdimport osclass FrontAddView(BaseView): # 前台图书添加def primaryKeyExist(self, barcode): # 判断主键是否存在try:Book.objects.get(barcode=barcode)return Trueexcept Book.DoesNotExist:return Falsedef get(self,request):bookTypes = BookType.objects.all() # 获取所有图书类型context = {'bookTypes': bookTypes,}# 使用模板return render(request, 'Book/book_frontAdd.html', context)def post(self,request):barcode = request.POST.get('book.barcode') # 判断图书条形码是否存在if self.primaryKeyExist(barcode):return JsonResponse({'success': False, 'message': '图书条形码已经存在'})book = Book() # 新建一个图书对象然后获取参数book.barcode = barcodebook.bookName = request.POST.get('book.bookName')book.bookTypeObj = BookType.objects.get(bookTypeId=int(request.POST.get('book.bookTypeObj.bookTypeId')))book.price = float(request.POST.get('book.price'))book.count = int(request.POST.get('book.count'))book.publishDate = request.POST.get('book.publishDate')book.publish = request.POST.get('book.publish')try:book.bookPhoto = self.uploadImageFile(request,'book.bookPhoto')except ImageFormatException as ife:return JsonResponse({'success': False, 'message': ife.error})book.bookDesc = request.POST.get('book.bookDesc')book.bookFile = self.uploadCommonFile(request,'book.bookFile')book.save() # 保存图书信息到数据库return JsonResponse({'success': True, 'message': '保存成功'})class FrontModifyView(BaseView): # 前台修改图书def get(self, request, barcode):context = {"barcode": barcode}return render(request, 'Book/book_frontModify.html', context)class FrontListView(BaseView): # 前台图书查询列表def get(self, request):return self.handle(request)def post(self, request):return self.handle(request)def handle(self,request):self.getCurrentPage(request) # 获取当前要显示第几页# 下面获取查询参数barcode = self.getStrParam(request, 'barcode')bookName = self.getStrParam(request, 'bookName')publishDate = self.getStrParam(request, 'publishDate')bookTypeObj_bookTypeId = self.getIntParam(request, 'bookTypeObj.bookTypeId')# 然后条件组合查询过滤book = Book.objects.all()if barcode != '':book = book.filter(barcode__contains=barcode)if bookName != '':book = book.filter(bookName__contains=bookName)if publishDate != '':book = book.filter(publishDate__contains=publishDate)if bookTypeObj_bookTypeId != '0':book = book.filter(bookTypeObj=bookTypeObj_bookTypeId)# 对查询结果利用Paginator进行分页self.paginator = Paginator(book, self.pageSize)# 计算总的页码数，要显示的页码列表，总记录等self.calculatePages()# 获取第page页的Page实例对象books_page = self.paginator.page(self.currentPage)# 获取所有图书类型bookTypes = BookType.objects.all()# 构造模板需要的参数context = {'bookTypes': bookTypes,'books_page': books_page,'barcode': barcode,'bookName': bookName,'publishDate': publishDate,'bookTypeObj_bookTypeId': int(bookTypeObj_bookTypeId),'currentPage': self.currentPage,'totalPage': self.totalPage,'recordNumber': self.recordNumber,'startIndex': self.startIndex,'pageList': self.pageList,}# 渲染模板界面return render(request, 'Book/book_frontquery_result.html', context)class FrontShowView(View): # 前台显示图片详情页def get(self, request, barcode):bookTypes = BookType.objects.all()# 查询需要显示的图书对象book = Book.objects.get(barcode=barcode)context = {'bookTypes': bookTypes,'book': book}# 渲染模板显示return render(request, 'Book/book_frontshow.html', context)class UpdateView(BaseView): # Ajax方式图书更新def get(self, request, barcode):# GET方式请求查询图书对象并返回图书json格式book = Book.objects.get(barcode=barcode)return JsonResponse(book.getJsonObj())def post(self, request, barcode):# POST方式提交图书修改信息更新到数据库book = Book.objects.get(barcode=barcode)book.bookName = request.POST.get('book.bookName')book.bookTypeObj = BookType.objects.get(bookTypeId=int(request.POST.get('book.bookTypeObj.bookTypeId')))book.price = float(request.POST.get('book.price'))book.count = int(request.POST.get('book.count'))book.publishDate = request.POST.get('book.publishDate')book.publish = request.POST.get('book.publish')try:bookPhotoName = self.uploadImageFile(request, 'book.bookPhoto')except ImageFormatException as ife:return JsonResponse({'success': False, 'message': ife.error})if bookPhotoName != 'img/NoImage.jpg':book.bookPhoto = bookPhotoNamebook.bookDesc = request.POST.get('book.bookDesc')bookFileName = self.uploadCommonFile(request, 'book.bookFile')if bookFileName != 'file/NoFile.jpg':book.bookFile = bookFileNamebook.save()return JsonResponse({'success': True, 'message': '保存成功'})class AddView(BaseView): # 后台添加图书def primaryKeyExist(self, barcode): # 判断主键是否存在try:Book.objects.get(barcode=barcode)return Trueexcept Book.DoesNotExist:return Falsedef get(self, request):# 获取所有图书类型bookTypes = BookType.objects.all()context = {'bookTypes': bookTypes,}# 渲染显示模板界面return render(request, 'Book/book_add.html', context)def post(self, request):# POST方式处理图书添加业务barcode = request.POST.get('book.barcode')if self.primaryKeyExist(barcode):return JsonResponse({'success': False, 'message': '图书条形码已经存在'})# 新建一个图书对象然后收集图书参数book = Book()book.barcode = barcodebook.bookName = request.POST.get('book.bookName')book.bookTypeObj = BookType.objects.get(bookTypeId=int(request.POST.get('book.bookTypeObj.bookTypeId')))book.price = float(request.POST.get('book.price'))book.count = int(request.POST.get('book.count'))book.publishDate = request.POST.get('book.publishDate')book.publish = request.POST.get('book.publish')try:book.bookPhoto = self.uploadImageFile(request, 'book.bookPhoto')except ImageFormatException as ife:return JsonResponse({'success': False, 'message': ife.error})book.bookDesc = request.POST.get('book.bookDesc')book.bookFile = self.uploadCommonFile(request, 'book.bookFile')book.save() # 这里提交更新到数据库return JsonResponse({'success': True, 'message': '保存成功'})class BackModifyView(BaseView): # 后台更新图书def get(self, request, barcode):context = {"barcode": barcode}return render(request, 'Book/book_modify.html', context)class ListView(BaseView): # 后台图书列表def get(self, request):# 使用模板return render(request, 'Book/book_query_result.html')def post(self,request):# 获取当前要显示第几页和每页几条数据self.getPageAndSize(request)# 收集查询参数barcode = self.getStrParam(request, 'barcode')bookName = self.getStrParam(request, 'bookName')publishDate = self.getStrParam(request, 'publishDate')bookTypeObj_bookTypeId = self.getIntParam(request, 'bookTypeObj.bookTypeId')# 然后条件组合查询过滤books = Book.objects.all()if barcode != '':books = books.filter(barcode__contains=barcode)if bookName != '':books = books.filter(bookName__contains=bookName)if publishDate != '':books = books.filter(publishDate__contains=publishDate)if bookTypeObj_bookTypeId != '0':books = books.filter(bookTypeObj=bookTypeObj_bookTypeId)# 利用Paginator对查询结果集分页self.paginator = Paginator(books, self.pageSize)# 计算总的页码数，要显示的页码列表，总记录等self.calculatePages()# 获取第page页的Page实例对象books_page = self.paginator.page(self.currentPage)# 查询的结果集转换为列表bookList = []for book in books_page:book = book.getJsonObj()bookList.append(book)# 构造模板页面需要的参数book_res = {'rows': bookList,'total': self.recordNumber,}# 渲染模板页面显示return JsonResponse(book_res, json_dumps_params={'ensure_ascii':False})class DeletesView(BaseView): # 删除图书信息def get(self, request):return self.handle(request)def post(self, request):return self.handle(request)def handle(self, request):barcodes = self.getStrParam(request, 'barcodes')barcodes = barcodes.split(',')count = 0try:for barcode in barcodes:Book.objects.get(barcode=barcode).delete()count = count + 1message = '%s条记录删除成功！' % countsuccess = Trueexcept Exception as e:message = '数据库删除发生错误！'success = Falsereturn JsonResponse({"success": success, "message": message})class OutToExcelView(BaseView): # 导出图书信息到excel并下载def get(self,request):# 收集查询参数barcode = self.getStrParam(request, 'barcode')bookName = self.getStrParam(request, 'bookName')publishDate = self.getStrParam(request, 'publishDate')bookTypeObj_bookTypeId = self.getIntParam(request, 'bookTypeObj.bookTypeId')# 然后条件组合查询过滤books = Book.objects.all()if barcode != '':books = books.filter(barcode__contains=barcode)if bookName != '':books = books.filter(bookName__contains=bookName)if publishDate != '':books = books.filter(publishDate__contains=publishDate)if bookTypeObj_bookTypeId != '0':books = books.filter(bookTypeObj=bookTypeObj_bookTypeId)#将查询结果集转换成列表bookList = []for book in books:book = book.getJsonObj()bookList.append(book)# 利用pandas实现数据的导出功能pf = pd.DataFrame(bookList)# 设置要导入到excel的列columns_map = {'barcode': '图书条形码','bookName': '图书名称','bookTypeObj': '图书类别','price': '图书价格','count': '图书数量','publishDate': '出版日期','publish': '出版社',}pf = pf[columns_map.keys()]pf.rename(columns=columns_map, inplace=True)# 将空的单元格替换为空字符pf.fillna('', inplace=True)#设定文件名和导出路径filename = 'books.xlsx'# 这个路径可以在settings中设置也可以直接手动输入root_path = settings.MEDIA_ROOT + '/output/'file_path = os.path.join(root_path, filename)pf.to_excel(file_path, encoding='utf-8', index=False)# 将生成的excel文件输出到网页下载file = open(file_path, 'rb')response = FileResponse(file)response['Content-Type'] = 'application/octet-stream'response['Content-Disposition'] = 'attachment;filename="books.xlsx"'return response
完整程序代码下载：Python基于mysql+Django框架图书管理系统源代码(含mysql文件)
更多Python源代码请关注公众号：Python代码大全。
