py文件
from flask import Flask,render_template,request,redirect
from flask_sqlalchemy import SQLAlchemy
import config
app = Flask(__name__)
app.config.from_object(config)
db=SQLAlchemy(app)
class student(db.Model):
__tablename__ = "student"
id = db.Column(db.Integer,primary_key = True)
name = db.Column(db.String(300))
qq = db.relationship("book",backref = "s")
class book(db.Model):
__tablename__ = ‘book‘
id = db.Column(db.Integer,primary_key=True,nullable=True)
name = db.Column(db.String(100),nullable=True)
author = db.Column(db.String(200),nullable=True)
publish = db.Column(db.String(20),nullable=True)
price = db.Column(db.String(20),nullable=True)
types = db.Column(db.String(100),nullable=True)
pages = db.Column(db.Integer, nullable=True)
s_id = db.Column(db.Integer,db.ForeignKey(student.id))
@app.route(‘/‘)
def login():
return render_template(‘login.html‘)
@app.route("/index/")
def index():
s_all = student.query.all()
return render_template("index.html",s_all = s_all)
if __name__ == ‘__main__‘:
db.drop_all()
db.create_all()
s1 = student(name = "李晓冰")
s2 = student(name = "程熙")
s3 = student(name = "车雨波")
db.session.add_all([s1,s2,s3])
db.session.commit()
b1 = book(name = ‘互联网思维‘,author = ‘赵大伟‘,publish = ‘2014-03-20‘,price = ‘49‘,types = ‘it‘,pages= 280,s_id = s1.id)
b2 = book(name = ‘互联网:从it到dt‘, author=‘阿里研究院‘, publish=‘2015-05-30‘, price=‘59‘, types=‘it‘, pages=285,s_id = s2.id)
b3 = book(name = ‘道德经‘, author=‘老子‘, publish=‘1955-01-14‘, price=‘88‘, types=‘国学‘, pages=81,s_id = s3.id)
db.session.add_all([b1,b2,b3])
db.session.commit()
app.run(debug=True)
html:
<form action="">
<table border="1px">
{% for s in s_all %}
{% for b in s.qq %}
<tr>
<td>{{s.name}}</td>
<td>{{b.name}}</td>
<td>{{b.author}}</td>
</tr>
{% endfor %}
{% endfor %}
</table>
</form>
<span><a href="{{ url_for(‘index‘) }}"><b>图书商场管理系统</b></a></span>
relationship使用方法 通过book表查找student表所有数据
原文：https://www.cnblogs.com/aixiaodeluotuo/p/14048518.html
