• Java项目:养老院综合服务系统(java+SSM+JSP+jQuery+echarts+mysql)

    源码获取：俺的博客首页 "资源" 里下载！

    项目介绍

    该项目为后台管理项目，分为管理员与护工两种角色；
    管理员角色包含以下功能：
    管理员登录,个人资料密码管理,用户管理,床位类型管理,床位管理,护工管理,老人管理,咨询登记管理,预约登记管理,老人健康信息管理,费用管理等功能。
    护工角色包含以下功能：
    护工登录,个人资料修改,床位类型查看,床位查看,护工查看,老人查看,健康信息上报管理,费用查看等功能。


    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 
    5.数据库：MySql 5.7版本；
    6.是否Maven项目：否；


    技术栈

    1. 后端：Spring+SpringMVC+Mybatis
    2. 前端：JSP+CSS+JavaScript+jQuery+echarts


    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中spring-mvc.xml配置文件中的数据库配置改为自己的配置;
    4. 运行项目，浏览器中输入http://localhost:8080/ssm_yanglaoyuan_sys 登录
    管理员账号/密码：admin/admin
    护工账号/密码： hugong/123456

     

     

     

     

     

    用户管理控制层：

    1. //UserInfo管理控制层
    2. @Controller
    3. @RequestMapping("/UserInfo")
    4. public class UserInfoController extends BaseController {
    5.  
    6.     /*业务层对象*/
    7.     @Resource UserInfoService userInfoService;
    8.  
    9. 	@InitBinder("userInfo")
    10. 	public void initBinderUserInfo(WebDataBinder binder) {
    11. 		binder.setFieldDefaultPrefix("userInfo.");
    12. 	}
    13. 	/*跳转到添加UserInfo视图*/
    14. 	@RequestMapping(value = "/add", method = RequestMethod.GET)
    15. 	public String add(Model model,HttpServletRequest request) throws Exception {
    16. 		model.addAttribute(new UserInfo());
    17. 		return "UserInfo_add";
    18. 	}
    19.  
    20. 	/*客户端ajax方式提交添加用户信息*/
    21. 	@RequestMapping(value = "/add", method = RequestMethod.POST)
    22. 	public void add(@Validated UserInfo userInfo, BindingResult br,
    23. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    24. 		String message = "";
    25. 		boolean success = false;
    26. 		if (br.hasErrors()) {
    27. 			message = "输入信息不符合要求！";
    28. 			writeJsonResponse(response, success, message);
    29. 			return ;
    30. 		}
    31. 		if(userInfoService.getUserInfo(userInfo.getUser_name()) != null) {
    32. 			message = "用户名已经存在！";
    33. 			writeJsonResponse(response, success, message);
    34. 			return ;
    35. 		}
    36. 		try {
    37. 			userInfo.setUserPhoto(this.handlePhotoUpload(request, "userPhotoFile"));
    38. 		} catch(UserException ex) {
    39. 			message = "图片格式不正确！";
    40. 			writeJsonResponse(response, success, message);
    41. 			return ;
    42. 		}
    43.         userInfoService.addUserInfo(userInfo);
    44.         message = "用户添加成功!";
    45.         success = true;
    46.         writeJsonResponse(response, success, message);
    47. 	}
    48. 	/*ajax方式按照查询条件分页查询用户信息*/
    49. 	@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
    50. 	public void list(String user_name,String name,String birthDate,String telephone,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    51. 		if (page==null || page == 0) page = 1;
    52. 		if (user_name == null) user_name = "";
    53. 		if (name == null) name = "";
    54. 		if (birthDate == null) birthDate = "";
    55. 		if (telephone == null) telephone = "";
    56. 		if(rows != 0)userInfoService.setRows(rows);
    57. 		List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, page);
    58. 	    /*计算总的页数和总的记录数*/
    59. 	    userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone);
    60. 	    /*获取到总的页码数目*/
    61. 	    int totalPage = userInfoService.getTotalPage();
    62. 	    /*当前查询条件下总记录数*/
    63. 	    int recordNumber = userInfoService.getRecordNumber();
    64.         response.setContentType("text/json;charset=UTF-8");
    65. 		PrintWriter out = response.getWriter();
    66. 		//将要被返回到客户端的对象
    67. 		JSONObject jsonObj=new JSONObject();
    68. 		jsonObj.accumulate("total", recordNumber);
    69. 		JSONArray jsonArray = new JSONArray();
    70. 		for(UserInfo userInfo:userInfoList) {
    71. 			JSONObject jsonUserInfo = userInfo.getJsonObject();
    72. 			jsonArray.put(jsonUserInfo);
    73. 		}
    74. 		jsonObj.accumulate("rows", jsonArray);
    75. 		out.println(jsonObj.toString());
    76. 		out.flush();
    77. 		out.close();
    78. 	}
    79.  
    80. 	/*ajax方式按照查询条件分页查询用户信息*/
    81. 	@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
    82. 	public void listAll(HttpServletResponse response) throws Exception {
    83. 		List<UserInfo> userInfoList = userInfoService.queryAllUserInfo();
    84.         response.setContentType("text/json;charset=UTF-8"); 
    85. 		PrintWriter out = response.getWriter();
    86. 		JSONArray jsonArray = new JSONArray();
    87. 		for(UserInfo userInfo:userInfoList) {
    88. 			JSONObject jsonUserInfo = new JSONObject();
    89. 			jsonUserInfo.accumulate("user_name", userInfo.getUser_name());
    90. 			jsonUserInfo.accumulate("name", userInfo.getName());
    91. 			jsonArray.put(jsonUserInfo);
    92. 		}
    93. 		out.println(jsonArray.toString());
    94. 		out.flush();
    95. 		out.close();
    96. 	}
    97.  
    98. 	/*前台按照查询条件分页查询用户信息*/
    99. 	@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
    100. 	public String frontlist(String user_name,String name,String birthDate,String telephone,Integer currentPage, Model model, HttpServletRequest request) throws Exception  {
    101. 		if (currentPage==null || currentPage == 0) currentPage = 1;
    102. 		if (user_name == null) user_name = "";
    103. 		if (name == null) name = "";
    104. 		if (birthDate == null) birthDate = "";
    105. 		if (telephone == null) telephone = "";
    106. 		List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, currentPage);
    107. 	    /*计算总的页数和总的记录数*/
    108. 	    userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone);
    109. 	    /*获取到总的页码数目*/
    110. 	    int totalPage = userInfoService.getTotalPage();
    111. 	    /*当前查询条件下总记录数*/
    112. 	    int recordNumber = userInfoService.getRecordNumber();
    113. 	    request.setAttribute("userInfoList",  userInfoList);
    114. 	    request.setAttribute("totalPage", totalPage);
    115. 	    request.setAttribute("recordNumber", recordNumber);
    116. 	    request.setAttribute("currentPage", currentPage);
    117. 	    request.setAttribute("user_name", user_name);
    118. 	    request.setAttribute("name", name);
    119. 	    request.setAttribute("birthDate", birthDate);
    120. 	    request.setAttribute("telephone", telephone);
    121. 		return "UserInfo/userInfo_frontquery_result"; 
    122. 	}
    123.  
    124.      /*前台查询UserInfo信息*/
    125. 	@RequestMapping(value="/{user_name}/frontshow",method=RequestMethod.GET)
    126. 	public String frontshow(@PathVariable String user_name,Model model,HttpServletRequest request) throws Exception {
    127. 		/*根据主键user_name获取UserInfo对象*/
    128.         UserInfo userInfo = userInfoService.getUserInfo(user_name);
    129.  
    130.         request.setAttribute("userInfo",  userInfo);
    131.         return "UserInfo/userInfo_frontshow";
    132. 	}
    133.  
    134. 	/*ajax方式显示用户修改jsp视图页*/
    135. 	@RequestMapping(value="/{user_name}/update",method=RequestMethod.GET)
    136. 	public void update(@PathVariable String user_name,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
    137.         /*根据主键user_name获取UserInfo对象*/
    138.         UserInfo userInfo = userInfoService.getUserInfo(user_name);
    139.  
    140.         response.setContentType("text/json;charset=UTF-8");
    141.         PrintWriter out = response.getWriter();
    142. 		//将要被返回到客户端的对象 
    143. 		JSONObject jsonUserInfo = userInfo.getJsonObject();
    144. 		out.println(jsonUserInfo.toString());
    145. 		out.flush();
    146. 		out.close();
    147. 	}
    148.  
    149. 	/*ajax方式更新用户信息*/
    150. 	@RequestMapping(value = "/{user_name}/update", method = RequestMethod.POST)
    151. 	public void update(@Validated UserInfo userInfo, BindingResult br,
    152. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    153. 		String message = "";
    154.     	boolean success = false;
    155. 		if (br.hasErrors()) { 
    156. 			message = "输入的信息有错误！";
    157. 			writeJsonResponse(response, success, message);
    158. 			return;
    159. 		}
    160. 		String userPhotoFileName = this.handlePhotoUpload(request, "userPhotoFile");
    161. 		if(!userPhotoFileName.equals("upload/NoImage.jpg"))userInfo.setUserPhoto(userPhotoFileName); 
    162.  
    163.  
    164. 		try {
    165. 			userInfoService.updateUserInfo(userInfo);
    166. 			message = "用户更新成功!";
    167. 			success = true;
    168. 			writeJsonResponse(response, success, message);
    169. 		} catch (Exception e) {
    170. 			e.printStackTrace();
    171. 			message = "用户更新失败!";
    172. 			writeJsonResponse(response, success, message); 
    173. 		}
    174. 	}
    175.     /*删除用户信息*/
    176. 	@RequestMapping(value="/{user_name}/delete",method=RequestMethod.GET)
    177. 	public String delete(@PathVariable String user_name,HttpServletRequest request) throws UnsupportedEncodingException {
    178. 		  try {
    179. 			  userInfoService.deleteUserInfo(user_name);
    180. 	            request.setAttribute("message", "用户删除成功!");
    181. 	            return "message";
    182. 	        } catch (Exception e) { 
    183. 	            e.printStackTrace();
    184. 	            request.setAttribute("error", "用户删除失败!");
    185. 				return "error";
    186.  
    187. 	        }
    188.  
    189. 	}
    190.  
    191. 	/*ajax方式删除多条用户记录*/
    192. 	@RequestMapping(value="/deletes",method=RequestMethod.POST)
    193. 	public void delete(String user_names,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
    194. 		String message = "";
    195.     	boolean success = false;
    196.         try { 
    197.         	int count = userInfoService.deleteUserInfos(user_names);
    198.         	success = true;
    199.         	message = count + "条记录删除成功";
    200.         	writeJsonResponse(response, success, message);
    201.         } catch (Exception e) { 
    202.             //e.printStackTrace();
    203.             message = "有记录存在外键约束,删除失败";
    204.             writeJsonResponse(response, success, message);
    205.         }
    206. 	}
    207.  
    208. 	/*按照查询条件导出用户信息到Excel*/
    209. 	@RequestMapping(value = { "/OutToExcel" }, method = {RequestMethod.GET,RequestMethod.POST})
    210. 	public void OutToExcel(String user_name,String name,String birthDate,String telephone, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    211.         if(user_name == null) user_name = "";
    212.         if(name == null) name = "";
    213.         if(birthDate == null) birthDate = "";
    214.         if(telephone == null) telephone = "";
    215.         List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name,name,birthDate,telephone);
    216.         ExportExcelUtil ex = new ExportExcelUtil();
    217.         String _title = "UserInfo信息记录"; 
    218.         String[] headers = { "用户名","姓名","性别","出生日期","用户照片","联系电话","邮箱","注册时间"};
    219.         List<String[]> dataset = new ArrayList<String[]>(); 
    220.         for(int i=0;i<userInfoList.size();i++) {
    221.         	UserInfo userInfo = userInfoList.get(i); 
    222.         	dataset.add(new String[]{userInfo.getUser_name(),userInfo.getName(),userInfo.getGender(),userInfo.getBirthDate(),userInfo.getUserPhoto(),userInfo.getTelephone(),userInfo.getEmail(),userInfo.getRegTime()});
    223.         }
    224.         /*
    225.         OutputStream out = null;
    226. 		try {
    227. 			out = new FileOutputStream("C://output.xls");
    228. 			ex.exportExcel(title,headers, dataset, out);
    229. 		    out.close();
    230. 		} catch (Exception e) {
    231. 			e.printStackTrace();
    232. 		}
    233. 		*/
    234. 		OutputStream out = null;//创建一个输出流对象 
    235. 		try { 
    236. 			out = response.getOutputStream();//
    237. 			response.setHeader("Content-disposition","attachment; filename="+"UserInfo.xls");//filename是下载的xls的名，建议最好用英文 
    238. 			response.setContentType("application/msexcel;charset=UTF-8");//设置类型 
    239. 			response.setHeader("Pragma","No-cache");//设置头 
    240. 			response.setHeader("Cache-Control","no-cache");//设置头 
    241. 			response.setDateHeader("Expires", 0);//设置日期头  
    242. 			String rootPath = request.getSession().getServletContext().getRealPath("/");
    243. 			ex.exportExcel(rootPath,_title,headers, dataset, out);
    244. 			out.flush();
    245. 		} catch (IOException e) { 
    246. 			e.printStackTrace(); 
    247. 		}finally{
    248. 			try{
    249. 				if(out!=null){ 
    250. 					out.close(); 
    251. 				}
    252. 			}catch(IOException e){ 
    253. 				e.printStackTrace(); 
    254. 			} 
    255. 		}
    256.     }
    257. }

    老人管理控制层： 

    1. //OldMan管理控制层
    2. @Controller
    3. @RequestMapping("/OldMan")
    4. public class OldManController extends BaseController {
    5.  
    6.     /*业务层对象*/
    7.     @Resource OldManService oldManService;
    8.  
    9.     @Resource UserInfoService userInfoService;
    10. 	@InitBinder("userObj")
    11. 	public void initBinderuserObj(WebDataBinder binder) {
    12. 		binder.setFieldDefaultPrefix("userObj.");
    13. 	}
    14. 	@InitBinder("oldMan")
    15. 	public void initBinderOldMan(WebDataBinder binder) {
    16. 		binder.setFieldDefaultPrefix("oldMan.");
    17. 	}
    18. 	/*跳转到添加OldMan视图*/
    19. 	@RequestMapping(value = "/add", method = RequestMethod.GET)
    20. 	public String add(Model model,HttpServletRequest request) throws Exception {
    21. 		model.addAttribute(new OldMan());
    22. 		/*查询所有的UserInfo信息*/
    23. 		List<UserInfo> userInfoList = userInfoService.queryAllUserInfo();
    24. 		request.setAttribute("userInfoList", userInfoList);
    25. 		return "OldMan_add";
    26. 	}
    27.  
    28. 	/*客户端ajax方式提交添加老人信息*/
    29. 	@RequestMapping(value = "/add", method = RequestMethod.POST)
    30. 	public void add(@Validated OldMan oldMan, BindingResult br,
    31. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    32. 		String message = "";
    33. 		boolean success = false;
    34. 		if (br.hasErrors()) {
    35. 			message = "输入信息不符合要求！";
    36. 			writeJsonResponse(response, success, message);
    37. 			return ;
    38. 		}
    39. 		try {
    40. 			oldMan.setManPhoto(this.handlePhotoUpload(request, "manPhotoFile"));
    41. 		} catch(UserException ex) {
    42. 			message = "图片格式不正确！";
    43. 			writeJsonResponse(response, success, message);
    44. 			return ;
    45. 		}
    46.         oldManService.addOldMan(oldMan);
    47.         message = "老人添加成功!";
    48.         success = true;
    49.         writeJsonResponse(response, success, message);
    50. 	}
    51. 	/*ajax方式按照查询条件分页查询老人信息*/
    52. 	@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
    53. 	public void list(String name,@ModelAttribute("userObj") UserInfo userObj,String addTime,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    54. 		if (page==null || page == 0) page = 1;
    55. 		if (name == null) name = "";
    56. 		if (addTime == null) addTime = "";
    57. 		if(rows != 0)oldManService.setRows(rows);
    58. 		List<OldMan> oldManList = oldManService.queryOldMan(name, userObj, addTime, page);
    59. 	    /*计算总的页数和总的记录数*/
    60. 	    oldManService.queryTotalPageAndRecordNumber(name, userObj, addTime);
    61. 	    /*获取到总的页码数目*/
    62. 	    int totalPage = oldManService.getTotalPage();
    63. 	    /*当前查询条件下总记录数*/
    64. 	    int recordNumber = oldManService.getRecordNumber();
    65.         response.setContentType("text/json;charset=UTF-8");
    66. 		PrintWriter out = response.getWriter();
    67. 		//将要被返回到客户端的对象
    68. 		JSONObject jsonObj=new JSONObject();
    69. 		jsonObj.accumulate("total", recordNumber);
    70. 		JSONArray jsonArray = new JSONArray();
    71. 		for(OldMan oldMan:oldManList) {
    72. 			JSONObject jsonOldMan = oldMan.getJsonObject();
    73. 			jsonArray.put(jsonOldMan);
    74. 		}
    75. 		jsonObj.accumulate("rows", jsonArray);
    76. 		out.println(jsonObj.toString());
    77. 		out.flush();
    78. 		out.close();
    79. 	}
    80.  
    81. 	/*ajax方式按照查询条件分页查询老人信息*/
    82. 	@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
    83. 	public void listAll(HttpServletResponse response) throws Exception {
    84. 		List<OldMan> oldManList = oldManService.queryAllOldMan();
    85.         response.setContentType("text/json;charset=UTF-8"); 
    86. 		PrintWriter out = response.getWriter();
    87. 		JSONArray jsonArray = new JSONArray();
    88. 		for(OldMan oldMan:oldManList) {
    89. 			JSONObject jsonOldMan = new JSONObject();
    90. 			jsonOldMan.accumulate("oldManId", oldMan.getOldManId());
    91. 			jsonOldMan.accumulate("name", oldMan.getName());
    92. 			jsonArray.put(jsonOldMan);
    93. 		}
    94. 		out.println(jsonArray.toString());
    95. 		out.flush();
    96. 		out.close();
    97. 	}
    98.  
    99. 	/*前台按照查询条件分页查询老人信息*/
    100. 	@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
    101. 	public String frontlist(String name,@ModelAttribute("userObj") UserInfo userObj,String addTime,Integer currentPage, Model model, HttpServletRequest request) throws Exception  {
    102. 		if (currentPage==null || currentPage == 0) currentPage = 1;
    103. 		if (name == null) name = "";
    104. 		if (addTime == null) addTime = "";
    105. 		List<OldMan> oldManList = oldManService.queryOldMan(name, userObj, addTime, currentPage);
    106. 	    /*计算总的页数和总的记录数*/
    107. 	    oldManService.queryTotalPageAndRecordNumber(name, userObj, addTime);
    108. 	    /*获取到总的页码数目*/
    109. 	    int totalPage = oldManService.getTotalPage();
    110. 	    /*当前查询条件下总记录数*/
    111. 	    int recordNumber = oldManService.getRecordNumber();
    112. 	    request.setAttribute("oldManList",  oldManList);
    113. 	    request.setAttribute("totalPage", totalPage);
    114. 	    request.setAttribute("recordNumber", recordNumber);
    115. 	    request.setAttribute("currentPage", currentPage);
    116. 	    request.setAttribute("name", name);
    117. 	    request.setAttribute("userObj", userObj);
    118. 	    request.setAttribute("addTime", addTime);
    119. 	    List<UserInfo> userInfoList = userInfoService.queryAllUserInfo();
    120. 	    request.setAttribute("userInfoList", userInfoList);
    121. 		return "OldMan/oldMan_frontquery_result"; 
    122. 	}
    123.  
    124.      /*前台查询OldMan信息*/
    125. 	@RequestMapping(value="/{oldManId}/frontshow",method=RequestMethod.GET)
    126. 	public String frontshow(@PathVariable Integer oldManId,Model model,HttpServletRequest request) throws Exception {
    127. 		/*根据主键oldManId获取OldMan对象*/
    128.         OldMan oldMan = oldManService.getOldMan(oldManId);
    129.  
    130.         List<UserInfo> userInfoList = userInfoService.queryAllUserInfo();
    131.         request.setAttribute("userInfoList", userInfoList);
    132.         request.setAttribute("oldMan",  oldMan);
    133.         return "OldMan/oldMan_frontshow";
    134. 	}
    135.  
    136. 	/*ajax方式显示老人修改jsp视图页*/
    137. 	@RequestMapping(value="/{oldManId}/update",method=RequestMethod.GET)
    138. 	public void update(@PathVariable Integer oldManId,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
    139.         /*根据主键oldManId获取OldMan对象*/
    140.         OldMan oldMan = oldManService.getOldMan(oldManId);
    141.  
    142.         response.setContentType("text/json;charset=UTF-8");
    143.         PrintWriter out = response.getWriter();
    144. 		//将要被返回到客户端的对象 
    145. 		JSONObject jsonOldMan = oldMan.getJsonObject();
    146. 		out.println(jsonOldMan.toString());
    147. 		out.flush();
    148. 		out.close();
    149. 	}
    150.  
    151. 	/*ajax方式更新老人信息*/
    152. 	@RequestMapping(value = "/{oldManId}/update", method = RequestMethod.POST)
    153. 	public void update(@Validated OldMan oldMan, BindingResult br,
    154. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    155. 		String message = "";
    156.     	boolean success = false;
    157. 		if (br.hasErrors()) { 
    158. 			message = "输入的信息有错误！";
    159. 			writeJsonResponse(response, success, message);
    160. 			return;
    161. 		}
    162. 		String manPhotoFileName = this.handlePhotoUpload(request, "manPhotoFile");
    163. 		if(!manPhotoFileName.equals("upload/NoImage.jpg"))oldMan.setManPhoto(manPhotoFileName); 
    164.  
    165.  
    166. 		try {
    167. 			oldManService.updateOldMan(oldMan);
    168. 			message = "老人更新成功!";
    169. 			success = true;
    170. 			writeJsonResponse(response, success, message);
    171. 		} catch (Exception e) {
    172. 			e.printStackTrace();
    173. 			message = "老人更新失败!";
    174. 			writeJsonResponse(response, success, message); 
    175. 		}
    176. 	}
    177.     /*删除老人信息*/
    178. 	@RequestMapping(value="/{oldManId}/delete",method=RequestMethod.GET)
    179. 	public String delete(@PathVariable Integer oldManId,HttpServletRequest request) throws UnsupportedEncodingException {
    180. 		  try {
    181. 			  oldManService.deleteOldMan(oldManId);
    182. 	            request.setAttribute("message", "老人删除成功!");
    183. 	            return "message";
    184. 	        } catch (Exception e) { 
    185. 	            e.printStackTrace();
    186. 	            request.setAttribute("error", "老人删除失败!");
    187. 				return "error";
    188.  
    189. 	        }
    190.  
    191. 	}
    192.  
    193. 	/*ajax方式删除多条老人记录*/
    194. 	@RequestMapping(value="/deletes",method=RequestMethod.POST)
    195. 	public void delete(String oldManIds,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
    196. 		String message = "";
    197.     	boolean success = false;
    198.         try { 
    199.         	int count = oldManService.deleteOldMans(oldManIds);
    200.         	success = true;
    201.         	message = count + "条记录删除成功";
    202.         	writeJsonResponse(response, success, message);
    203.         } catch (Exception e) { 
    204.             //e.printStackTrace();
    205.             message = "有记录存在外键约束,删除失败";
    206.             writeJsonResponse(response, success, message);
    207.         }
    208. 	}
    209.  
    210. 	/*按照查询条件导出老人信息到Excel*/
    211. 	@RequestMapping(value = { "/OutToExcel" }, method = {RequestMethod.GET,RequestMethod.POST})
    212. 	public void OutToExcel(String name,@ModelAttribute("userObj") UserInfo userObj,String addTime, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    213.         if(name == null) name = "";
    214.         if(addTime == null) addTime = "";
    215.         List<OldMan> oldManList = oldManService.queryOldMan(name,userObj,addTime);
    216.         ExportExcelUtil ex = new ExportExcelUtil();
    217.         String _title = "OldMan信息记录"; 
    218.         String[] headers = { "老人编号","姓名","性别","年龄","老人照片","登记用户","登记时间"};
    219.         List<String[]> dataset = new ArrayList<String[]>(); 
    220.         for(int i=0;i<oldManList.size();i++) {
    221.         	OldMan oldMan = oldManList.get(i); 
    222.         	dataset.add(new String[]{oldMan.getOldManId() + "",oldMan.getName(),oldMan.getSex(),oldMan.getAge() + "",oldMan.getManPhoto(),oldMan.getUserObj().getName(),oldMan.getAddTime()});
    223.         }
    224.         /*
    225.         OutputStream out = null;
    226. 		try {
    227. 			out = new FileOutputStream("C://output.xls");
    228. 			ex.exportExcel(title,headers, dataset, out);
    229. 		    out.close();
    230. 		} catch (Exception e) {
    231. 			e.printStackTrace();
    232. 		}
    233. 		*/
    234. 		OutputStream out = null;//创建一个输出流对象 
    235. 		try { 
    236. 			out = response.getOutputStream();//
    237. 			response.setHeader("Content-disposition","attachment; filename="+"OldMan.xls");//filename是下载的xls的名，建议最好用英文 
    238. 			response.setContentType("application/msexcel;charset=UTF-8");//设置类型 
    239. 			response.setHeader("Pragma","No-cache");//设置头 
    240. 			response.setHeader("Cache-Control","no-cache");//设置头 
    241. 			response.setDateHeader("Expires", 0);//设置日期头  
    242. 			String rootPath = request.getSession().getServletContext().getRealPath("/");
    243. 			ex.exportExcel(rootPath,_title,headers, dataset, out);
    244. 			out.flush();
    245. 		} catch (IOException e) { 
    246. 			e.printStackTrace(); 
    247. 		}finally{
    248. 			try{
    249. 				if(out!=null){ 
    250. 					out.close(); 
    251. 				}
    252. 			}catch(IOException e){ 
    253. 				e.printStackTrace(); 
    254. 			} 
    255. 		}
    256.     }
    257. }

    护工管理控制层：

    1. //Nurse管理控制层
    2. @Controller
    3. @RequestMapping("/Nurse")
    4. public class NurseController extends BaseController {
    5.  
    6.     /*业务层对象*/
    7.     @Resource NurseService nurseService;
    8.  
    9. 	@InitBinder("nurse")
    10. 	public void initBinderNurse(WebDataBinder binder) {
    11. 		binder.setFieldDefaultPrefix("nurse.");
    12. 	}
    13. 	/*跳转到添加Nurse视图*/
    14. 	@RequestMapping(value = "/add", method = RequestMethod.GET)
    15. 	public String add(Model model,HttpServletRequest request) throws Exception {
    16. 		model.addAttribute(new Nurse());
    17. 		return "Nurse_add";
    18. 	}
    19.  
    20. 	/*客户端ajax方式提交添加老人看护信息*/
    21. 	@RequestMapping(value = "/add", method = RequestMethod.POST)
    22. 	public void add(@Validated Nurse nurse, BindingResult br,
    23. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    24. 		String message = "";
    25. 		boolean success = false;
    26. 		if (br.hasErrors()) {
    27. 			message = "输入信息不符合要求！";
    28. 			writeJsonResponse(response, success, message);
    29. 			return ;
    30. 		}
    31.         nurseService.addNurse(nurse);
    32.         message = "老人看护添加成功!";
    33.         success = true;
    34.         writeJsonResponse(response, success, message);
    35. 	}
    36. 	/*ajax方式按照查询条件分页查询老人看护信息*/
    37. 	@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
    38. 	public void list(String nurseType,String title,String publishDate,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    39. 		if (page==null || page == 0) page = 1;
    40. 		if (nurseType == null) nurseType = "";
    41. 		if (title == null) title = "";
    42. 		if (publishDate == null) publishDate = "";
    43. 		if(rows != 0)nurseService.setRows(rows);
    44. 		List<Nurse> nurseList = nurseService.queryNurse(nurseType, title, publishDate, page);
    45. 	    /*计算总的页数和总的记录数*/
    46. 	    nurseService.queryTotalPageAndRecordNumber(nurseType, title, publishDate);
    47. 	    /*获取到总的页码数目*/
    48. 	    int totalPage = nurseService.getTotalPage();
    49. 	    /*当前查询条件下总记录数*/
    50. 	    int recordNumber = nurseService.getRecordNumber();
    51.         response.setContentType("text/json;charset=UTF-8");
    52. 		PrintWriter out = response.getWriter();
    53. 		//将要被返回到客户端的对象
    54. 		JSONObject jsonObj=new JSONObject();
    55. 		jsonObj.accumulate("total", recordNumber);
    56. 		JSONArray jsonArray = new JSONArray();
    57. 		for(Nurse nurse:nurseList) {
    58. 			JSONObject jsonNurse = nurse.getJsonObject();
    59. 			jsonArray.put(jsonNurse);
    60. 		}
    61. 		jsonObj.accumulate("rows", jsonArray);
    62. 		out.println(jsonObj.toString());
    63. 		out.flush();
    64. 		out.close();
    65. 	}
    66.  
    67. 	/*ajax方式按照查询条件分页查询老人看护信息*/
    68. 	@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
    69. 	public void listAll(HttpServletResponse response) throws Exception {
    70. 		List<Nurse> nurseList = nurseService.queryAllNurse();
    71.         response.setContentType("text/json;charset=UTF-8"); 
    72. 		PrintWriter out = response.getWriter();
    73. 		JSONArray jsonArray = new JSONArray();
    74. 		for(Nurse nurse:nurseList) {
    75. 			JSONObject jsonNurse = new JSONObject();
    76. 			jsonNurse.accumulate("nurseId", nurse.getNurseId());
    77. 			jsonNurse.accumulate("title", nurse.getTitle());
    78. 			jsonArray.put(jsonNurse);
    79. 		}
    80. 		out.println(jsonArray.toString());
    81. 		out.flush();
    82. 		out.close();
    83. 	}
    84.  
    85. 	/*前台按照查询条件分页查询老人看护信息*/
    86. 	@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
    87. 	public String frontlist(String nurseType,String title,String publishDate,Integer currentPage, Model model, HttpServletRequest request) throws Exception  {
    88. 		if (currentPage==null || currentPage == 0) currentPage = 1;
    89. 		if (nurseType == null) nurseType = "";
    90. 		if (title == null) title = "";
    91. 		if (publishDate == null) publishDate = "";
    92. 		List<Nurse> nurseList = nurseService.queryNurse(nurseType, title, publishDate, currentPage);
    93. 	    /*计算总的页数和总的记录数*/
    94. 	    nurseService.queryTotalPageAndRecordNumber(nurseType, title, publishDate);
    95. 	    /*获取到总的页码数目*/
    96. 	    int totalPage = nurseService.getTotalPage();
    97. 	    /*当前查询条件下总记录数*/
    98. 	    int recordNumber = nurseService.getRecordNumber();
    99. 	    request.setAttribute("nurseList",  nurseList);
    100. 	    request.setAttribute("totalPage", totalPage);
    101. 	    request.setAttribute("recordNumber", recordNumber);
    102. 	    request.setAttribute("currentPage", currentPage);
    103. 	    request.setAttribute("nurseType", nurseType);
    104. 	    request.setAttribute("title", title);
    105. 	    request.setAttribute("publishDate", publishDate);
    106. 		return "Nurse/nurse_frontquery_result"; 
    107. 	}
    108.  
    109.      /*前台查询Nurse信息*/
    110. 	@RequestMapping(value="/{nurseId}/frontshow",method=RequestMethod.GET)
    111. 	public String frontshow(@PathVariable Integer nurseId,Model model,HttpServletRequest request) throws Exception {
    112. 		/*根据主键nurseId获取Nurse对象*/
    113.         Nurse nurse = nurseService.getNurse(nurseId);
    114.  
    115.         request.setAttribute("nurse",  nurse);
    116.         return "Nurse/nurse_frontshow";
    117. 	}
    118.  
    119. 	/*ajax方式显示老人看护修改jsp视图页*/
    120. 	@RequestMapping(value="/{nurseId}/update",method=RequestMethod.GET)
    121. 	public void update(@PathVariable Integer nurseId,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
    122.         /*根据主键nurseId获取Nurse对象*/
    123.         Nurse nurse = nurseService.getNurse(nurseId);
    124.  
    125.         response.setContentType("text/json;charset=UTF-8");
    126.         PrintWriter out = response.getWriter();
    127. 		//将要被返回到客户端的对象 
    128. 		JSONObject jsonNurse = nurse.getJsonObject();
    129. 		out.println(jsonNurse.toString());
    130. 		out.flush();
    131. 		out.close();
    132. 	}
    133.  
    134. 	/*ajax方式更新老人看护信息*/
    135. 	@RequestMapping(value = "/{nurseId}/update", method = RequestMethod.POST)
    136. 	public void update(@Validated Nurse nurse, BindingResult br,
    137. 			Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    138. 		String message = "";
    139.     	boolean success = false;
    140. 		if (br.hasErrors()) { 
    141. 			message = "输入的信息有错误！";
    142. 			writeJsonResponse(response, success, message);
    143. 			return;
    144. 		}
    145. 		try {
    146. 			nurseService.updateNurse(nurse);
    147. 			message = "老人看护更新成功!";
    148. 			success = true;
    149. 			writeJsonResponse(response, success, message);
    150. 		} catch (Exception e) {
    151. 			e.printStackTrace();
    152. 			message = "老人看护更新失败!";
    153. 			writeJsonResponse(response, success, message); 
    154. 		}
    155. 	}
    156.     /*删除老人看护信息*/
    157. 	@RequestMapping(value="/{nurseId}/delete",method=RequestMethod.GET)
    158. 	public String delete(@PathVariable Integer nurseId,HttpServletRequest request) throws UnsupportedEncodingException {
    159. 		  try {
    160. 			  nurseService.deleteNurse(nurseId);
    161. 	            request.setAttribute("message", "老人看护删除成功!");
    162. 	            return "message";
    163. 	        } catch (Exception e) { 
    164. 	            e.printStackTrace();
    165. 	            request.setAttribute("error", "老人看护删除失败!");
    166. 				return "error";
    167.  
    168. 	        }
    169.  
    170. 	}
    171.  
    172. 	/*ajax方式删除多条老人看护记录*/
    173. 	@RequestMapping(value="/deletes",method=RequestMethod.POST)
    174. 	public void delete(String nurseIds,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
    175. 		String message = "";
    176.     	boolean success = false;
    177.         try { 
    178.         	int count = nurseService.deleteNurses(nurseIds);
    179.         	success = true;
    180.         	message = count + "条记录删除成功";
    181.         	writeJsonResponse(response, success, message);
    182.         } catch (Exception e) { 
    183.             //e.printStackTrace();
    184.             message = "有记录存在外键约束,删除失败";
    185.             writeJsonResponse(response, success, message);
    186.         }
    187. 	}
    188.  
    189. 	/*按照查询条件导出老人看护信息到Excel*/
    190. 	@RequestMapping(value = { "/OutToExcel" }, method = {RequestMethod.GET,RequestMethod.POST})
    191. 	public void OutToExcel(String nurseType,String title,String publishDate, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
    192.         if(nurseType == null) nurseType = "";
    193.         if(title == null) title = "";
    194.         if(publishDate == null) publishDate = "";
    195.         List<Nurse> nurseList = nurseService.queryNurse(nurseType,title,publishDate);
    196.         ExportExcelUtil ex = new ExportExcelUtil();
    197.         String _title = "Nurse信息记录"; 
    198.         String[] headers = { "记录id","信息类别","信息标题","发布时间"};
    199.         List<String[]> dataset = new ArrayList<String[]>(); 
    200.         for(int i=0;i<nurseList.size();i++) {
    201.         	Nurse nurse = nurseList.get(i); 
    202.         	dataset.add(new String[]{nurse.getNurseId() + "",nurse.getNurseType(),nurse.getTitle(),nurse.getPublishDate()});
    203.         }
    204.         /*
    205.         OutputStream out = null;
    206. 		try {
    207. 			out = new FileOutputStream("C://output.xls");
    208. 			ex.exportExcel(title,headers, dataset, out);
    209. 		    out.close();
    210. 		} catch (Exception e) {
    211. 			e.printStackTrace();
    212. 		}
    213. 		*/
    214. 		OutputStream out = null;//创建一个输出流对象 
    215. 		try { 
    216. 			out = response.getOutputStream();//
    217. 			response.setHeader("Content-disposition","attachment; filename="+"Nurse.xls");//filename是下载的xls的名，建议最好用英文 
    218. 			response.setContentType("application/msexcel;charset=UTF-8");//设置类型 
    219. 			response.setHeader("Pragma","No-cache");//设置头 
    220. 			response.setHeader("Cache-Control","no-cache");//设置头 
    221. 			response.setDateHeader("Expires", 0);//设置日期头  
    222. 			String rootPath = request.getSession().getServletContext().getRealPath("/");
    223. 			ex.exportExcel(rootPath,_title,headers, dataset, out);
    224. 			out.flush();
    225. 		} catch (IOException e) { 
    226. 			e.printStackTrace(); 
    227. 		}finally{
    228. 			try{
    229. 				if(out!=null){ 
    230. 					out.close(); 
    231. 				}
    232. 			}catch(IOException e){ 
    233. 				e.printStackTrace(); 
    234. 			} 
    235. 		}
    236.     }
    237. }

     源码获取：俺的博客首页 "资源" 里下载！

  • 相关阅读:
    对程序的一些小思考
    SpringMVC之CRUD和文件上传下载
    Go Zero微服务个人探究之路（十六）回顾api服务和rpc服务的本质
    【漏洞复现】panalog日志审计系统任意用户创建漏洞和后台命令执行
    CMS，CDN，WAF指纹识别
    统计力学中的概率论基础（二）
    【Python】你真的了解异常吗?-别再说你不了解异常啦
    汽车电子相关术语
    socket in Linux
    深度解析Kafka中的消息奥秘
  • 原文地址：https://blog.csdn.net/m0_66863468/article/details/124855202