python+flask+mysql 用网页展示数据库内容

最新推荐文章于 2023-07-19 16:32:55 发布

忌颓废

最新推荐文章于 2023-07-19 16:32:55 发布

阅读量1.1w

点赞数 21

分类专栏： python 数据可视化文章标签：数据库 mysql flask python

本文链接：https://blog.csdn.net/weixin_44947339/article/details/104305365

版权

python 同时被 2 个专栏收录

15 篇文章 6 订阅

订阅专栏

数据可视化

12 篇文章 3 订阅

订阅专栏

阅读目录

利用flask框架，把数据库的内容用网页展示出来，并可以用关键词进行搜索操作。

一、项目目录

在这里插入图片描述
数据库的内容

二、Flask.py

from flask import Flask,request
from flask import render_template
from mysql import Mysql

app = Flask(__name__)

@app.route('/index')
def name():
    page = request.args.get('page')
    if not page or int(page) == 0:
        page = 1
    db = Mysql()
    keyword = request.args.get('keyword')
    items = db.getItems(page, keyword)
    page_range = range(int(page) - 3, int(page) + 2)
    if int(page) < 4:
        page_range = range(1, int(page) + 4)
    return render_template('index.html', items=items,page=int(page),prange = page_range)

if __name__ == '__main__':
    app.run(app.run(debug=True,port=5222,host='127.0.0.1'))

三、mysql.py

import pymysql

class Mysql(object):
    def __init__(self):
        try:
            self.conn = pymysql.connect(host='localhost',user='root',password='fxl395126',database='nba',charset="utf8")
            self.cursor = self.conn.cursor()  # 游标对象
            print("连接数据库成功")
        except:
            print("连接失败")

    def getItems(self,page,keyword=None):
        sql = "select * from news"
        if keyword:
            sql = sql + " where title like '%" + keyword + "%'"
        start = (int(page) - 1) * 10
        sql = sql + " limit " + str(start) + ",13"
        self.cursor.execute(sql)
        items = self.cursor.fetchall()
        return items

四、index.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <script src="/static/jquery-2.1.4.min.js"></script>
    <link rel="stylesheet" href="/static/bootstrap-3.3.7-dist/css/bootstrap.min.css">
    <script src="/static/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
    <style>
        .container{
            width: 80%;
        }
    </style>
</head>
<body>
    <div class="container">
{#        标题#}
        <h2>篮球新闻</h2>
{#         图片#}
         <div class="col-md-4">
             <img src="../static/basketball.jpg" style="height :700px;width:300px;"/>
         </div>
        <div class="col-md-8">
{#        搜索关键词#}
            <div class="row search">
                <div class="col-lg-6">
                    <div class="input-group">
                        <form action="/index">
                            <div class="col-lg-9">
                              <input type="text" class="form-control" name="keyword" placeholder="关键词">
                            </div>
                             <div class="col-lg-3">
                              <span class="input-group-btn">
                                <input class="btn btn-default" type="submit"/>
                              </span></div>
                        </form>
                    </div>
                </div>
            </div>
{#        新闻列表#}
            <table class="table mytable-striped">
                <thead>
                <tr>
                    <th>序号</th>
                    <th>标题</th>
                </tr>
                </thead>
                <tbody>
                    {% for item in items %}
                        <tr>
                            <td>{{ item[0]}}</td>
                            <td>{{ item[1]}}</td>

                        </tr>
                    {% endfor %}
                </tbody>
                </table>
            </div>
{#            页数#}
            <nav aria-label="Page navigation">
                <ul class="pagination">
                    <li>
                        <a href="/index?page={{ page - 1 }}" aria-label="Previous">
                        <span aria-hidden="true">&laquo;</span>
                        </a>
                    </li>
                       {% for pg in prange %}
                         <li><a href="/index?page={{ pg }}">{{ pg }}</a></li>
                         {% endfor %}
                    <li>
                        <a href="/index?page={{ page + 1}}" aria-label="Next">
                            <span aria-hidden="true">&raquo;</span>
                        </a>
                    </li>
                </ul>
            </nav>
    </div>
</body>
</html>