一个好家园后台信息管理

app.py

import pymysql
from Mysql import mysql
from flask import Flask,render_template,request,redirect
import pandas as pd

app=Flask(__name__)
global rows
db=mysql()

@app.route("/")
def index():
    global rows
    db=mysql(db="housedb")
    sql="select * from housetypes a,houses b where a.housetypeid=b.housetypeid order by houseid"
    db.cursor.execute(sql)
    rows=db.cursor.fetchall()
    return render_template("index.html",rows=rows)

@app.route("/addHouse",methods=["GET","POST"])
def addHouse():
    if request.method=="GET":
        sql="select * from housetypes"
        db.cursor.execute(sql)
        rowTypes=db.cursor.fetchall()
        return render_template("addHouse.html",rowTypes=rowTypes)
    else:
        housetypeid=request.form.get("selType")
        area=request.form.get("txtArea")
        price=request.form.get("txtPrice")
        adress=request.form.get("txtAddress")
        desc=request.form.get("txtDesc")
        sql="insert into houses values(null,%s,%s,%s,'%s','%s')"%(housetypeid,area,price,adress,desc)
        print(sql)
        db.cursor.execute(sql)
        db.conn.commit()
        return redirect("/")
@app.route("/huizong")
def huizong():
    sql = "select * from housetypes a,houses b where a.housetypeid=b.housetypeid"
    db.cursor.execute(sql)
    rows = db.cursor.fetchall()
    df=pd.DataFrame(rows)
    df1=df.groupby("HouseTypeName").count()["HouseID"].sort_values(ascending=False)
    return render_template("addecharts.html",x=list(df1.index),y=list(df1.values))
if __name__ == '__main__':
    app.run(debug=True)

Mysql.py

import pymysql

class mysql():
    def __init__(self,db="housedb"):
        self.conn=pymysql.connect(host="127.0.0.1",db=db,user="root",passwd="123456")
        self.cursor=self.conn.cursor(pymysql.cursors.DictCursor)

    def query(self,sql,args=None):
        num=self.cursor.execute(sql,args=args)
        self.conn.commit()
        if num:
            return True
        else:
            return False

    def close(self):
        self.conn.close()

templates/addecharts.html

{% extends "base.html" %}
{% block content %}
 
  
    
{% endblock %}

addHouse.html

{% extends "base.html" %}
{% block content %}

  
    房型
    
        
            {% for row in rowTypes %}
            {{ row["HouseTypeName"] }}
            {% endfor %}
        
    
  
  
    面积
    
      
    
  
  
    价格
    
      
    
  
 
    地址
    
      
    
  
 
    描述
    
      
    
  
  
    
      发布
    
  

    
{% endblock %}

base.html

    
    
    
        







    




    好家园房产中介网后台管理

    
        查看住房信息 | 发布住房信息| 汇总住房信息
        

    


    {% block content %}
    {% endblock %}

index.html

{% extends "base.html" %}
{% block content %}



{% for row in rows %}

{% endfor %}

  

  

      
编号
      
房型
      
面积（平方米）
      
价格（万）
      
地址
      
描述
  
  

  
{{ row["HouseID"] }}
  
{{ row["HouseTypeName"] }}
  
{{ row["Area"] }}
  
{{ row["Price"] }}
  
{{ row["Adress"] }}
  
{{ row["HouseDesc"] }}

{% endblock %}