<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>首页 {% block logintitle %}{% endblock %} {% block registertitle %}{% endblock %} </title> <nav style="background-color: white"> <ul class="nav nav-tabs"> <li><a href="{{ url_for('lx') }}">首页</a></li> {% if username %} <li><a href="#">{{ username }}</a></li> <li><a href="{{ url_for('logout')}}">注销</a></li> {% else %} <li><a href="{{ url_for('login') }}">登录</a></li> <li><a href="{{ url_for('regist') }}">注册</a></li> {% endif %} <li><a href="{{ url_for('fabu') }}">发布</a></li> <li><input type="text" class="form-control" style=" 200px"></li> <button type="button" class="btn btn-default">搜索</button> </ul> </nav> {% block loginhead %}{% endblock %} {% block registerhead %}{% endblock %} </head> <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> <link type="text/css" rel="stylesheet" href="{{ url_for('static',filename='css/webb.css') }}"> <body class="body"> <h1 align="center">欢迎进入我的网站</h1> {% block body %} <div class="container"> <div class="row clearfix"> <div class="col-md-2 column"> </div> <div class="col-md-8 column"> {% for foo in question %} <div class="list-group"> <a href="" class="list-group-item active">作者：{{ foo.author_id}}</a> <div class="list-group-item"> <a href="{{ url_for('detail',question_id=foo.id)}}" class="list-group-item-heading"> {{ foo.title}} </a> <p class="list-group-item-text"> {{foo.detail}} </p> </div> <div class="list-group-item"> <span class="badge">发布时间:{{foo.creat_time}}</span> 发布时间 </div> </div> {% endfor %} <div class="col-md-2 column"> </div> </div> </div> {% endblock %} <footer class="foot"> <div><a href="#"> 联系我们</a> · <a href="#"> 加入我们</a> · <a href="#"> 品牌与徽标 </a> · <a href="#">帮助中心</a> · <a href="#">合作伙伴</a> </div> <div>©2015-2017 广州商学院信息技术与工程学院 / 粤ICP备278953737号-5 / 粤公网安备2015060050046号 / Smrz 粤公网安备201506050046号 / Wxb 举报电话：020-15533935928 </div> </footer> </body> </html>
{% extends 'lx3.html' %} {% block registertitle %} 内容{% endblock %} {% block registerhead %} <script type="text/javascript" src="../static/js/js.js"></script>{% endblock %} <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" type="text/css" href="../static/css/webb.css"> <base href="www.gzcc.cn" target="_blank"> <body id="myBody"> {% block body %} <div class="panel panel-default"> <ul><li>作者：{{ quest.author_id}}</li><li>time:{{ quest.creat_time}}</li></ul> <div class="panel-heading"> <h3 class="panel-title"> {{ quest.title}} </h3> </div> <div class="panel-body"> {{ quest.detail}} </div> </div> <div> <form action="{{ url_for('')}}"method="post"> <textarea name="detail" id="detail" cols="30" rows="10"></textarea> <button type="submit">发布</button> </form> </div> </body> {% endblock %} </html>
class Comment(db.Model): __tablename__ = 'comment' id = db.Column(db.Integer, primary_key=True, autoincrement=True) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) question_id = db.Column(db.Integer, db.ForeignKey('question.id')) creat_time = db.Column(db.DateTime, default=datetime.now) detail = db.Column(db.Text, nullable=False) question = db.relationship('Ques', backref=db.backref('comment')) author = db.relationship('User', backref=db.backref('comment')) db.create_all() @app.route('/detail/<question_id>', methods=['GET', 'POST']) def detail(question_id): quest = Ques.query.filter(Ques.id == question_id).first() return render_template('detail.html', quest=quest)
