系统功能：
用户端：
登录注册首页浏览乐器信息发表评论分类筛选乐器查询乐器资讯在线客服加入购物车乐器收藏提交订单地址管理个人中心收藏管理订单管理退出登录
管理员端：
系统登录个人中心用户管理乐器分类管理乐器信息管理订单评价管理订单管理系统管理（轮播图管理、乐器资讯管理、在线客服管理）退出登录
页面效果：
核心代码：
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 mons.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.ShangpinxinxiEntity;import com.entity.view.ShangpinxinxiView;import com.service.ShangpinxinxiService;import com.service.TokenService;import com.utils.PageUtils;import com.utils.R;import com.utils.MD5Util;import com.utils.MPUtil;import monUtil;/*** 飞机信息* 后端接口* @author* @email*/@RestController@RequestMapping("/shangpinxinxi")public class ShangpinxinxiController {@Autowiredprivate ShangpinxinxiService shangpinxinxiService;/*** 后端列表*/@RequestMapping("/page")public R page(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi,HttpServletRequest request){EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));return R.ok().put("data", page);}/*** 前端列表*/@IgnoreAuth@RequestMapping("/list")public R list(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));return R.ok().put("data", page);}/*** 列表*/@RequestMapping("/lists")public R list( ShangpinxinxiEntity shangpinxinxi){EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();ew.allEq(MPUtil.allEQMapPre( shangpinxinxi, "shangpinxinxi"));return R.ok().put("data", shangpinxinxiService.selectListView(ew));}/*** 查询*/@RequestMapping("/query")public R query(ShangpinxinxiEntity shangpinxinxi){EntityWrapper< ShangpinxinxiEntity> ew = new EntityWrapper< ShangpinxinxiEntity>();ew.allEq(MPUtil.allEQMapPre( shangpinxinxi, "shangpinxinxi"));ShangpinxinxiView shangpinxinxiView = shangpinxinxiService.selectView(ew);return R.ok("查询飞机信息成功").put("data", shangpinxinxiView);}/*** 后端详情*/@RequestMapping("/info/{id}")public R info(@PathVariable("id") Long id){ShangpinxinxiEntity shangpinxinxi = shangpinxinxiService.selectById(id);shangpinxinxi.setClicknum(shangpinxinxi.getClicknum()+1);shangpinxinxi.setClicktime(new Date());shangpinxinxiService.updateById(shangpinxinxi);return R.ok().put("data", shangpinxinxi);}/*** 前端详情*/@IgnoreAuth@RequestMapping("/detail/{id}")public R detail(@PathVariable("id") Long id){ShangpinxinxiEntity shangpinxinxi = shangpinxinxiService.selectById(id);shangpinxinxi.setClicknum(shangpinxinxi.getClicknum()+1);shangpinxinxi.setClicktime(new Date());shangpinxinxiService.updateById(shangpinxinxi);return R.ok().put("data", shangpinxinxi);}/*** 后端保存*/@RequestMapping("/save")public R save(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){shangpinxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(shangpinxinxi);shangpinxinxiService.insert(shangpinxinxi);return R.ok();}/*** 前端保存*/@RequestMapping("/add")public R add(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){shangpinxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(shangpinxinxi);shangpinxinxiService.insert(shangpinxinxi);return R.ok();}/*** 修改*/@RequestMapping("/update")public R update(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){//ValidatorUtils.validateEntity(shangpinxinxi);shangpinxinxiService.updateById(shangpinxinxi);//全部更新return R.ok();}/*** 删除*/@RequestMapping("/delete")public R delete(@RequestBody Long[] ids){shangpinxinxiService.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<ShangpinxinxiEntity> wrapper = new EntityWrapper<ShangpinxinxiEntity>();if(map.get("remindstart")!=null) {wrapper.ge(columnName, map.get("remindstart"));}if(map.get("remindend")!=null) {wrapper.le(columnName, map.get("remindend"));}int count = shangpinxinxiService.selectCount(wrapper);return R.ok().put("count", count);}/*** 前端智能排序*/@IgnoreAuth@RequestMapping("/autoSort")public R autoSort(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request,String pre){EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();Map<String, Object> newMap = new HashMap<String, Object>();Map<String, Object> param = new HashMap<String, Object>();Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();while (it.hasNext()) {Map.Entry<String, Object> entry = it.next();String key = entry.getKey();String newKey = entry.getKey();if (pre.endsWith(".")) {newMap.put(pre + newKey, entry.getValue());} else if (StringUtils.isEmpty(pre)) {newMap.put(newKey, entry.getValue());} else {newMap.put(pre + "." + newKey, entry.getValue());}}params.put("sort", "clicknum");params.put("order", "desc");PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));return R.ok().put("data", page);}}package com.service.impl;import org.springframework.stereotype.Service;import java.util.Map;import java.util.List;import com.baomidou.mybatisplus.mapper.Wrapper;import com.baomidou.mybatisplus.mapper.EntityWrapper;import com.baomidou.mybatisplus.plugins.Page;import com.baomidou.mybatisplus.service.impl.ServiceImpl;import com.utils.PageUtils;import com.utils.Query;import com.dao.ShangpinxinxiDao;import com.entity.ShangpinxinxiEntity;import com.service.ShangpinxinxiService;import com.entity.vo.ShangpinxinxiVO;import com.entity.view.ShangpinxinxiView;@Service("shangpinxinxiService")public class ShangpinxinxiServiceImpl extends ServiceImpl<ShangpinxinxiDao, ShangpinxinxiEntity> implements ShangpinxinxiService {@Overridepublic PageUtils queryPage(Map<String, Object> params) {Page<ShangpinxinxiEntity> page = this.selectPage(new Query<ShangpinxinxiEntity>(params).getPage(),new EntityWrapper<ShangpinxinxiEntity>());return new PageUtils(page);}@Overridepublic PageUtils queryPage(Map<String, Object> params, Wrapper<ShangpinxinxiEntity> wrapper) {Page<ShangpinxinxiView> page =new Query<ShangpinxinxiView>(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil = new PageUtils(page);return pageUtil;}@Overridepublic List<ShangpinxinxiVO> selectListVO(Wrapper<ShangpinxinxiEntity> wrapper) {return baseMapper.selectListVO(wrapper);}@Overridepublic ShangpinxinxiVO selectVO(Wrapper<ShangpinxinxiEntity> wrapper) {return baseMapper.selectVO(wrapper);}@Overridepublic List<ShangpinxinxiView> selectListView(Wrapper<ShangpinxinxiEntity> wrapper) {return baseMapper.selectListView(wrapper);}@Overridepublic ShangpinxinxiView selectView(Wrapper<ShangpinxinxiEntity> wrapper) {return baseMapper.selectView(wrapper);}}package com.dao;import com.entity.ShangpinxinxiEntity;import com.baomidou.mybatisplus.mapper.BaseMapper;import java.util.List;import com.baomidou.mybatisplus.mapper.Wrapper;import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;import com.entity.vo.ShangpinxinxiVO;import com.entity.view.ShangpinxinxiView;/*** 飞机信息** @author* @email*/public interface ShangpinxinxiDao extends BaseMapper<ShangpinxinxiEntity> {List<ShangpinxinxiVO> selectListVO(@Param("ew") Wrapper<ShangpinxinxiEntity> wrapper);ShangpinxinxiVO selectVO(@Param("ew") Wrapper<ShangpinxinxiEntity> wrapper);List<ShangpinxinxiView> selectListView(@Param("ew") Wrapper<ShangpinxinxiEntity> wrapper);List<ShangpinxinxiView> selectListView(Pagination page,@Param("ew") Wrapper<ShangpinxinxiEntity> wrapper);ShangpinxinxiView selectView(@Param("ew") Wrapper<ShangpinxinxiEntity> wrapper);}package com.entity;import com.baomidou.mybatisplus.annotations.TableId;import com.baomidou.mybatisplus.annotations.TableName;import javax.validation.constraints.NotBlank;import javax.validation.constraints.NotEmpty;import javax.validation.constraints.NotNull;import com.fasterxml.jackson.annotation.JsonIgnoreProperties;import java.lang.reflect.InvocationTargetException;import java.io.Serializable;import java.util.Date;import java.util.List;import org.springframework.format.annotation.DateTimeFormat;import com.fasterxml.jackson.annotation.JsonFormat;import mons.beanutils.BeanUtils;import com.baomidou.mybatisplus.annotations.TableField;import com.baomidou.mybatisplus.enums.FieldFill;import com.baomidou.mybatisplus.enums.IdType;/*** 飞机信息* 数据库通用操作实体类（普通增删改查）* @author* @email*/@TableName("shangpinxinxi")public class ShangpinxinxiEntity<T> implements Serializable {private static final long serialVersionUID = 1L;public ShangpinxinxiEntity() {}public ShangpinxinxiEntity(T t) {try {BeanUtils.copyProperties(this, t);} catch (IllegalAccessException | InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/*** 主键id*/@TableIdprivate Long id;/*** 飞机名称*/private String shangpinmingcheng;/*** 飞机舱位*/private String shangpinfenlei;/*** 图片*/private String tupian;/*** 起点*/private String pinpai;/*** 评分*/private String guige;/*** 飞机详情*/private String shangpinxiangqing;/*** 最近点击时间*/@JsonFormat(locale="zh", timezone="GMT+8", pattern="yyyy-MM-dd HH:mm:ss")@DateTimeFormatprivate Date clicktime;/*** 点击次数*/private Integer clicknum;/*** 价格*/private Float price;@JsonFormat(locale="zh", timezone="GMT+8", pattern="yyyy-MM-dd HH:mm:ss")@DateTimeFormatprivate Date addtime;public Date getAddtime() {return addtime;}public void setAddtime(Date addtime) {this.addtime = addtime;}private String startdate;public String getStartdate() {return startdate;}public void setStartdate(String startdate) {this.startdate = startdate;}public Long getId() {return id;}public void setId(Long id) {this.id = id;}/*** 设置：飞机名称*/public void setShangpinmingcheng(String shangpinmingcheng) {this.shangpinmingcheng = shangpinmingcheng;}/*** 获取：飞机名称*/public String getShangpinmingcheng() {return shangpinmingcheng;}/*** 设置：飞机舱位*/public void setShangpinfenlei(String shangpinfenlei) {this.shangpinfenlei = shangpinfenlei;}/*** 获取：飞机舱位*/public String getShangpinfenlei() {return shangpinfenlei;}/*** 设置：图片*/public void setTupian(String tupian) {this.tupian = tupian;}/*** 获取：图片*/public String getTupian() {return tupian;}/*** 设置：起点*/public void setPinpai(String pinpai) {this.pinpai = pinpai;}/*** 获取：起点*/public String getPinpai() {return pinpai;}/*** 设置：评分*/public void setGuige(String guige) {this.guige = guige;}/*** 获取：评分*/public String getGuige() {return guige;}/*** 设置：飞机详情*/public void setShangpinxiangqing(String shangpinxiangqing) {this.shangpinxiangqing = shangpinxiangqing;}/*** 获取：飞机详情*/public String getShangpinxiangqing() {return shangpinxiangqing;}/*** 设置：最近点击时间*/public void setClicktime(Date clicktime) {this.clicktime = clicktime;}/*** 获取：最近点击时间*/public Date getClicktime() {return clicktime;}/*** 设置：点击次数*/public void setClicknum(Integer clicknum) {this.clicknum = clicknum;}/*** 获取：点击次数*/public Integer getClicknum() {return clicknum;}/*** 设置：价格*/public void setPrice(Float price) {this.price = price;}/*** 获取：价格*/public Float getPrice() {return price;}}
