本文首先实现了“一分钟”寝室小卖部系统设计与实现管理技术的发展随后依照传统的软件开发流程，最先为系统挑选适用的言语和软件开发平台，依据需求分析开展控制模块制做和数据库查询构造设计，随后依据系统整体功能模块的设计，制作系统的功能模块图、E-R图。随后，设计框架，依据设计的框架撰写编码，完成系统的每个功能模块。最终，对基本系统开展了检测，包含软件性能测试、单元测试和性能指标。测试结果表明，该系统能够实现所需的功能，运行状况尚可并无明显缺点。
关键字：“一分钟”寝室小卖部系统; B/S架构;Spring Boot框架;
springboot vue寝室小卖部系统源码和答辩PPT论文802
本次系统采用Spring Boot框架集进行开发，Spring Boot框架是一款主流的软件开发框架，其简化了开发流程，大大缩减了软件开发所需的时间提高了软件的响应速度。系统基本结构图如图4-1所示。
图4-1 系统基本结构图
4.2 数据库设计
4.2.1 数据库实体
E-R图，即实体-联系图，它是一种通过对实例进行抽象，以可视化的方式来描述现实世界的概念模型。根据需求分析绘制出数据库的E-R图，能够直观地映射出各个表之间的关系。
用户信息包括；用户名、姓名、性别、头像、手机号、积分、是否会员等信息，实体图如图4-2所示。
Abstract
This article first realized the development of the "One Minute" bedroom snack bar system design and implementation management technology. Then, according to the traditional software development process, it first selected the appropriate language and software development platform for the system, developed the control module design and database query construction design based on demand analysis, and then produced the system's functional module diagram and E-R diagram based on the overall functional module design of the system. Subsequently, design the framework, write the code according to the designed framework, and complete each functional module of the system. Finally, the basic system was tested, including software performance testing, unit testing, and performance indicators. The test results show that the system can achieve the required functions, and the operation condition is still acceptable without obvious shortcomings.
Key words: "One Minute" bedroom snack bar system; B/S architecture; Spring Boot framework;
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("/chongwuYuyue")
public class ChongwuYuyueController {
private static final Logger logger = LoggerFactory.getLogger(ChongwuYuyueController.class);
private static final String TABLE_NAME = "chongwuYuyue";
@Autowired
private ChongwuYuyueService chongwuYuyueService;
@Autowired
private TokenService tokenService;
@Autowired
private AichongService aichongService;//爱宠天地
@Autowired
private ChongwuService chongwuService;//宠物
@Autowired
private ChongwuCollectionService chongwuCollectionService;//宠物收藏
@Autowired
private ChongwuLiuyanService chongwuLiuyanService;//宠物留言
@Autowired
private DictionaryService dictionaryService;//字典
@Autowired
private NewsService newsService;//宠物资讯
@Autowired
private YonghuService yonghuService;//用户
@Autowired
private UsersService usersService;//管理员
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, 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"));
CommonUtil.checkMap(params);
PageUtils page = chongwuYuyueService.queryPage(params);
//字典表数据转换
List<ChongwuYuyueView> list =(List<ChongwuYuyueView>)page.getList();
for(ChongwuYuyueView 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);
ChongwuYuyueEntity chongwuYuyue = chongwuYuyueService.selectById(id);
if(chongwuYuyue !=null){
//entity转view
ChongwuYuyueView view = new ChongwuYuyueView();
BeanUtils.copyProperties( chongwuYuyue , view );//把实体数据重构到view中
//级联表 宠物
//级联表
ChongwuEntity chongwu = chongwuService.selectById(chongwuYuyue.getChongwuId());
if(chongwu != null){
BeanUtils.copyProperties( chongwu , view ,new String[]{ "id", "createTime", "insertTime", "updateTime", "yonghuId"});//把级联的数据添加到view中,并排除id和创建时间字段,当前表的级联注册表
view.setChongwuId(chongwu.getId());
}
//级联表 用户
//级联表
YonghuEntity yonghu = yonghuService.selectById(chongwuYuyue.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createTime", "insertTime", "updateTime", "yonghuId"});//把级联的数据添加到view中,并排除id和创建时间字段,当前表的级联注册表
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ChongwuYuyueEntity chongwuYuyue, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,chongwuYuyue:{}",this.getClass().getName(),chongwuYuyue.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
else if("用户".equals(role))
chongwuYuyue.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
Wrapper<ChongwuYuyueEntity> queryWrapper = new EntityWrapper<ChongwuYuyueEntity>()
.eq("chongwu_id", chongwuYuyue.getChongwuId())
.eq("yonghu_id", chongwuYuyue.getYonghuId())
.in("chongwu_yuyue_yesno_types", new Integer[]{1,2})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ChongwuYuyueEntity chongwuYuyueEntity = chongwuYuyueService.selectOne(queryWrapper);
if(chongwuYuyueEntity==null){
chongwuYuyue.setChongwuYuyueYesnoTypes(1);
chongwuYuyue.setInsertTime(new Date());
chongwuYuyue.setCreateTime(new Date());
chongwuYuyueService.insert(chongwuYuyue);
return R.ok();
}else {
if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes()==1)
return R.error(511,"有相同的待审核的数据");
else if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes()==2)
return R.error(511,"有相同的审核通过的数据");
else
return R.error(511,"表中有相同数据");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody ChongwuYuyueEntity chongwuYuyue, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {
logger.debug("update方法:,,Controller:{},,chongwuYuyue:{}",this.getClass().getName(),chongwuYuyue.toString());
ChongwuYuyueEntity oldChongwuYuyueEntity = chongwuYuyueService.selectById(chongwuYuyue.getId());//查询原先数据
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
// else if("用户".equals(role))
// chongwuYuyue.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
chongwuYuyueService.updateById(chongwuYuyue);//根据id更新
return R.ok();
}
/**
* 审核
*/
@RequestMapping("/shenhe")
public R shenhe(@RequestBody ChongwuYuyueEntity chongwuYuyueEntity, HttpServletRequest request){
logger.debug("shenhe方法:,,Controller:{},,chongwuYuyueEntity:{}",this.getClass().getName(),chongwuYuyueEntity.toString());
ChongwuYuyueEntity oldChongwuYuyue = chongwuYuyueService.selectById(chongwuYuyueEntity.getId());//查询原先数据
// if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes() == 2){//通过
// chongwuYuyueEntity.setChongwuYuyueTypes();
// }else if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes() == 3){//拒绝
// chongwuYuyueEntity.setChongwuYuyueTypes();
// }
chongwuYuyueEntity.setChongwuYuyueShenheTime(new Date());//审核时间
chongwuYuyueService.updateById(chongwuYuyueEntity);//审核
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids, HttpServletRequest request){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
List<ChongwuYuyueEntity> oldChongwuYuyueList =chongwuYuyueService.selectBatchIds(Arrays.asList(ids));//要删除的数据
chongwuYuyueService.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 {
List<ChongwuYuyueEntity> chongwuYuyueList = new ArrayList<>();//上传的东西
Map<String, List<String>> 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{
List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
dataList.remove(0);//删除第一行，因为第一行是提示
for(List<String> data:dataList){
//循环
ChongwuYuyueEntity chongwuYuyueEntity = new ChongwuYuyueEntity();
// chongwuYuyueEntity.setChongwuYuyueUuidNumber(data.get(0)); //报名编号 要改的
// chongwuYuyueEntity.setChongwuId(Integer.valueOf(data.get(0))); //宠物 要改的
// chongwuYuyueEntity.setYonghuId(Integer.valueOf(data.get(0))); //用户 要改的
// chongwuYuyueEntity.setChongwuYuyueText(data.get(0)); //报名理由 要改的
// chongwuYuyueEntity.setChongwuYuyueYesnoTypes(Integer.valueOf(data.get(0))); //报名状态 要改的
// chongwuYuyueEntity.setChongwuYuyueYesnoText(data.get(0)); //审核回复 要改的
// chongwuYuyueEntity.setChongwuYuyueShenheTime(sdf.parse(data.get(0))); //审核时间 要改的
// chongwuYuyueEntity.setChongwuYuyueTime(sdf.parse(data.get(0))); //预约时间 要改的
// chongwuYuyueEntity.setInsertTime(date);//时间
// chongwuYuyueEntity.setCreateTime(date);//时间
chongwuYuyueList.add(chongwuYuyueEntity);
//把要查询是否重复的字段放入map中
//报名编号
if(seachFields.containsKey("chongwuYuyueUuidNumber")){
List<String> chongwuYuyueUuidNumber = seachFields.get("chongwuYuyueUuidNumber");
chongwuYuyueUuidNumber.add(data.get(0));//要改的
}else{
List<String> chongwuYuyueUuidNumber = new ArrayList<>();
chongwuYuyueUuidNumber.add(data.get(0));//要改的
seachFields.put("chongwuYuyueUuidNumber",chongwuYuyueUuidNumber);
}
}
//查询是否重复
//报名编号
List<ChongwuYuyueEntity> chongwuYuyueEntities_chongwuYuyueUuidNumber = chongwuYuyueService.selectList(new EntityWrapper<ChongwuYuyueEntity>().in("chongwu_yuyue_uuid_number", seachFields.get("chongwuYuyueUuidNumber")));
if(chongwuYuyueEntities_chongwuYuyueUuidNumber.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(ChongwuYuyueEntity s:chongwuYuyueEntities_chongwuYuyueUuidNumber){
repeatFields.add(s.getChongwuYuyueUuidNumber());
}
return R.error(511,"数据库的该表中的 [报名编号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
chongwuYuyueService.insertBatch(chongwuYuyueList);
return R.ok();
}
}
}
}catch (Exception e){
e.printStackTrace();
return R.error(511,"批量插入数据异常，请联系管理员");
}
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = chongwuYuyueService.queryPage(params);
//字典表数据转换
List<ChongwuYuyueView> list =(List<ChongwuYuyueView>)page.getList();
for(ChongwuYuyueView c:list)
dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
return R.ok().put("data", page);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ChongwuYuyueEntity chongwuYuyue = chongwuYuyueService.selectById(id);
if(chongwuYuyue !=null){
//entity转view
ChongwuYuyueView view = new ChongwuYuyueView();
BeanUtils.copyProperties( chongwuYuyue , view );//把实体数据重构到view中
//级联表
ChongwuEntity chongwu = chongwuService.selectById(chongwuYuyue.getChongwuId());
if(chongwu != null){
BeanUtils.copyProperties( chongwu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setChongwuId(chongwu.getId());
}
//级联表
YonghuEntity yonghu = yonghuService.selectById(chongwuYuyue.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ChongwuYuyueEntity chongwuYuyue, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,chongwuYuyue:{}",this.getClass().getName(),chongwuYuyue.toString());
Wrapper<ChongwuYuyueEntity> queryWrapper = new EntityWrapper<ChongwuYuyueEntity>()
.eq("chongwu_yuyue_uuid_number", chongwuYuyue.getChongwuYuyueUuidNumber())
.eq("chongwu_id", chongwuYuyue.getChongwuId())
.eq("yonghu_id", chongwuYuyue.getYonghuId())
.eq("chongwu_yuyue_text", chongwuYuyue.getChongwuYuyueText())
.in("chongwu_yuyue_yesno_types", new Integer[]{1,2})
.eq("chongwu_yuyue_yesno_text", chongwuYuyue.getChongwuYuyueYesnoText())
// .notIn("chongwu_yuyue_types", new Integer[]{102})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ChongwuYuyueEntity chongwuYuyueEntity = chongwuYuyueService.selectOne(queryWrapper);
if(chongwuYuyueEntity==null){
chongwuYuyue.setChongwuYuyueYesnoTypes(1);
chongwuYuyue.setInsertTime(new Date());
chongwuYuyue.setCreateTime(new Date());
chongwuYuyueService.insert(chongwuYuyue);
return R.ok();
}else {
if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes()==1)
return R.error(511,"有相同的待审核的数据");
else if(chongwuYuyueEntity.getChongwuYuyueYesnoTypes()==2)
return R.error(511,"有相同的审核通过的数据");
else
return R.error(511,"表中有相同数据");
}
}
}