文章目录
详细视频演示
文章底部名片,获取项目的完整演示视频,免费解答技术疑问
项目介绍
如今的信息时代,对信息的共享性,信息的流通性有着较高要求,因此传统管理方式就不适合。为了让管理模式进行升级,也为了更好的维护信息,高校后勤网上报修系统的开发运用就显得很有必要。并且通过开发高校后勤网上报修系统,不仅可以让所学的微信小程序技术得到实际运用,也可以掌握MySQL的使用方法,对自身编程能力也有一个检验和提升的过程。尤其是通过实践,可以对系统的开发流程加深印象,无论是前期的分析与设计,还是后期的编码测试等环节,都可以有一个深刻的了解。
借助于高校后勤网上报修系统这样的工具,让信息系统化,流程化,规范化是最终的发展结果,让其遵循实际操作流程的情况下,对信息实施规范化处理,让信息通过电子的方式进行保存,无论是管理人员检索信息,可以便利化操作,真正缩短信息处理时间,节省人力和信息管理的成本。
技术介绍
开发语言:Java
框架:springboot
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven
安卓框架:uniapp
安卓开发软件:HBuilder X
开发模式:混合开发
功能介绍
这部分内容使用结构图这样的工具,显示设计结果,设计的管理员功能见下图。管理员为用户忘记密码时可以重置用户密码,管理在线申报、商品收藏、商品订单、公告信息、及配件申请,
图4-1 管理员功能结构图
核心代码
package com.example.controller;
import cn.hutool.core.util.StrUtil;
import cn.hutool.crypto.SecureUtil;
import com.example.common.Result;
import com.example.common.ResultCode;
import com.example.entity.Caiwu;
import com.example.exception.CustomException;
import com.example.service.CaiwuService;
import com.example.utils.MapWrapperUtils;
import com.example.utils.jwt.JwtUtil;
import com.example.vo.CaiwuVo;
import org.springframework.beans.BeanUtils;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@RestController
@RequestMapping(value = "/caiwu")
public class CaiwuController {
@Resource
private CaiwuService caiwuService;
@PostMapping
public Result<Caiwu> add(@RequestBody CaiwuVo caiwu) {
caiwuService.add(caiwu);
return Result.success(caiwu);
}
@PostMapping("/deleteList")
public Result<Caiwu> deleteList(@RequestBody CaiwuVo caiwu) {
caiwuService.deleteList(caiwu.getList());
return Result.success();
}
@DeleteMapping("/{id}")
public Result delete(@PathVariable Long id) {
caiwuService.delete(id);
return Result.success();
}
@PutMapping
public Result update(@RequestBody CaiwuVo caiwu) {
caiwuService.update(caiwu);
return Result.success();
}
@GetMapping("/{id}")
public Result<Caiwu> detail(@PathVariable Integer id) {
Caiwu caiwu = caiwuService.findById(id);
return Result.success(caiwu);
}
@GetMapping
public Result<List<Caiwu>> all() {
return Result.success(caiwuService.list());
}
@PostMapping("/page")
public Result<CaiwuVo> page(@RequestBody CaiwuVo caiwuVo) {
return Result.success(caiwuService.findPage(caiwuVo));
}
@PostMapping("/login")
public Result login(@RequestBody Caiwu caiwu, HttpServletRequest request) {
if (StrUtil.isBlank(caiwu.getZhanghao()) || StrUtil.isBlank(caiwu.getMima())) {
throw new CustomException(ResultCode.PARAM_LOST_ERROR);
}
Caiwu login = caiwuService.login(caiwu);
// if(!login.getStatus()){
// return Result.error("1001","状态限制,无法登录系统");
// }
if(login != null) {
HashMap hashMap = new HashMap();
hashMap.put("user", login);
Map<String, Object> map = MapWrapperUtils.builder(MapWrapperUtils.KEY_USER_ID,caiwu.getId());
String token = JwtUtil.creatToken(map);
hashMap.put("token", token);
return Result.success(hashMap);
}else {
return Result.error();
}
}
@PutMapping("/updatePassword")
public Result updatePassword(@RequestBody Caiwu info, HttpServletRequest request) {
Caiwu caiwu = caiwuService.findById(info.getId());
String oldPassword = SecureUtil.md5(info.getMima());
if (!oldPassword.equals(caiwu.getMima())) {
return Result.error(ResultCode.PARAM_PASSWORD_ERROR.code, ResultCode.PARAM_PASSWORD_ERROR.msg);
}
info.setMima(SecureUtil.md5(info.getNewPassword()));
Caiwu caiwu1 = new Caiwu();
BeanUtils.copyProperties(info, caiwu1);
caiwuService.update(caiwu1);
return Result.success();
}
}
数据库参考
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`gaoxiaohouqinbaoxiu` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `gaoxiaohouqinbaoxiu`;
/*Table structure for table `config` */
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) DEFAULT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*Data for the table `config` */
insert into `config`(`id`,`name`,`value`) values (1,'轮播图1','upload/config1.jpg'),(2,'轮播图2','upload/config2.jpg'),(3,'轮播图3','upload/config3.jpg');
/*Table structure for table `dictionary` */
DROP TABLE IF EXISTS `dictionary`;
CREATE TABLE `dictionary` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
`code_index` int(11) DEFAULT NULL COMMENT '编码',
`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字 Search111 ',
`super_id` int(11) DEFAULT NULL COMMENT '父字段id',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='字典';
/*Data for the table `dictionary` */
insert into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (20,'quyu_types','楼栋',1,'楼栋1',NULL,NULL,'2023-03-25 16:13:42'),(21,'quyu_types','楼栋',2,'楼栋2',NULL,NULL,'2023-03-25 16:13:43'),(22,'quyu_types','楼栋',3,'楼栋3',NULL,NULL,'2023-03-25 16:13:43'),(23,'guzhangshangbao_types','故障类型',1,'故障类型1',NULL,NULL,'2023-03-25 16:13:43'),(24,'guzhangshangbao_types','故障类型',2,'故障类型2',NULL,NULL,'2023-03-25 16:13:43'),(25,'guzhangshangbao_types','故障类型',3,'故障类型3',NULL,NULL,'2023-03-25 16:13:43'),(26,'guzhangshangbao_yesno_types','处理结果',1,'待处理',NULL,NULL,'2023-03-25 16:13:43'),(27,'guzhangshangbao_yesno_types','处理结果',2,'已通过',NULL,NULL,'2023-03-25 16:13:43'),(28,'guzhangshangbao_yesno_types','处理结果',3,'已拒绝',NULL,NULL,'2023-03-25 16:13:43'),(29,'guzhangshangbao_yesno_types','处理结果',4,'待维修',NULL,NULL,'2023-03-25 16:13:43'),(30,'guzhangshangbao_yesno_types','处理结果',5,'已维修',NULL,NULL,'2023-03-25 16:13:43'),(31,'news_types','公告类型',1,'公告类型1',NULL,NULL,'2023-03-25 16:13:43'),(32,'news_types','公告类型',2,'公告类型2',NULL,NULL,'2023-03-25 16:13:43'),(33,'news_types','公告类型',3,'公告类型3',NULL,NULL,'2023-03-25 16:13:43'),(34,'sex_types','性别类型',1,'男',NULL,NULL,'2023-03-25 16:13:43'),(35,'sex_types','性别类型',2,'女',NULL,NULL,'2023-03-25 16:13:43'),(36,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2023-03-25 16:13:43'),(37,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2023-03-25 16:13:43'),(38,'peijianshenqing_yesno_types','处理结果',1,'待处理',NULL,NULL,'2023-03-25 16:13:43'),(39,'peijianshenqing_yesno_types','处理结果',2,'已通过',NULL,NULL,'2023-03-25 16:13:43'),(40,'peijianshenqing_yesno_types','处理结果',3,'已拒绝',NULL,NULL,'2023-03-25 16:13:43'),(41,'weixiuyuan_types','维修员类型',1,'维修员类型1',NULL,NULL,'2023-03-25 16:13:43'),(42,'weixiuyuan_types','维修员类型',2,'维修员类型2',NULL,NULL,'2023-03-25 16:13:43'),(43,'weixiuyuan_types','维修员类型',3,'维修员类型3',NULL,NULL,'2023-03-25 16:13:43');
/*Table structure for table `forum` */
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题 Search111 ',
`weixiuyuan_id` int(11) DEFAULT NULL COMMENT '维修人员',
`yonghu_id` int(11) DEFAULT NULL COMMENT '学生',
`users_id` int(11) DEFAULT NULL COMMENT '管理员',
`forum_content` longtext COMMENT '发布内容',
`super_ids` int(11) DEFAULT NULL COMMENT '父id',
`forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='论坛';
/*Data for the table `forum` */
insert into `forum`(`id`,`forum_name`,`weixiuyuan_id`,`yonghu_id`,`users_id`,`forum_content`,`super_ids`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',NULL,3,NULL,'发布内容1',172,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(2,'帖子标题2',NULL,1,NULL,'发布内容2',435,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(3,'帖子标题3',NULL,3,NULL,'发布内容3',109,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(4,'帖子标题4',NULL,1,NULL,'发布内容4',450,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(5,'帖子标题5',NULL,2,NULL,'发布内容5',498,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(6,'帖子标题6',NULL,1,NULL,'发布内容6',214,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(7,'帖子标题7',NULL,3,NULL,'发布内容7',487,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(8,'帖子标题8',NULL,3,NULL,'发布内容8',441,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(9,'帖子标题9',NULL,2,NULL,'发布内容9',456,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(10,'帖子标题10',NULL,1,NULL,'发布内容10',25,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(11,'帖子标题11',NULL,1,NULL,'发布内容11',251,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(12,'帖子标题12',NULL,2,NULL,'发布内容12',291,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(13,'帖子标题13',NULL,3,NULL,'发布内容13',81,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(14,'帖子标题14',NULL,1,NULL,'发布内容14',138,1,'2023-03-25 16:14:01','2023-03-25 16:14:01','2023-03-25 16:14:01'),(18,NULL,NULL,1,NULL,'123123',14,2,'2023-03-25 17:01:40',NULL,'2023-03-25 17:01:40'),(19,NULL,NULL,NULL,1,'312312',14,2,'2023-03-25 17:03:02',NULL,'2023-03-25 17:03:02'),(20,NULL,1,NULL,NULL,'3333333333',14,2,'2023-03-25 17:03:22',NULL,'2023-03-25 17:03:22'),(21,NULL,3,NULL,NULL,'1111111111111111',14,2,'2023-03-25 17:04:05',NULL,'2023-03-25 17:04:05');
/*Table structure for table `guzhangshangbao` */
DROP TABLE IF EXISTS `guzhangshangbao`;
CREATE TABLE `guzhangshangbao` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '学生',
`guzhangshangbao_uuid_number` varchar(200) DEFAULT NULL COMMENT '报修编号',
`quyu_types` int(11) DEFAULT NULL COMMENT '楼栋',
`guzhangshangbao_address` varchar(200) DEFAULT NULL COMMENT '详细地址',
`guzhangshangbao_guzhang` varchar(200) DEFAULT NULL COMMENT '故障信息',
`guzhangshangbao_types` int(11) DEFAULT NULL COMMENT '故障类型 Search111',
`weixiuyuan_id` int(11) DEFAULT NULL COMMENT '维修人员',
`guzhangshangbao_yesno_types` int(11) DEFAULT NULL COMMENT '处理结果',
`guzhangshangbao_yesno_text` longtext COMMENT '处理回复',
`guzhangshangbao_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow ',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='在线报修';
/*Data for the table `guzhangshangbao` */
insert into `guzhangshangbao`(`id`,`yonghu_id`,`guzhangshangbao_uuid_number`,`quyu_types`,`guzhangshangbao_address`,`guzhangshangbao_guzhang`,`guzhangshangbao_types`,`weixiuyuan_id`,`guzhangshangbao_yesno_types`,`guzhangshangbao_yesno_text`,`guzhangshangbao_delete`,`create_time`) values (1,2,'1679732041258',2,'详细地址1','故障信息1',3,3,1,NULL,1,'2023-03-25 16:14:01'),(2,2,'1679732041290',1,'详细地址2','故障信息2',1,3,1,NULL,1,'2023-03-25 16:14:01'),(3,2,'1679732041290',1,'详细地址3','故障信息3',1,1,1,NULL,1,'2023-03-25 16:14:01'),(4,1,'1679732041271',1,'详细地址4','故障信息4',3,3,1,NULL,1,'2023-03-25 16:14:01'),(5,1,'1679732041259',2,'详细地址5','故障信息5',3,2,1,NULL,1,'2023-03-25 16:14:01'),(6,3,'1679732041260',3,'详细地址6','故障信息6',1,1,1,NULL,1,'2023-03-25 16:14:01'),(7,3,'1679732041315',2,'详细地址7','故障信息7',3,2,1,NULL,1,'2023-03-25 16:14:01'),(8,2,'1679732041258',1,'详细地址8','故障信息8',3,3,1,NULL,1,'2023-03-25 16:14:01'),(9,1,'1679732041280',1,'详细地址9','故障信息9',3,2,1,NULL,1,'2023-03-25 16:14:01'),(10,1,'1679732041255',3,'详细地址10','故障信息10',3,1,1,NULL,1,'2023-03-25 16:14:01'),(11,2,'1679732041279',3,'详细地址11','故障信息11',2,1,1,NULL,1,'2023-03-25 16:14:01'),(12,1,'1679732041329',3,'详细地址12','故障信息12',2,2,1,NULL,1,'2023-03-25 16:14:01'),(13,3,'1679732041274',1,'详细地址13','故障信息13',2,2,1,NULL,1,'2023-03-25 16:14:01'),(14,2,'1679732041317',3,'详细地址14','故障信息14',1,2,5,'123123',1,'2023-03-25 16:14:01'),(17,1,'1679734871852',2,'123','123',1,3,5,'12312',1,'2023-03-25 17:01:20');
/*Table structure for table `news` */
系统效果图
源码获取
下方名片联系我即可!!
标签:03,报修,14,25,16,2023,android,NULL,高校后勤 From: https://blog.csdn.net/QQ1039692211/article/details/144157617
大家点赞、收藏、关注、评论啦 、查看