这个类似与Java的MyBatis。
这样的话开发就快速很多了!
程序运行截图如下:
程序结构如下:
源码如下:
account.py
from application import db
class Account(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(50))
password = db.Column(db.String(50))
index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<p>Flask 查询数据库</p>
<p>
{% for item in result %}
{{item['id']}} {{item['name']}} {{item['password']}}
{% endfor %}
</p>
</body>
</html>
application.py
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql://root:XXXXXXXXX@122.XXX.XXX.XXX/mytest"
db = SQLAlchemy(app)
controller.py
from flask import Flask,Blueprint,request,make_response,jsonify,render_template
from sqlalchemy import text
from application import db
from common.models.account import Account
index_page = Blueprint("index_page", __name__)
@index_page.route("/sql")
def sqlQuery():
context = {}
result = Account.query.all()
context["result"] = result
return render_template("index.html", **context)
manager.py
from application import app
from www import *
if __name__ == "__main__":
app.run(host = "0.0.0.0", debug = "True")
www.py
from application import app
from controller import index_page
app.register_blueprint(index_page, url_prefix = "/it1995")