环境:开发工具:idea,数据库:MySQL5.7 jdk1.8
架构:springMVC,前端jsp
主要功能
超级管理员:发布公告、公告管理、用户信息、房产管理、管理管理、报修等;
管理员:用户信息、房产管理、报修(填写订单、报修订单)等;
业主:查询公告、填写报修订单、报修订单评价、查询全部报修订单;
维修工:个人信息、查询公告、订单维修等;
项目图片:
部分代码:
package com.lcz.controller;
import com.lcz.entity.House;
import com.lcz.entity.Role;
import com.lcz.entity.UnitInfo;
import com.lcz.entity.UserS;
import com.lcz.service.HouseService;
import com.lcz.service.UnitInfoService;
import com.lcz.service.UsersService;
import com.lcz.utils.ResultUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.sql.ResultSet;
import java.text.ParseException;
import java.util.List;
/**
* @ClassName House
* @Description TODO
* @Author lcz
* @Date 2021/4/20 9:35
**/
@Controller
@RequestMapping(value = "/house")
public class HouseController {
@Autowired
private HouseService hs;
@Autowired
private UnitInfoService us;
@Autowired
private UsersService usersService;
/**
* 根据单元号,楼层,门牌号查询房子信息
* @param unitId 单元号
* @param floor 楼层
* @param houseNum 门牌号
* @return 房子信息
*/
@RequestMapping(value = "/getHouseOwner")
@ResponseBody
public House getHouseOwner(Integer unitId,Integer floor,String houseNum)
{
return hs.selectByHouseInfo(unitId, floor, houseNum);
}
/**
* 更新房子信息
* @param house 新的房子信息
* @return 更新结果
*/
@RequestMapping(value = "/updHouse")
@ResponseBody
public ResultUtil updHouse(House house)
{
hs.update(house);
return ResultUtil.ok();
}
/*
* 通过Id删除房产信息
*/
@RequestMapping("/delHouseById/{id}")
@ResponseBody
public ResultUtil delAdminById(@PathVariable("id")Integer id) {
try {
hs.delHouseById(id);
return ResultUtil.ok();
} catch (Exception e) {
e.printStackTrace();
return ResultUtil.error();
}
}
/**
* 增加房产信息
* @param house 房产信息
* @return 新增结果
*/
@RequestMapping(value = "/insHouse")
@ResponseBody
public ResultUtil insHouse(House house)
{
hs.add(house);
return ResultUtil.ok();
}
/**
* 查询所有的房产信息,并分页
* @param page 页的大小
* @param limit 第几页
* @return 查询结果
*/
@RequestMapping(value = "/getHouseList")
@ResponseBody
public ResultUtil getHouseList(Integer page, Integer limit)
{
return hs.getAllHouse( page, limit);
}
/**
* 前往增加房产信息界面
* @return 路径
*/
@RequestMapping(value = "/addHouse")
public String addHouse()
{
return "jsp/house/addHouse";
}
/**
* 前往房产信息列表界面
* @return 路径
*/
@RequestMapping(value = "/houseList")
public String houseList()
{
return "jsp/house/houseList";
}
/*
* 编辑房产信息
*/
@RequestMapping("/editHouse/{id}")
public String editAdmin(HttpServletRequest req, @PathVariable("id")int id) throws ParseException {
House house = hs.selById(id);
//获取全部的业主信息
List<UserS> users = usersService.getUserByRoleId(18);
req.setAttribute("house",house);
req.setAttribute("users", users);
return "jsp/house/editHouse";
}
@RequestMapping("/selByOwner")
public ModelAndView selMyHouse(HttpSession session)
{
//创建对象
ModelAndView mv = new ModelAndView();
//获取当前用户对象
UserS mAdmin = (UserS)session.getAttribute("admin");
//查询当前用户对象的房产信息
List<House> houseByUserId = hs.getHouseByUserId(mAdmin.getId());
//将房产信息保存入ModelAndView对象中
mv.setViewName("jsp/house/MyHouses");
mv.addObject("houses",houseByUserId);
return mv;
}
}
获取方式:联系下方名片获取👇