基于jsp+servlet+mysql的实验室设备管理系统.zip

package cn.itcast.LabManagement.admin.device.web.servlet; import java.io.File; import java.io.IOException; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import cn.itcast.LabManagement.category.domain.Category; import cn.itcast.LabManagement.category.service.CategoryService; import cn.itcast.LabManagement.device.domain.Device; import cn.itcast.LabManagement.device.service.DeviceService; import cn.itcast.LabManagement.pager.PageBean; import cn.itcast.commons.CommonUtils; import cn.itcast.servlet.BaseServlet; public class AdminDeviceServlet extends BaseServlet { private DeviceService deviceService = new DeviceService(); private CategoryService categoryService = new CategoryService(); private String toJson(Category category) { StringBuilder sb = new StringBuilder("{"); sb.append("\"cid\"").append(":").append("\"").append(category.getCid()).append("\""); sb.append(","); sb.append("\"cname\"").append(":").append("\"").append(category.getCname()).append("\""); sb.append("}"); return sb.toString(); } private String toJson(List<Category> categoryList) { StringBuilder sb = new StringBuilder("["); for(int i = 0; i < categoryList.size(); i++) { sb.append(toJson(categoryList.get(i))); if(i < categoryList.size() - 1) { sb.append(","); } } sb.append("]"); return sb.toString(); } public String findCategoryAll(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { /* * 1. 通过service得到所有的分类 * 2. 保存到request中，转发到left.jsp */ List<Category> parents = categoryService.findAll(); req.setAttribute("parents", parents); return "/adminjsps/admin/device/left.jsp"; } private int getPc(HttpServletRequest req) { int pc = 1; String param = req.getParameter("pc"); if(param != null && !param.trim().isEmpty()) { try { pc = Integer.parseInt(param); } catch(RuntimeException e) {} } return pc; } private String getUrl(HttpServletRequest req) { String url = req.getRequestURI() + "?" + req.getQueryString(); int index = url.lastIndexOf("&pc="); if(index != -1) { url = url.substring(0, index); } return url; } public String findByCategory(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { int pc = getPc(req); String url = getUrl(req); String cid = req.getParameter("cid"); PageBean<Device> pb = deviceService.findByCategory(cid, pc); pb.setUrl(url); req.setAttribute("pb", pb); return "/adminjsps/admin/device/list.jsp"; } public String findByDname(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { int pc = getPc(req); String url = getUrl(req); String dname = req.getParameter("dname"); PageBean<Device> pb = deviceService.findByDname(dname, pc); pb.setUrl(url); req.setAttribute("pb", pb); return "/adminjsps/admin/device/list.jsp"; } public String load(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String bid = req.getParameter("bid");//获取链接的参数bid Device device = deviceService.load(bid); req.setAttribute("device", device); req.setAttribute("parents", categoryService.findParents()); String pid = device.getCategory().getParent().getCid(); req.setAttribute("children", categoryService.findChildren(pid)); return "/adminjsps/admin/device/desc.jsp"; } public String addPre(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { /* * 获取所有一级分类，保存 转发到add.jsp */ List<Category> parents = categoryService.findParents(); req.setAttribute("parents", parents); return "/adminjsps/admin/device/add.jsp"; } public String ajaxFindChildren(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String pid = req.getParameter("pid"); List<Category> children = categoryService.findChildren(pid); String json = toJson(children); resp.getWriter().print(json); return null; } public String edit(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { Map map = req.getParameterMap(); Device device = CommonUtils.toBean(map, Device.class); Category category = CommonUtils.toBean(map, Category.class); device.setCategory(category); deviceService.edit(device); req.setAttribute("msg", "修改成功！"); return "/adminjsps/msg.jsp"; } public String delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String bid = req.getParameter("bid"); /* * 删除图片 */ Device device = deviceService.load(bid); String savepath = this.getServletContext().getRealPath("/");//获取真实的路径 new File(savepath, device.getImage_b()).delete();//删除文件 deviceService.delete(bid);//删除数据库的记录 req.setAttribute("msg", "删除成功！"); return "f:/adminjsps/msg.jsp"; } }