企业网站定制开发Python图书管理系统(终章)

文章目录

  
  
  

前言

  

企业网站定制开发上次写了用MySQL企业网站定制开发完成数据存储的图书管理系统,
企业网站定制开发这次我将把各个模块划企业网站定制开发分为系统的各个功能,企业网站定制开发通过框架与前端进行数据交互。企业网站定制开发做成一个小型的完整网页项目。

  
  
  

企业网站定制开发总的项目布局

  

企业网站定制开发项目布局很重要,企业网站定制开发什么类型的文件就放在企业网站定制开发对应类型的文件夹下。


blueprints :企业网站定制开发里放各个功能模块。

static :里面放css用的图片等美化网页的文件。(这个项目只是练手,前端就没细搞,所以我这个文件夹里是空的)

templates:里面放前端代码。

app.py:作为一个主文件运行,用来启动网站。

config.py:其实app.py下还应有个config.py作为配置文件。设置这样一个专门放项目配置的配置文件,就不用在每个项目中写几十甚至上百条配置语句了,配置时只需调用此文件即可。(这个项目很小,几乎用不到配置,所以没弄这个)

  
  

数据库层面:

这些是项目中用来存储数据的表。


  
  
  

效果展示

  
1.未登录时

有个提示登陆的弹窗,点确定就进入了


没有账号的需要注册


注册完成后就可以登录了
  

2.登录

若用普通学号(2028124001)登录,则功能较少

PS:项目较小,普通人登录的功能没怎么弄,就只能登录、注销和查看图书信息,更多功能都在管理员登录那。

注销,换个账号登录

就又回到了刚刚没登陆前的页面

这次用管理员学号(2028124078)登录

  
3.功能操作

管理员可以操作三个表:图书列表、已借出的书、借阅人信息,并可以对这三个表的数据进行“增删查”。(暂时没有“改”,等会了Ajax再加上)

具体操作就不一一展示了。

  
  
  

全部代码

  

话不多说,上代码!!!
  

blueprints里:

AllBooks.py

import pymysqlfrom flask import Blueprint, render_template, request, redirect, url_forbp = Blueprint('AllBooks', __name__, url_prefix='/user')@bp.route('/AllBooks', methods=['GET', 'POST'])def AllBooks():    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'select * from allbooks'    try:        cursor.execute(sql)        f = cursor.fetchall()        context = {            'books': f,        }    except:        db.rollback()    db.close()    return render_template('AllBooks.html', **context)@bp.route('/delete', methods=['GET', 'POST'])def delete():    uid = request.args.get('uid')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'delete from allbooks where 编号 = "%d"'    try:        cursor.execute(sql % int(uid))      # 要转换成int型,否则没功能        db.commit()    except:        db.rollback()    db.close()    return redirect(url_for('AllBooks.AllBooks'))@bp.route('/search', methods=['GET', 'POST'])def search():    data = request.args.get('search')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接    cursor = db.cursor()  # 使用cursor()方法获取操作游标    sql = 'select * from allbooks where 编号 = "%d"'    try:        cursor.execute(sql % int(data))        f = cursor.fetchall()        context = {            'books': f            }    except:        db.rollback()    db.close()    return render_template('AllBooks.html', **context)@bp.route('/add', methods=['GET', 'POST'])def add():    if request.method == 'GET':        return render_template('addall.html')    else:        data = request.form        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接        cursor = db.cursor()  # 使用cursor()方法获取操作游标        sql = 'insert into allbooks(书名,作者,种类,数量,剩余) values("%s", "%s", "%s", "%d", "%d")'  # SQL 插入语句        try:            cursor.execute(sql % (data['bookname'], data['writer'], data['typ'], int(data['qu']), int(data['sur'])))  # 执行sql语句            db.commit()        except:            db.rollback()  # 发生错误时回滚        db.close()  # 关闭数据库连接    return redirect(url_for('AllBooks.AllBooks'))
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76

  
BooksOfLent

import pymysqlfrom flask import Blueprint, render_template, request, url_for, redirectbp = Blueprint('BooksOfLent', __name__, url_prefix='/lent')@bp.route('/books', methods=['GET', 'POST'])def lent():    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'select * from books_of_lent'    try:        cursor.execute(sql)        f = cursor.fetchall()        context = {            'books': f,        }    except:        db.rollback()    db.close()    return render_template('Books Of Lent.html', **context)@bp.route('/delete', methods=['GET', 'POST'])def delete():    uid = request.args.get('uid')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'delete from books_of_lent where 编号 = "%d"'    try:        cursor.execute(sql % int(uid))      # 要转换成int型,否则没功能        db.commit()    except:        db.rollback()    db.close()    return redirect(url_for('BooksOfLent.lent'))@bp.route('/search', methods=['GET', 'POST'])def search():    data = request.args.get('search')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接    cursor = db.cursor()  # 使用cursor()方法获取操作游标    sql = 'select * from books_of_lent where 编号 = "%d"'    try:        cursor.execute(sql % int(data))        f = cursor.fetchall()        context = {            'books': f            }    except:        db.rollback()    db.close()    return render_template('Books Of Lent.html', **context)@bp.route('/add', methods=['GET', 'POST'])def add():    if request.method == 'GET':        return render_template('addlent.html')    else:        data = request.form        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接        cursor = db.cursor()  # 使用cursor()方法获取操作游标        sql = 'insert into books_of_lent(编号,书名,借阅人学号,借出时间,归还时间) values("%d","%s", "%s", "%s", "%s")'        try:            cursor.execute(sql % (int(data['num']), data['bookname'], data['stunum'], data['lenttime'], (data['returntime'])))  # 执行sql语句            db.commit()        except:            db.rollback()  # 发生错误时回滚        db.close()  # 关闭数据库连接    return redirect(url_for('BooksOfLent.lent'))
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75

  
borrower

import pymysqlfrom flask import Blueprint, render_template, requestbp = Blueprint('borrower', __name__, url_prefix='/user')@bp.route('/borrower')def AllBooks():    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'select * from allbooks'    try:        cursor.execute(sql)        f = cursor.fetchall()        context = {            'books': f,        }    except:        db.rollback()    db.close()    return render_template('borrower.html', **context)
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26

  
BorrowerInformation

import pymysqlfrom flask import Blueprint, render_template, request, url_for, redirectbp = Blueprint('BorrowerInformation', __name__, url_prefix='/Borrower')@bp.route('/Information', methods=['GET', 'POST'])def borrower():    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'select * from borrower_information'    try:        cursor.execute(sql)        f = cursor.fetchall()        context = {            'inf': f        }    except:        db.rollback()    db.close()    return render_template('Borrower Information.html', **context)@bp.route('/delete', methods=['GET', 'POST'])def delete():    uid = request.args.get('uid')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')    cursor = db.cursor()    sql = 'delete from borrower_information where 学号 = "%s"'    try:        cursor.execute(sql % str(uid))        db.commit()    except:        db.rollback()    db.close()    return redirect(url_for('BorrowerInformation.borrower'))@bp.route('/search', methods=['GET', 'POST'])def search():    data = request.args.get('search')    db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接    cursor = db.cursor()  # 使用cursor()方法获取操作游标    sql = 'select * from borrower_information where 学号 = "%s"'    # try:    cursor.execute(sql % data)    f = cursor.fetchall()    context = {        'inf': f        }    # except:    #     db.rollback()    db.close()    return render_template('Borrower Information.html', **context)@bp.route('/add', methods=['GET', 'POST'])def add():    if request.method == 'GET':        return render_template('addinf.html')    else:        data = request.form        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接        cursor = db.cursor()  # 使用cursor()方法获取操作游标        sql = 'insert into borrower_information(学号,姓名) values("%s", "%s")'  # SQL 插入语句        try:            cursor.execute(sql % (data['num'], data['name']))  # 执行sql语句            db.commit()        except:            db.rollback()  # 发生错误时回滚        db.close()  # 关闭数据库连接    return redirect(url_for('BorrowerInformation.borrower'))
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76

  
register

import pymysqlfrom flask import Blueprint, render_template, request, redirect, url_forbp = Blueprint('register', __name__, url_prefix='/register')@bp.route('/people', methods=['GET', 'POST'])def register():    if request.method == 'GET':        return render_template('register.html')    else:        data = request.form        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')  # 打开数据库连接        cursor = db.cursor()  # 使用cursor()方法获取操作游标        sql = 'insert into borrower_information(学号,姓名) values("%s", "%s")'  # SQL 插入语句        try:            cursor.execute(sql % (data['password'], data['username']))  # 执行sql语句            db.commit()        except:            db.rollback()  # 发生错误时回滚        db.close()  # 关闭数据库连接        return redirect(url_for('user.index'))
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22

  
user

# home page and loginimport pymysqlfrom flask import Blueprint, render_template, request, redirect, url_forbp = Blueprint('user', __name__, url_prefix='/')@bp.route('/', methods=['GET', 'POST'])def index():    if request.method == 'GET':        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')        cursor = db.cursor()        sql = 'select * from allbooks'        try:            cursor.execute(sql)            f = cursor.fetchall()            context = {                'books': f,            }        except:            db.rollback()        db.close()        return render_template('AllBooks(Before login).html', **context)    else:        data = request.form        db = pymysql.connect(host='localhost', user="root", passwd='MQ20201008', database='final_assignment')        cursor = db.cursor()        sql = 'select * from borrower_information where 学号 = "%s"'        try:            cursor.execute(sql % data['password'])            f = cursor.fetchall()            if f:                return redirect(url_for('borrower.AllBooks'))        except:            db.rollback()        sql = 'select * from admin where 学号 = "%s"'        try:            cursor.execute(sql % data['password'])            f = cursor.fetchall()            if f:                return redirect(url_for('AllBooks.AllBooks'))        except:            db.rollback()        db.close()
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48

  
  
templates里:

addall.html

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>注册页面</title>    <style>        *{            margin: 0px;            padding: 0px;            box-sizing: border-box;        }        body{            background: url("../demo_html/file/17.jpg" )  no-repeat ;            background-size: 1920px 1200px;        }        .rg_layout{            width: 800px;            height: 500px;            border: 5px solid #EEEEEE;            background-color: #FBFBEF;            margin-left: 100px;            margin-top: 180px;        }        .rg_left{            /*border: 1px red solid;*/            float: left;            margin: 15px;        }        .rg_center{            /*border: 1px red solid;*/            float: left;            margin-left: 60px;            margin-top: 40px;        }        .rg_right{            /*border: 1px red solid;*/            float: right;            margin: 10px;        }        .rg_left > p:first-child{            color: #FFD026;            font-size: 18px;        }        .rg_left >p:last-child{            color: #A6A6A6;            font-size: 16px;        }        .rg_right >p:first-child{            font-size: 10px;        }        .rg_right p a {            color: pink;        }        .td_left{            width: 100px;            height: 40px;            text-align: right;        }        .td_right{            padding-left: 20px;        }        #username,#password,#email,#name,#phone,#abirthday,#checkcod   {            width: 180px;            height: 25px;            border: 1px solid #A6A6A6 ;            border-radius: 5px;            padding-left: 10px;        }        #checkcod{            width: 90px;        }        #img_check{            vertical-align: middle;        }        #btn_sub{            width: 100px;            height: 25px;            background-color: #FFD026;            border: solid #FFD026 1px;            margin-left: 40px;            margin-top: 20px;        }    </style></head><body><!--    最外边的-->    <div class="rg_layout">        <!--    最左边的-->        <div class="rg_left">            <p>新增</p>            <p>ADD</p>        </div><!--中间的-->        <div class="rg_center">            <div class="rg_from">                <form method="post" >                    <table >                        <tr>                            <td class="td_left"><label>书名</label> </td>                            <td class="td_right"> <input type="text" name="bookname" id="bookname" placeholder="请输入书名"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>作者</label> </td>                            <td class="td_right"> <input type="text" name="writer" id="writer" placeholder="请输入作者"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>种类</label> </td>                            <td class="td_right"> <input type="text" name="typ" id="typ" placeholder="请输入种类"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>数量</label> </td>                            <td class="td_right"> <input type="text" name="qu" id="qu" placeholder="请输入数量"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>剩余</label> </td>                            <td class="td_right"> <input type="text" name="sur" id="sur" placeholder="请输入剩余"> </td>                        </tr>                        <tr>                            <td colspan="2" align="center"> <input type="submit" id="btn_sub" value="新增" > </td>                        </tr>                    </table>                </form>            </div>        </div>    </div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143

  
addinf.html

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>注册页面</title>    <style>        *{            margin: 0px;            padding: 0px;            box-sizing: border-box;        }        body{            background: url("../demo_html/file/17.jpg" )  no-repeat ;            background-size: 1920px 1200px;        }        .rg_layout{            width: 800px;            height: 500px;            border: 5px solid #EEEEEE;            background-color: #FBFBEF;            margin-left: 100px;            margin-top: 180px;        }        .rg_left{            /*border: 1px red solid;*/            float: left;            margin: 15px;        }        .rg_center{            /*border: 1px red solid;*/            float: left;            margin-left: 60px;            margin-top: 40px;        }        .rg_right{            /*border: 1px red solid;*/            float: right;            margin: 10px;        }        .rg_left > p:first-child{            color: #FFD026;            font-size: 18px;        }        .rg_left >p:last-child{            color: #A6A6A6;            font-size: 16px;        }        .rg_right >p:first-child{            font-size: 10px;        }        .rg_right p a {            color: pink;        }        .td_left{            width: 100px;            height: 40px;            text-align: right;        }        .td_right{            padding-left: 20px;        }        #username,#password,#email,#name,#phone,#abirthday,#checkcod   {            width: 180px;            height: 25px;            border: 1px solid #A6A6A6 ;            border-radius: 5px;            padding-left: 10px;        }        #checkcod{            width: 90px;        }        #img_check{            vertical-align: middle;        }        #btn_sub{            width: 100px;            height: 25px;            background-color: #FFD026;            border: solid #FFD026 1px;            margin-left: 40px;            margin-top: 20px;        }    </style></head><body><!--    最外边的-->    <div class="rg_layout">        <!--    最左边的-->        <div class="rg_left">            <p>新增</p>            <p>ADD</p>        </div><!--中间的-->        <div class="rg_center">            <div class="rg_from">                <form method="post" >                    <table >                        <tr>                            <td class="td_left"><label>学号</label> </td>                            <td class="td_right"> <input type="text" name="num" id="num" placeholder="请输入学号"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>姓名</label> </td>                            <td class="td_right"> <input type="text" name="name" id="name" placeholder="请输入姓名"> </td>                        </tr>                        <tr>                            <td colspan="2" align="center"> <input type="submit" id="btn_sub" value="新增" > </td>                        </tr>                    </table>                </form>            </div>        </div>    </div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132

  
addlent.html

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>注册页面</title>    <style>        *{            margin: 0px;            padding: 0px;            box-sizing: border-box;        }        body{            background: url("../demo_html/file/17.jpg" )  no-repeat ;            background-size: 1920px 1200px;        }        .rg_layout{            width: 800px;            height: 500px;            border: 5px solid #EEEEEE;            background-color: #FBFBEF;            margin-left: 100px;            margin-top: 180px;        }        .rg_left{            /*border: 1px red solid;*/            float: left;            margin: 15px;        }        .rg_center{            /*border: 1px red solid;*/            float: left;            margin-left: 60px;            margin-top: 40px;        }        .rg_right{            /*border: 1px red solid;*/            float: right;            margin: 10px;        }        .rg_left > p:first-child{            color: #FFD026;            font-size: 18px;        }        .rg_left >p:last-child{            color: #A6A6A6;            font-size: 16px;        }        .rg_right >p:first-child{            font-size: 10px;        }        .rg_right p a {            color: pink;        }        .td_left{            width: 100px;            height: 40px;            text-align: right;        }        .td_right{            padding-left: 20px;        }        #username,#password,#email,#name,#phone,#abirthday,#checkcod   {            width: 180px;            height: 25px;            border: 1px solid #A6A6A6 ;            border-radius: 5px;            padding-left: 10px;        }        #checkcod{            width: 90px;        }        #img_check{            vertical-align: middle;        }        #btn_sub{            width: 100px;            height: 25px;            background-color: #FFD026;            border: solid #FFD026 1px;            margin-left: 40px;            margin-top: 20px;        }    </style></head><body><!--    最外边的-->    <div class="rg_layout">        <!--    最左边的-->        <div class="rg_left">            <p>新增</p>            <p>ADD</p>        </div><!--中间的-->        <div class="rg_center">            <div class="rg_from">                <form method="post" >                    <table >                        <tr>                            <td class="td_left"><label>编号</label> </td>                            <td class="td_right"> <input type="text" name="num" id="num" placeholder="请输入编号"> </td>                        </tr>                        <tr>                            <td class="td_left"><label>书名</label> </td>                            <td class="td_right"> <input type="text" name="bookname" id="bookname" placeholder="请输入书名"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>学号</label> </td>                            <td class="td_right"> <input type="text" name="stunum" id="stunum" placeholder="请输入借阅人学号"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>借出时间</label> </td>                            <td class="td_right"> <input type="text" name="lenttime" id="lenttime" placeholder="请输入借时 XXXX-XX-XX"> </td>                        </tr>                        <tr>                            <td class="td_left"> <label>归还时间</label> </td>                            <td class="td_right"> <input type="text" name="returntime" id="returntime" placeholder="请输入还时 XXXX-XX-XX"> </td>                        </tr>                        <tr>                            <td colspan="2" align="center"> <input type="submit" id="btn_sub" value="新增" > </td>                        </tr>                    </table>                </form>            </div>        </div>    </div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144

  
AllBooks(Before login).html

<!--一打开就是这个页面,注册完跳回这个页面,普通用户登录也跳转回这个页面--><!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>图书列表(登录前)</title>    <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.js"></script>    <link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">    <script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script>    <script>alert("请先登录")</script></head><body><!--图书馆管理系统页面--><nav class="navbar navbar-inverse">  <div class="container-fluid">    <!-- Brand and toggle get grouped for better mobile display -->    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">        <span class="sr-only">Toggle navigation</span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>      </button>      <a class="navbar-brand" href="#">资料室图书管理系统</a>    </div>    <!-- Collect the nav links, forms, and other content for toggling -->    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">      <ul class="nav navbar-nav">        <li class="active"><a href="{{ url_for('register.register') }}"> 注册 <span class="sr-only">(current)</span></a></li>      </ul>      <form class="navbar-form navbar-left" method="post">        <div class="form-group">          <input type="text" class="form-control" placeholder="学号" name="password">        </div>        <button type="submit" class="btn btn-default">登录</button>      </form>      <ul class="nav navbar-nav navbar-right">        <li class="dropdown">          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>          <ul class="dropdown-menu">            <li><a href="#">注销</a></li>          </ul>        </li>      </ul>    </div>  </div></nav><div class="container">    <div class="row">        <div class="col-md-2">            <div class="list-group">          <a href="#" class="list-group-item active">            图书列表          </a></div>        </div>        <div class="col-md-10">            <div class="panel panel-primary">              <div class="panel-heading clearfix">                <h3 class="panel-title">图书馆管理系统<span class="glyphicon glyphicon-leaf pull-right"></span></h3>              </div>              <div class="panel-body">                  <form class="form-inline pull-right">                      <div class="form-group">                        <div class="input-group">                          <input type="text" class="form-control" id="exampleInputAmount" placeholder="编号">                        </div>                      </div>                      <button type="submit" class="btn btn-primary">搜索</button>                    </form>                  <table class="table table-hover table-striped table-bordered" style="margin-top: 10px">                      <thead>                          <tr>                              <th>编号</th>                              <th>书名</th>                              <th>作者</th>                              <th>种类</th>                              <th>数量</th>                              <th>剩余</th>                          </tr>                      </thead>                      <tbody>                      {% for book in books %}                          <tr>                          <td>{{ book[0] }}</td>                          <td>{{ book[1] }}</td>                          <td>{{ book[2] }}</td>                          <td>{{ book[3] }}</td>                          <td>{{ book[4] }}</td>                          <td>{{ book[5] }}</td>                      </tr>                      {% endfor %}                      </tbody>                  </table>              </div>                </div>        </div>          </div></div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111

  
AllBooks.html

<!--图书列表(管理员)--><!--管理员登陆后跳到此页面--><!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>图书列表(管理员)</title>    <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.js"></script>    <link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">    <script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script></head><body><!--图书馆管理系统页面--><nav class="navbar navbar-inverse">  <div class="container-fluid">    <!-- Brand and toggle get grouped for better mobile display -->    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">        <span class="sr-only">Toggle navigation</span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>      </button>      <a class="navbar-brand" href="#">资料室图书管理系统</a>    </div>    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">      <ul class="nav navbar-nav">        <li class="active"><a href="{{ url_for('register.register') }}"> 注册 <span class="sr-only">(current)</span></a></li>      </ul>      <form class="navbar-form navbar-left">        <div class="form-group">          <input type="text" class="form-control" placeholder="学号">        </div>        <button type="submit" class="btn btn-default">登录</button>      </form>      <ul class="nav navbar-nav navbar-right"><!--        <li><a href="#">godlover</a></li>-->        <li class="dropdown">          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>          <ul class="dropdown-menu">            <li><a href="{{ url_for('user.index') }}">注销</a></li>          </ul>        </li>      </ul>    </div>  </div></nav><div class="container">    <div class="row">        <div class="col-md-2">            <div class="list-group">          <a href="#" class="list-group-item active">            图书列表          </a>          <a href="{{url_for('BooksOfLent.lent')}}" class="list-group-item">已借出的书</a>          <a href="{{url_for('BorrowerInformation.borrower')}}" class="list-group-item">借阅人信息</a></div>        </div>        <div class="col-md-10">            <div class="panel panel-primary">              <div class="panel-heading clearfix">                <h3 class="panel-title">图书馆管理系统<span class="glyphicon glyphicon-leaf pull-right"></span></h3>              </div>              <div class="panel-body">                <a href="{{ url_for('AllBooks.add') }}" class="btn btn-success">新增</a>                  <form class="form-inline pull-right" method="GET" action="{{ url_for('AllBooks.search') }}">                      <div class="form-group">                        <div class="input-group">                          <input type="text" class="form-control" name="search" id="search" placeholder="编号">                        </div>                      </div>                      <button type="submit" class="btn btn-primary">搜索</button>                    </form>                  <table class="table table-hover table-striped table-bordered" style="margin-top: 10px">                      <thead>                          <tr>                              <th>编号</th>                              <th>书名</th>                              <th>作者</th>                              <th>种类</th>                              <th>数量</th>                              <th>剩余</th>                              <th class="text-center">操作</th>                          </tr>                      </thead>                      <tbody>                      {% for book in books %}                          <form method="POST">                              <tr>                              <td>{{ book[0] }}</td>                              <td>{{ book[1] }}</td>                              <td>{{ book[2] }}</td>                              <td>{{ book[3] }}</td>                              <td>{{ book[4] }}</td>                              <td>{{ book[5] }}</td>                              <td class="text-center">{#                                  <a class="btn btn-primary btn-sm">编辑</a>#}                                  <a class="btn btn-danger btn-sm" href="{{ url_for('AllBooks.delete',uid=book[0]) }}">删除</a>                              </td>                          </tr>                          </form>                      {% endfor %}                      </tbody>                  </table>              </div>                </div>        </div>          </div></div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123

  
Books Of Lent.html

<!--已借出的书--><!--管理员登录才能查看--><!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>已借出的书</title>    <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.js"></script>    <link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">    <script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script></head><body><!--图书馆管理系统页面--><nav class="navbar navbar-inverse">  <div class="container-fluid">    <!-- Brand and toggle get grouped for better mobile display -->    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">        <span class="sr-only">Toggle navigation</span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>      </button>      <a class="navbar-brand" href="#">资料室图书管理系统</a>    </div>    <!-- Collect the nav links, forms, and other content for toggling -->    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">      <ul class="nav navbar-nav">        <li class="active"><a href="{{ url_for('register.register') }}"> 注册 <span class="sr-only">(current)</span></a></li>      </ul>      <form class="navbar-form navbar-left">        <div class="form-group">          <input type="text" class="form-control" placeholder="学号">        </div>        <button type="submit" class="btn btn-default">登录</button>      </form>      <ul class="nav navbar-nav navbar-right">        <li class="dropdown">          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>          <ul class="dropdown-menu">            <li><a href="{{ url_for('user.index') }}">注销</a></li>          </ul>        </li>      </ul>    </div>  </div></nav><div class="container">    <div class="row">        <div class="col-md-2">            <div class="list-group">                <a href="{{ url_for('AllBooks.AllBooks') }}" class="list-group-item">图书列表</a>          <a href="#" class="list-group-item active">            已借出的书          </a>          <a href="{{url_for('BorrowerInformation.borrower')}}" class="list-group-item">借阅人信息</a></div>        </div>        <div class="col-md-10">            <div class="panel panel-primary">              <div class="panel-heading clearfix">                <h3 class="panel-title">图书馆管理系统<span class="glyphicon glyphicon-leaf pull-right"></span></h3>              </div>              <div class="panel-body">                  <a href="{{ url_for('BooksOfLent.add') }}" class="btn btn-success">新增</a>                  <form class="form-inline pull-right" method="GET" action="{{ url_for('BooksOfLent.search') }}">                      <div class="form-group">                        <div class="input-group">                          <input type="text" class="form-control" name="search" id="search" placeholder="编号">                        </div>                      </div>                      <button type="submit" class="btn btn-primary">搜索</button>                    </form>                  <table class="table table-hover table-striped table-bordered" style="margin-top: 10px">                      <thead>                          <tr>                              <th>编号</th>                              <th>书名</th>                              <th>借阅人学号</th>                              <th>借出时间</th>                              <th>归还时间</th>                              <th>操作</th>                          </tr>                      </thead>                      <tbody>                      {% for book in books %}                          <form method="POST">                            <tr>                                <td>{{ book[0] }}</td>                                <td>{{ book[1] }}</td>                                <td>{{ book[2] }}</td>                                <td>{{ book[3] }}</td>                                <td>{{ book[4] }}</td>                                <td class="text-center">                                    <a class="btn btn-danger btn-sm" href="{{ url_for('BooksOfLent.delete',uid=book[0]) }}">删除</a>                                </td>                            </tr>                          </form>                      {% endfor %}                      </tbody>                  </table>              </div>                </div>        </div>          </div></div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119

  
borrower.html

<!--一打开就是这个页面,注册完跳回这个页面,普通用户登录也跳转回这个页面--><!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>图书列表(普通用户)</title>    <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.js"></script>    <link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">    <script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script></head><body><!--图书馆管理系统页面--><nav class="navbar navbar-inverse">  <div class="container-fluid">    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">        <span class="sr-only">Toggle navigation</span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>      </button>      <a class="navbar-brand" href="#">资料室图书管理系统</a>    </div>    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">      <ul class="nav navbar-nav">        <li class="active"><a href="{{ url_for('register.register') }}"> 注册 <span class="sr-only">(current)</span></a></li>      </ul>      <form class="navbar-form navbar-left">        <div class="form-group">          <input type="text" class="form-control" placeholder="学号">        </div>        <button type="submit" class="btn btn-default">登录</button>      </form>      <ul class="nav navbar-nav navbar-right">        <li class="dropdown">          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>          <ul class="dropdown-menu">            <li><a href="{{ url_for('user.index') }}">注销</a></li>          </ul>        </li>      </ul>    </div>  </div></nav><div class="container">    <div class="row">        <div class="col-md-2">            <div class="list-group">          <a href="#" class="list-group-item active">            图书列表          </a></div>        </div>        <div class="col-md-10">            <div class="panel panel-primary">              <div class="panel-heading clearfix">                <h3 class="panel-title">图书馆管理系统<span class="glyphicon glyphicon-leaf pull-right"></span></h3>              </div>              <div class="panel-body">                  <table class="table table-hover table-striped table-bordered" style="margin-top: 10px">                      <thead>                          <tr>                              <th>编号</th>                              <th>书名</th>                              <th>作者</th>                              <th>种类</th>                              <th>数量</th>                              <th>剩余</th>                          </tr>                      </thead>                      <tbody>                      {% for book in books %}                          <tr>                          <td>{{ book[0] }}</td>                          <td>{{ book[1] }}</td>                          <td>{{ book[2] }}</td>                          <td>{{ book[3] }}</td>                          <td>{{ book[4] }}</td>                          <td>{{ book[5] }}</td>                      </tr>                      {% endfor %}                      </tbody>                  </table>              </div>                </div>        </div>          </div></div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99

  
Borrower Information.html

<!--借阅人信息--><!--管理员登录才能查看--><!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>借阅人信息</title>    <script src="https://cdn.bootcss.com/jquery/3.4.1/jquery.js"></script>    <link href="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet">    <script src="https://cdn.bootcss.com/twitter-bootstrap/3.4.1/js/bootstrap.min.js"></script></head><body><!--图书馆管理系统页面--><nav class="navbar navbar-inverse">  <div class="container-fluid">    <div class="navbar-header">      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">        <span class="sr-only">Toggle navigation</span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>        <span class="icon-bar"></span>      </button>      <a class="navbar-brand" href="#">资料室图书管理系统</a>    </div>    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">      <ul class="nav navbar-nav">        <li class="active"><a href="{{ url_for('register.register') }}"> 注册 <span class="sr-only">(current)</span></a></li>      </ul>      <form class="navbar-form navbar-left">        <div class="form-group">          <input type="text" class="form-control" placeholder="学号">        </div>        <button type="submit" class="btn btn-default">登录</button>      </form>      <ul class="nav navbar-nav navbar-right">        <li class="dropdown">          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">更多操作 <span class="caret"></span></a>          <ul class="dropdown-menu">            <li><a href="{{ url_for('user.index') }}">注销</a></li>          </ul>        </li>      </ul>    </div><!-- /.navbar-collapse -->  </div><!-- /.container-fluid --></nav><div class="container">    <div class="row">        <div class="col-md-2">            <div class="list-group">                <a href="{{ url_for('AllBooks.AllBooks') }}" class="list-group-item">图书列表</a>          <a href="{{url_for('BooksOfLent.lent')}}" class="list-group-item">已借出的书</a>          <a href="#" class="list-group-item active">            借阅人信息          </a></div>        </div>        <div class="col-md-10">            <div class="panel panel-primary">              <div class="panel-heading clearfix">                <h3 class="panel-title">图书馆管理系统<span class="glyphicon glyphicon-leaf pull-right"></span></h3>              </div>              <div class="panel-body">                <a href="{{ url_for('BorrowerInformation.add') }}" class="btn btn-success">新增</a>                      <form class="form-inline pull-right" method="GET" action="{{ url_for('BorrowerInformation.search') }}">                          <div class="form-group">                            <div class="input-group">                              <input type="text" class="form-control" name="search" id="search" placeholder="学号">                            </div>                          </div>                          <button type="submit" class="btn btn-primary">搜索</button>                      </form>                  <table class="table table-hover table-striped table-bordered" style="margin-top: 10px">                      <thead>                          <tr>                              <th>学号</th>                              <th>姓名</th>                              <th class="text-center">操作</th>                          </tr>                      </thead>                      <tbody>                      {% for i in inf %}                      <tr>                          <td>{{ i[0] }}</td>                          <td>{{ i[1] }}</td>                          <td class="text-center">                              <a class="btn btn-danger btn-sm" href="{{ url_for('BorrowerInformation.delete',uid=i[0]) }}">删除</a>                          </td>                      </tr>                      {% endfor %}                      </tbody>                  </table>              </div>                </div>        </div>          </div></div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110

  
register.html

<!DOCTYPE html><html lang="en"><head>    <meta charset="UTF-8">    <title>注册页面</title>    <style>        *{            margin: 0px;            padding: 0px;            box-sizing: border-box;        }        body{            background: url("../demo_html/file/17.jpg" )  no-repeat ;            background-size: 1920px 1200px;        }        .rg_layout{            width: 800px;            height: 500px;            border: 5px solid #EEEEEE;            background-color: #FBFBEF;            margin-left: 100px;            margin-top: 180px;        }        .rg_left{            /*border: 1px red solid;*/            float: left;            margin: 15px;        }        .rg_center{            /*border: 1px red solid;*/            float: left;            margin-left: 60px;            margin-top: 40px;        }        .rg_right{            /*border: 1px red solid;*/            float: right;            margin: 10px;        }        .rg_left > p:first-child{            color: #FFD026;            font-size: 18px;        }        .rg_left >p:last-child{            color: #A6A6A6;            font-size: 16px;        }        .rg_right >p:first-child{            font-size: 10px;        }        .rg_right p a {            color: pink;        }        .td_left{            width: 100px;            height: 40px;            text-align: right;        }        .td_right{            padding-left: 20px;        }        #username,#password,#email,#name,#phone,#abirthday,#checkcod   {            width: 180px;            height: 25px;            border: 1px solid #A6A6A6 ;            border-radius: 5px;            padding-left: 10px;        }        #checkcod{            width: 90px;        }        #img_check{            vertical-align: middle;        }        #btn_sub{            width: 100px;            height: 25px;            background-color: #FFD026;            border: solid #FFD026 1px;            margin-left: 40px;            margin-top: 20px;        }    </style></head><body><!--    最外边的-->    <div class="rg_layout">        <!--    最左边的-->        <div class="rg_left">            <p >新用户注册</p>            <p>USER REGISIER</p>        </div><!--中间的-->        <div class="rg_center">            <div class="rg_from">                <form method="post">                    <table >                        <tr>                            <td class="td_left"> <label>学号</label> </td>                            <td class="td_right"> <input type="password" name="password" id="password" placeholder="请输入学号"> </td>                        </tr>                        <tr>                            <td class="td_left"><label>姓名</label> </td>                            <td class="td_right"> <input type="text" name="username" id="username" placeholder="请输入姓名"> </td>                        </tr>                        <tr>                            <td colspan="2" align="center"> <input type="submit" id="btn_sub" value="注册" > </td>                        </tr>                    </table>                </form>            </div>        </div>    </div></body></html>
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130

其实该用模板继承呢,会大大减少重复代码量。我弄的这太冗余了!
  
  
app.py

from flask import Flaskfrom blueprints.user import bp as user_bpfrom blueprints.register import bp as register_bpfrom blueprints.AllBooks import bp as AllBooks_bpfrom blueprints.BooksOfLent import bp as BooksOfLent_bpfrom blueprints.BorrowerInformation import bp as BorrowerInformation_bpfrom blueprints.borrower import bp as borrower_bpapp = Flask(__name__)app.register_blueprint(user_bp)app.register_blueprint(register_bp)app.register_blueprint(AllBooks_bp)app.register_blueprint(BooksOfLent_bp)app.register_blueprint(BorrowerInformation_bp)app.register_blueprint(borrower_bp)if __name__ == '__main__':    app.run()
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19

  
  
  

总结

  
这是我学了一个月时间做出来的小项目,功能很少,长得很丑,算是个半成品,跟各位大佬的肯定比不了,大家也就将就着看看,未来要是有时间还是会翻出来优化它的。

我之前学的很浅,只会用语言完成学校布置的一些简单题目而已,并不会用语言做其他东西。
机缘巧合之下,铁甲小宝大佬带我走进编程的世界,引领我学习。没有他,我现在还是个天天傻玩的憨批。

这个项目是我的第一个编程项目,算是正式入门了,今后我会更加努力学习的!!!

最后,再次感谢铁甲小宝大佬,祝大佬如愿以偿进大厂!!!

  
          

网站建设定制开发 软件系统开发定制 定制软件开发 软件开发定制 定制app开发 app开发定制 app开发定制公司 电商商城定制开发 定制小程序开发 定制开发小程序 客户管理系统开发定制 定制网站 定制开发 crm开发定制 开发公司 小程序开发定制 定制软件 收款定制开发 企业网站定制开发 定制化开发 android系统定制开发 定制小程序开发费用 定制设计 专注app软件定制开发 软件开发定制定制 知名网站建设定制 软件定制开发供应商 应用系统定制开发 软件系统定制开发 企业管理系统定制开发 系统定制开发