以下为本人作品案例展示,供学弟妹妹参考,有需求欢迎咨询!
大学餐厅菜品推荐和点评系统设计与实现
使用旧方法对大学餐厅菜品推荐和点评信息进行系统化管理已经不再让人们信赖了,把现在的网络信息技术运用在大学餐厅菜品推荐和点评信息的管理上面可以解决许多信息管理上面的难题,比如处理数据时间很长,数据存在错误不能及时纠正等问题。
这次开发的大学餐厅菜品推荐和点评系统管理员和用户。管理员功能有个人中心,用户管理,菜品分类管理,菜品信息管理,菜品订单管理,菜品评价管理,系统管理等。用户可以注册登录,购买菜品,菜品评价等。经过前面自己查阅的网络知识,加上自己在学校课堂上学习的知识,决定开发系统选择B/S模式这种高效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网站访问,采用的主流的Java语言这种面向对象的语言进行大学餐厅菜品推荐和点评系统程序的开发,在数据库的选择上面,选择功能强大的MySQL数据库进行数据的存放操作。
大学餐厅菜品推荐和点评系统被人们投放于现在的生活中进行使用,该款管理类软件就可以让管理人员处理信息的时间介于十几秒之间。在这十几秒内就能完成信息的编辑等操作。有了这样的管理软件,大学餐厅菜品推荐和点评信息的管理就离无纸化办公的目标更贴近了。
Java SSM餐厅点餐系统,后端基于SSM框架进行开发设计,前端页面效果通过使用Vue进行编码实现,主要实现了用户跟管理员角色,将实现菜品订单管理、菜品评价管理等功能。
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://127.0.0.1:3306/ssm7q964?useUnicode=true&characterEncoding=UTF-8&tinyInt1isBit=false
jdbc_username=root
jdbc_password=123456
#jdbc_url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ssm7q964
#jdbc_username=sa
#jdbc_password=123456
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 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.CaipinpingjiaEntity;
import com.entity.view.CaipinpingjiaView;
import com.service.CaipinpingjiaService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
/**
-
菜品评价
-
后端接口
-
@author
-
@email
-
@date 2021-05-08 09:36:22
*/
@RestController
@RequestMapping(“/caipinpingjia”)
public class CaipinpingjiaController {
@Autowired
private CaipinpingjiaService caipinpingjiaService;/**
-
后端列表
*/
@RequestMapping(“/page”)
public R page(@RequestParam Map<String, Object> params,CaipinpingjiaEntity caipinpingjia,
HttpServletRequest request){String tableName = request.getSession().getAttribute(“tableName”).toString();
if(tableName.equals(“yonghu”)) {
caipinpingjia.setYonghuming((String)request.getSession().getAttribute(“username”));
}
EntityWrapper ew = new EntityWrapper();
PageUtils page = caipinpingjiaService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, caipinpingjia), params), params));
return R.ok().put(“data”, page);
}
/**
- 前端列表
*/
@RequestMapping(“/list”)
public R list(@RequestParam Map<String, Object> params,CaipinpingjiaEntity caipinpingjia,
HttpServletRequest request){
EntityWrapper ew = new EntityWrapper();
PageUtils page = caipinpingjiaService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, caipinpingjia), params), params));
return R.ok().put(“data”, page);
}
/**
- 列表
*/
@RequestMapping(“/lists”)
public R list( CaipinpingjiaEntity caipinpingjia){
EntityWrapper ew = new EntityWrapper();
ew.allEq(MPUtil.allEQMapPre( caipinpingjia, “caipinpingjia”));
return R.ok().put(“data”, caipinpingjiaService.selectListView(ew));
}
/**
- 查询
*/
@RequestMapping(“/query”)
public R query(CaipinpingjiaEntity caipinpingjia){
EntityWrapper< CaipinpingjiaEntity> ew = new EntityWrapper< CaipinpingjiaEntity>();
ew.allEq(MPUtil.allEQMapPre( caipinpingjia, “caipinpingjia”));
CaipinpingjiaView caipinpingjiaView = caipinpingjiaService.selectView(ew);
return R.ok(“查询菜品评价成功”).put(“data”, caipinpingjiaView);
}
/**
- 后端详情
*/
@RequestMapping(“/info/{id}”)
public R info(@PathVariable(“id”) Long id){
CaipinpingjiaEntity caipinpingjia = caipinpingjiaService.selectById(id);
return R.ok().put(“data”, caipinpingjia);
}
/**
- 前端详情
*/
@RequestMapping(“/detail/{id}”)
public R detail(@PathVariable(“id”) Long id){
CaipinpingjiaEntity caipinpingjia = caipinpingjiaService.selectById(id);
return R.ok().put(“data”, caipinpingjia);
}
/**
-
后端保存
*/
@RequestMapping(“/save”)
public R save(@RequestBody CaipinpingjiaEntity caipinpingjia, HttpServletRequest request){
caipinpingjia.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(caipinpingjia);caipinpingjiaService.insert(caipinpingjia);
return R.ok();
}
/**
-
前端保存
*/
@RequestMapping(“/add”)
public R add(@RequestBody CaipinpingjiaEntity caipinpingjia, HttpServletRequest request){
caipinpingjia.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(caipinpingjia);caipinpingjiaService.insert(caipinpingjia);
return R.ok();
}
/**
- 修改
*/
@RequestMapping(“/update”)
public R update(@RequestBody CaipinpingjiaEntity caipinpingjia, HttpServletRequest request){
//ValidatorUtils.validateEntity(caipinpingjia);
caipinpingjiaService.updateById(caipinpingjia);//全部更新
return R.ok();
}
/**
- 删除
*/
@RequestMapping(“/delete”)
public R delete(@RequestBody Long[] ids){
caipinpingjiaService.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 wrapper = new EntityWrapper();
if(map.get(“remindstart”)!=null) {
wrapper.ge(columnName, map.get(“remindstart”));
}
if(map.get(“remindend”)!=null) {
wrapper.le(columnName, map.get(“remindend”));
}String tableName = request.getSession().getAttribute(“tableName”).toString();
if(tableName.equals(“yonghu”)) {
wrapper.eq(“yonghuming”, (String)request.getSession().getAttribute(“username”));
}int count = caipinpingjiaService.selectCount(wrapper);
return R.ok().put(“count”, count);
}
-
}
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 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.StoreupEntity;
import com.entity.view.StoreupView;
import com.service.StoreupService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
/**
-
收藏表
-
后端接口
-
@author
-
@email
-
@date 2021-05-08 09:36:22
*/
@RestController
@RequestMapping(“/storeup”)
public class StoreupController {
@Autowired
private StoreupService storeupService;/**
-
后端列表
*/
@RequestMapping(“/page”)
public R page(@RequestParam Map<String, Object> params,StoreupEntity storeup,
HttpServletRequest request){
if(!request.getSession().getAttribute(“role”).toString().equals(“管理员”)) {
storeup.setUserid((Long)request.getSession().getAttribute(“userId”));
}EntityWrapper ew = new EntityWrapper();
PageUtils page = storeupService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, storeup), params), params));
return R.ok().put(“data”, page);
}
/**
-
前端列表
*/
@RequestMapping(“/list”)
public R list(@RequestParam Map<String, Object> params,StoreupEntity storeup,
HttpServletRequest request){
if(!request.getSession().getAttribute(“role”).toString().equals(“管理员”)) {
storeup.setUserid((Long)request.getSession().getAttribute(“userId”));
}EntityWrapper ew = new EntityWrapper();
PageUtils page = storeupService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, storeup), params), params));
return R.ok().put(“data”, page);
}
/**
- 列表
*/
@RequestMapping(“/lists”)
public R list( StoreupEntity storeup){
EntityWrapper ew = new EntityWrapper();
ew.allEq(MPUtil.allEQMapPre( storeup, “storeup”));
return R.ok().put(“data”, storeupService.selectListView(ew));
}
/**
- 查询
*/
@RequestMapping(“/query”)
public R query(StoreupEntity storeup){
EntityWrapper< StoreupEntity> ew = new EntityWrapper< StoreupEntity>();
ew.allEq(MPUtil.allEQMapPre( storeup, “storeup”));
StoreupView storeupView = storeupService.selectView(ew);
return R.ok(“查询收藏表成功”).put(“data”, storeupView);
}
/**
- 后端详情
*/
@RequestMapping(“/info/{id}”)
public R info(@PathVariable(“id”) Long id){
StoreupEntity storeup = storeupService.selectById(id);
return R.ok().put(“data”, storeup);
}
/**
- 前端详情
*/
@RequestMapping(“/detail/{id}”)
public R detail(@PathVariable(“id”) Long id){
StoreupEntity storeup = storeupService.selectById(id);
return R.ok().put(“data”, storeup);
}
/**
-
后端保存
*/
@RequestMapping(“/save”)
public R save(@RequestBody StoreupEntity storeup, HttpServletRequest request){
storeup.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(storeup);
storeup.setUserid((Long)request.getSession().getAttribute(“userId”));storeupService.insert(storeup);
return R.ok();
}
/**
-
前端保存
*/
@RequestMapping(“/add”)
public R add(@RequestBody StoreupEntity storeup, HttpServletRequest request){
storeup.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(storeup);
storeup.setUserid((Long)request.getSession().getAttribute(“userId”));storeupService.insert(storeup);
return R.ok();
}
/**
- 修改
*/
@RequestMapping(“/update”)
public R update(@RequestBody StoreupEntity storeup, HttpServletRequest request){
//ValidatorUtils.validateEntity(storeup);
storeupService.updateById(storeup);//全部更新
return R.ok();
}
/**
- 删除
*/
@RequestMapping(“/delete”)
public R delete(@RequestBody Long[] ids){
storeupService.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 wrapper = new EntityWrapper();
if(map.get(“remindstart”)!=null) {
wrapper.ge(columnName, map.get(“remindstart”));
}
if(map.get(“remindend”)!=null) {
wrapper.le(columnName, map.get(“remindend”));
}
if(!request.getSession().getAttribute(“role”).toString().equals(“管理员”)) {
wrapper.eq(“userid”, (Long)request.getSession().getAttribute(“userId”));
}int count = storeupService.selectCount(wrapper);
return R.ok().put(“count”, count);
}
-
}
package com.controller;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
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.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;
/**
-
登录相关
*/
@RequestMapping(“users”)
@RestController
public class UserController{@Autowired
private UserService userService;@Autowired
private TokenService tokenService;/**
- 登录
*/
@IgnoreAuth
@PostMapping(value = “/login”)
public R login(String username, String password, String captcha, HttpServletRequest request) {
UserEntity user = userService.selectOne(new EntityWrapper().eq(“username”, username));
if(user==null || !user.getPassword().equals(password)) {
return R.error(“账号或密码不正确”);
}
String token = tokenService.generateToken(user.getId(),username, “users”, user.getRole());
return R.ok().put(“token”, token);
}
/**
- 注册
*/
@IgnoreAuth
@PostMapping(value = “/register”)
public R register(@RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);
if(userService.selectOne(new EntityWrapper().eq(“username”, user.getUsername())) !=null) {
return R.error(“用户已存在”);
}
userService.insert(user);
return R.ok();
}
/**
- 退出
*/
@GetMapping(value = “logout”)
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok(“退出成功”);
}
/**
- 密码重置
*/
@IgnoreAuth
@RequestMapping(value = “/resetPass”)
public R resetPass(String username, HttpServletRequest request){
UserEntity user = userService.selectOne(new EntityWrapper().eq(“username”, username));
if(user==null) {
return R.error(“账号不存在”);
}
user.setPassword(“123456”);
userService.update(user,null);
return R.ok(“密码已重置为:123456”);
}
/**
- 列表
*/
@RequestMapping(“/page”)
public R page(@RequestParam Map<String, Object> params,UserEntity user){
EntityWrapper ew = new EntityWrapper();
PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
return R.ok().put(“data”, page);
}
/**
- 列表
*/
@RequestMapping(“/list”)
public R list( UserEntity user){
EntityWrapper ew = new EntityWrapper();
ew.allEq(MPUtil.allEQMapPre( user, “user”));
return R.ok().put(“data”, userService.selectListView(ew));
}
/**
- 信息
*/
@RequestMapping(“/info/{id}”)
public R info(@PathVariable(“id”) String id){
UserEntity user = userService.selectById(id);
return R.ok().put(“data”, user);
}
/**
- 获取用户的session用户信息
*/
@RequestMapping(“/session”)
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute(“userId”);
UserEntity user = userService.selectById(id);
return R.ok().put(“data”, user);
}
/**
- 保存
*/
@PostMapping(“/save”)
public R save(@RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);
if(userService.selectOne(new EntityWrapper().eq(“username”, user.getUsername())) !=null) {
return R.error(“用户已存在”);
}
userService.insert(user);
return R.ok();
}
/**
- 修改
*/
@RequestMapping(“/update”)
public R update(@RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);
UserEntity u = userService.selectOne(new EntityWrapper().eq(“username”, user.getUsername()));
if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
return R.error(“用户名已存在。”);
}
userService.updateById(user);//全部更新
return R.ok();
}
/**
- 删除
*/
@RequestMapping(“/delete”)
public R delete(@RequestBody Long[] ids){
userService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
}
- 登录