基于javaweb和mysql的springboot大学城水电管理系统(java+springboot+mybaits+vue+elementui+mysql)

私信源码获取及调试交流

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Node.js≥14

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行

前端：WebStorm/VSCode/HBuilderX等均可

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SpringBoot大学城水电管理系统(java+springboot+mybaits+vue+elementui+mysql)

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。

2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;

3.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；

4.数据库：MySql 5.7/8.0版本均可；

5.是否Maven项目：是；

技术栈

后端：SpringBoot+Mybaits

前端：Vue + elementui

使用说明

项目运行：

1. 使用Navicat或者其它工具，在mysql中创建对应sql文件名称的数据库，并导入项目的sql文件；

2. 使用IDEA/Eclipse/MyEclipse导入项目，导入成功后请执行maven clean;maven install命令；

3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

4. 运行项目，在浏览器中输入地址：

前台地址：http://localhost:8080/springbootrpj39/front/index.html

后台地址：http://localhost:8080/springbootrpj39/admin/dist/index.html

管理员 abo 密码 abo

用户：用户1 密码： 123456

注意项目文件路径中不能含有中文、空格、特殊字符等，否则图片会上传不成功。

* 提交报修单的POST方法

* @param model

* @return

*/

@RequestMapping(value = "/commit", method = RequestMethod.GET)

public String commit(Model model) {

return "/student/commit";

@RequestMapping(value = "/commit", method = RequestMethod.POST)

public String commit(@RequestParam("detail") String detail, @RequestParam("place") String place,

@RequestParam("file") MultipartFile file, HttpServletRequest httpServletRequest) {

String id = httpServletRequest.getSession().getAttribute(StudentConst.STUDENT_ID).toString();

Student student = studentService.getStudentById(id);

public String login(Model model) {

return "redirect:../student/login";

@RequestMapping(value = "/login", method = RequestMethod.POST)

@ResponseBody

public LoginResult login(int id, String password, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) {

logger.info("================admin login===================");

logger.info("admin id: "+id);

logger.info("admin password: "+password);

logger.info("================admin login===================");

Admin admin = adminService.getAdminById(id);

/**

* 退出的控制

* @param httpSession

* @return

*/

@RequestMapping(value = "/logout", method = RequestMethod.GET)

public String logout(HttpSession httpSession) {

httpSession.removeAttribute(StudentConst.STUDENT_EMAIL);

return "redirect:/student/login";

/**

return "redirect:/student/urgent";

/**

* 重新提交某条催单

* @param repairId

* @return

*/

@RequestMapping(value = "/urgent/{repairId}/resubmit", method = RequestMethod.GET)

public String reSubmitUrgent(@PathVariable("repairId") int repairId) {

urgentRepairService.reSubmit(repairId);

return "redirect:/student/urgent";

/**

* 获取所有待取消的报修单

for(Repair repair: repairs){

repair.setPicMD5("/"+repair.getPicMD5());

RepairInfoVo repairInfoVo = new RepairInfoVo(repair);

repairInfoVo.setStatesInfo(RepairEnumCN.stateOf(repair.getStatus()).getStateInfo());

repairInfoVos.add(repairInfoVo);

model.addAttribute("repairInfoVos", repairInfoVos);

return "/student/dashboard";

/**

* 报修单详情

* @param repairId

* @param model

@ResponseBody

LoginResult login(String id, String password, HttpSession httpSession, HttpServletResponse httpServletResponse) {

LoginResult loginResult=null;

String stuName = null;

Student student = studentService.getStudentById(id);

Spider spider = new Spider();

try {

//调用service将数据存入数据库中

if(student==null){

//                stuName = spider.getStudentName(id, password);

//                student = new Student(id, stuName, password);

//                System.out.println(stuName);

loginResult.setReason("invalid user");

logger.info("LoginResult:"+loginResult);

return loginResult;

@RequestMapping(value = "/logout", method = RequestMethod.GET)

public String logout(HttpSession httpSession) {

logger.info("退出要移除的sessionId是:"+httpSession.getId());

httpSession.removeAttribute("ADMIN_ID");

return "redirect:../student/login";

@RequestMapping(value = "/dashboard", method = RequestMethod.GET)

public String dashboard(Model model, HttpServletRequest httpServletRequest) {

model.addAttribute("techniciens", techniciens);

return "/admin/addArrange";

@RequestMapping(value = "/maintenance/{repairId}/add", method = RequestMethod.POST)

public String submitArrange(@PathVariable("repairId") int repairId, @RequestParam("technicianId") String technicianId) {

// 解决表单提交时乱码的问题(JSP在表单提交时默认采用ISO-8859-1编码)

try {

technicianId = new String(technicianId.getBytes("ISO-8859-1"), "utf8");

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

repairService.arrangeRepair(repairId, Integer.valueOf(technicianId));

return "redirect:/admin/dashboard";

doorObject.setPower("100");

doorObject.setWater("100");

doorDao.add(doorObject);

return "redirect:/admin/student";

@RequestMapping(value = "/technician", method = RequestMethod.GET)

public String technician(Model model) {

List<Technician> techniciens = technicianService.getAllTechnician();

model.addAttribute("techniciens", techniciens);

return "admin/technician";

/**

* 添加维修人员 GET方法

* @param model

* @return

*/

technicianService.addTechnician(name,number,phone);

return "redirect:/admin/technician";

用户的web控制层:

/**

* 用户的web层

*/

@Controller

@CrossOrigin(origins = {"http://localhost:18084", "null"})

@RequestMapping("/student")

public class StudentController {

private final Logger logger = LoggerFactory.getLogger(this.getClass());

@Resource

private StudentService studentService;

List<UrgentRepairResult> urgentRepairResults = new ArrayList<UrgentRepairResult>();

Student student;

Repair repair;

for (UrgentRepair urgentRepair : urgentRepairs) {

repair = repairService.getRepairById(urgentRepair.getRepairId());

student = studentService.getStudentById(urgentRepair.getStudentId());

urgentRepairResults.add(

new UrgentRepairResult

(urgentRepair.getId(),

urgentRepair.getStatus(), UrgentRepairEnum.stateOf(urgentRepair.getStatus()).getStateInfo(),

* @return

*/

@RequestMapping(value = "/login", method = RequestMethod.POST)

public

@ResponseBody

LoginResult login(String id, String password, HttpSession httpSession, HttpServletResponse httpServletResponse) {

LoginResult loginResult=null;

String stuName = null;

Student student = studentService.getStudentById(id);

Spider spider = new Spider();

try {

//调用service将数据存入数据库中

logger.info("================admin login===================");

logger.info("admin id: "+id);

logger.info("admin password: "+password);

logger.info("================admin login===================");

Admin admin = adminService.getAdminById(id);

LoginResult loginResult = null;

if(admin==null){

logger.info("admin null");

loginResult = new LoginResult(false);

}else{

String psw = admin.getPassword();

public String index() {

return "student/introduce";

/**

* 登录的GET方法

* @return

*/

@RequestMapping(value = "/login", method = RequestMethod.GET)

public String login() {

return "student/login";

/**

* 登录的POST方法

* @param id

* @param httpServletRequest

* @return

*/

@RequestMapping(value = "/changeinfo", method = RequestMethod.POST)

public

@ResponseBody

LoginResult changeInfo(String name, String phone, String sexual, HttpSession httpSession, HttpServletResponse httpServletResponse, HttpServletRequest httpServletRequest) {

String id = httpServletRequest.getSession().getAttribute(StudentConst.STUDENT_ID).toString();

System.out.println("name:"+name+";phone:"+phone+";sexual:"+sexual);

Student student = studentService.getStudentByEmail(id);

if(sexual.equals("男"))

private StudentService studentService;

@Resource

private RepairService repairService;

@Resource

private UrgentRepairService urgentRepairService;

@Resource

private DoorDao doorDao;

@RequestMapping(value = "/introduce", method = RequestMethod.GET)

public String index() {

return "student/introduce";

/**

repairService.submitRepair(detail, place, picMD5, student.getId());

// 保存现场照片

String path = httpServletRequest.getSession().getServletContext().getRealPath("/");

System.out.println("图片路径：" + path);

String fileName = picMD5;

File targetFile = new File(path, fileName);

try {

InputStream inputStream = file.getInputStream();

OutputStream outputStream = new FileOutputStream(targetFile);

byte[] buffer = new byte[2048];

int len = 0;

return "/admin/finish";

@RequestMapping(value = "/urgent", method = RequestMethod.GET)

public String urgent(Model model) {

List<UrgentRepair> urgentRepairs = urgentRepairService.getAllUrgentRepair();

List<UrgentRepairResult> urgentRepairResults = new ArrayList<UrgentRepairResult>();

Student student;

Repair repair;

for (UrgentRepair urgentRepair : urgentRepairs) {

repair = repairService.getRepairById(urgentRepair.getRepairId());

student = studentService.getStudentById(urgentRepair.getStudentId());

urgentRepairResults.add(

new UrgentRepairResult