基于javaweb+mysql的ssm业主+物业相结合小区物业管理系统(java+ssm+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM业主+物业相结合小区物业管理系统(java+ssm+jsp+mysql)
功能包括: 分为管理员及普通业主角色,业主信息,社区房屋,维护 管理,社区车辆,社区投诉,社区缴费,社区业务信息维 护等等功能。
return "manage/carMg";
}
@RequestMapping(value="/manage/car-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
Car car = new Car();
car.setUserId(key);
PageVO<Car> page = pmsService.listCar(car, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addCar")
public void addCar(@ModelAttribute("car") Car car){
pmsService.addCar(car);
System.out.println("add car :"+ car.getCarNum());
car = null;
}
@RequestMapping(value="/manage/updateCar")
public void updateCar(@ModelAttribute("car") Car car){
pmsService.modifyCar(car);
System.out.println("modify Car :"+ car.getCarNum());
}
@RequestMapping(value="/manage/deleteCar")
public void deleteCar(@RequestBody Car car, HttpServletResponse response){
String carNum = car.getCarNum();
pmsService.removeCarById(carNum);
System.out.println("delete Car :"+ carNum);
}
@RequestMapping(value="/payconsume")
public void payconsume(HttpServletRequest request, HttpServletResponse response) {
String[] list = request.getParameterValues("list");
for (String item : list) {
int consumeId=Integer.valueOf(item);
pmsService.payOneItem(consumeId);
}
}
}
@Controller
public class HouseController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/houseMg"})
@Controller
public class CarController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/carMg"})
public String carMg(@ModelAttribute("car") Car car) {
return "manage/carMg";
}
@RequestMapping(value="/manage/car-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
Car car = new Car();
car.setUserId(key);
PageVO<Car> page = pmsService.listCar(car, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
PageVO<Notice> page = pmsService.listNotice( pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/news_item")
public String newsItem(@RequestParam("id")String id,Model model) {
Notice notice=pmsService.selectNewsItem(id);
model.addAttribute("notice", notice);
return "user/news_item";
}
@RequestMapping(value="/testResponseBody")
// @ResponseBody会将集合数据转换json格式返回客户端
@ResponseBody
public Object getJson() {
List<Notice> list = pmsService.selectTopThree();
return list;
}
@RequestMapping(value="/getNotice")
// @ResponseBody会将集合数据转换json格式返回客户端
@ResponseBody
public Object getNotice() {
List<Notice> list = pmsService.getNoticeTwo();
return list;
}
@RequestMapping(value="/getMissing")
// @ResponseBody会将集合数据转换json格式返回客户端
@ResponseBody
public Object getMissing() {
Notice notice= pmsService.getMissing();
return notice;
}
@RequestMapping(value="/manage/notice-list")
public void selectNotice(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
String noticeType1 = request.getParameter("noticeType");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
int noticeType = Integer.valueOf(noticeType1);
Notice notice = new Notice();
notice.setNoticeTitle(key);
@RequestMapping(value="/manage/loadEditHouse")
@ResponseBody
public Object loadEditHouse(
@RequestParam(value="buildingNum",required=false) String buildingNum,
@RequestParam(value="roomNum",required=false) String roomNum){
House house = new House();
int bNum = Integer.valueOf(buildingNum);
int rNum = Integer.valueOf(roomNum);
house = pmsService.findHouse(bNum, rNum);
System.out.println("load House :"+ buildingNum + " "+roomNum);
return house;
}
}
@Controller
public class HouseTypeController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/houseTypeMg"})
public String houseTypeMg(@ModelAttribute("houseType") HouseType houseType) {
@Controller
public class HouseTypeController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/houseTypeMg"})
public String houseTypeMg(@ModelAttribute("houseType") HouseType houseType) {
return "manage/houseTypeMg";
}
@RequestMapping(value="/manage/houseType-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
HouseType houseType = new HouseType();
houseType.setDescription(key);;
//house.setHouseType(type);
PageVO<HouseType> page = pmsService.listHouseType(houseType, pageNo, rowMax);
public Object loadEditHouseType(@RequestParam(value="houseType",required=false) String houseType){
HouseType houseType1 = new HouseType();
int houseTypeNum = Integer.valueOf(houseType);
houseType1 = pmsService.findHouseType(houseTypeNum);
System.out.println("load HouseType :"+ houseType);
return houseType1;
}
}
@Controller
public class CarController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/carMg"})
public String carMg(@ModelAttribute("car") Car car) {
return "manage/carMg";
}
@RequestMapping(value="/manage/car-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
HouseType houseType = new HouseType();
houseType.setDescription(key);;
//house.setHouseType(type);
PageVO<HouseType> page = pmsService.listHouseType(houseType, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addHouseType")
public void addHouseType(@ModelAttribute("houseType") HouseType houseType){
pmsService.addHouseType(houseType);
System.out.println("add HouseType :"+ houseType.getHouseType());
houseType = null;
}
@RequestMapping(value="/manage/updateHouseType")
public void updateHouseType(@ModelAttribute("houseType") HouseType houseType){
pmsService.modifyHouseType(houseType);
System.out.println("modify HouseType :"+ houseType.getHouseType());
}
@RequestMapping(value="/manage/deleteHouseType")
public void deleteHouseType(@RequestBody HouseType houseType, HttpServletResponse response){
int houseType1 = houseType.getHouseType();
pmsService.removeHouseType(houseType1);;
System.out.println("delete HouseType :"+ houseType1);
return "manage/adviceMg";
}
@RequestMapping(value="advice")
public String advice(Model model) {
return "user/advice";
}
@RequestMapping(value="/manage/advice-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
String adviceState1 = request.getParameter("adviceState");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
int adviceState = Integer.valueOf(adviceState1);
Advice advice = new Advice();
advice.setUserId(key);
advice.setAdviceState(adviceState);
PageVO<Advice> page = pmsService.listAdvice(advice, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/updateAdvice")
public void updateAdvice(@ModelAttribute("advice") Advice advice){
advice.setAdviceState(advice.getTypeId());
pmsService.modifyAdvice(advice);
System.out.println("modify Advice :"+ advice.getAdviceId());
}
@RequestMapping(value="/manage/deleteAdvice")
public void deleteAdvice(@RequestBody Advice advice, HttpServletResponse response){
int adviceId = advice.getAdviceId();
pmsService.removeAdvice(adviceId);
System.out.println("delete Advice :"+ adviceId);
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addHouse")
public void addUser(@ModelAttribute("house") House house){
pmsService.addHouse(house);
System.out.println("add house :"+ house.getUserId());
house = null;
}
@RequestMapping(value="/manage/updateHouse")
public void updateHouse(@ModelAttribute("house") House house){
//User user = new User();
pmsService.modifyHouse(house);
System.out.println("modify House :"+ house.getBuildingNum()+" "+ house.getRoomNum());
}
@RequestMapping(value="/manage/deleteHouse")
public void deleteHouse(@RequestBody House house, HttpServletResponse response){
int buildingNum = house.getBuildingNum();
int roomNum = house.getRoomNum();
pmsService.removeHouse(buildingNum,roomNum);
System.out.println("delete house :"+ buildingNum + " " + roomNum);
}
@RequestMapping(value="/manage/loadEditHouse")
@ResponseBody
public Object loadEditHouse(
@RequestParam(value="buildingNum",required=false) String buildingNum,
@RequestParam(value="roomNum",required=false) String roomNum){
House house = new House();
int bNum = Integer.valueOf(buildingNum);
int rNum = Integer.valueOf(roomNum);
}
@RequestMapping(value="/manage/deleteCar")
public void deleteCar(@RequestBody Car car, HttpServletResponse response){
String carNum = car.getCarNum();
pmsService.removeCarById(carNum);
System.out.println("delete Car :"+ carNum);
}
@RequestMapping(value="/manage/loadEditCar")
@ResponseBody
public Object loadEditCar(@RequestParam(value="carNum",required=false) String carNum){
Car car = new Car();
car = pmsService.findCarById(carNum);
System.out.println("load Car :"+ carNum);
return car;
}
}
/**
*/
public class AuthorizationIntercepor implements HandlerInterceptor {
/*private static final String[]Ignore={"/loginForm","/login"};*/
@Override
public boolean preHandle(HttpServletRequest request , HttpServletResponse response, Object handler)throws Exception{
boolean flag=false;
/* String servletPath=request.getServletPath();
private static final long serialVersionUID = 1L;
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/noticeMg"})
public String noticeMg(@ModelAttribute("notice") Notice notice) {
return "manage/noticeMg";
}
@RequestMapping(value="/news")
public void String (HttpServletRequest request, HttpServletResponse response,@RequestParam("pageNo")String pageNoStr,
@RequestParam("rowMax")String rowMaxStr)throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
PageVO<Notice> page = pmsService.listNotice( pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/news_item")
public String newsItem(@RequestParam("id")String id,Model model) {
Notice notice=pmsService.selectNewsItem(id);
model.addAttribute("notice", notice);
return "user/news_item";
}
@RequestMapping(value="/testResponseBody")
// @ResponseBody会将集合数据转换json格式返回客户端
@ResponseBody
public Object getJson() {
List<Notice> list = pmsService.selectTopThree();
return list;
}
@RequestMapping(value="/getNotice")
// @ResponseBody会将集合数据转换json格式返回客户端
@ResponseBody
public Object getNotice() {
List<Notice> list = pmsService.getNoticeTwo();
return list;
}
@RequestMapping(value="/getMissing")
// @ResponseBody会将集合数据转换json格式返回客户端
Notice notice = new Notice();
notice.setNoticeTitle(key);
notice.setNoticeType(noticeType);
PageVO<Notice> page = pmsService.listNotice(notice, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addNotice")
public void addNotice(@ModelAttribute("notice") Notice notice){
System.out.println("add notice :"+ notice.getNoticeTitle());
notice.setNoticeDate(new Timestamp(System.currentTimeMillis()));
notice.setNoticeType(notice.getTypeId());
notice.setChangeDate(new Timestamp(System.currentTimeMillis()));
File file = new File(notice.getPictureAddress().trim());
String fileName = file.getName();
fileName = "images/"+fileName;
notice.setPictureAddress(fileName);
pmsService.addNotice(notice);
}
@RequestMapping(value="/manage/updateNotice")
public void updateNotice(@ModelAttribute("notice") Notice notice){
pmsService.modifyNotice(notice);
System.out.println("modify Notice :"+ notice.getNoticeId());
}
@RequestMapping(value="/manage/deleteNotice")
public void deleteNotice(@RequestBody Notice notice, HttpServletResponse response){
int noticeId = notice.getNoticeId();
pmsService.removeNotice(noticeId);
System.out.println("delete Notice :"+ noticeId);
}
@RequestMapping(value="/manage/loadEditNotice")
return "manage/adviceMg";
}
@RequestMapping(value="advice")
public String advice(Model model) {
return "user/advice";
}
@RequestMapping(value="/manage/advice-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
String adviceState1 = request.getParameter("adviceState");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
int adviceState = Integer.valueOf(adviceState1);
Advice advice = new Advice();
advice.setUserId(key);
advice.setAdviceState(adviceState);
PageVO<Advice> page = pmsService.listAdvice(advice, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/updateAdvice")
public void updateAdvice(@ModelAttribute("advice") Advice advice){
advice.setAdviceState(advice.getTypeId());
pmsService.modifyAdvice(advice);
System.out.println("modify Advice :"+ advice.getAdviceId());
}
@RequestMapping(value="/manage/deleteAdvice")
public void deleteAdvice(@RequestBody Advice advice, HttpServletResponse response){
@Controller
public class HouseTypeController {
@Autowired
@Qualifier("pmsService")
private PmsService pmsService;
@RequestMapping(value= {"/houseTypeMg"})
public String houseTypeMg(@ModelAttribute("houseType") HouseType houseType) {
return "manage/houseTypeMg";
}
@RequestMapping(value="/manage/houseType-list")
public void selectRepair(
HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String key = request.getParameter("key");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
HouseType houseType = new HouseType();
houseType.setDescription(key);;
//house.setHouseType(type);
PageVO<HouseType> page = pmsService.listHouseType(houseType, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addHouseType")
public void addHouseType(@ModelAttribute("houseType") HouseType houseType){
pmsService.addHouseType(houseType);
System.out.println("add HouseType :"+ houseType.getHouseType());
@RequestMapping(value="/user/deleteUser")
public void deleteUser(@RequestBody User user, HttpServletResponse response){
String userId = user.getUserId();
pmsService.removeUserById(userId);
System.out.println("delete user :"+ userId);
}
@RequestMapping(value="/user/loadEditUser")
@ResponseBody
public Object loadEditUser(@RequestParam(value="name",required=false) String name){
User user = new User();
user = pmsService.findUserById(name);
System.out.println("load user :"+ user.getUserName());
return user;
}
@RequestMapping(value= {"/userMg"})
public String userMg(@ModelAttribute("user") User user) {
return "manage/userMg";
}
//关于我们
@RequestMapping(value="/info")
public String about() {
return "user/about";
}
}
int rowMax = Integer.valueOf(rowMaxStr);
int noticeType = Integer.valueOf(noticeType1);
Notice notice = new Notice();
notice.setNoticeTitle(key);
notice.setNoticeType(noticeType);
PageVO<Notice> page = pmsService.listNotice(notice, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();
}
@RequestMapping(value="/manage/addNotice")
public void addNotice(@ModelAttribute("notice") Notice notice){
System.out.println("add notice :"+ notice.getNoticeTitle());
notice.setNoticeDate(new Timestamp(System.currentTimeMillis()));
notice.setNoticeType(notice.getTypeId());
notice.setChangeDate(new Timestamp(System.currentTimeMillis()));
File file = new File(notice.getPictureAddress().trim());
String fileName = file.getName();
fileName = "images/"+fileName;
notice.setPictureAddress(fileName);
pmsService.addNotice(notice);
}
@RequestMapping(value="/manage/updateNotice")
public void updateNotice(@ModelAttribute("notice") Notice notice){
pmsService.modifyNotice(notice);
System.out.println("modify Notice :"+ notice.getNoticeId());
}
@RequestMapping(value="/manage/deleteNotice")
public void deleteNotice(@RequestBody Notice notice, HttpServletResponse response){
int noticeId = notice.getNoticeId();
pmsService.removeNotice(noticeId);
consume.setConsumeDate(date);
System.out.println("add consume :"+ consume.getUserId());
consume.setConsumeType(consume.getTypeId());
consume.setCreateDate(new Timestamp(System.currentTimeMillis()));
consume.setPrice(consume.getCount() * consume.getUnitPrice());
consume.setConsumeState(0);
pmsService.addConsume(consume);
}
@RequestMapping(value="/pay")
public String pay() {
return "user/pay";
}
@RequestMapping(value="/list_consume")
public void selectConsume(
HttpServletRequest request, HttpServletResponse response,HttpSession session)throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
String pageNoStr = request.getParameter("pageNo");
String rowMaxStr = request.getParameter("rowMax");
String consumeType = request.getParameter("consumeType");
int pageNo = Integer.valueOf(pageNoStr);
int rowMax = Integer.valueOf(rowMaxStr);
String select=request.getParameter("select");
User user=(User)session.getAttribute("user");
Map<String, Object> map=new HashMap<>();
String calendar=request.getParameter("calendar");
String calendar1=request.getParameter("calendar1");
map.put("calendar", calendar);
map.put("calendar1", calendar1);
System.out.println(calendar+"9");
System.out.println(calendar1+"10");
map.put("consumeType", consumeType);
map.put("user", user);
map.put("select", select);
PageVO<Consume> page = pmsService.listConsumeUser(map, pageNo, rowMax);
response.reset();
response.setContentType("text/plain;charset=UTF-8");
response.getWriter().print(JSON.toJSONString(page));
response.flushBuffer();