博主主页:一季春秋
博主简介:专注Java技术领域和毕业设计项目实战、Java、微信小程序、安卓等技术开发,远程调试部署、代码讲解、文档指导、ppt制作等技术指导。
主要内容:SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、小程序、安卓app、大数据等设计与开发精彩专栏推荐订阅👇🏻👇🏻 不然下次找不到哟
SpringBoot+Vue项目持续更新中
http://t.csdn.cn/1mgm8
🍅文末获取联系🍅
目录
一、项目介绍
管理系统根据需求分析设计出对应的功能,主要有这六个功能模板,包括用户管理功能、体育场地管理功能、场地分类管理、场地租赁管理、体育器材管理、器材分类管理、器材借用管理、器材归还管理、器材报废登记管理功能等。
主要实现体育器材管理、体育器材借还管理,体育器材场地租借管理,器材报废登记,用户留言反馈功能。
二、项目主要技术
开发语言:Java
使用框架:spring boot
前端技术:JavaScript、Vue 、css3
开发工具:IDEA/MyEclipse/Eclipse、Visual Studio Code
数据库:MySQL 5.7/8.0
数据库管理工具:phpstudy/Navicat
JDK版本:jdk1.8
Maven: apache-maven 3.8.1-bin
三、系统功能结构设计
本系统设计时,确定详细功能,这些功能主要通过需求阶段的调研分析得来的,具体功能模块如下图,如图所示。
四、系统实现
4.1 首页实现
在前台首页,主要有首页、体育场地、体育器材、公告信息、留言反馈、后台管理等主要模块。
4.2 体育场地
4.3 体育器材
4.4 管理员后台登录
4.5 体育场地管理
4.6 场地租赁管理
4.7 器材报废登记管理
五、实现代码
体育器材
/**
* 体育器材
* 后端接口
* @author
* @email
* @date 2023-01-14 16:19:24
*/
@RestController
@RequestMapping("/tiyuqicai")
public class TiyuqicaiController {
@Autowired
private TiyuqicaiService tiyuqicaiService;
@Autowired
private StoreupService storeupService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,TiyuqicaiEntity tiyuqicai,
HttpServletRequest request){
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
PageUtils page = tiyuqicaiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tiyuqicai), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,TiyuqicaiEntity tiyuqicai,
HttpServletRequest request){
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
PageUtils page = tiyuqicaiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tiyuqicai), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( TiyuqicaiEntity tiyuqicai){
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
ew.allEq(MPUtil.allEQMapPre( tiyuqicai, "tiyuqicai"));
return R.ok().put("data", tiyuqicaiService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(TiyuqicaiEntity tiyuqicai){
EntityWrapper< TiyuqicaiEntity> ew = new EntityWrapper< TiyuqicaiEntity>();
ew.allEq(MPUtil.allEQMapPre( tiyuqicai, "tiyuqicai"));
TiyuqicaiView tiyuqicaiView = tiyuqicaiService.selectView(ew);
return R.ok("查询体育器材成功").put("data", tiyuqicaiView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
TiyuqicaiEntity tiyuqicai = tiyuqicaiService.selectById(id);
return R.ok().put("data", tiyuqicai);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
TiyuqicaiEntity tiyuqicai = tiyuqicaiService.selectById(id);
return R.ok().put("data", tiyuqicai);
}
/**
* 赞或踩
*/
@RequestMapping("/thumbsup/{id}")
public R vote(@PathVariable("id") String id,String type){
TiyuqicaiEntity tiyuqicai = tiyuqicaiService.selectById(id);
if(type.equals("1")) {
tiyuqicai.setThumbsupnum(tiyuqicai.getThumbsupnum()+1);
} else {
tiyuqicai.setCrazilynum(tiyuqicai.getCrazilynum()+1);
}
tiyuqicaiService.updateById(tiyuqicai);
return R.ok("投票成功");
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody TiyuqicaiEntity tiyuqicai, HttpServletRequest request){
tiyuqicai.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tiyuqicai);
tiyuqicaiService.insert(tiyuqicai);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody TiyuqicaiEntity tiyuqicai, HttpServletRequest request){
tiyuqicai.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tiyuqicai);
tiyuqicaiService.insert(tiyuqicai);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
public R update(@RequestBody TiyuqicaiEntity tiyuqicai, HttpServletRequest request){
//ValidatorUtils.validateEntity(tiyuqicai);
tiyuqicaiService.updateById(tiyuqicai);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
tiyuqicaiService.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<TiyuqicaiEntity> wrapper = new EntityWrapper<TiyuqicaiEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = tiyuqicaiService.selectCount(wrapper);
return R.ok().put("count", count);
}
/**
* (按值统计)
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}")
public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
List<Map<String, Object>> result = tiyuqicaiService.selectValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计)时间统计类型
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
params.put("timeStatType", timeStatType);
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
List<Map<String, Object>> result = tiyuqicaiService.selectTimeStatValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 分组统计
*/
@RequestMapping("/group/{columnName}")
public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("column", columnName);
EntityWrapper<TiyuqicaiEntity> ew = new EntityWrapper<TiyuqicaiEntity>();
List<Map<String, Object>> result = tiyuqicaiService.selectGroup(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
}