常州外贸公司网站建设,企业网站建设板块,会员管理系统开发,营销计划的主要内容作者主页#xff1a;编程千纸鹤 作者简介#xff1a;Java领域优质创作者、CSDN博客专家 、CSDN内容合伙人、掘金特邀作者、阿里云博客专家、51CTO特邀作者、多年架构师设计经验、多年校企合作经验#xff0c;被多个学校常年聘为校外企业导师#xff0c;指导学生毕业设计并参… 作者主页编程千纸鹤 作者简介Java领域优质创作者、CSDN博客专家 、CSDN内容合伙人、掘金特邀作者、阿里云博客专家、51CTO特邀作者、多年架构师设计经验、多年校企合作经验被多个学校常年聘为校外企业导师指导学生毕业设计并参与学生毕业答辩指导有较为丰富的相关经验。期待与各位高校教师、企业讲师以及同行交流合作 主要内容Java项目、Python项目、前端项目、PHP、ASP.NET、人工智能与大数据、单片机开发、物联网设计与开发设计、简历模板、学习资料、面试题库、技术互助、就业指导等 业务范围免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等。 收藏点赞不迷路 关注作者有好处 文末获取源码 项目编号BS-XCX-064
一环境介绍
语言环境微信小程序
数据库Mysql: mysql5.7
WEB框架SpringBootVue
开发工具IDEA和微信开发者工具
开发工具微信小程序SpringBootVue
二项目简介
使用旧方法对高校宿舍信息管理系统小程序的信息进行系统化管理已经不再让人们信赖了把现在的网络信息技术运用在高校宿舍信息管理系统小程序的管理上面可以解决许多信息管理上面的难题比如处理数据时间很长数据存在错误不能及时纠正等问题。这次开发的高校宿舍信息管理系统小程序对报修管理、字典管理、试卷管理、试卷选题管理、试题表管理、考试记录表管理、答题详情表管理、错题表管理、访客管理、公寓管理、公寓收藏管理、公寓学生管理、公寓退宿申请管理、公寓入住申请管理、缴费管理、留言管理、宿舍管理员管理、调宿申请管理、卫生管理、学生管理、管理员管理等进行集中化处理。经过前面自己查阅的网络知识加上自己在学校课堂上学习的知识决定开发系统选择小程序模式这种高效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网站访问采用的主流的Java语言这种面向对象的语言进行高校宿舍信息管理系统小程序程序的开发在数据库的选择上面选择功能强大的Mysql数据库进行数据的存放操作。高校宿舍信息管理系统小程序的开发让用户查看公寓信息变得容易让管理员高效管理公寓信息。 三系统展示 四核心代码展示 package com.controller;import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;/*** 试题表* 后端接口* author* email
*/
RestController
Controller
RequestMapping(/examquestion)
public class ExamquestionController {private static final Logger logger LoggerFactory.getLogger(ExamquestionController.class);private static final String TABLE_NAME examquestion;Autowiredprivate ExamquestionService examquestionService;Autowiredprivate TokenService tokenService;Autowiredprivate BaoxiuService baoxiuService;//报修Autowiredprivate DictionaryService dictionaryService;//字典Autowiredprivate ExampaperService exampaperService;//试卷Autowiredprivate ExampapertopicService exampapertopicService;//试卷选题Autowiredprivate ExamrecordService examrecordService;//考试记录表Autowiredprivate ExamredetailsService examredetailsService;//答题详情表Autowiredprivate ExamrewrongquestionService examrewrongquestionService;//错题表Autowiredprivate FangkeService fangkeService;//访客Autowiredprivate FangwuService fangwuService;//公寓Autowiredprivate FangwuCollectionService fangwuCollectionService;//公寓收藏Autowiredprivate FangwuRuzhuService fangwuRuzhuService;//公寓学生Autowiredprivate FangwuTuisuService fangwuTuisuService;//公寓退宿申请Autowiredprivate FangwuYuyueService fangwuYuyueService;//公寓入住申请Autowiredprivate JiaofeiService jiaofeiService;//缴费Autowiredprivate LiuyanService liuyanService;//留言Autowiredprivate SusheguanliyuanService susheguanliyuanService;//宿舍管理员Autowiredprivate TiaosushenqingService tiaosushenqingService;//调宿申请Autowiredprivate WeishengService weishengService;//卫生Autowiredprivate YonghuService yonghuService;//学生Autowiredprivate UsersService usersService;//管理员/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(page方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永不会进入);else if(学生.equals(role))params.put(yonghuId,request.getSession().getAttribute(userId));else if(宿舍管理员.equals(role))params.put(susheguanliyuanId,request.getSession().getAttribute(userId));CommonUtil.checkMap(params);PageUtils page examquestionService.queryPage(params);//字典表数据转换ListExamquestionView list (ListExamquestionView)page.getList();for(ExamquestionView c:list){//修改对应字典表字段dictionaryService.dictionaryConvert(c, request);}return R.ok().put(data, page);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id, HttpServletRequest request){logger.debug(info方法:,,Controller:{},,id:{},this.getClass().getName(),id);ExamquestionEntity examquestion examquestionService.selectById(id);if(examquestion !null){//entity转viewExamquestionView view new ExamquestionView();BeanUtils.copyProperties( examquestion , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody ExamquestionEntity examquestion, HttpServletRequest request){logger.debug(save方法:,,Controller:{},,examquestion:{},this.getClass().getName(),examquestion.toString());String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永远不会进入);WrapperExamquestionEntity queryWrapper new EntityWrapperExamquestionEntity().eq(examquestion_name, examquestion.getExamquestionName()).eq(examquestion_options, examquestion.getExamquestionOptions()).eq(examquestion_answer, examquestion.getExamquestionAnswer()).eq(examquestion_analysis, examquestion.getExamquestionAnalysis()).eq(examquestion_types, examquestion.getExamquestionTypes()).eq(examquestion_sequence, examquestion.getExamquestionSequence());logger.info(sql语句:queryWrapper.getSqlSegment());ExamquestionEntity examquestionEntity examquestionService.selectOne(queryWrapper);if(examquestionEntitynull){examquestion.setCreateTime(new Date());examquestionService.insert(examquestion);return R.ok();}else {return R.error(511,表中有相同数据);}}/*** 后端修改*/RequestMapping(/update)public R update(RequestBody ExamquestionEntity examquestion, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {logger.debug(update方法:,,Controller:{},,examquestion:{},this.getClass().getName(),examquestion.toString());ExamquestionEntity oldExamquestionEntity examquestionService.selectById(examquestion.getId());//查询原先数据String role String.valueOf(request.getSession().getAttribute(role));
// if(false)
// return R.error(511,永远不会进入);examquestionService.updateById(examquestion);//根据id更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Integer[] ids, HttpServletRequest request){logger.debug(delete:,,Controller:{},,ids:{},this.getClass().getName(),ids.toString());ListExamquestionEntity oldExamquestionList examquestionService.selectBatchIds(Arrays.asList(ids));//要删除的数据examquestionService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 批量上传*/RequestMapping(/batchInsert)public R save( String fileName, HttpServletRequest request){logger.debug(batchInsert方法:,,Controller:{},,fileName:{},this.getClass().getName(),fileName);Integer yonghuId Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId)));SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd HH:mm:ss);//.eq(time, new SimpleDateFormat(yyyy-MM-dd).format(new Date()))try {ListExamquestionEntity examquestionList new ArrayList();//上传的东西MapString, ListString seachFields new HashMap();//要查询的字段Date date new Date();int lastIndexOf fileName.lastIndexOf(.);if(lastIndexOf -1){return R.error(511,该文件没有后缀);}else{String suffix fileName.substring(lastIndexOf);if(!.xls.equals(suffix)){return R.error(511,只支持后缀为xls的excel文件);}else{URL resource this.getClass().getClassLoader().getResource(static/upload/ fileName);//获取文件路径File file new File(resource.getFile());if(!file.exists()){return R.error(511,找不到上传文件请联系管理员);}else{ListListString dataList PoiUtil.poiImport(file.getPath());//读取xls文件dataList.remove(0);//删除第一行因为第一行是提示for(ListString data:dataList){//循环ExamquestionEntity examquestionEntity new ExamquestionEntity();
// examquestionEntity.setExamquestionName(data.get(0)); //试题名称 要改的
// examquestionEntity.setExamquestionOptions(data.get(0)); //选项json字符串 要改的
// examquestionEntity.setExamquestionAnswer(data.get(0)); //正确答案 要改的
// examquestionEntity.setExamquestionAnalysis(data.get(0)); //答案解析 要改的
// examquestionEntity.setExamquestionTypes(Integer.valueOf(data.get(0))); //试题类型 要改的
// examquestionEntity.setExamquestionSequence(Integer.valueOf(data.get(0))); //试题排序值越大排越前面 要改的
// examquestionEntity.setCreateTime(date);//时间examquestionList.add(examquestionEntity);//把要查询是否重复的字段放入map中}//查询是否重复examquestionService.insertBatch(examquestionList);return R.ok();}}}}catch (Exception e){e.printStackTrace();return R.error(511,批量插入数据异常请联系管理员);}}/*** 前端列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(list方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));CommonUtil.checkMap(params);PageUtils page examquestionService.queryPage(params);//字典表数据转换ListExamquestionView list (ListExamquestionView)page.getList();for(ExamquestionView c:list)dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段return R.ok().put(data, page);}/*** 前端详情*/RequestMapping(/detail/{id})public R detail(PathVariable(id) Integer id, HttpServletRequest request){logger.debug(detail方法:,,Controller:{},,id:{},this.getClass().getName(),id);ExamquestionEntity examquestion examquestionService.selectById(id);if(examquestion !null){//entity转viewExamquestionView view new ExamquestionView();BeanUtils.copyProperties( examquestion , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody ExamquestionEntity examquestion, HttpServletRequest request){logger.debug(add方法:,,Controller:{},,examquestion:{},this.getClass().getName(),examquestion.toString());WrapperExamquestionEntity queryWrapper new EntityWrapperExamquestionEntity().eq(examquestion_name, examquestion.getExamquestionName()).eq(examquestion_options, examquestion.getExamquestionOptions()).eq(examquestion_answer, examquestion.getExamquestionAnswer()).eq(examquestion_analysis, examquestion.getExamquestionAnalysis()).eq(examquestion_types, examquestion.getExamquestionTypes()).eq(examquestion_sequence, examquestion.getExamquestionSequence())
// .notIn(examquestion_types, new Integer[]{102});logger.info(sql语句:queryWrapper.getSqlSegment());ExamquestionEntity examquestionEntity examquestionService.selectOne(queryWrapper);if(examquestionEntitynull){examquestion.setCreateTime(new Date());examquestionService.insert(examquestion);return R.ok();}else {return R.error(511,表中有相同数据);}}} 五相关作品展示
基于Java开发、Python开发、PHP开发、C#开发等相关语言开发的实战项目
基于Nodejs、Vue等前端技术开发的前端实战项目
基于微信小程序和安卓APP应用开发的相关作品
基于51单片机等嵌入式物联网开发应用
基于各类算法实现的AI智能应用
基于大数据实现的各类数据管理和推荐系统
