基于微信小程序的高校学生事务管理系统+ssm后台管理

微信小程序高校学生事务管理系统的设计与实现

摘要

随着信息技术在管理上越来越深入而广泛的应用，管理信息系统的实施在技术上已逐步成熟。本文介绍了微信小程序高校学生事务管理系统的开发全过程。通过分析微信小程序高校学生事务管理系统管理的不足，创建了一个计算机管理微信小程序高校学生事务管理系统的方案。文章介绍了微信小程序高校学生事务管理系统的系统分析部分，包括可行性分析等，系统设计部分主要介绍了系统功能设计和数据库设计。

本微信小程序高校学生事务管理系统有管理员，教师，学生三个角色。管理员和教师主要在后台操作，学生在微信端操作，功能方向主要关于学生资料的管理，考试管理，试题管理，各种通知等。因而具有一定的实用性。

本站后台采用Java的SSM框架进行后台管理开发，可以在浏览器上登录进行后台数据方面的管理，MySQL作为本地数据库，微信小程序用到了微信开发者工具，充分保证系统的稳定性。系统具有界面清晰、操作简单，功能齐全的特点，使得微信小程序高校学生事务管理系统管理工作系统化、规范化。

关键词：微信小程序高校学生事务管理系统；SSM框架；MYSQL数据库

基于微信小程序的高校学生事务管理系统+ssm后台管理weixin171

演示视频：

基于微信小程序的高校学生事务管理系统+ssm后台管理

Abstract

With the more and more in-depth and extensive application of information technology in management, the implementation of management information system has gradually matured in technology. This paper introduces the whole development process of wechat applet college student affairs management system. By analyzing the shortcomings of wechat applet college student affairs management system, a scheme of computer management wechat applet college student affairs management system is created. This paper introduces the system analysis part of wechat applet college student affairs management system, including feasibility analysis. The system design part mainly introduces the system function design and database design.

This wechat applet college student affairs management system has three roles: administrator, teacher and student. Administrators and teachers mainly operate in the background and students operate on wechat. The functional direction is mainly about the management of student data, examination management, test question management, various notices, etc. Therefore, it has certain practicability.

The background of this site adopts the SSM framework of Java for background management and development, which can log in on the browser for background data management. MySQL is a local database, and wechat applet uses wechat developer tools to fully ensure the stability of the system. The system has the characteristics of clear interface, simple operation and complete functions, which makes the management of wechat applet college student affairs management system systematic and standardized.

Keywords:Wechat applet college student affairs management system; SSM framework; Mysql database

package com.controller;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;

import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;

import com.entity.JiangzuotongzhiEntity;
import com.entity.view.JiangzuotongzhiView;

import com.service.JiangzuotongzhiService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.InputStream;
import org.springframework.web.multipart.MultipartFile;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;

/**
 * 讲座通知
 * 后端接口
 * @author 
 * @email 
 * @date 2022-02-26 18:00:12
 */
@RestController
@RequestMapping("/jiangzuotongzhi")
public class JiangzuotongzhiController {
    @Autowired
    private JiangzuotongzhiService jiangzuotongzhiService;



    


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,JiangzuotongzhiEntity jiangzuotongzhi, 
		HttpServletRequest request){

        EntityWrapper<JiangzuotongzhiEntity> ew = new EntityWrapper<JiangzuotongzhiEntity>();
		PageUtils page = jiangzuotongzhiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiangzuotongzhi), params), params));
        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,JiangzuotongzhiEntity jiangzuotongzhi, 
		HttpServletRequest request){
        EntityWrapper<JiangzuotongzhiEntity> ew = new EntityWrapper<JiangzuotongzhiEntity>();
		PageUtils page = jiangzuotongzhiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jiangzuotongzhi), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( JiangzuotongzhiEntity jiangzuotongzhi){
       	EntityWrapper<JiangzuotongzhiEntity> ew = new EntityWrapper<JiangzuotongzhiEntity>();
      	ew.allEq(MPUtil.allEQMapPre( jiangzuotongzhi, "jiangzuotongzhi")); 
        return R.ok().put("data", jiangzuotongzhiService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(JiangzuotongzhiEntity jiangzuotongzhi){
        EntityWrapper< JiangzuotongzhiEntity> ew = new EntityWrapper< JiangzuotongzhiEntity>();
 		ew.allEq(MPUtil.allEQMapPre( jiangzuotongzhi, "jiangzuotongzhi")); 
		JiangzuotongzhiView jiangzuotongzhiView =  jiangzuotongzhiService.selectView(ew);
		return R.ok("查询讲座通知成功").put("data", jiangzuotongzhiView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        JiangzuotongzhiEntity jiangzuotongzhi = jiangzuotongzhiService.selectById(id);
        return R.ok().put("data", jiangzuotongzhi);
    }

    /**
     * 前端详情
     */
	@IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        JiangzuotongzhiEntity jiangzuotongzhi = jiangzuotongzhiService.selectById(id);
        return R.ok().put("data", jiangzuotongzhi);
    }
    



    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody JiangzuotongzhiEntity jiangzuotongzhi, HttpServletRequest request){
    	jiangzuotongzhi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(jiangzuotongzhi);

        jiangzuotongzhiService.insert(jiangzuotongzhi);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody JiangzuotongzhiEntity jiangzuotongzhi, HttpServletRequest request){
    	jiangzuotongzhi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(jiangzuotongzhi);

        jiangzuotongzhiService.insert(jiangzuotongzhi);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody JiangzuotongzhiEntity jiangzuotongzhi, HttpServletRequest request){
        //ValidatorUtils.validateEntity(jiangzuotongzhi);
        jiangzuotongzhiService.updateById(jiangzuotongzhi);//全部更新
        return R.ok();
    }
    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        jiangzuotongzhiService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
    
    /**
     * 提醒接口
     */
	@RequestMapping("/remind/{columnName}/{type}")
	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
		map.put("column", columnName);
		map.put("type", type);
		
		if(type.equals("2")) {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c = Calendar.getInstance();
			Date remindStartDate = null;
			Date remindEndDate = null;
			if(map.get("remindstart")!=null) {
				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
				c.setTime(new Date()); 
				c.add(Calendar.DAY_OF_MONTH,remindStart);
				remindStartDate = c.getTime();
				map.put("remindstart", sdf.format(remindStartDate));
			}
			if(map.get("remindend")!=null) {
				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
				c.setTime(new Date());
				c.add(Calendar.DAY_OF_MONTH,remindEnd);
				remindEndDate = c.getTime();
				map.put("remindend", sdf.format(remindEndDate));
			}
		}
		
		Wrapper<JiangzuotongzhiEntity> wrapper = new EntityWrapper<JiangzuotongzhiEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}


		int count = jiangzuotongzhiService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	






    @RequestMapping("/importExcel")
    public R importExcel(@RequestParam("file") MultipartFile file){
        try {
            //获取输入流
            InputStream inputStream = file.getInputStream();
            //创建读取工作簿
            Workbook workbook = WorkbookFactory.create(inputStream);
            //获取工作表
            Sheet sheet = workbook.getSheetAt(0);
            //获取总行
            int rows=sheet.getPhysicalNumberOfRows();
            if(rows>1){
                //获取单元格
                for (int i = 1; i < rows; i++) {
                    Row row = sheet.getRow(i);
                    JiangzuotongzhiEntity jiangzuotongzhiEntity =new JiangzuotongzhiEntity();
                    jiangzuotongzhiEntity.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
                    String kechengmingcheng = CommonUtil.getCellValue(row.getCell(0));
                    jiangzuotongzhiEntity.setKechengmingcheng(kechengmingcheng);
                    String xuefen = CommonUtil.getCellValue(row.getCell(1));
                    jiangzuotongzhiEntity.setXuefen(xuefen);
                    String suoshupingtai = CommonUtil.getCellValue(row.getCell(2));
                    jiangzuotongzhiEntity.setSuoshupingtai(suoshupingtai);
                    String lianjie = CommonUtil.getCellValue(row.getCell(3));
                    jiangzuotongzhiEntity.setLianjie(lianjie);
                     
                    //想数据库中添加新对象
                    jiangzuotongzhiService.insert(jiangzuotongzhiEntity);//方法
                }
            }
            inputStream.close();
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return R.ok("导入成功");
    }

}