关于后端:Python-Django-MySQL的教务系统的设计与实现第六稿中期检查表

博主介绍：✌退职Java研发工程师、专一于程序设计、源码分享、技术交换、专一于Java技术畛域和毕业设计✌

[项目名称

Python Django MySQL的教务零碎的设计与实现

视频演示

Python Django MySQL的教务零碎的设计与实现_哔哩哔哩_bilibili](https://ym.maptoface.com/archives/59063)

零碎介绍

2.1 零碎整体性能框架

教务零碎分三大部分，即管理员治理、老师治理和学生治理。从管理员出拿到调配好的账号密码能够进入零碎，应用相干的零碎利用，管理员权限最大，其次的老师和学生。零碎整体模块设计：零碎分为管理员、老师和学生三大用户角色，系统管理员有最大的权限，整体性能展现如图2-1所示。

2.3 零碎用例剖析

本文旨在综合网络空间开发设计要求，将传统教务治理形式转变为在线治理，实现教务治理的便捷、高安全性和标准交易。教务零碎的指标明确，性能划分为管理员、老师和学生三个次要角色。管理员性能包含系统管理和用户权限治理；老师性能包含教学管理和学生治理；学生性能次要波及选课、查问课程信息和集体问题查看。通过教务零碎，管理人员、老师和学生能够在网上进行教务治理，进步工作效率，确保交易的安全性和规范性。

（1）管理员在教务零碎中领有多个要害性能，包含集体核心、学生治理、老师治理、课程管理、选课治理、问题治理、评教治理、班级治理。通过这些性能，管理员可能治理账户信息、解决学生和老师档案、治理课程和选课信息、录入和统计问题、进行评教、治理班级和教室，以及进行零碎设置和权限治理。这些性能的高效运行和协同工作，确保了教务零碎的顺利运行和信息管理的准确性。管理员用例如下：

老师在教务零碎中领有要害性能，包含集体核心、课程管理、选课治理、退课治理、问题治理、重考告诉和重修告诉。通过这些性能，老师能够治理个人信息，治理课程信息，解决选课和退课事务，录入和统计学生问题，公布重考和重修告诉。这些性能使老师可能高效地治理教学工作和学生信息，提供学术反对和领导，促成教学质量的晋升。老师用例如下：

图2-8 老师用例图

学生在教务零碎中具备要害性能，包含集体核心、选课治理、退课治理、问题治理、评教治理、重考告诉和重修告诉。通过这些性能，学生能够治理个人信息，浏览和抉择课程，办理退课手续，查问和剖析问题，参加老师评教，接管重考和重修告诉。这些性能使学生可能不便地治理学习过程，进行选课决策，把握学业成绩，提供反馈和倡议，获取重要告诉信息，从而晋升学习效果和学习体验。学生用例如下：

图2-9 学生用例图

编辑

技术栈

后端：Spring+SpringMVC+Mybatis
前端：JSP+CSS+JavaScript+jQuery

应用阐明

应用Navicat或者其它工具，在mysql中创立对应名称的数据库，并导入我的项目的sql文件；
应用IDEA/Eclipse/MyEclipse导入我的项目，Eclipse/MyEclipse导入时，若为maven我的项目请抉择maven;
若为maven我的项目，导入胜利后请执行maven clean;maven install命令，而后运行；
将我的项目中springmvc-servlet.xml配置文件中的数据库配置改为本人的配置;
运行我的项目，在浏览器中输出http://localhost:8080/ 登录

运行截图

编辑

用户管理控制层:

package com.houserss.controller;

import javax.servlet.http.HttpSession;

import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.houserss.common.Const;
import com.houserss.common.Const.Role;
import com.houserss.common.ServerResponse;
import com.houserss.pojo.User;
import com.houserss.service.IUserService;
import com.houserss.service.impl.UserServiceImpl;
import com.houserss.util.MD5Util;
import com.houserss.util.TimeUtils;
import com.houserss.vo.DeleteHouseVo;
import com.houserss.vo.PageInfoVo;

/**

Created by admin
*/

@Controller
@RequestMapping("/user/")
public class UserController {

@Autowiredprivate IUserService iUserService;/** * 用户登录 * @param username * @param password * @param session * @return */@RequestMapping(value = "login.do",method = RequestMethod.POST)@ResponseBodypublic ServerResponse<User> login(User user,String uvcode, HttpSession session){    String code = (String)session.getAttribute("validationCode");    if(StringUtils.isNotBlank(code)) {        if(!code.equalsIgnoreCase(uvcode)) {            return ServerResponse.createByErrorMessage("验证码不正确");        }    }    ServerResponse<User> response = iUserService.login(user.getUsername(),user.getPassword());    if(response.isSuccess()){        session.setAttribute(Const.CURRENT_USER,response.getData());    }    return response;}

}

管理员管理控制层:

package com.sxl.controller.admin;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.sxl.controller.MyController;

@Controller("adminController")
@RequestMapping(value = "/admin")
public class AdminController extends MyController {

@RequestMapping(value = "/index")public String frame(Model model, HttpServletRequest request)throws Exception {    return "/admin/index";}@RequestMapping(value = "/main")public String main(Model model, HttpServletRequest request)throws Exception {    return "/admin/main";}@RequestMapping(value = "/tj1")public String tj1(Model model, HttpServletRequest request)throws Exception {    String sql="select DATE_FORMAT(insertDate,'%Y-%m-%d') dates,sum(allPrice) price from t_order order by DATE_FORMAT(insertDate,'%Y-%m-%d')  desc";    List<Map> list = db.queryForList(sql);    model.addAttribute("list", list);    System.out.println(list);    return "/admin/tj/tj1";}@RequestMapping(value = "/password")public String password(Model model, HttpServletRequest request)throws Exception {    return "/admin/password";}@RequestMapping(value = "/changePassword")public ResponseEntity<String> loginSave(Model model,HttpServletRequest request,String oldPassword,String newPassword) throws Exception {    Map admin = getAdmin(request);    if(oldPassword.equals(admin.get("password").toString())){        String sql="update t_admin set password=? where id=?";        db.update(sql, new Object[]{newPassword,admin.get("id")});        return renderData(true,"1",null);    }else{        return renderData(false,"1",null);    }}

}

批改明码业务逻辑:

package com.sxl.controller.admin;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.sxl.controller.MyController;

@Controller("userController")
@RequestMapping(value = "/user")
public class UserController extends MyController {

@RequestMapping(value = "/index")public String frame(Model model, HttpServletRequest request)throws Exception {    return "/user/index";}@RequestMapping(value = "/main")public String main(Model model, HttpServletRequest request)throws Exception {    return "/user/main";}@RequestMapping(value = "/password")public String password(Model model, HttpServletRequest request)throws Exception {    return "/user/password";}@RequestMapping(value = "/changePassword")public ResponseEntity<String> loginSave(Model model,HttpServletRequest request,String oldPassword,String newPassword) throws Exception {    Map user = getUser(request);    if(oldPassword.equals(user.get("password").toString())){        String sql="update t_user set password=? where id=?";        db.update(sql, new Object[]{newPassword,user.get("id")});        return renderData(true,"1",null);    }else{        return renderData(false,"1",null);    }}@RequestMapping(value = "/mine")public String mine(Model model, HttpServletRequest request)throws Exception {

Map user =getUser(request);Map map = db.queryForMap("select * from t_user where id=?",new Object[]{user.get("id")});model.addAttribute("map", map); return "/user/mine";

}@RequestMapping(value = "/mineSave")public ResponseEntity<String> mineSave(Model model,HttpServletRequest request,Long id    ,String username,String password,String name,String gh,String mobile) throws Exception{    int result = 0;        String sql="update t_user set name=?,gh=?,mobile=? where id=?";        result = db.update(sql, new Object[]{name,gh,mobile,id});    if(result==1){        return renderData(true,"操作胜利",null);    }else{        return renderData(false,"操作失败",null);    }}}

通用治理模块:

package com.sxl.controller;

import java.nio.charset.Charset;
import java.util.Locale;
import java.util.ResourceBundle;

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;

import com.sxl.util.JacksonJsonUtil;
import com.sxl.util.StringUtil;
import com.sxl.util.SystemProperties;

public class BaseController {

public static final Long EXPIRES_IN = 1000 * 3600 * 24 * 1L;// 1天@Autowiredprivate SystemProperties systemProperties;/** * 取得配置文件内容 */public String getConfig(String key) {    return systemProperties.getProperties(key);}/** * 返回服务器地址 like http://192.168.1.1:8441/UUBean/ */public String getHostUrl(HttpServletRequest request) {    String hostName = request.getServerName();    Integer hostPort = request.getServerPort();    String path = request.getContextPath();    if (hostPort == 80) {        return "http://" + hostName + path + "/";    } else {        return "http://" + hostName + ":" + hostPort + path + "/";    }}/*** * 获取以后的website门路 String */public static String getWebSite(HttpServletRequest request) {    String returnUrl = request.getScheme() + "://"            + request.getServerName();    if (request.getServerPort() != 80) {        returnUrl += ":" + request.getServerPort();    }    returnUrl += request.getContextPath();    return returnUrl;}/** * 初始化HTTP头. *  * @return HttpHeaders */public HttpHeaders initHttpHeaders() {    HttpHeaders headers = new HttpHeaders();    MediaType mediaType = new MediaType("text", "html",            Charset.forName("utf-8"));    headers.setContentType(mediaType);    return headers;}/** * 返回 信息数据 *  * @param status * @param msg * @return */public ResponseEntity<String> renderMsg(Boolean status, String msg) {    if (StringUtils.isEmpty(msg)) {        msg = "";    }    String str = "{\"status\":\"" + status + "\",\"msg\":\"" + msg + "\"}";    ResponseEntity<String> responseEntity = new ResponseEntity<String>(str,            initHttpHeaders(), HttpStatus.OK);    return responseEntity;}/** * 返回obj数据 *  * @param status * @param msg * @param obj * @return */public ResponseEntity<String> renderData(Boolean status, String msg,        Object obj) {    if (StringUtils.isEmpty(msg)) {        msg = "";    }    StringBuffer sb = new StringBuffer();    sb.append("{");    sb.append("\"status\":\"" + status + "\",\"msg\":\"" + msg + "\",");    sb.append("\"data\":" + JacksonJsonUtil.toJson(obj) + "");    sb.append("}");    ResponseEntity<String> responseEntity = new ResponseEntity<String>(            sb.toString(), initHttpHeaders(), HttpStatus.OK);    return responseEntity;}/*** * 获取IP（如果是多级代理，则失去的是一串IP值） */public static String getIpAddr(HttpServletRequest request) {    String ip = request.getHeader("x-forwarded-for");    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {        ip = request.getHeader("Proxy-Client-IP");    }    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {        ip = request.getHeader("WL-Proxy-Client-IP");    }    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {        ip = request.getRemoteAddr();    }    if (ip != null && ip.length() > 0) {        String[] ips = ip.split(",");        for (int i = 0; i < ips.length; i++) {            if (!"unknown".equalsIgnoreCase(ips[i])) {                ip = ips[i];                break;            }        }    }    return ip;}/** * 国际化取得语言内容 *  * @param key *            语言key * @param args * @param argsSplit * @param defaultMessage * @param locale * @return */public static String getLanguage(String key, String args, String argsSplit,        String defaultMessage, String locale) {    String language = "zh";    String contry = "cn";    String returnValue = defaultMessage;    if (!StringUtil.isEmpty(locale)) {        try {            String[] localeArray = locale.split("_");            language = localeArray[0];            contry = localeArray[1];        } catch (Exception e) {        }    }    try {        ResourceBundle resource = ResourceBundle.getBundle("lang.resource",                new Locale(language, contry));        returnValue = resource.getString(key);        if (!StringUtil.isEmpty(args)) {            String[] argsArray = args.split(argsSplit);            for (int i = 0; i < argsArray.length; i++) {                returnValue = returnValue.replace("{" + i + "}",                        argsArray[i]);            }        }    } catch (Exception e) {    }    return returnValue;}

}