Flask实现简单搜索功能

矫情吗；* 2023-01-19 14:54 218阅读 0赞

Flask实现简单搜索功能

主要功能是通过form的方式传值，再到数据库中查询。下面是数据库的内容我们这里主要是实现对content进行模糊匹配。

![20210510232216640.png][]

首先打开pycharm，构建一个最简单的flask应用。

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #search.py from flask import Flask app = Flask(__name__) @app.route("/") def index(): &nbsp;&nbsp;&nbsp; return render_template('search.html') if __name__ =="__main__": &nbsp;&nbsp;&nbsp; app.run() </td> 
 </tr> 
 </tbody> 
</table>

既然要搜索，必要要连接数据库，要引入SQLAlchemy这个包。

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #search.py from flask_sqlalchemy import SQLAlchemy &nbsp; app.config['SQLALCHEMY_DATABASE_URI']='mysql+pymysql://root:123456@127.0.0.1:3306/test?charset=utf8' app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True #root用户名123456密码 test数据库 </td> 
 </tr> 
 </tbody> 
</table>

最后我们需要从form表单拿到我们想要的数据。然后进行数据库查询操作

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> @app.route('/', methods=['post', 'get']) def search(): &nbsp;&nbsp;&nbsp; content = request.form.get('content') #需要查询的内容 &nbsp;&nbsp;&nbsp; if content is None: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; content = " " &nbsp;&nbsp;&nbsp; quotes = Quotes.query.filter(Quotes.content.like("%"+content+"%")if content is not None else "").all() #查询跟content有关的数据，返回结果为列表 &nbsp;&nbsp;&nbsp; return render_template('search.html',quotes = quotes) #将查询结果返回到前端 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #search,html &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt; &nbsp;&nbsp;&nbsp; &lt;meta charset="UTF-8"&gt; &nbsp;&nbsp;&nbsp; &lt;title&gt;Title&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;form method="post" action="{ {url_for('search')}}"&gt; &nbsp;&nbsp;&nbsp; &lt;input type="text" name="content" id="content" placeholder="请输入搜索内容"&gt; &nbsp;&nbsp;&nbsp; &lt;input type="submit" value="搜索"&gt; &lt;/form&gt; &lt;div&gt; &nbsp;&nbsp;&nbsp; &lt;table border="1px" cellspacing="0px"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {% for i in quotes %} &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;名字&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;{ {i.name}}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;内容&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;{ {i.content}}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {% endfor %} &nbsp;&nbsp;&nbsp; &lt;/table&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; </td> 
 </tr> 
 </tbody> 
</table>

效果如下：

![20210510232228533.png][]

![20210510232233286.png][]

一个简单的查询功能就完成了，这里只是做了单条件模糊查询。接下来介绍多条件模糊查询和精确查询

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #多条件模糊查询 content = Quotes.query.filter( &nbsp;&nbsp;&nbsp;&nbsp; Quotes.id.like("%" + id + "%") if id is not None else "", &nbsp;&nbsp;&nbsp;&nbsp; Quotes.name.like("%" + name + "%") if name is not None else "", &nbsp;&nbsp;&nbsp;&nbsp; Quotes.content.like("%" + content + "%") if content is not None else "" &nbsp;).all() </td> 
 </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #单条件精确查询 content = Quotes.query.filter_by(id=id).all() </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #多条件精确查询 content = Quotes.query.filter_by(id=id,name=name).all() </td> 
 </tr> 
 </tbody> 
</table>

最后附上完整代码

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #search.py from flask import Flask, config, render_template, request, flash, url_for, session from flask_sqlalchemy import SQLAlchemy &nbsp; &nbsp; app = Flask(__name__) &nbsp; app.config.from_object(config) &nbsp; app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:1914571065lyj@127.0.0.1:3306/java2019?charset=utf8' app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True &nbsp; db = SQLAlchemy(app) &nbsp; &nbsp; class Quotes(db.Model): &nbsp;&nbsp;&nbsp; id = db.Column(db.Integer, primary_key=True, comment='ID') &nbsp;&nbsp;&nbsp; name = db.Column(db.String(255), unique=True, comment='名称') &nbsp;&nbsp;&nbsp; content = db.Column(db.String(255), comment='内容') &nbsp; &nbsp; @app.route('/', methods=['post', 'get']) def search(): &nbsp;&nbsp;&nbsp; content = request.form.get('content') &nbsp;&nbsp;&nbsp; if content is None: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; content = " " &nbsp;&nbsp;&nbsp; quotes = Quotes.query.filter(Quotes.content.like("%"+content+"%")if content is not None else "").all() &nbsp;&nbsp;&nbsp; return render_template('search.html',quotes = quotes) &nbsp; &nbsp; if __name__ == "__main__": &nbsp;&nbsp;&nbsp; app.run(debug=True) </td> 
 </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:424.7pt;"> #search.py &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt; &nbsp;&nbsp;&nbsp; &lt;meta charset="UTF-8"&gt; &nbsp;&nbsp;&nbsp; &lt;title&gt;Title&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;form method="post" action="{ {url_for('search')}}"&gt; &nbsp;&nbsp;&nbsp; &lt;input type="text" name="content" id="content" placeholder="请输入搜索内容"&gt; &nbsp;&nbsp;&nbsp; &lt;input type="submit" value="搜索"&gt; &lt;/form&gt; &lt;div&gt; &nbsp;&nbsp;&nbsp; &lt;table border="1px" cellspacing="0px"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {% for i in quotes %} &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;名字&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;{ {i.name}}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;内容&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;{ {i.content}}&lt;/td&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {% endfor %} &nbsp;&nbsp;&nbsp; &lt;/table&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; </td> 
 </tr> 
 </tbody> 
</table>

[20210510232216640.png]: /images/20221021/69e31abde18a4b91a9482d31d8a98b7c.png
[20210510232228533.png]: /images/20221021/9c7e80391f7c409c8ffa8449908b3558.png
[20210510232233286.png]: /images/20221021/7ca701a5a12442d7a1f5413d680c2612.png