I.书籍管理系统
models
class Book(models.Model): """ 书籍 """ title=models.CharField(max_length=32) price=models.IntegerField() dates=models.DateField(null=True) p=models.ForeignKey('Publish')class Publish(models.Model): """ 出版社 """ name=models.CharField(max_length=32) address=models.CharField(max_length=32) city=models.CharField(max_length=32,null=True)class Author(models.Model): """ 作者 """ name=models.CharField(max_length=32)class Book2Author(models.Model): """ 书籍和作者关系表 """ book=models.ForeignKey('Book') author=models.ForeignKey('Author')
urls.py
#---书籍 url(r'^book/',views.book), url(r'^add_book/',views.add_book), url(r'^del_book/',views.del_book), url(r'^edit_book/(\d+)/',views.edit_book), #---出版社 url(r'^publish/',views.publish), url(r'^add_publish/',views.add_publish), url(r'^del_publish/',views.del_publish), url(r'^edit_publish/(\d+)/',views.edit_publish), #---作者和书籍关系 url(r'^author/', views.author), url(r'^add_author', views.add_author), url(r'^del_author/', views.del_author), url(r'^edit_author/(\d+)/', views.edit_author),
views.py
##-------------书籍----------def book(request): book_list=models.Book.objects.all() for obj in book_list: print(obj.title,obj.p.name) return render(request,'book.html',locals())def add_book(request): if request.method=='GET': publish_list=models.Publish.objects.all() print(publish_list) return render(request,'add_book.html',locals()) else: title=request.POST.get('title') price=request.POST.get('price') dates=request.POST.get('dates') p_id=request.POST.get('p_id') models.Book.objects.create(title=title,price=price,dates=dates,p_id=p_id) return redirect('/book/')def del_book(request): nid=request.GET.get('nid') models.Book.objects.filter(id=nid).delete() return redirect('/book/')def edit_book(request,a1): if request.method=='GET': current_book_info=models.Book.objects.filter(id=a1).first() publish_list = models.Publish.objects.all() print(locals()) return render(request,'edit_book.html',locals()) else: title=request.POST.get('title') price=request.POST.get('price') dates=request.POST.get('dates') p_id=request.POST.get('p_id') print(title,price,dates,p_id) models.Book.objects.filter(id=a1).update(title=title,price=price,dates=dates,p_id=p_id) return redirect('/book/')#--------------- 出版社 -------------def publish(request): publish_list=models.Publish.objects.all() return render(request,'publish.html',locals())def add_publish(request): if request.method=='GET': return render(request,'add_publish.html') else: name=request.POST.get('name') address=request.POST.get('address') city=request.POST.get('city') models.Publish.objects.create(name=name,address=address,city=city) return redirect('/publish/')def del_publish(request): nid=request.GET.get('nid') models.Publish.objects.filter(id=nid).delete() return redirect('/publish/')def edit_publish(request,a1): if request.method=='GET': current_publish_info=models.Publish.objects.filter(id=a1).first() return render(request,'edit_publish.html',locals()) else: name=request.POST.get('name') address=request.POST.get('address') city=request.POST.get('city') models.Publish.objects.filter(id=a1).update(name=name,address=address,city=city) return redirect('/publish/')#------------作者和书籍(多对多)------------def author(request): author_list=models.Author.objects.all().values('id','name','book2author__book__title') # for i in author_list: # print(i['id'],i['name'],i['book2author__book__title']) # print('******',author_list) result={} for row in author_list: id=row['id'] print('###',id) if row['id'] in result: result[row['id']]['title'].append(row['book2author__book__title']) else: result[row['id']] = { 'id':row['id'],'name':row['name'],'title':[row['book2author__book__title']]} print('*********',result) return render(request,'author.html',{ 'author_list':result.values()})def add_author(request): if request.method=='GET': book_list=models.Book.objects.all() return render(request,'add_author.html',locals()) else: name=request.POST.get('name') author_id=models.Author.objects.create(name=name) book_ids=request.POST.getlist('book_ids') ###传过来的书籍可能会多个:getlist # print('***#####**',author_id) # print('***#####***',book_ids) #多次连接,多次提交 for b_id in book_ids: models.Book2Author.objects.create(author_id=author_id.id,book_id=b_id) return redirect('/author/')def edit_author(request,a1): if request.method=='GET': author_info=models.Author.objects.filter(id=a1).first() book_id_list=models.Book2Author.objects.filter(author_id=a1).values_list("book_id") book_id_list = [i[0] for i in book_id_list] book_list=models.Book.objects.all() # print('****',author_info) # print('****', book_id_list) return render(request,'edit_author.html',locals()) else: name=request.POST.get('name') book_ids=request.POST.getlist('b_ids') print('b)ids') #更新作者表 models.Author.objects.filter(id=a1).update(name=name) #更新作者和书籍表 #先把当前作者和书籍表 对象关系删除 models.Book2Author.objects.filter(author_id=a1).delete() for id in book_ids: models.Book2Author.objects.create(author_id=a1,book_id=id) return redirect('/author/')
***.html
#-----------书籍表
book.html
Title
add_book.html
{% load staticfiles %}添加书籍
edit_book.html
编辑书籍 编辑书籍
#--------出版社表
publish.html
{% load staticfiles %}Title
add_publish.html
{% load staticfiles %}添加出版社
edit_author.html
编辑作者 编辑作者
#--------作者表(包含Book和Author 关系)
authot.html
{% load staticfiles %}Title
add_author.html
{% load staticfiles %}添加作者
edit_author.html
编辑作者 编辑作者
所用背景图片: