【毕业设计】基于springMVC蓝迪酒店租房管理系统【源码+SQL脚本】.zip

package org.ld.controller; import java.io.FileOutputStream; import java.io.IOException; import java.io.File; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; import javax.print.attribute.standard.MediaSize.Other; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.commons.fileupload.util.Streams; import org.apache.log4j.Logger; import org.apache.poi.xslf.model.geom.CosExpression; import org.ld.app.Config; import org.ld.model.*; import org.ld.model.CostLe; import org.ld.service.GuestMissionService; import org.ld.service.ItemService; import org.ld.service.RoomService; import org.ld.service.ServerService; import org.ld.service.UserService; import org.ld.utils.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; @Controller @RequestMapping("/userRoom") public class UserRoomController { @Autowired private UserService userService; @Autowired private RoomService roomService; @Autowired private GuestMissionService guestService; @Autowired private ServerService serverService; @Autowired private ItemService itemService; private static Logger logger = Logger.getLogger("logRec"); // 多文件上传 @RequestMapping(value = "/uploadFiles", method = RequestMethod.POST) public String uploadFiles(@RequestParam("file") MultipartFile[] file, Integer room_id, HttpServletRequest request) { // System.out.println(request.getSession().getServletContext().getRealPath("")); System.out.println("room_id：" + room_id); String roomNumber = roomService.getRoomById(room_id).getROOM_NUMBER(); // 遍历文件 for (MultipartFile mul : file) { System.out.println(mul.getName() + "---" + mul.getContentType() + "---" + mul.getOriginalFilename()); try { if (!mul.isEmpty()) { Streams.copy(mul.getInputStream(), new FileOutputStream(request.getSession().getServletContext().getRealPath("") + "/resources/room_pic/" + mul.getOriginalFilename()), true); RoomPic roompic = new RoomPic(); roompic.setROOM_ID(room_id); roompic.setTYPE(1); roompic.setCTIME(null); roompic.setNAME("1"); roompic.setTAG("1"); roompic.setPATH("/resources/room_pic/" + mul.getOriginalFilename()); roomService.insertRoomPic(roompic); } } catch (IOException e) { System.out.println("文件上传失败"); e.printStackTrace(); } } return "forward:/views/user/tenant/roomCheck.jsp?rid=" + room_id + "&rNum=" + roomNumber; } // 获取房间图片路径 @RequestMapping(value = "/getRoomPic", method = { RequestMethod.POST, RequestMethod.GET }) @ResponseBody public List<RoomPic> getRoomPic(@RequestParam(value = "id", required = true) Integer room_id) throws Exception { System.out.println(room_id); List<RoomPic> roomPic = roomService.getPic(room_id); return roomPic; } // 根据roomNumber 查询 roomID @RequestMapping(value = "/getRoomIDByNumber") @ResponseBody public Room getRoomIDByNumber(@RequestParam(value = "roomNumber", required = true) String roomNumber) throws Exception { System.out.println(roomNumber); Room room = roomService.getRoomByNumber(roomNumber); return room; } @RequestMapping("/getAllRoom") // 所有房间 @ResponseBody public Map<String, Object> getAllRoom(HttpSession session) { User curUser = (User) session.getAttribute("curUser"); Map<String, Object> ans = new HashMap<String, Object>(); if ((curUser.getAUTH() & (0x01 << Config.getAuths().get("rRoom"))) == 0) { ans.put("State", "Invalid"); return ans; } else { ans.put("State", "Valid"); } List<Room> rooms = roomService.getAllRoom(); ans.put("roomList", rooms); return ans; } @RequestMapping("/getAllRoomState") // 获取所有房间状态信息（租客一览表） @ResponseBody public Map<String, Object> getAllRoomState(HttpSession session) { User curUser = (User) session.getAttribute("curUser"); Map<String, Object> ans = new HashMap<String, Object>(); if ((curUser.getAUTH() & (0x01 << Config.getAuths().get("rRoom"))) == 0) { ans.put("State", "Invalid"); return ans; } else { ans.put("State", "Valid"); } //取出全部roomState信息 //List<RoomState> rooms = roomService.getAllRoomState(); List<RoomState> rooms = roomService.getTotalRoomState(); ans.put("roomStateList", rooms); // List<Room> type_room = roomService.getAllEditedTypeRoom(); // // Map<String,Object> toType = new HashMap<String,Object>() ; // Map<String,Object> toState = new HashMap<String,Object>(); // // if(type_room != null) { // for(Room r : type_room) { // toType.put(r.getROOM_NUMBER(),r.getTYPE()); // toState.put(r.getROOM_NUMBER(),r.getSTATE()); // } // } // ans.put("roomType",toType); // ans.put("roomState",toState); //取出全部room信息 List<Room> roomInfo = roomService.getAllRoom(); Map<String,String> toInfo = new HashMap<String,String>(); for(Room r : roomInfo){ toInfo.put(r.getROOM_NUMBER(),r.getTYPE()); } ans.put("roomInfo",toInfo); return ans; } @RequestMapping("/getManageOption") //获取房间管理状况 @ResponseBody public Map<String,Object> getManageOption(HttpSession session ,@RequestBody String data) { User curUser = (User) session.getAttribute("curUser"); Map<String, Object> ans = new HashMap<String, Object>(); if ((curUser.getAUTH() & (0x01 << Config.getAuths().get("rRoom"))) == 0) { ans.put("State", "Invalid"); return ans; } else { ans.put("State", "Valid"); } JSONObject dataJson = JSONObject.parseObject(data); String rn = dataJson.getString("rNum"); Room room = roomService.getRoomByNumber(rn); if(room == null) ans.put("State","Invalid"); else { ans.put("RoomType",room.getTYPE()); ans.put("State",room.getSTATE()); } return ans; } @RequestMapping("/updateRoomInfo") @ResponseBody public Integer updateRoomInfo(HttpSession session , @RequestBody String data){ User curUser = (User) session.getAttribute("curUser"); if((curUser.getAUTH() & (0x01 << Config.getAuths().get("rRoom"))) == 0) { return 0; } JSONObject dataJson = JSONObject.parseObject(data); String rNum = dataJson.getString("rNum"); String room_type = dataJson.getString("room_type"); String owner = dataJson.getString("name").equals("") ? null: dataJson.getString("name"); Date time = dataJson.getDate("time"); String manage = dataJson.getString("manage"); String replace_room = dataJson.getString("replace_room").equals("") ? null: dataJson.getString("replace_room") ; String com = dataJson.getString("com"); Room room = roomService.getRoomByNumber(rNum); room.setCOMM(com); if(room != null){ if(manage.equals("添加房源") ) { room.setTYPE(room_type); room.setOWNER_NAME(owner); room.setSTATE(1); room.setRECEIPT_TIME(time); room.setREFUND_TIME(null); room.setREPLACE_ROOM(null); }else if(manage.equals("替换房源")) { room.setREPLACE_ROOM(replace_room); }else if(manage.equals("退还房源")) { room.setREFUND_TIME(time); //由于数据库表结构 没有存历史记录 退还后该记录保存 是为了查阅的功能 room.setSTATE(null); } roomService.updateRoom(room); return 1; }