#x1f34a;心愿#xff1a;点…

源码、代码讲解、文档撰写、ppt制作。

做自己喜欢的事生活就是快乐的。

心愿点赞

不然下次找不到哟~Java毕业设计项目~热门选题推荐《1000套》

技术选型

springboot、mybatisplus、vue、elementui、html、css、js、mysql、jdk1.8

数据库表结构

登录首页个人中心管理员管理基础数据管理房间信息管理论坛管理公告信息管理用户管理轮播图管理

项目演示截图

token(id,userid,username,tablename,role,token,addtime,expiratedtime)

values

(1,1,admin,users,管理员,eujhisuzw4wbe4v31vxpnknzf6n1gi81,2022-04-13

11:12:35,2022-04-13

12:21:31),(2,1,a1,yonghu,用户,1t7hsw4ap15wq61c3zxp8c33e15qyq2f,2022-04-13

11:13:53,2022-04-13

com.alibaba.fastjson.JSONObject;

import

org.springframework.beans.BeanUtils;

import

javax.servlet.http.HttpServletRequest;

import

org.springframework.web.context.ContextLoader;

import

java.lang.reflect.InvocationTargetException;import

import

org.apache.commons.lang3.StringUtils;

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

LoggerFactory.getLogger(FangjianController.class);Autowiredprivate

FangjianService

fangjianService;Autowiredprivate

TokenService

dictionaryService;//级联表serviceAutowiredprivate

YonghuService

后端列表*/RequestMapping(/page)public

page(RequestParam

request){logger.debug(page方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));String

role

String.valueOf(request.getSession().getAttribute(role));if(false)return

if(用户.equals(role))params.put(yonghuId,request.getSession().getAttribute(userId));if(params.get(orderBy)null

params.get(orderBy)){params.put(orderBy,id);}PageUtils

page

fangjianService.queryPage(params);//字典表数据转换ListFangjianView

list

(ListFangjianView)page.getList();for(FangjianView

c:list){//修改对应字典表字段dictionaryService.dictionaryConvert(c,

request);}return

后端详情*/RequestMapping(/info/{id})public

Long

request){logger.debug(info方法:,,Controller:{},,id:{},this.getClass().getName(),id);FangjianEntity

fangjian

fangjianService.selectById(id);if(fangjian

!null){//entity转viewFangjianView

view

FangjianView();BeanUtils.copyProperties(

fangjian

);//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view,

request);return

后端保存*/RequestMapping(/save)public

save(RequestBody

request){logger.debug(save方法:,,Controller:{},,fangjian:{},this.getClass().getName(),fangjian.toString());String

role

String.valueOf(request.getSession().getAttribute(role));if(false)return

R.error(511,永远不会进入);WrapperFangjianEntity

queryWrapper

EntityWrapperFangjianEntity().eq(fangjian_name,

fangjian.getFangjianName()).eq(fangjian_tese,

fangjian.getFangjianTese()).eq(fangjian_peizhi,

fangjian.getFangjianPeizhi()).eq(fangjian_shangpin,

fangjian.getFangjianShangpin()).eq(fangjian_fuwu,

fangjian.getFangjianFuwu()).eq(fangjian_types,

fangjian.getFangjianTypes()).eq(fangjian_number,

fangjian.getFangjianNumber()).eq(fangjian_clicknum,

fangjian.getFangjianClicknum());logger.info(sql语句:queryWrapper.getSqlSegment());FangjianEntity

fangjianEntity

fangjianService.selectOne(queryWrapper);if(fangjianEntitynull){fangjian.setFangjianClicknum(1);fangjian.setCreateTime(new

Date());fangjianService.insert(fangjian);return

R.ok();}else

后端修改*/RequestMapping(/update)public

update(RequestBody

request){logger.debug(update方法:,,Controller:{},,fangjian:{},this.getClass().getName(),fangjian.toString());String

role

String.valueOf(request.getSession().getAttribute(role));//根据字段查询是否有相同数据WrapperFangjianEntity

queryWrapper

EntityWrapperFangjianEntity().notIn(id,fangjian.getId()).andNew().eq(fangjian_name,

fangjian.getFangjianName()).eq(fangjian_tese,

fangjian.getFangjianTese()).eq(fangjian_peizhi,

fangjian.getFangjianPeizhi()).eq(fangjian_shangpin,

fangjian.getFangjianShangpin()).eq(fangjian_fuwu,

fangjian.getFangjianFuwu()).eq(fangjian_types,

fangjian.getFangjianTypes()).eq(fangjian_number,

fangjian.getFangjianNumber()).eq(fangjian_clicknum,

fangjian.getFangjianClicknum());logger.info(sql语句:queryWrapper.getSqlSegment());FangjianEntity

fangjianEntity

fangjianService.selectOne(queryWrapper);if(.equals(fangjian.getFangjianPhoto())

null.equals(fangjian.getFangjianPhoto())){fangjian.setFangjianPhoto(null);}if(fangjianEntitynull){fangjianService.updateById(fangjian);//根据id更新return

R.ok();}else

删除*/RequestMapping(/delete)public

delete(RequestBody

ids){logger.debug(delete:,,Controller:{},,ids:{},this.getClass().getName(),ids.toString());fangjianService.deleteBatchIds(Arrays.asList(ids));return

R.ok();}/***

批量上传*/RequestMapping(/batchInsert)public

save(

request){logger.debug(batchInsert方法:,,Controller:{},,fileName:{},this.getClass().getName(),fileName);Integer

yonghuId

Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId)));SimpleDateFormat

sdf

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/

file

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){//循环FangjianEntity

fangjianEntity

FangjianEntity();fangjianList.add(fangjianEntity);//把要查询是否重复的字段放入map中}//查询是否重复fangjianService.insertBatch(fangjianList);return

R.ok();}}}}catch

R.error(511,批量插入数据异常请联系管理员);}}/***

前端列表*/IgnoreAuthRequestMapping(/list)public

list(RequestParam

request){logger.debug(list方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));//

没有指定排序字段就默认id倒序if(StringUtil.isEmpty(String.valueOf(params.get(orderBy)))){params.put(orderBy,id);}PageUtils

page

fangjianService.queryPage(params);//字典表数据转换ListFangjianView

list

(ListFangjianView)page.getList();for(FangjianView

c:list)dictionaryService.dictionaryConvert(c,

request);

前端详情*/RequestMapping(/detail/{id})public

Long

request){logger.debug(detail方法:,,Controller:{},,id:{},this.getClass().getName(),id);FangjianEntity

fangjian

fangjianService.selectById(id);if(fangjian

!null){//点击数量加1fangjian.setFangjianClicknum(fangjian.getFangjianClicknum()1);fangjianService.updateById(fangjian);//entity转viewFangjianView

view

FangjianView();BeanUtils.copyProperties(

fangjian

);//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view,

request);return

前端保存*/RequestMapping(/add)public

add(RequestBody

request){logger.debug(add方法:,,Controller:{},,fangjian:{},this.getClass().getName(),fangjian.toString());WrapperFangjianEntity

queryWrapper

EntityWrapperFangjianEntity().eq(fangjian_name,

fangjian.getFangjianName()).eq(fangjian_tese,

fangjian.getFangjianTese()).eq(fangjian_peizhi,

fangjian.getFangjianPeizhi()).eq(fangjian_shangpin,

fangjian.getFangjianShangpin()).eq(fangjian_fuwu,

fangjian.getFangjianFuwu()).eq(fangjian_types,

fangjian.getFangjianTypes()).eq(fangjian_number,

fangjian.getFangjianNumber()).eq(fangjian_clicknum,

fangjian.getFangjianClicknum());logger.info(sql语句:queryWrapper.getSqlSegment());FangjianEntity

fangjianEntity

fangjianService.selectOne(queryWrapper);if(fangjianEntitynull){fangjian.setCreateTime(new

Date());fangjianService.insert(fangjian);return

R.ok();}else