基于Python+Flask实现宿舍管理系统

作者主页:编程千纸鹤

作者简介:Java领域优质创作者、CSDN博客专家 、CSDN内容合伙人、掘金特邀作者、阿里云博客专家、51CTO特邀作者、多年架构师设计经验、多年校企合作经验,被多个学校常年聘为校外企业导师,指导学生毕业设计并参与学生毕业答辩指导,有较为丰富的相关经验。期待与各位高校教师、企业讲师以及同行交流合作

主要内容:Java项目、Python项目、前端项目、PHP、ASP.NET、人工智能与大数据、单片机开发、物联网设计与开发设计、简历模板、学习资料、面试题库、技术互助、就业指导等

业务范围:免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等

收藏点赞不迷路  关注作者有好处

文末获取源码 

项目编号:BS-Python-048

一,环境介绍

语言环境:Python3.8

数据库:Mysql: mysql5.7

WEB框架:Django

开发工具:IDEA或PyCharm

二,项目简介

基于Python和Flask实现的宿舍管理系统是一个旨在提升宿舍管理效率和便捷性的Web应用。该系统利用Flask框架快速构建后端服务,提供RESTful API接口,支持用户登录、宿舍信息管理、学生入住与退宿记录、物品报修及维修跟踪、安全巡查记录等功能。前端可以采用Vue+HTML/CSS/JavaScript进行界面设计,与后端通过AJAX等技术实现数据交互,提供友好的用户操作界面。

系统核心在于数据库设计,需合理构建宿舍、学生、管理员、报修记录等数据表,并通过SQLAlchemy等ORM工具简化数据库操作。安全性方面,通过用户认证与授权机制保护数据安全,如使用JWT进行用户身份验证。此外,系统还应具备可扩展性和可维护性,便于未来功能升级和故障排查。

整体而言,该宿舍管理系统通过自动化管理流程,减轻了宿管人员的工作负担,提高了宿舍管理的透明度和效率,为学生提供了更加便捷和舒适的生活环境。

三,系统展示

学生角色功能

四,核心代码展示

# coding:utf-8
__author__ = "ila"

import logging, os, xlrd
from flask import request, jsonify,session
from sqlalchemy.sql import func,and_,or_
from api.models.brush_model import *
from . import main_bp
from utils.codes import *
from utils.jwt_auth import Auth
from configs import configs
from utils.helper import *
import random
import smtplib
from email.mime.text import MIMEText
from email.header import Header


# 注册接口
@main_bp.route("/python90kns/fangkedengji/register", methods=['POST'])
def python90kns_fangkedengji_register():
    if request.method == 'POST':
        msg = {'code': normal_code, 'message': 'success', 'data': [{}]}
        req_dict = session.get("req_dict")


        error = fangkedengji.createbyreq(fangkedengji, fangkedengji, req_dict)
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = "注册用户已存在"
        return jsonify(msg)

# 登录接口
@main_bp.route("/python90kns/fangkedengji/login", methods=['GET','POST'])
def python90kns_fangkedengji_login():
    if request.method == 'GET' or request.method == 'POST':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")
        req_model = session.get("req_dict")
        try:
            del req_model['role']
        except:
            pass


        datas = fangkedengji.getbyparams(fangkedengji, fangkedengji, req_model)
        if not datas:
            msg['code'] = password_error_code
            msg['msg']='密码错误或用户不存在'
            return jsonify(msg)


        req_dict['id'] = datas[0].get('id')
        return Auth.authenticate(Auth, fangkedengji, req_dict)

# 登出接口
@main_bp.route("/python90kns/fangkedengji/logout", methods=['POST'])
def python90kns_fangkedengji_logout():
    if request.method == 'POST':
        msg = {
            "msg": "退出成功",
            "code": 0
        }
        req_dict = session.get("req_dict")

        return jsonify(msg)

# 重置密码接口
@main_bp.route("/python90kns/fangkedengji/resetPass", methods=['POST'])
def python90kns_fangkedengji_resetpass():
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success"}

        req_dict = session.get("req_dict")

        if req_dict.get('mima') != None:
            req_dict['mima'] = '123456'

        error = fangkedengji.updatebyparams(fangkedengji, fangkedengji, req_dict)

        if error != None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        else:
            msg['msg'] = '密码已重置为:123456'
        return jsonify(msg)

# 获取会话信息接口
@main_bp.route("/python90kns/fangkedengji/session", methods=['GET'])
def python90kns_fangkedengji_session():
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "data": {}}
        req_dict={"id":session.get('params').get("id")}
        msg['data']  = fangkedengji.getbyparams(fangkedengji, fangkedengji, req_dict)[0]

        return jsonify(msg)

# 分类接口(后端)
@main_bp.route("/python90kns/fangkedengji/page", methods=['GET'])
def python90kns_fangkedengji_page():
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success",  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
        req_dict = session.get("req_dict")
        userinfo = session.get("params")

        try:
            __hasMessage__=fangkedengji.__hasMessage__
        except:
            __hasMessage__=None
        if __hasMessage__ and __hasMessage__!="否":
            tablename=session.get("tablename")
            if tablename!="users" and session.get("params")!=None and fangkedengji!='chat':
                req_dict["userid"]=session.get("params").get("id")

        tablename=session.get("tablename")
        if tablename=="users" :
            try:
                pass
            except:
                pass
        else:
            mapping_str_to_object = {}
            for model in Base_model._decl_class_registry.values():
                if hasattr(model, '__tablename__'):
                    mapping_str_to_object[model.__tablename__] = model

            try:
                __isAdmin__=mapping_str_to_object[tablename].__isAdmin__
            except:
                __isAdmin__=None

            if __isAdmin__!="是" and session.get("params")!=None:
                req_dict["userid"]=session.get("params").get("id")
            else:
                try:
                    del req_dict["userid"]
                except:
                    pass

        tablename = session.get("tablename")
        if tablename == 'xuesheng':
            req_dict['xueshengxuehao'] = userinfo['xueshengxuehao']
            if 'userid' in req_dict.keys():
                del req_dict["userid"]

        clause_args = []
        or_clauses = or_(*clause_args)

        msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
        msg['data']['pageSize']  = fangkedengji.page(fangkedengji, fangkedengji, req_dict, or_clauses)

        return jsonify(msg)

# 排序接口
@main_bp.route("/python90kns/fangkedengji/autoSort", methods=['GET'])
def python90kns_fangkedengji_autosort():
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success",  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
        req_dict = session.get("req_dict")
        req_dict['sort']='clicktime'
        req_dict['order']='desc'

        try:
            __browseClick__= fangkedengji.__browseClick__
        except:
            __browseClick__=None

        if __browseClick__ =='是':
            req_dict['sort']='clicknum'
        elif __browseClick__ =='时长':
            req_dict['sort']='browseduration'
        else:
            req_dict['sort']='clicktime'
        msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
        msg['data']['pageSize']  = fangkedengji.page(fangkedengji, fangkedengji, req_dict)

        return jsonify(msg)

# 分页接口(前端)
@main_bp.route("/python90kns/fangkedengji/list", methods=['GET'])
def python90kns_fangkedengji_list():
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success",  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}
        req_dict = session.get("req_dict")
        if req_dict.__contains__('vipread'):
            del req_dict['vipread']
            
        userinfo = session.get("params")

        try:
            __foreEndList__=fangkedengji.__foreEndList__
        except:
            __foreEndList__=None

        if __foreEndList__ and __foreEndList__!="否":
            tablename=session.get("tablename")
            if tablename!="users" and session.get("params")!=None:
                req_dict['userid']=session.get("params").get("id")

        try:
            __foreEndListAuth__=fangkedengji.__foreEndListAuth__
        except:
            __foreEndListAuth__=None

        if __foreEndListAuth__ and __foreEndListAuth__!="否":
            tablename=session.get("tablename")
            if tablename!="users" and session.get("params")!=None:
                req_dict['userid']=session.get("params").get("id")

        tablename=session.get("tablename")
        if tablename=="users" :
            try:
                del req_dict["userid"]
            except:
                pass
        else:
            mapping_str_to_object = {}
            for model in Base_model._decl_class_registry.values():
                if hasattr(model, '__tablename__'):
                    mapping_str_to_object[model.__tablename__] = model

            try:
                __isAdmin__=mapping_str_to_object[tablename].__isAdmin__
            except:
                __isAdmin__=None

            if __isAdmin__!="是" and session.get("params")!=None:
                req_dict["userid"]=session.get("params").get("id")
            else:
                try:
                    del req_dict["userid"]
                except:
                    pass

        if 'luntan' in 'fangkedengji':
            if 'userid' in req_dict.keys():
                del req_dict["userid"]


        msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
        msg['data']['pageSize']  = fangkedengji.page(fangkedengji, fangkedengji, req_dict)

        return jsonify(msg)

# 保存接口(后端)
@main_bp.route("/python90kns/fangkedengji/save", methods=['POST'])
def python90kns_fangkedengji_save():
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")
        for key in req_dict:
            if req_dict[key] == '':
                req_dict[key] = None
        error= fangkedengji.createbyreq(fangkedengji, fangkedengji, req_dict)
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        return jsonify(msg)

# 添加接口(前端)
@main_bp.route("/python90kns/fangkedengji/add", methods=['POST'])
def python90kns_fangkedengji_add():
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")
        try:
            __foreEndListAuth__=fangkedengji.__foreEndListAuth__
        except:
            __foreEndListAuth__=None

        if __foreEndListAuth__ and __foreEndListAuth__!="否":
            tablename=session.get("tablename")
            if tablename!="users":
                req_dict['userid']=session.get("params").get("id")
            
        error= fangkedengji.createbyreq(fangkedengji, fangkedengji, req_dict)
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        return jsonify(msg)

# 踩、赞接口
@main_bp.route("/python90kns/fangkedengji/thumbsup/<id_>", methods=['GET'])
def python90kns_fangkedengji_thumbsup(id_):
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")
        id_=int(id_)
        type_=int(req_dict.get("type",0))
        rets=fangkedengji.getbyid(fangkedengji, fangkedengji,id_)

        update_dict={
        "id":id_,
        }
        if type_==1:#赞
            update_dict["thumbsupnum"]=int(rets[0].get('thumbsupnum'))+1
        elif type_==2:#踩
            update_dict["crazilynum"]=int(rets[0].get('crazilynum'))+1
        error = fangkedengji.updatebyparams(fangkedengji, fangkedengji, update_dict)
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        return jsonify(msg)

# 获取详情信息(后端)
@main_bp.route("/python90kns/fangkedengji/info/<id_>", methods=['GET'])
def python90kns_fangkedengji_info(id_):
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}

        data = fangkedengji.getbyid(fangkedengji, fangkedengji, int(id_))
        if len(data)>0:
            msg['data']=data[0]
        #浏览点击次数
        try:
            __browseClick__= fangkedengji.__browseClick__
        except:
            __browseClick__=None

        if __browseClick__  and  "clicknum"  in fangkedengji.__table__.columns:
            click_dict={"id":int(id_),"clicknum":str(int(data[0].get("clicknum") or 0)+1)}
            ret=fangkedengji.updatebyparams(fangkedengji,fangkedengji,click_dict)
            if ret!=None:
                msg['code'] = crud_error_code
                msg['msg'] = ret
        return jsonify(msg)

# 获取详情信息(前端)
@main_bp.route("/python90kns/fangkedengji/detail/<id_>", methods=['GET'])
def python90kns_fangkedengji_detail(id_):
    '''
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}

        data = fangkedengji.getbyid(fangkedengji, fangkedengji, int(id_))
        if len(data)>0:
            msg['data']=data[0]

        #浏览点击次数
        try:
            __browseClick__= fangkedengji.__browseClick__
        except:
            __browseClick__=None

        if __browseClick__   and  "clicknum"  in fangkedengji.__table__.columns:
            click_dict={"id":int(id_),"clicknum":str(int(data[0].get("clicknum") or 0)+1)}
            ret=fangkedengji.updatebyparams(fangkedengji,fangkedengji,click_dict)
            if ret!=None:
                msg['code'] = crud_error_code
                msg['msg'] = ret
        return jsonify(msg)

# 更新接口
@main_bp.route("/python90kns/fangkedengji/update", methods=['POST'])
def python90kns_fangkedengji_update():
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")
        if req_dict.get("mima") and "mima" not in fangkedengji.__table__.columns :
            del req_dict["mima"]
        if req_dict.get("password") and "password" not in fangkedengji.__table__.columns :
            del req_dict["password"]
        try:
            del req_dict["clicknum"]
        except:
            pass


        error = fangkedengji.updatebyparams(fangkedengji, fangkedengji, req_dict)
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        return jsonify(msg)

# 删除接口
@main_bp.route("/python90kns/fangkedengji/delete", methods=['POST'])
def python90kns_fangkedengji_delete():
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success", "data": {}}
        req_dict = session.get("req_dict")

        error=fangkedengji.delete(
            fangkedengji,
            req_dict
        )
        if error!=None:
            msg['code'] = crud_error_code
            msg['msg'] = error
        return jsonify(msg)

# 投票接口
@main_bp.route("/python90kns/fangkedengji/vote/<int:id_>", methods=['POST'])
def python90kns_fangkedengji_vote(id_):
    '''
    '''
    if request.method == 'POST':
        msg = {"code": normal_code, "msg": "success"}


        data= fangkedengji.getbyid(fangkedengji, fangkedengji, int(id_))
        for i in data:
            votenum=i.get('votenum')
            if votenum!=None:
                params={"id":int(id_),"votenum":votenum+1}
                error=fangkedengji.updatebyparams(fangkedengji,fangkedengji,params)
                if error!=None:
                    msg['code'] = crud_error_code
                    msg['msg'] = error
        return jsonify(msg)





# 分组统计接口
@main_bp.route("/python90kns/fangkedengji/group/<columnName>", methods=['GET'])
def python90kns_fangkedengji_group(columnName):
    '''
    分组统计接口
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}

        msg['data'] = fangkedengji.groupbycolumnname(fangkedengji,fangkedengji,columnName)
        return jsonify(msg)

# 按值统计接口
@main_bp.route("/python90kns/fangkedengji/value/<xColumnName>/<yColumnName>", methods=['GET'])
def python90kns_fangkedengji_value(xColumnName, yColumnName):
    '''
    按值统计接口,
    {
        "code": 0,
        "data": [
            {
                "total": 10.0,
                "shangpinleibie": "aa"
            },
            {
                "total": 20.0,
                "shangpinleibie": "bb"
            },
            {
                "total": 15.0,
                "shangpinleibie": "cc"
            }
        ]
    }
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}

        msg['data'] = fangkedengji.getvaluebyxycolumnname(fangkedengji,fangkedengji,xColumnName,yColumnName)
        return jsonify(msg)

# 按日期统计接口
@main_bp.route("/python90kns/fangkedengji/value/<xColumnName>/<yColumnName>/<timeStatType>", methods=['GET'])
def python90kns_fangkedengji_value_riqi(xColumnName, yColumnName, timeStatType):
    '''
    按日期统计接口
    '''
    if request.method == 'GET':
        msg = {"code": normal_code, "msg": "success", "data": {}}

        where = ' where 1 = 1 '

        sql = ''
        if timeStatType == '日':
            sql = "SELECT DATE_FORMAT({0}, '%Y-%m-%d') {0}, sum({1}) total FROM fangkedengji {2} GROUP BY DATE_FORMAT({0}, '%Y-%m-%d')".format(xColumnName, yColumnName, where, '%Y-%m-%d')

        if timeStatType == '月':
            sql = "SELECT DATE_FORMAT({0}, '%Y-%m') {0}, sum({1}) total FROM fangkedengji {2} GROUP BY DATE_FORMAT({0}, '%Y-%m')".format(xColumnName, yColumnName, where, '%Y-%m')

        if timeStatType == '年':
            sql = "SELECT DATE_FORMAT({0}, '%Y') {0}, sum({1}) total FROM fangkedengji {2} GROUP BY DATE_FORMAT({0}, '%Y')".format(xColumnName, yColumnName, where, '%Y')

        data = db.session.execute(sql)
        data = data.fetchall()
        results = []
        for i in range(len(data)):
            result = {
                xColumnName: decimalEncoder(data[i][0]),
                'total': decimalEncoder(data[i][1])
            }
            results.append(result)
            
        msg['data'] = results
        return jsonify(msg)

# 推荐算法接口
@main_bp.route("/python90kns/fangkedengji/autoSort2", methods=['GET'])
def python90kns_fangkedengji_autoSort2():
    if request.method == 'GET':

        leixing = set()
        req_dict = session.get("req_dict")
        userinfo = session.get("params")
        sql = "select inteltype from storeup where userid = "+userinfo.get("id")+" and tablename = 'fangkedengji' order by addtime desc"
        try:
            data = db.session.execute(sql)
            rows = data.fetchall()
            for row in rows:
                for item in row:
                    if item != None:
                        leixing.add(item)
        except:
            leixing = set()

        L = []
        sql ="select * from fangkedengji where $intelRecomColumn in ('%s"%("','").join(leixing)+"') union all select * from fangkedengji where $intelRecomColumn not in('%s"%("','").join(leixing)+"')"
        data = db.session.execute(sql)
        data_dict = [dict(zip(result.keys(), result)) for result in data.fetchall()]
        for online_dict in data_dict:
            for key in online_dict:
                if 'datetime.datetime' in str(type(online_dict[key])):
                    online_dict[key] = online_dict[key].strftime(
                        "%Y-%m-%d %H:%M:%S")
                else:
                    pass
            L.append(online_dict)

        return jsonify({"code": 0, "msg": '',  "data":{"currPage":1,"totalPage":1,"total":1,"pageSize":5,"list": L[0:6]}})





五,相关作品展示

基于Java开发、Python开发、PHP开发、C#开发等相关语言开发的实战项目

基于Nodejs、Vue等前端技术开发的前端实战项目

基于微信小程序和安卓APP应用开发的相关作品

基于51单片机等嵌入式物联网开发应用

基于各类算法实现的AI智能应用

基于大数据实现的各类数据管理和推荐系统

 

 

抱歉,我无法提供完整的代码实现。但是,我可以给出一个大致的思路和实现步骤: 1. 安装必要的库和工具: - Python 3.x - Flask - SQLite3 2. 创建数据库: 使用SQLite3创建一个名为student.db的数据库文件,在其中创建两个表:student和dormitory。student表用于存储学生信息,包括学号、姓名、性别、班级和宿舍号;dormitory表用于存储宿舍信息,包括宿舍号、楼层和床位数。 3. 编写程序: - 引入必要的库和工具: ```python from flask import Flask, render_template, request, redirect, url_for, flash import sqlite3 ``` - 创建Flask实例: ```python app = Flask(__name__) app.secret_key = "secret_key" ``` - 定义路由: ```python @app.route("/") def index(): return render_template("index.html") ``` - 编写视图函数: ```python @app.route("/add_student", methods=["POST"]) def add_student(): if request.method == "POST": student_id = request.form["student_id"] name = request.form["name"] gender = request.form["gender"] class_name = request.form["class_name"] dormitory_id = request.form["dormitory_id"] # 将学生信息插入数据库 conn = sqlite3.connect("student.db") c = conn.cursor() c.execute("INSERT INTO student VALUES (?, ?, ?, ?, ?)", (student_id, name, gender, class_name, dormitory_id)) conn.commit() conn.close() flash("添加成功!") return redirect(url_for("index")) ``` - 在HTML页面中添加表单: ```html <form action="{{ url_for('add_student') }}" method="POST"> <label for="student_id">学号:</label> <input type="text" name="student_id" id="student_id"> <br> <label for="name">姓名:</label> <input type="text" name="name" id="name"> <br> <label for="gender">性别:</label> <input type="radio" name="gender" value="男" id="gender">男 <input type="radio" name="gender" value="女" id="gender">女 <br> <label for="class_name">班级:</label> <input type="text" name="class_name" id="class_name"> <br> <label for="dormitory_id">宿舍号:</label> <input type="text" name="dormitory_id" id="dormitory_id"> <br> <input type="submit" value="添加"> </form> ``` 4. 运行程序: 在命令行中输入以下命令启动程序: ```python python app.py ``` 然后在浏览器中访问http://localhost:5000即可使用学生寝室管理系统
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

编程千纸鹤

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值