基于MVC用JSP/Servlet实现JPetStore——基本任务2（用户管理业务模块）

以你之姓@ 2021-11-09 10:02 324阅读 0赞

## 基于MVC用JSP/Servlet实现JPetStore ##

CSDN下载：[基于MVC用JSP/Servlet实现JPetStore][MVC_JSP_Servlet_JPetStore]

--------------------

2.用户管理业务模块，包括用户注册、登录、修改用户信息、查询用户相关订单等业务功能。

--------------------

2.1 用户注册  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70]  
  用户注册时，需要一个全新的包含用户所有信息的输入界面即NewAccountForm.jsp，之后需要先进行设计NewAccountFormServlet，该Servlet的功能仅为实现用户点击注册后跳转用户输入新账号信息的表格，接下实现Account.java，完成Account的基础功能，之后进行AccountDAO接口定义以及完成AccountDAOImpl连接数据库的实现，接下来完成AccountService的编写，之后进行NewAccountServlet配置，获取网页界面的信息，赋值给一个新账号，再将该账号插入到数据库中。

AccountService：

public class AccountService { 
    
        private AccountDAO accountDAO;
    
        public AccountService(){ 
            accountDAO = new AccountDAOImpl();
        }
    
        public Account getAccount(String username) { 
            return accountDAO.getAccountByUsername(username);
        }
    
        public Account getAccount(String username, String password) { 
            Account account = new Account();
            account.setUsername(username);
            account.setPassword(password);
            return accountDAO.getAccountByUsernameAndPassword(account);
        }
    
        public void insertAccount(Account account) { 
            accountDAO.insertAccount(account);
            accountDAO.insertProfile(account);
            accountDAO.insertSignon(account);
        }
    
        public void updateAccount(Account account) { 
            accountDAO.updateAccount(account);
            accountDAO.updateProfile(account);
    
            if (account.getPassword() != null && account.getPassword().length() > 0) { 
                accountDAO.updateSignon(account);
            }
        }
    }

NewAccountServlet：

public class NewAccountServlet extends HttpServlet { 
        private static final String MAIN = "/WEB-INF/jsp/catalog/Main.jsp";
        private static final String NEWACCOUNTFORM = "/WEB-INF/jsp/account/NewAccountForm.jsp";
    
        private Account account;
        private Account account1;
        private AccountService accountService;
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            HttpSession session = request.getSession();
            account = (Account) session.getAttribute("account");
            account = null;
            session.setAttribute("account", account);
    
            //获得输入的验证码值
            String value1=request.getParameter("vCode");
            /*获取图片的值*/
            String value2=(String)session.getAttribute("checkcode");
            Boolean isSame = false;
            /*对比两个值（字母不区分大小写）*/
            if(value2.equalsIgnoreCase(value1)){ 
                isSame = true;
            }
    
            String username = request.getParameter("username");
            String password = request.getParameter("password");
            String firstName = request.getParameter("firstName");
            String lastName = request.getParameter("lastName");
            String email = request.getParameter("email");
            String phone = request.getParameter("phone");
            String address1 = request.getParameter("address1");
            String address2 = request.getParameter("address2");
            String city = request.getParameter("city");
            String state = request.getParameter("state");
            String zip = request.getParameter("zip");
            String country = request.getParameter("country");
            String languagePreference = request.getParameter("languagePreference");
            String favouriteCategoryId = request.getParameter("favouriteCategoryId");
            String listOption = request.getParameter("listOption");
            String bannerOption = request.getParameter("bannerOption");
    
            account1 = new Account();
            account1.setUsername(username);
            account1.setPassword(password);
            account1.setFirstName(firstName);
            account1.setLastName(lastName);
            account1.setEmail(email);
            account1.setPhone(phone);
            account1.setAddress1(address1);
            account1.setAddress2(address2);
            account1.setCity(city);
            account1.setState(state);
            account1.setZip(zip);
            account1.setCountry(country);
            account1.setLanguagePreference(languagePreference);
            account1.setFavouriteCategoryId(favouriteCategoryId);
            account1.setListOption(Boolean.parseBoolean(listOption));
            account1.setBannerOption(Boolean.parseBoolean(bannerOption));
    
            if(isSame){ 
                accountService = new AccountService();
                accountService.insertAccount(account1);
    
                if(account1 != null){ 
                request.getRequestDispatcher(MAIN).forward(request, response);
            }else{ 
                session.setAttribute("messageAccount", "Invalid Verification Code.");
    
                if(account1 != null){ 
                request.getRequestDispatcher(NEWACCOUNTFORM).forward(request, response);
            }
        }
    }

2.2 用户登录

用户登录先完成SignonForm.jsp，能够使用户输入登入的账号与密码，接下来先用一个Servlet实现SignOnFormServlet实现点击登录时网页跳转到用户输入账号密码的界面，接下来使用SignOnServlet实现获取用户的账号密码对数据库进行核查，如果存在则登录，反之则给予一定的错误信息提示。

SignOnFormServlet：

public class SignOnFormServlet extends HttpServlet { 
    
        private static final String SIGNONFORM = "/WEB-INF/jsp/account/SignonForm.jsp";
    
        private Account account;
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
    
            HttpSession session = request.getSession();
            account = (Account)session.getAttribute("account");
    
            request.getRequestDispatcher(SIGNONFORM).forward(request, response);
        }
    }

SignOnServlet：

public class SignOnServlet extends HttpServlet { 
        private static final String MAIN = "/WEB-INF/jsp/catalog/Main.jsp";
        private static final String SIGNONFORM = "/WEB-INF/jsp/account/SignonForm.jsp";
    
        private Account account;
        private AccountService accountService;
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
    
            String username = request.getParameter("username");
            String password = request.getParameter("password");
    
            accountService = new AccountService();
            account = accountService.getAccount(username, password);
    
            HttpSession session = request.getSession();
            session.setAttribute("account", account);
    
            //获得输入的验证码值
            String value1=request.getParameter("vCode");
            /*获取图片的值*/
            String value2=(String)session.getAttribute("checkcode");
            Boolean isSame = false;
            /*对比两个值（字母不区分大小写）*/
            if(value2.equalsIgnoreCase(value1)){ 
                isSame = true;
            }
    
            if (account == null || !isSame){ 
                if(!isSame){ 
                    session.setAttribute("messageSignOn", "Invalid Verification Code. Signon failed.");
                }else{ 
                    session.setAttribute("messageSignOn", "Invalid username or password. Signon failed.");
                }
                session.setAttribute("account", null);
                request.getRequestDispatcher(SIGNONFORM).forward(request, response);
            }else{ 
                account.setPassword(null);
                request.getRequestDispatcher(MAIN).forward(request, response);
            }
        }
    }

2.3 用户修改信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70 1]  
  修改个人账号信息也就是进行个人信息查看，同时可以进行修改，修改后点击Save Account Information即可获取新的用户信息，之后进行数据库信息更新。

EditAccountServlet：

public class EditAccountServlet extends HttpServlet { 
    
        private static final String EDITACOUNT = "/WEB-INF/jsp/account/EditAccountForm.jsp";
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            request.getRequestDispatcher(EDITACOUNT).forward(request, response);
        }
    }

SaveAccountServlet：

public class SaveAccountServlet extends HttpServlet { 
    
        private static final String EDITACOUNT = "/WEB-INF/jsp/account/EditAccountForm.jsp";
    
        private Account account;
        private AccountService accountService;
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            HttpSession session = request.getSession();
            account = (Account) session.getAttribute("account");
    
            String username = account.getUsername();
            String password = request.getParameter("password");
            String firstName = request.getParameter("firstName");
            String lastName = request.getParameter("lastName");
            String email = request.getParameter("email");
            String phone = request.getParameter("phone");
            String address1 = request.getParameter("address1");
            String address2 = request.getParameter("address2");
            String city = request.getParameter("city");
            String state = request.getParameter("state");
            String zip = request.getParameter("zip");
            String country = request.getParameter("country");
            String languagePreference = request.getParameter("languagePreference");
            String favouriteCategoryId = request.getParameter("favouriteCategoryId");
            String listOption = request.getParameter("listOption");
            String bannerOption = request.getParameter("bannerOption");
    
            account.setUsername(username);
            account.setPassword(password);
            account.setFirstName(firstName);
            account.setLastName(lastName);
            account.setEmail(email);
            account.setPhone(phone);
            account.setAddress1(address1);
            account.setAddress2(address2);
            account.setCity(city);
            account.setState(state);
            account.setZip(zip);
            account.setCountry(country);
            account.setLanguagePreference(languagePreference);
            account.setFavouriteCategoryId(favouriteCategoryId);
            account.setListOption(Boolean.parseBoolean(listOption));
            account.setBannerOption(Boolean.parseBoolean(bannerOption));
    
            accountService = new AccountService();
            accountService.updateAccount(account);
    
            session.setAttribute("account", account);
    
            request.getRequestDispatcher(EDITACOUNT).forward(request, response);
        }
    }

2.4 查询订单  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70 2]

账户订单查看，先完成ListOrders.jsp的实现，接下来实现Order.java的基础模块，创建OrderDAO接口，完成数据库的具体操作OrderDAOImpl，接下来实现OrderService，成功完成业务层调用，最后完成ViewListOrderServlet实现用户可以从数据库中查看到自己的订单信息。

OrderService

public class OrderService { 
    
      private ItemDAO itemDAO;
      private OrderDAO orderDAO;
      private SequenceDAO sequenceDAO;
      private LineItemDAO lineItemDAO;
    
      public OrderService(){ 
        itemDAO = new ItemDAOImpl();
        orderDAO = new OrderDAOImpl();
        sequenceDAO = new SequenceDAOImpl();
        lineItemDAO = new LineItemDAOImpl();
      }
    
      public void insertOrder(Order order) { 
        order.setOrderId(getNextId("ordernum"));
        for (int i = 0; i < order.getLineItems().size(); i++) { 
          LineItem lineItem = (LineItem) order.getLineItems().get(i);
          String itemId = lineItem.getItemId();
          Integer increment = new Integer(lineItem.getQuantity());
          Map<String, Object> param = new HashMap<String, Object>(2);
          param.put("itemId", itemId);
          param.put("increment", increment);
          itemDAO.updateInventoryQuantity(param);
        }
    
        orderDAO.insertOrder(order);
        orderDAO.insertOrderStatus(order);
        for (int i = 0; i < order.getLineItems().size(); i++) { 
          LineItem lineItem = (LineItem) order.getLineItems().get(i);
          lineItem.setOrderId(order.getOrderId());
          lineItemDAO.insertLineItem(lineItem);
        }
      }
    
      public Order getOrder(int orderId) { 
        Order order = orderDAO.getOrder(orderId);
        order.setLineItems(lineItemDAO.getLineItemsByOrderId(orderId));
    
        for (int i = 0; i < order.getLineItems().size(); i++) { 
          LineItem lineItem = (LineItem) order.getLineItems().get(i);
          Item item = itemDAO.getItem(lineItem.getItemId());
          item.setQuantity(itemDAO.getInventoryQuantity(lineItem.getItemId()));
          lineItem.setItem(item);
        }
    
        return order;
      }
    
      public List<Order> getOrdersByUsername(String username) { 
        return orderDAO.getOrdersByUsername(username);
      }
    
      public int getNextId(String name) { 
        Sequence sequence = new Sequence(name, -1);
        sequence = sequenceDAO.getSequence(sequence);
        if (sequence == null) { 
          throw new RuntimeException("Error: A null sequence was returned from the database (could not get next " + name
              + " sequence).");
        }
        Sequence parameterObject = new Sequence(name, sequence.getNextId() + 1);
        sequenceDAO.updateSequence(parameterObject);
        return sequence.getNextId();
      }
    
    }

ViewListServlet：

public class ViewListOrderServlet extends HttpServlet { 
        private static final String VIEWLISTORDER = "/WEB-INF/jsp/order/ListOrders.jsp";
    
        private String username;
        private OrderService orderService;
        private List<Order> orderList = new ArrayList<Order>();
    
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            doGet(request, response);
        }
    
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            username = request.getParameter("username");
            orderService = new OrderService();
            orderList = orderService.getOrdersByUsername(username);
    
            HttpSession session = request.getSession();
            session.setAttribute("orderList", orderList);
    
            //HttpSession session = request.getSession();
            Account account = (Account)session.getAttribute("account");
    
    
            request.getRequestDispatcher(VIEWLISTORDER).forward(request, response);
        }
    }

--------------------

完整项目文档及源码请参考：[实验一 基于MVC用JSPServlet实现JPetStore][_MVC_JSPServlet_JPetStore]

--------------------

[MVC_JSP_Servlet_JPetStore]: https://download.csdn.net/download/qq_39564555/11465159
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70]: /images/20211109/2b63a08893864b8181727c152c3fb7b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70 1]: /images/20211109/b966e17037664deeb2f6670b6e7588fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTY0NTU1_size_16_color_FFFFFF_t_70 2]: /images/20211109/8e324ad97cf7459da210667a1aedf0f8.png
[_MVC_JSPServlet_JPetStore]: https://github.com/zz2summer/JavaWeb-Application-Developing-Technology/tree/master/%E5%AE%9E%E9%AA%8C%E7%9B%B8%E5%85%B3/%E5%AE%9E%E9%AA%8C%E4%B8%80%20%20%E5%9F%BA%E4%BA%8EMVC%E7%94%A8JSPServlet%E5%AE%9E%E7%8E%B0JPetStore