将项目列表添加到SQLite3烧瓶中,可以按照以下步骤进行操作:
pip install flask
。from flask import Flask, render_template, request
import sqlite3
conn = sqlite3.connect('database.db')
conn.execute('CREATE TABLE IF NOT EXISTS projects (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)')
@app.route('/add_project', methods=['POST'])
def add_project():
project_name = request.form['name']
conn.execute('INSERT INTO projects (name) VALUES (?)', (project_name,))
conn.commit()
return 'Project added successfully'
@app.route('/projects')
def projects():
cursor = conn.execute('SELECT * FROM projects')
project_list = cursor.fetchall()
return render_template('projects.html', projects=project_list)
<!DOCTYPE html>
<html>
<head>
<title>Project List</title>
</head>
<body>
<h1>Project List</h1>
<ul>
{% for project in projects %}
<li>{{ project[1] }}</li>
{% endfor %}
</ul>
</body>
</html>
@app.route('/')
def index():
return redirect('/projects')
if __name__ == '__main__':
app.run(debug=True)
现在,当访问应用程序的根URL时,将重定向到项目列表页面。可以通过发送POST请求到/add_project
路由来添加新的项目。项目列表将存储在SQLite3数据库中,并在项目列表页面中显示出来。
请注意,以上代码示例仅为演示目的,实际应用中可能需要进行更多的错误处理和安全性措施。
领取专属 10元无门槛券
手把手带您无忧上云