管理系统

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

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>

    <link rel="stylesheet" href="/static/bootstrap-3.3.5-dist/css/bootstrap.css">
    <style>

        .container{
            margin-top: 200px;
            margin-left: 150px;
        }

        body{
            background-image:url("/static/img/6.jpg");
            background-size: 100%;
            background-repeat: no-repeat;

        }


    </style>
</head>


<body>


<div class="container">


    <div class="row">

        <div class="col-md-6 col-md-offset-2">
            <a href="/add_book/"><button class="btn btn-primary">添加</button></a>
             <table class="table table-bordered ">
                    <tr>
                        <th>ID</th>
                        <th>书名</th>
                        <th>价格</th>
                        <th>出版日期</th>
                        <th>出版社</th>
                        <th>操作</th>

                    </tr>


                    {% for obj in book_list %}

                        <tr>
                            <td>{{ obj.id }}</td>
                            <td>{{ obj.title }}</td>
                            <td>{{ obj.price }}</td>
                            <td>{{ obj.dates|date:'Y-m-d' }}</td>
                            <td>{{ obj.p.name }}</td>
                            <td>
                                <a href="/edit_book/{{ obj.id }}" class="btn btn-info">编辑</a>
                                <a href="/del_book/?nid={{ obj.id }} " class="btn btn-warning">删除</a>
                            </td>
                        </tr>

                    {% endfor %}




             </table>
        </div>
    </div>


</div>

add_book.html

{% load staticfiles %}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>添加书籍</title>

    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/css/bootstrap.css' %}">
    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/js/bootstrap.js' %}">

    <style>
        .container{
            margin-top: 100px;
        }
    </style>

</head>
<body>

<div class="container">


    <div class="row">

        <div class="col-md-6 col-md-offset-2">

            <form  action="/add_book/" method="post">
                      <div class="form-group">
                        <label for="title">书名</label>
                        <input type="text" class="form-control" id="title" placeholder="title" name="title">
                      </div>

                      <div class="form-group">
                            <label for="price">价格</label>
                            <input type="text" class="form-control" id="price" placeholder="price" name="price">
                      </div>
                      <div class="form-group">
                            <label for="dates">出版日期</label>
                            <input type="date" class="form-control" id="dates" placeholder="dates" name="dates">
                       </div>
                      <div class="form-group">
                        <label for="publish">出版社</label>
{#                        <input type="text" class="form-control" id="publish" placeholder="publish" name="publish">#}

                      <p>
                          <select name="p_id" >
                            {% for row in publish_list %}
                            <option value="{{ row.id }}">{{ row.name }}</option>

                            {% endfor %}

                          </select>
                      </p>

                      </div>

                <input type="submit" class="btn btn-info">

                   </form>


        </div>
    </div>


</div>

</body>
</html>

edit_book.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>编辑书籍</title>
</head>
<body>

    <h1>编辑书籍</h1>

    <form method="POST" action="/edit_book/{{ a1 }}/">


        <p>书籍名称<input type="text" name="title"  value="{{ current_book_info.title }}" /></p>
        <p>价格<input type="text" name="price"  value="{{ current_book_info.price }}" /></p>
        <p>日期<input type="date" name="dates"  value="{{ current_book_info.dates|date:'Y-m-d' }}" /></p>


        <p>
            所属出版社
            <select name="p_id">


                <!-- 循环所有的出版社 -->
                {% for row in publish_list %}
                    <!-- 如果是当前书籍所在的出版社，则默认选中 -->
                    {% if current_book_info.p_id == row.id %}
                        <option selected value="{{  row.id }}">{{ row.name }}</option>
                    {% else %}
                        <option value="{{ row.id }}">{{ row.name }}</option>
                    {% endif %}

                {% endfor %}



            </select>
        </p>

        <input type="submit" value="提交" />

    </form>





</body>
</html>

#--------出版社表

publish.html

{% load staticfiles %}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>

    <link rel="stylesheet" href="{% static  'bootstrap-3.3.5-dist/css/bootstrap.css'%}">
    <style>

        .container{
            margin-top: 200px;
            margin-left: 150px;
        }

        body{
            background-image:url("/static/img/6.jpg");
            background-size: 100%;
            background-repeat: no-repeat;

        }


    </style>
</head>


<body>


<div class="container">


    <div class="row">

        <div class="col-md-6 col-md-offset-2">
            <a href="/add_publish/"><button class="btn btn-primary">添加</button></a>
             <table class="table table-bordered ">
                    <tr>
                        <th>ID</th>
                        <th>出版社</th>
                        <th>地址</th>
                        <th>城市</th>
                        <th>操作</th>

                    </tr>


                    {% for obj in publish_list %}

                        <tr>
                            <td>{{ obj.id }}</td>
                            <td>{{ obj.name }}</td>
                            <td>{{ obj.address }}</td>
                            <td>{{ obj.city }}</td>


                            <td >
                                <a href="/edit_publish/{{ obj.id }}" class="btn btn-info col-md-offset-2">编辑</a>
                                <a href="/del_publish/?nid={{ obj.id }}" class="btn btn-warning col-md-offset-1">删除</a>
                            </td>
                        </tr>

                    {% endfor %}





             </table>
        </div>
    </div>


</div>






</body>



</html>

add_publish.html

{% load staticfiles %}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>添加出版社</title>

    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/css/bootstrap.css' %}">
    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/js/bootstrap.js' %}">

    <style>
        .container{
            margin-top: 100px;
        }
    </style>

</head>
<body>

<div class="container">


    <div class="row">

        <div class="col-md-6 col-md-offset-2">

            <form  action="/add_publish/" method="POST">
                      <div class="form-group">
                        <label for="name">出版社</label>
                        <input type="text" class="form-control" id="name" placeholder="name" name="name">
                      </div>

                      <div class="form-group">
                            <label for="address">地址</label>
                            <input type="text" class="form-control" id="address" placeholder="address" name="address">
                      </div>
                      <div class="form-group">
                            <label for="city">所在城市</label>
                            <input type="text" class="form-control" id="city" placeholder="city" name="dcity">
                       </div>



                <input type="submit" class="btn btn-info">

                   </form>


        </div>
    </div>


</div>

</body>
</html>

edit_author.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>编辑作者</title>
</head>
<body>

    <h1>编辑作者</h1>

    <form method="POST" action="/edit_author/{{ a1 }}/">


        <p>作者姓名<input type="text" name="name"  value="{{ author_info.name }}" /></p>

        <div>所写书籍


        <p>
            <select name="b_ids" multiple size="3">

                {% for item in book_list %}
                    {% if item.id in book_id_list %}
                        <option value="{{ item.id }}" selected>{{ item.title }}</option>
                    {% else %}
                        <option value="{{ item.id }}">{{ item.title }}</option>
                    {% endif %}
                {% endfor %}


            </select>
        </p>

        </div>
        <input type="submit" value="提交" />

    </form>





</body>
</html>

#--------作者表（包含Book和Author 关系）

authot.html

{% load staticfiles %}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>

    <link rel="stylesheet" href="{% static  'bootstrap-3.3.5-dist/css/bootstrap.css'%}">
    <style>

        .container{
            margin-top: 200px;
            margin-left: 150px;
        }

        body{
            background-image:url("/static/img/6.jpg");
            background-size: 100%;
            background-repeat: no-repeat;

        }


    </style>
</head>


<body>


<div class="container">


    <div class="row">

        <div class="col-md-7 col-md-offset-2">
            <a href="/add_author/"><button class="btn btn-primary">添加</button></a>
             <table class="table table-bordered ">
                    <tr>
                        <th>ID</th>
                        <th>作者姓名</th>
                        <th class="col-md-3">所写书籍</th>

                        <th>操作</th>

                    </tr>


                    {% for obj in author_list %}

                        <tr>
                            <td>{{ obj.id }}</td>
                            <td>{{ obj.name }}</td>

                            <td>
                                {% for item in obj.title %}

                                    <span style="display: inline-block;padding: 5px;border: 2px solid #c0a16b">{{ item }}</span>

                                {% endfor %}

                            </td>

                            <td >
                                <a href="/edit_author/{{ obj.id }}" class="btn btn-info col-md-offset-3">编辑</a>
                                <a href="/del_author/?nid={{ obj.id }}" class="btn btn-warning ">删除</a>
                            </td>
                        </tr>

                    {% endfor %}





             </table>
        </div>
    </div>


</div>

add_author.html

{% load staticfiles %}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>添加作者</title>

    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/css/bootstrap.css' %}">
    <link rel="stylesheet" href="{% static 'bootstrap-3.3.5-dist/js/bootstrap.js' %}">

    <style>
        .container{
            margin-top: 100px;
        }
    </style>

</head>
<body>

<div class="container">


    <div class="row">

        <div class="col-md-6 col-md-offset-2">

            <form  action="/add_author/" method="post">
                      <div class="form-group">
                        <label for="name">作者姓名</label>
                        <input type="text" class="form-control" id="name" placeholder="姓名" name="name">
                      </div>

                    <div class="form-group">
                        <label for="title">所写书籍</label>
{#                        <input type="text" class="form-control" id="title" placeholder="所写书籍" name="title">#}
                        <p>
                            <select name="book_ids" multiple size="3">
                            {% for item in book_list %}
                                <option value="{{ item.id }}">{{ item.title }}</option>
                            {% endfor %}

                            </select>
                        </p>

                    </div>


                <input type="submit" class="btn btn-info">

                   </form>


        </div>
    </div>


</div>

</body>
</html>

edit_author.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>编辑作者</title>
</head>
<body>

    <h1>编辑作者</h1>

    <form method="POST" action="/edit_author/{{ a1 }}/">


        <p>作者姓名<input type="text" name="name"  value="{{ author_info.name }}" /></p>

        <div>所写书籍


        <p>
            <select name="b_ids" multiple size="3">

                {% for item in book_list %}
                    {% if item.id in book_id_list %}
                        <option value="{{ item.id }}" selected>{{ item.title }}</option>
                    {% else %}
                        <option value="{{ item.id }}">{{ item.title }}</option>
                    {% endif %}
                {% endfor %}


            </select>
        </p>

        </div>
        <input type="submit" value="提交" />

    </form>





</body>
</html>

 

所用背景图片：