基于javaweb网上商城项目包含数据库(eclipse+mysql)

package cn.edu.aynu.rjxy.servlet; import java.io.File; import java.io.IOException; import java.io.PrintWriter; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import cn.edu.aynu.rjxy.bean.Admin; import cn.edu.aynu.rjxy.bean.Order; import cn.edu.aynu.rjxy.bean.Page; import cn.edu.aynu.rjxy.bean.Product; import cn.edu.aynu.rjxy.service.AdminService; import cn.edu.aynu.rjxy.service.OrderService; import cn.edu.aynu.rjxy.service.ProductService; import cn.edu.aynu.rjxy.utils.CommonsUtils; public class AdminServlet extends HttpServlet{ private AdminService aService = new AdminService(); private ProductService ps = new ProductService(); private OrderService os = new OrderService(); private static final long serialVersionUID = 1L; // 上传文件存储目录 private static final String UPLOAD_DIRECTORY = "img"; // 上传配置 private static final int MEMORY_THRESHOLD = 1024 * 1024 * 3; // 3MB private static final int MAX_FILE_SIZE = 1024 * 1024 * 40; // 40MB private static final int MAX_REQUEST_SIZE = 1024 * 1024 * 50; // 50MB public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 处理中文乱码 request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=UTF-8"); // 获取隐藏字段method的值，并把它转换为int型 int method = Integer.parseInt(request.getParameter("method")); switch (method) { case 1: this.login(request, response); break; case 2: this.query(request, response); break; case 3: this.add(request, response); break; case 4: this.loadForUpdate(request, response); break; case 5: this.edit(request, response); break; case 6: this.delete(request, response); break; case 7: this.order(request, response); break; case 8: this.uploadpicture(request, response); break; case 9: this.uploadForpicture(request, response); break; } } // 管理员登录 public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 从请求中解析用户名和密码 String username = request.getParameter("username"); String password = request.getParameter("password"); // 执行加载业务 Admin a = aService.login(username, password); if (a != null) { HttpSession session = request.getSession(); session.setAttribute("userId", a.getId()); response.getWriter().print("登录成功" + a.getId()); // 通过请求转发将pb带到list.jsp上去 request.getRequestDispatcher("/admin/home.jsp").forward(request, response); } else { response.getWriter().print("登录失败，即将跳转到登录页面，请重新登录......"); response.setHeader("Refresh", "3;url=/shopping/admin/login.jsp"); } } // 管理员查看商品 public void query(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 当前页有一个默认值为1 int pageCode = 1; String s = request.getParameter("pageCode"); // 如果请求中存在pageCode参数 if (s != null && !s.trim().isEmpty()) { pageCode = Integer.parseInt(s); } // 查询当前页的记录 Page pb = ps.queryByPage(pageCode); // 将pb保存在request域中 request.setAttribute("pb", pb); // 通过请求转发将pb带到list.jsp上去 request.getRequestDispatcher("/admin/list.jsp").forward(request, response); } // 管理员添加商品 public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 使用CommonUtils工具类将请求数据封装到bean中 Product p = CommonsUtils.toBean(request.getParameterMap(), Product.class); // 使用UUID作为id属性的值 p.setId(CommonsUtils.uuid()); // p.setImgurl(uploadPath); // 执行添加 ps.add(p); // 输出添加成功提示 response.getWriter().print("添加成功......"); } // 加载商品为修改做准备 public void loadForUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 从请求中获取客户的id String id = request.getParameter("id"); // 执行加载业务 Product p = ps.findById(id); // 将Customer对象c保存在request域中 request.setAttribute("product", p); // t=通过请求转发将customer对象显示在list.jsp页面上 request.getRequestDispatcher("/admin/edit.jsp").forward(request, response); } // 管理员修改商品信息 public void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 使用CommonUtils工具类将请求数据封装到bean中 Product p = CommonsUtils.toBean(request.getParameterMap(), Product.class); // 执行更改业务 ps.edit(p); // 给客户端发送更改成功提示 response.getWriter().print("更改成功......"); } // 管理员删除商品 public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 从请求中获取id String id = request.getParameter("id"); // 执行删除 ps.delete(id); // 给客户端发送删除成功提示 response.getWriter().print("删除成功......"); } // 管理员查看所有订单 public void order(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { List<Order> list = os.findAllOrder(); request.setAttribute("allorderList", list); request.getRequestDispatcher("/admin/orderproduct.jsp").forward( request, response); } // 为上传照片做准备 public void uploadForpicture(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("id"); Product p = ps.findById(id); System.out.println(id + "id"); ps.upload(p, id); // 将Customer对象c保存在request域中 request.setAttribute("product", p); // t=通过请求转发将customer对象显示在list.jsp页面上 request.getRequestDispatcher("/admin/upload.jsp").forward(request, response); } // 管理员上传照片 public void uploadpicture(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 检测是否为多媒体上传 if (!ServletFileUpload.isMultipartContent(request)) { // 如果不是则停止 PrintWriter writer = response.getWriter(); writer.println("Error: 表单必须包含 enctype=multipart/form-data"); writer.flush(); return; } // 配置上传参数 DiskFileItemFactory factory = new DiskFileItemFactory(); // 设置内存临界值 - 超过后将产生临时文件并存储于临时目录中 factory.setSizeThreshold(MEMORY_THRESHOLD); // 设置临时存储目录 factory.setRepository(new File(System.getProperty("java.io.tmpdir"))); ServletFileUpload upload = new ServletFileUpload(factory); // 设置最大文件上传值 upload.setFileSizeMax(MAX_FILE_SIZE); // 设置最大请求值 (包含文件和表单数据) upload.setSizeMax(MAX_REQUEST_SIZE); // 构造临时路径来存�