基于javaweb+jsp的养老院管理系统(java+SSM+JSP+Easyui+maven+mysql)
运行环境：
JDK1.8、tomcat8、eclipse、mysql5.6、Navicat
功能实现：
用户: 用户名,登录密码,姓名,性别,出生日期,用户照片,联系电话,邮箱,家庭地址,注册时间
老人: 老人编号,姓名,性别,年龄,老人照片,老人介绍,登记用户,登记时间
房间类型: 房间类型id,房间类型名称
房间: 房间编号,房间类型,房间名称,房间主图,房间价格,房间详情,房间状态
订单: 订单编号,入住房间,入住老人,入住日期,入住时间,订单总金额,订单状态,订单费用明细,订单时间
老人看护: 记录id,信息类别,信息标题,信息内容,发布时间
接待: 接待记录id,接待类别,接待主题,接待内容,接待日期
部门: 部门编号,部门名称,成立日期,负责人
员工: 用户名,登录密码,所在部门,姓名,性别,出生日期,员工照片,联系电话,家庭地址
工资: 工资id,员工,工资年份,工资月份,工资金额,发放日期,工资备注
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
}
@RequestMapping(value="/{roomNo}/frontshow",method=RequestMethod.GET)
public String frontshow(@PathVariable String roomNo,Model model,HttpServletRequest request) throws Exception {
Room room = roomService.getRoom(roomNo);
List roomTypeList = roomTypeService.queryAllRoomType();
request.setAttribute("roomTypeList", roomTypeList);
request.setAttribute("room", room);
return "Room/room_frontshow";
}
@RequestMapping(value="/{roomNo}/update",method=RequestMethod.GET)
} catch(UserException ex) {
message = "图片格式不正确！";
writeJsonResponse(response, success, message);
return ;
}
userInfoService.addUserInfo(userInfo);
message = "用户添加成功!";
success = true;
writeJsonResponse(response, success, message);
}
@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
public void list(String user_name,String name,String birthDate,String telephone,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
if (page==null || page == 0) page = 1;
if (user_name == null) user_name = "";
if (name == null) name = "";
if (birthDate == null) birthDate = "";
if (telephone == null) telephone = "";
if(rows != 0)userInfoService.setRows(rows);
Room room = roomList.get(i);
dataset.add(new String[]{room.getRoomNo(),room.getRoomTypeObj().getTypeName(),room.getRoomName(),room.getMainPhoto(),room.getPrice() + "",room.getRoomState()});
}
OutputStream out = null;//创建一个输出流对象
try {
out = response.getOutputStream();//
response.setHeader("Content-disposition","attachment; filename="+"Room.xls");//filename是下载的xls的名，建议最好用英文
response.setContentType("application/msexcel;charset=UTF-8");//设置类型
response.setHeader("Pragma","No-cache");//设置头
response.setHeader("Cache-Control","no-cache");//设置头
response.setDateHeader("Expires", 0);//设置日期头
String rootPath = request.getSession().getServletContext().getRealPath("/");
ex.exportExcel(rootPath,_title,headers, dataset, out);
out.flush();
UserInfo userInfo = userInfoService.getUserInfo(user_name);
request.setAttribute("userInfo", userInfo);
return "UserInfo/userInfo_frontshow";
}
@RequestMapping(value="/{user_name}/update",method=RequestMethod.GET)
public void update(@PathVariable String user_name,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
UserInfo userInfo = userInfoService.getUserInfo(user_name);
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject jsonUserInfo = userInfo.getJsonObject();
out.println(jsonUserInfo.toString());
out.flush();
out.close();
}
ExportExcelUtil ex = new ExportExcelUtil();
String _title = "Room信息记录";
String[] headers = { "房间编号","房间类型","房间名称","房间主图","房间价格","房间状态"};
List dataset = new ArrayList();
for(int i=0;i
Room room = roomList.get(i);
dataset.add(new String[]{room.getRoomNo(),room.getRoomTypeObj().getTypeName(),room.getRoomName(),room.getMainPhoto(),room.getPrice() + "",room.getRoomState()});
}
OutputStream out = null;//创建一个输出流对象
try {
out = response.getOutputStream();//
if(success) {
session.setAttribute("username", admin.getUsername());
}
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject json=new JSONObject();
json.accumulate("success", success);
json.accumulate("msg", msg);
out.println(json.toString());
out.flush();
out.close();
}
if (name == null) name = ""; if (birthDate == null) birthDate = ""; if (telephone == null) telephone = ""; if(rows != 0)userInfoService.setRows(rows); ListuserInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, page); userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone); int totalPage = userInfoService.getTotalPage(); int recordNumber = userInfoService.getRecordNumber(); response.setContentType("text/json;charset=UTF-8"); PrintWriter out = response.getWriter(); //将要被返回到客户端的对象 JSONObject jsonObj=new JSONObject(); jsonObj.accumulate("total", recordNumber); JSONArray jsonArray = new JSONArray(); for(UserInfo userInfo:userInfoList) { JSONObject jsonUserInfo = userInfo.getJsonObject(); jsonArray.put(jsonUserInfo); } jsonObj.accumulate("rows", jsonArray); out.println(jsonObj.toString()); out.flush(); out.close();
@RequestMapping(value="/{user_name}/delete",method=RequestMethod.GET)
public String delete(@PathVariable String user_name,HttpServletRequest request) throws UnsupportedEncodingException {
try {
userInfoService.deleteUserInfo(user_name);
request.setAttribute("message", "用户删除成功!");
return "message";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("error", "用户删除失败!");
return "error";
}
}
@RequestMapping(value="/deletes",method=RequestMethod.POST)
public void delete(String user_names,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
String message = "";
boolean success = false;
try {
int count = userInfoService.deleteUserInfos(user_names);
success = true;
message = count + "条记录删除成功";
writeJsonResponse(response, success, message);
} catch (Exception e) {
//e.printStackTrace();
}
@RequestMapping(value="/{roomNo}/frontshow",method=RequestMethod.GET)
public String frontshow(@PathVariable String roomNo,Model model,HttpServletRequest request) throws Exception {
Room room = roomService.getRoom(roomNo);
List roomTypeList = roomTypeService.queryAllRoomType();
request.setAttribute("roomTypeList", roomTypeList);
request.setAttribute("room", room);
return "Room/room_frontshow";
}
@RequestMapping(value="/{roomNo}/update",method=RequestMethod.GET)
return "message";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("error", "用户删除失败!");
return "error";
}
}
@RequestMapping(value="/deletes",method=RequestMethod.POST)
public void delete(String user_names,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
String message = "";
boolean success = false;
try {
jsonUserInfo.accumulate("name", userInfo.getName());
jsonArray.put(jsonUserInfo);
}
out.println(jsonArray.toString());
out.flush();
out.close();
}
@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
public String frontlist(String user_name,String name,String birthDate,String telephone,Integer currentPage, Model model, HttpServletRequest request) throws Exception {
if (currentPage==null || currentPage == 0) currentPage = 1;
if (user_name == null) user_name = "";
if (name == null) name = "";
if (birthDate == null) birthDate = "";
if (telephone == null) telephone = "";
List userInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, currentPage);
userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone);
int totalPage = userInfoService.getTotalPage();
int recordNumber = userInfoService.getRecordNumber();
